def update_idcardno_by_id(idcard, id): #print(idcard,id) sql = "UPDATE " + table_name + " set idcard = %s ,status =1 where id=%s " #print(sql) db = db_config.get_db() result = db.execute(sql, idcard, id) return result
def insert(invoice): sql = "INSERT INTO " + table_name + " (file_src,file_target,request_type,md5_code,file_name) VALUES (%s,%s,%s,%s,%s)" #print(sql) db = db_config.get_db() result = db.execute(sql, invoice.file_src, invoice.file_target, invoice.request_type, invoice.md5_code, invoice.file_name) return result
def get_invoice_by_src(img_src): result = None sql = "select * from " + table_name + " where file_src= %s" db = db_config.get_db() row = db.get(sql, img_src) if row: result = PeInvoice(row) return result
def get_invoice_by_md5(md5_code): result = None sql = "select * from " + table_name + " where md5_code= %s limit 1" db = db_config.get_db() row = db.get(sql, md5_code) if row: result = PeInvoice(row) return result
def query_by_filename(filename): result = None sql = "SELECT * FROM " + table_name + " where file_name =%s " db = db_config.get_db() rows = db.query(sql, filename) if rows and len(rows) > 0: result = [] for row in rows: result.append(PeInvoice(row)) return result
def query_unprocess_data_random(num): result = None sql = "SELECT * FROM " + table_name + " where status =0 order by RAND() limit " + str( num) db = db_config.get_db() rows = db.query(sql) if rows and len(rows) > 0: result = [] for row in rows: result.append(PeInvoice(row)) return result
def update_invoice_by_id(id, idcard=None, vin=None, organ=None, engine=None, price=None, predict_time=None, predict_type_idcard=None): update = False params = [] sql = "UPDATE " + table_name + " set" if idcard: sql += " idcard = %s," params.append(idcard) sql += " status = 1," update = True if vin: sql += " vin = %s," update = True params.append(vin) if organ: sql += " organ = %s," update = True params.append(organ) if engine: sql += " engine = %s," update = True params.append(engine) if price: sql += " price = %s," update = True params.append(price) if predict_time: sql += " predict_time = %s," update = True params.append(predict_time) if predict_type_idcard: sql += " predict_type_idcard = %s," update = True params.append(predict_type_idcard) sql = sql[:-1] sql += " where id=%s" params.append(id) result = 0 if update: db = db_config.get_db() result = db._cursor().execute(sql, params) else: print("no field to update") return result
def insert(log): sql = "INSERT INTO " + table_name + " (content,type,level,fk_data_id) VALUES (%s,%s,%s,%s)" #print(sql) db = db_config.get_db() result = db.execute(sql, log.content, log.type, log.level, log.data_id) return result
def update_price_by_id(price, id): sql = "UPDATE " + table_name + " set price = %s where id=%s" db = db_config.get_db() result = db.execute(sql, price, id) return result
def update_engineno_by_id(engine, id): sql = "UPDATE " + table_name + " set engine = %s where id=%s" db = db_config.get_db() result = db.execute(sql, engine, id) return result
def update_roganno_by_id(organ, id): sql = "UPDATE " + table_name + " set organ = %s where id=%s" db = db_config.get_db() result = db.execute(sql, organ, id) return result
def update_vin_by_id(vin, id): sql = "UPDATE " + table_name + " set vin = %s where id=%s" db = db_config.get_db() result = db.execute(sql, vin, id) return result
def update_unknow_status_by_id(id): sql = "UPDATE " + table_name + " set status =6 where id=%s" db = db_config.get_db() result = db.execute(sql, id) return result
def update_error_status_by_id(remark, id): sql = "UPDATE " + table_name + " set remark = %s, status =3 where id=%s" db = db_config.get_db() result = db.execute(sql, remark, id) return result