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()