-
Notifications
You must be signed in to change notification settings - Fork 193
Open
Description
@with_connection
def _update(sql, *args):
"""
执行update语句,返回行数
"""
global _db_ctx
cursor =None
sql = sql.replace('?','%s')
logging.info('SQL: %s, ARGS: %s' % (sql, args))
try:
cursor = _db_ctx.connection.cursor()
cursor.execute(sql, args)
r = cursor.rowcount
if _db_ctx.transactions == 0:
# no transaction enviroment:
logging.info('auto commit')
_db_ctx.connection.commit()
return r
finally:
if cursor:
cursor.close()
Metadata
Metadata
Assignees
Labels
No labels
