def run(target, fileUUID): basename = os.path.basename(target) extensionIndex = basename.rfind(".") if extensionIndex != -1: extension = basename[extensionIndex + 1:] print "extension:", extension sql1 = """SELECT FileIDsBySingleID.fileID FROM FileIDsBySingleID JOIN FileIDs ON FileIDsBySingleID.fileID = FileIDs.pk WHERE FileIDs.fileIDType = '16ae42ff-1018-4815-aac8-cceacd8d88a8' AND FileIDsBySingleID.id = '%s' AND FileIDs.enabled = TRUE AND FileIDsBySingleID.enabled = TRUE;""" % ( escapeForDB(extension.lower())) rows = databaseInterface.queryAllSQL(sql1) for row in rows: sql2 = """INSERT INTO FilesIdentifiedIDs (fileUUID, fileID) VALUES ('%s', '%s');""" % ( escapeForDB(fileUUID), row[0]) databaseInterface.runSQL(sql2)
def run(target, fileUUID): basename = os.path.basename(target) extensionIndex = basename.rfind(".") if extensionIndex != -1: extension = basename[extensionIndex+1:] print "extension:", extension sql = """INSERT INTO FilesIdentifiedIDs (fileUUID, fileID) VALUES ('%s', (SELECT FileIDs FROM FileIDsByExtension WHERE Extension = '%s'))""" % (escapeForDB(fileUUID), escapeForDB(extension.lower())) databaseInterface.runSQL(sql)
def run(target, fileUUID): basename = os.path.basename(target) extensionIndex = basename.rfind(".") if extensionIndex != -1: extension = basename[extensionIndex+1:] print "extension:", extension sql1= """SELECT FileIDsBySingleID.fileID FROM FileIDsBySingleID JOIN FileIDs ON FileIDsBySingleID.fileID = FileIDs.pk WHERE FileIDs.fileIDType = '16ae42ff-1018-4815-aac8-cceacd8d88a8' AND FileIDsBySingleID.id = '%s' AND FileIDs.enabled = TRUE AND FileIDsBySingleID.enabled = TRUE;""" % (escapeForDB(extension.lower())) rows = databaseInterface.queryAllSQL(sql1) for row in rows: sql2 = """INSERT INTO FilesIdentifiedIDs (fileUUID, fileID) VALUES ('%s', '%s');""" % (escapeForDB(fileUUID), row[0]) databaseInterface.runSQL(sql2)