tornado_mysql事务_tornado_mysql的pool使用事务的方法。

#/usr/bin/env python

#coding=utf-8

'''

Created on 2017-02-20

@author: chenjiahui

'''

import sys,os

from config import *

from tornado_mysql import pools

data_time=''

def create_pool():

print DB_CONN.PORT,DB_CONN.BATCH_USER,DB_CONN.BATCH_PASSWORD,DB_CONN.DBNAME

pool_db = pools.Pool(

dict(host=DB_CONN.IP, port=int(DB_CONN.PORT), user=DB_CONN.BATCH_USER,

passwd=DB_CONN.BATCH_PASSWORD, db=DB_CONN.DBNAME, charset='utf8mb4'),

max_idle_connections=50,

max_recycle_sec=3,

max_open_connections=100,

)

return pool_db

@gen.coroutine

def main():

conn = create_pool()

cur = yield conn.begin()

try:

yield cur.execute('insert into temple_text(words)values(99999)',())

print cur._executed

#sleep(100)

#yield cur.execute('insert into test(id,abc)values(99999)',())

yield cur.commit()

except Exception,e:

yield cur.rollback()

print str(e)

if __name__=='__main__':

try:

ioloop.IOLoop.current().run_sync(main)

except Exception,e:

print str(e)