def generic_bug(self, files):
with NamedTemporaryFile() as f:
args, sys, db = bootstrap_file(f, m(V), '5')
bootstrap_file(f, m(V), '5', mm(DEV), configurator=default)
for file in files:
args, sys, db = bootstrap_file(
f, m(V), '5', mm(DEV), 'monitor', mm(FAST),
'data/test/source/personal/[email protected]_%s.fit' %
file)
monitor(args, sys, db)
# run('sqlite3 %s ".dump"' % f.name, shell=True)
run_pipeline(sys,
db,
PipelineType.STATISTIC,
force=True,
start='2018-01-01',
n_cpu=1)
# run('sqlite3 %s ".dump"' % f.name, shell=True)
with db.session_context() as s:
# steps
summary = s.query(StatisticJournal).join(StatisticName). \
filter(StatisticJournal.time >= local_date_to_time('2018-10-07'),
StatisticJournal.time < local_date_to_time('2018-10-08'),
StatisticName.owner == MonitorCalculator,
StatisticName.name == DAILY_STEPS).one()
# connect has 3031 for this date.
self.assertEqual(summary.value, 3031)
def generic_bug(self, files, join=False):
with TemporaryDirectory() as f:
args, data = bootstrap_dir(f, m(V), '5')
bootstrap_dir(f, m(V), '5', mm(DEV), configurator=default)
if join:
files = [
'data/test/source/personal/[email protected]_%s.fit' % file
for file in files
]
args, data = bootstrap_dir(f, mm(DEV), 'read', *files)
read(args, data)
else:
for file in files:
args, data = bootstrap_dir(
f, mm(DEV), 'read',
'data/test/source/personal/[email protected]_%s.fit' %
file)
read(args, data)
# run('sqlite3 %s ".dump"' % f.name, shell=True)
with data.db.session_context() as s:
# steps
summary = s.query(StatisticJournal).join(StatisticName). \
filter(StatisticJournal.time >= local_date_to_time('2018-10-07'),
StatisticJournal.time < local_date_to_time('2018-10-08'),
StatisticName.owner == MonitorCalculator,
StatisticName.name == N.DAILY_STEPS).one()
# connect has 3031 for this date.
self.assertEqual(summary.value, 3031)
def test_values(self):
with NamedTemporaryFile() as f:
bootstrap_file(f, m(V), '5')
bootstrap_file(f, m(V), '5', mm(DEV), configurator=default)
for file in ('24696157869', '24696160481', '24696163486'):
args, db = bootstrap_file(f, m(V), '5', mm(DEV),
'monitor', mm(FAST),
'data/test/source/personal/[email protected]_%s.fit' % file)
monitor(args, db)
# run('sqlite3 %s ".dump"' % f.name, shell=True)
run_pipeline(db, PipelineType.STATISTIC, force=True, start='2018-01-01', n_cpu=1)
run('sqlite3 %s ".dump"' % f.name, shell=True)
with db.session_context() as s:
mjournals = s.query(MonitorJournal).order_by(MonitorJournal.start).all()
assert mjournals[2].start == to_time('2018-09-06 15:06:00'), mjournals[2].start
print(mjournals[2].fit_file)
# steps
summary = s.query(StatisticJournal).join(StatisticName). \
filter(StatisticJournal.time >= local_date_to_time('2018-09-06'),
StatisticJournal.time < local_date_to_time('2018-09-07'),
StatisticName.owner == MonitorCalculator,
StatisticName.name == DAILY_STEPS).one()
# connect has 12757 for this date,
self.assertEqual(summary.value, 12757)
# heart rate
summary = s.query(StatisticJournal).join(StatisticName). \
filter(StatisticJournal.time >= local_date_to_time('2018-09-06'),
StatisticJournal.time < local_date_to_time('2018-09-07'),
StatisticName.owner == MonitorCalculator,
StatisticName.name == REST_HR).one()
self.assertEqual(summary.value, 45)
def test_values(self):
with TemporaryDirectory() as f:
bootstrap_dir(f, m(V), '5')
bootstrap_dir(f, m(V), '5', mm(DEV), configurator=default)
for file in ('24696157869', '24696160481', '24696163486'):
args, data = bootstrap_dir(
f, m(V), '5', mm(DEV), 'read', mm(MONITOR),
'data/test/source/personal/[email protected]_%s.fit' %
file)
read(args, data)
# path = args.system_path(subdir='data', file='activity.db')
# run(f'sqlite3 {path} ".dump"', shell=True)
run_pipeline(data,
PipelineType.CALCULATE,
force=True,
like=('%Monitor%', ),
start='2018-01-01',
n_cpu=1)
with data.db.session_context() as s:
mjournals = s.query(MonitorJournal).order_by(
MonitorJournal.start).all()
assert mjournals[2].start == to_time(
'2018-09-06 15:06:00'), mjournals[2].start
# steps
summary = s.query(StatisticJournal).join(StatisticName). \
filter(StatisticJournal.time >= local_date_to_time('2018-09-06'),
StatisticJournal.time < local_date_to_time('2018-09-07'),
StatisticName.owner == MonitorCalculator,
StatisticName.name == N.DAILY_STEPS).one()
if summary.value != 12757:
path = args.system_path(subdir='data', file='activity.db')
run('sqlite3 %s "select * from statistic_journal as j, statistic_journal_integer as i, '
'statistic_name as n where j.id = i.id and j.statistic_name_id = n.id and '
'n.name = \'steps\' order by j.time"' % path,
shell=True)
run('sqlite3 %s "select * from statistic_journal as j, statistic_journal_integer as i, '
'statistic_name as n where j.id = i.id and j.statistic_name_id = n.id and '
'n.name = \'cumulative-steps\' order by j.time"' %
path,
shell=True)
# connect has 12757 for this date,
self.assertEqual(summary.value, 12757)