def update_model_id_of_allnet_car_source(model_id, car_sale_id):
db = wcar_pool.connection()
cursor = db.cursor()
sql = """UPDATE `car_allnet_source` SET `model_id` = %d WHERE `id` = %d""" % (model_id, car_sale_id)
try:
cursor.execute(sql)
# utils.debug("update %d's model_id to %d." % (car_sale_id, model_id))
db.commit()
except:
db.rollback()
db.close()
def wrapper(*a,**kw):
try:
return f(*a,**kw)
except db.Error as e:
if not b'schema "resultcache" does not exist' in e['message']:
raise
intrans = db.c.inTransaction
if intrans:
db.rollback()
print("loading schema...")
db.setup("sql/resultCache.sql",source=True,named=False)
if intrans:
db.begin()
# now try it with the db setup
return f(*a,**kw)
def update_series_id_of_allnet_car_source(start, limit): db = wcar_pool.connection() cursor = db.cursor() affected_rows = None sql = """UPDATE wcar.car_allnet_source a INNER JOIN (SELECT a.id, b.id AS series_id FROM wcar.car_allnet_source a, car_type.car_series b WHERE a.brand_id = b.brand_id AND a.series = b.name LIMIT %d, %d) b ON a.id = b.id SET a.series_id = b.series_id;""" % (start, limit) try: affected_rows = cursor.execute(sql) db.commit() except: db.rollback() db.close() return affected_rows
def rollback_on_exception(exc):
if exc:
rollback()
return exc
def __on_rollback(self, evt):
db.rollback()
def rollback_on_exception(exc):
if exc:
rollback()
return exc
