def test_from_db(self):
expected_results = {u'test_9trackpoints': {'start': 2, 'end': 3606}, u'test_all_trackpoints': {'start': 900, 'end': 1500}}
tcxparser = TcxParser(TEST_FILES,databasename="foo",tablename="foo2")
limits = tcxparser.get_limits_from_db('bar')
self.assertEqual(limits,expected_results)
def test_from_db_bad_db(self):
tcxparser = TcxParser(TEST_FILES,databasename="xxx",tablename="foo2")
with self.assertRaises(Exception):
limits = tcxparser.get_limits_from_db('bar')
os_file_delete(self.dname+".sqlite")
def test_from_db(self):
tcxparser = TcxParser(TEST_FILES,databasename="foo",tablename="foo2")
limits = tcxparser.get_limits_from_db('bar')
expected_results = {u'test_9trackpoints': {'start': 2, 'end': 6}, u'test_all_trackpoints': {'start': 900, 'end': 1500}}
self.assertEqual(limits,expected_results)
tcxparser.process_files(summation_type="avg",limits=limits,bucket_size=2)
tcxparser.persist()
database = Database('foo',True)
with database:
_,rows,_ = tbl_query(database,'select watts from foo2 where filename=\"test_9trackpoints\"')
self.assertListEqual(rows,self.wattsavg_points)
class TestTcxParserPersistWithLimits(unittest.TestCase):
def setUp(self):
self.test_file_name = "test_9trackpoints.tcx"
self.test_file_name2 = "test_all_trackpoints.tcx"
row = _quotestrs([["00:02","00:06","test_9trackpoints","foo_title","z2"],
["15:00","25:00","test_all_trackpoints","foo2_title","z2"]])
self.dtr_tcx = DownloadTrainerRoadTcx()
self.dtr_tcx._write_to_db(row,'foo', 'bar',DB_COLUMN_DEFN,DB_COLUMN_NAMES)
self.tcxparser = TcxParser(TEST_FILES,databasename="foo",tablename="foo")
limits = self.tcxparser.get_limits_from_db('bar')
self.tcxparser.process_files(summation_type="avg",bucket_size=3,limits=limits)
def test(self):
self.tcxparser.persist(self.test_file_name2)
database = Database('foo',True)
with database:
_,rows,_ = tbl_query(database,'select count(*) from foo where filename=\"'+os.path.splitext(self.test_file_name2)[0]+'\"')
self.assertEqual(200,rows[0][0])
