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