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