def __call__(self, chunk_size): self.logger.info( "%s (limited to %d rows)", self.statement.splitlines()[0], chunk_size) store = IMasterStore(DistroSeries) result = store.execute(self.statement, (self.series.id, chunk_size,)) self.done = (result.rowcount == 0) self.logger.info( "%d rows deleted (%s)", result.rowcount, ("done" if self.done else "not done")) store.commit()
def __call__(self, chunk_size): self.logger.info( "%s (limited to %d rows)", self.statement.splitlines()[0], chunk_size) store = IMasterStore(DistroSeries) result = store.execute(self.statement, (self.series.id, chunk_size,)) self.done = (result.rowcount == 0) self.logger.info( "%d rows deleted (%s)", result.rowcount, ("done" if self.done else "not done")) store.commit()
def main(self): "Run UpdateDatabaseTableStats." "" store = IMasterStore(Person) # The logic is in a stored procedure because we want to run # ps(1) on the database server rather than the host this script # is running on. self.logger.debug("Invoking update_database_stats()") store.execute("SELECT update_database_stats()", noresult=True) self.logger.debug("Committing") store.commit()
def main(self): "Run UpdateDatabaseTableStats.""" store = IMasterStore(Person) # The logic is in a stored procedure because we want to run # ps(1) on the database server rather than the host this script # is running on. self.logger.debug("Invoking update_database_stats()") store.execute("SELECT update_database_stats()", noresult=True) self.logger.debug("Committing") store.commit()