def get_expired_house_count(self): sum = 0 date = Utils.getDeltaDate(days=6) for city in self.city_list: sql = 'SELECT count(*) FROM %s WHERE date < "%s"' % (city, date) self.cursor.execute(sql) self.conn.commit() result = self.cursor.fetchone()['count(*)'] sum += result return sum
def backup_history_record(self): date = Utils.getDeltaDate(days=7) for city in self.city_list: sql = 'SELECT * FROM ' + city + ' WHERE date < "%s"' % (date) self.cursor.execute(sql) self.conn.commit() result = self.cursor.fetchall() self.write_history_houses(result) sql = 'DELETE FROM ' + city + ' WHERE date< "%s"' % (date) self.cursor.execute(sql) self.conn.commit()