def dal_update_second_scan_data(file_name, file_hash, file_path):
dbStr = 'update secondScan set uploadStatus=2, fileHash="%s", fileName="%s" where filePath="%s";' % (
file_hash, file_name, file_path)
db = DBMethods()
ret = db.updateMethods(dbStr)
print("[SECOND_UPDATE_SCAN_FILE] : " + dbStr)
return ret
def DAL_update_user_second_upload_status(user_id, status):
db = DBMethods()
values = (status, user_id)
dbStr = 'update secondScan set uploadStatus="%s" where userId="%s" and uploadStatus=1;'
dbStr = dbStr % values
ret = db.updateMethods(dbStr)
return ret
def DAL_update_user_scan_status(user_id, status):
db = DBMethods()
values = (status, user_id)
dbStr = 'update computerInf set userScanStatus="%s" where userId="%s";'
dbStr = dbStr % values
ret = db.updateMethods(dbStr)
return ret
def insertStream(dbStr):
db = DBMethods()
try:
retIndex = db.updateMethods(dbStr)
except DatabaseError as e:
raise DatabaseError(e)
return retIndex
def selectStream(dbStr):
db = DBMethods()
try:
retIndex = db.selectMethods(dbStr)
except DatabaseError as e:
raise DatabaseError(e)
return retIndex
def dal_set_loginStatus(userId, userIp, status):
db_str = "update userInf, computerInf set loginStatus=%s, userIp='%s' where userInf.userId=%s and userInf.userId=computerInf.userId" % (
str(status), userIp, str(userId))
db_conn = DBMethods()
ret = db_conn.updateMethods(db_str)
return ret
def dal_set_uninstall_status(user_no):
dbStr = 'update userInf set registStatus=0,loginStatus=0 where userNo="%s";' % (
user_no)
db = DBMethods()
ret = db.updateMethods(dbStr)
return ret
def dal_update_scan_second_failed(ssId):
ssId = int(ssId)
dbStr = 'update secondScan set uploadStatus=3 where ssId=%d;' % (ssId)
db = DBMethods()
ret = db.updateMethods(dbStr)
return ret
def dal_update_scan_failed(usId):
usId = int(usId)
dbStr = 'update userScan set uploadStatus=3 where usId=%d;' % (usId)
db = DBMethods()
ret = db.updateMethods(dbStr)
return ret
def dal_update_scan_data(file_name, file_hash, file_path):
dbStr = 'update userScan set uploadStatus=2, fileHash="%s", fileName="%s" where filePath="%s";' % (
file_hash, file_name, file_path)
db = DBMethods()
ret = db.updateMethods(dbStr)
return ret