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