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
