def deleteFromIdList(self, lNum):
if lNum == []:
return
TablePathAdaptator.deleteFromIdList(self, lNum)
sqlCmd = 'delete from %s where path=%d' % (self._table_idx, lNum[0])
for i in lNum[1:]:
sqlCmd += " or path=%d" % (i)
sqlCmd += ";"
self._iDb.execute(sqlCmd)
print string
logging.info( string )
string = "number of path(s) to remove: %i" % ( count )
logging.info( string )
if verbose > 0:
print string
lSetIdToRemovePaths.sort()
if verbose > 1:
print lSetIdToRemovePaths; sys.stdout.flush()
for i in xrange(0,len(lSetIdToRemovePaths),20):
lPathIdToRemove = lSetIdToRemovePaths[i:i+20]
if qtype == "path":
qtablePathAdaptator.deleteFromIdList( lPathIdToRemove )
elif qtype == "set":
qtableSetAdaptator.deleteFromIdList( lPathIdToRemove )
db.dropTable( "%s_bin" % ( stable ) )
db.close()
logging.info( "finished" )
if verbose > 0:
print "END %s" % (sys.argv[0].split("/")[-1])
sys.stdout.flush()
return 0
