def setUp(self) -> None: query = "SELECT QUOTEID,SYMBOL, CONCAT(QUOTE_DATE,' ',QUOTIM) AS TIME FROM daily_1m ORDER BY TIME DESC LIMIT 7" self.time_interval = 60 self.recent_7_ticks = DB(1).get_data_from_db(query) self.tick_times = self.recent_7_ticks['TIME'].values.tolist()
def test_daily30s_is_complete(self): query = f"SELECT * FROM daily_30s WHERE QUOTE_DATE = '{self.date}'" total_ticks = DB(1).get_data_from_db(query) self.assertEqual(20160, total_ticks.__len__())