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()
