def do_test1():
log.LogInit("udpserver-out", "debug", log.LOG_STD)
log.ColorDebug(log.GREEN, "%s okok", 2)
log.ColorInfo(log.GREEN, "%s okok", 2)
log.ColorWarning(log.YELLOW, "%s okok" % (2, ))
log.ColorError(log.RED, "%s okok", 2)
def do_test5():
import time
log.LogInit("udpserver-out", "debug", log.LOG_STD)
k = {"autocommit":True}
#db = mysqldbc("ijmaster", "ijjazhang", "sync_ijdbs", **k)
db = mysqldbc("ijmaster", "ijjazhang", "sync_ijdbs")
db.mysql_connect()
db.begin()
#time.sleep(10)
sql = 'insert into test(name, num) value("nnn", 1)'
r = db.insert(sql)
db.info()
#db.commit()
if r is not None:
print "insert ok"
db.begin()
#time.sleep(10)
db.insert(sql)
db.commit()
db.commit()
else:
print "insert failed"
db.rollback()
db.info()
sql = 'select * from test'
print db.select(sql)
db.info()
sql = 'insert into test(name, num) value("nnn", 1)'
#sql = 'update test set num=1 where id=83'
#db.update(sql)
#time.sleep(10)
db.begin()
#sql = 'select * from test'
print db.insert(sql)
db.info()
db.commit()
db.info()
print "over"
def do_test2():
import time
log.LogInit("udpserver-out", "debug", log.LOG_STD)
db = mysqldbc("ijmaster", "ijjazhang", "sync_ijdbs")
db.begin()
db.begin()
print "begin"
sql = 'select * from test'
print db.select(sql)
sql = 'insert into test(name, num) value("nnn", 1)'
#sql = 'update test set num=1 where id=83'
db.update(sql)
db.rollback()
time.sleep(5)
db.commit()
print self.select(sql)
def insert_test(self):
sql = 'insert into test(name,num) value("yangchuan", 1)'
print self.insert(sql)
def info(self):
log.Debug(
"transactions: %s, current_autocommit: %s default_autocommit: %s" %
(self.transactions, self.current_autocommit,
self.default_autocommit))
def do_test(db):
pass
if __name__ == '__main__':
log.LogInit(level="debug")
# test()
# do_insert = False
mysqldb = mysqldbc("ijmaster",
'ijjazhang',
'sync_ijdbs',
host='127.0.0.1',
port=3306)
mysqldb.select_test()
mysqldb.close()