本文整理汇总了Python中DB.insertFileTable方法的典型用法代码示例。如果您正苦于以下问题：Python DB.insertFileTable方法的具体用法？Python DB.insertFileTable怎么用？Python DB.insertFileTable使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DB的用法示例。
在下文中一共展示了DB.insertFileTable方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: getSubfolder
# 需要导入模块: import DB [as 别名]
# 或者: from DB import insertFileTable [as 别名]
def getSubfolder(self, handle, fileDirectory):
conn = handle[0]
DBhandle = handle[1]
number = 0
count = 0
maxCount = 1
#backupCount = 0
#backupTableHandle = DB.initBackupDB()
while len(fileDirectory) > 0:
if os.path.exists(fileDirectory[0][0]) == False:
fileDirectory.pop(0)
continue
if fileDirectory[0][1] != count:
if fileDirectory[0][1] > maxCount:
maxCount = fileDirectory[0][1]
number = 0
tableName = "filepath_%d" % fileDirectory[0][1]
DBhandle.execute('''create table if not exists %s (CurrentId INTEGER, PreviousId INTEGER, FileName text)''' % tableName)
count = fileDirectory[0][1]
folder = fileDirectory[0][0]
if folder[-1] == "\\":
baseName = folder.split("\\")[0]
else:
baseName = os.path.basename(folder)
number += 1
DB.insertFileTable (DBhandle, tableName, number, fileDirectory[0][2], baseName)
#if backupCount%5000 == 0 and backupCount != 0:
# DB.insertBackupTable(backupTableHandle[1],backupCount/5000, folder)
#backupCount += 1
#DB.operatorCommit(backupTableHandle[0])
DB.operatorCommit(conn)
if os.path.isdir(folder):
try:
for subFolder in os.listdir(folder):
if folder[-1] != '\\':
fileDirectory.append((folder + '\\' + subFolder, fileDirectory[0][1]+1, number))
else:
fileDirectory.append((folder + subFolder, fileDirectory[0][1]+1, number))
except Exception as e:
pass
fileDirectory.pop(0)
#DB.closeDB(backupTableHandle)
return maxCount