本文整理汇总了Python中DB.operatorCommit方法的典型用法代码示例。如果您正苦于以下问题:Python DB.operatorCommit方法的具体用法?Python DB.operatorCommit怎么用?Python DB.operatorCommit使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DB
的用法示例。
在下文中一共展示了DB.operatorCommit方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: getSubfolder
# 需要导入模块: import DB [as 别名]
# 或者: from DB import operatorCommit [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
示例2: storeToFileTable
# 需要导入模块: import DB [as 别名]
# 或者: from DB import operatorCommit [as 别名]
def storeToFileTable(DBhandle, memStore):
for i in range(len(memStore)):
dbAction(DBhandle, memStore[i][0], memStore[i][1])
DB.operatorCommit(DBhandle[0])