def seed_db():
"""Seed the database with a set of users and flight schedules
"""
timestamp = datetime.fromtimestamp(1570749472)
for x in range(20):
# 20 days
for y in range(3):
# 3 entries per day
housekeepingData = fakeHousekeepingAsDict(
timestamp + timedelta(days=x, minutes=y * 15))
if (x + y) % 10 == 0:
housekeepingData['satellite_mode'] = 'Danger'
housekeeping = Housekeeping(**housekeepingData)
for i in range(1, 25):
channel = fake_power_channel_as_dict(i)
p = PowerChannels(**channel)
housekeeping.channels.append(p)
db.session.add(housekeeping)
db.session.commit()
commands = {
'ping': (0, False),
'get-hk': (0, False),
'turn-on': (1, True),
'turn-off': (1, True),
'upload-fs': (0, False),
'adjust-attitude': (1, True),
'magnetometer': (0, False),
'imaging': (0, False)
}
for name, (num_args, is_danger) in commands.items():
c = add_telecommand(command_name=name,
num_arguments=num_args,
is_dangerous=is_danger)
command = Telecommands.query.filter_by(command_name='ping').first()
flightschedule = add_flight_schedule(creation_date=timestamp,
upload_date=timestamp,
status=2,
execution_time=timestamp)
flightschedule_commands = add_command_to_flightschedule(
timestamp=timestamp,
flightschedule_id=flightschedule.id,
command_id=command.id)
add_user(username='******', password='******', is_admin=True)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=True)
command = Telecommands.query.filter_by(command_name='turn-on').first()
flightschedule_commands = add_command_to_flightschedule(
timestamp=timestamp,
flightschedule_id=flightschedule.id,
command_id=command.id)
flightschedulecommand_arg = add_arg_to_flightschedulecommand(
index=0,
argument='5',
flightschedule_command_id=flightschedule_commands.id)
message = add_message_to_communications(timestamp=timestamp,
message='ping',
sender='user',
receiver='comm')
now = datetime.utcnow()
add_passover(timestamp=now - timedelta(seconds=10))
for i in range(1, 20):
p = add_passover(timestamp=now + timedelta(minutes=i * 5))
def setUp(self):
self.driver = webdriver.Firefox()
self.driver.get(self.get_server_url())
db.drop_all()
db.create_all()
db.session.commit()
# seed the database for testing
timestamp = datetime.fromtimestamp(1570749472)
for i in range(20):
housekeepingData = fakeHousekeepingAsDict(timestamp + timedelta(
minutes=i * 15))
housekeeping = Housekeeping(**housekeepingData)
for i in range(1, 25):
channel = fake_power_channel_as_dict(i)
p = PowerChannels(**channel)
housekeeping.channels.append(p)
db.session.add(housekeeping)
db.session.commit()
commands = {
'ping': (0, False),
'get-hk': (0, False),
'turn-on': (1, True),
'turn-off': (1, True),
'set-fs': (1, True),
'upload-fs': (0, False)
}
for name, (num_args, is_danger) in commands.items():
c = add_telecommand(command_name=name,
num_arguments=num_args,
is_dangerous=is_danger)
command = Telecommands.query.filter_by(command_name='ping').first()
flightschedule = add_flight_schedule(creation_date=timestamp,
upload_date=timestamp,
status=2,
execution_time=timestamp)
flightschedule_commands = add_command_to_flightschedule(
timestamp=timestamp,
flightschedule_id=flightschedule.id,
command_id=command.id)
add_user(username='******', password='******', is_admin=True)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=False)
command = Telecommands.query.filter_by(command_name='turn-on').first()
flightschedule_commands = add_command_to_flightschedule(
timestamp=timestamp,
flightschedule_id=flightschedule.id,
command_id=command.id)
flightschedulecommand_arg = add_arg_to_flightschedulecommand(
index=0,
argument='5',
flightschedule_command_id=flightschedule_commands.id)
message = add_message_to_communications(timestamp=timestamp,
message='ping',
sender='user',
receiver='comm')
now = datetime.utcnow()
add_passover(timestamp=now - timedelta(seconds=10))
for i in range(1, 20):
p = add_passover(timestamp=now + timedelta(minutes=i * 5))
db.session.commit()
def demo_db():
timestamp = datetime.fromtimestamp(1570749472)
time2 = datetime.fromisoformat('2019-11-04 00:05:23.283+00:00')
#time3 = datetime.fromisoformat('2019-11-05 00:08:43.203+00:00')
#time4 = datetime.fromisoformat('2019-11-05 00:15:20.118+00:00')
housekeepingData = fakeHousekeepingAsDict(timestamp)
hkd2 = fakeHousekeepingAsDict(time2)
#hkd3 = fakeHousekeepingAsDict(time3)
#hkd4 = fakeHousekeepingAsDict(time4)
housekeeping = Housekeeping(**housekeepingData)
hk2 = Housekeeping(**hkd2)
#hk3 = Housekeeping(**hkd3)
#hk4 = Housekeeping(**hkd4)
db.session.add(housekeeping)
db.session.add(hk2)
#db.session.add(hk3)
#db.session.add(hk4)
db.session.commit()
add_user(username='******', password='******', is_admin=True)
add_user(username='******', password='******', is_admin=True)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=False)
add_user(username='******', password='******', is_admin=False)
commands = {
'ping': (0, False),
'get-hk': (0, False),
'turn-on': (1, True),
'turn-off': (1, True),
'set-fs': (1, True),
'upload-fs': (0, False)
}
for name, (num_args, is_danger) in commands.items():
c = add_telecommand(command_name=name,
num_arguments=num_args,
is_dangerous=is_danger)
command = Telecommands.query.filter_by(command_name='ping').first()
flightschedule = add_flight_schedule(creation_date=timestamp,
upload_date=timestamp,
status=2)
flightschedule_commands = add_command_to_flightschedule(
timestamp=timestamp,
flightschedule_id=flightschedule.id,
command_id=command.id)
command = Telecommands.query.filter_by(command_name='turn-on').first()
flightschedule_commands = add_command_to_flightschedule(
timestamp=timestamp,
flightschedule_id=flightschedule.id,
command_id=command.id)
flightschedulecommand_arg = add_arg_to_flightschedulecommand(
index=0,
argument='5',
flightschedule_command_id=flightschedule_commands.id)
message = add_message_to_communications(timestamp=timestamp,
message='ping',
sender='user',
receiver='comm')
command = Telecommands.query.filter_by(command_name='ping').first()
flightschedule = add_flight_schedule(creation_date=time2,
upload_date=time2,
status=2)
flightschedule_commands = add_command_to_flightschedule(
timestamp=time2,
flightschedule_id=flightschedule.id,
command_id=command.id)
flightschedulecommand_arg = add_arg_to_flightschedulecommand(
index=1,
argument='5',
flightschedule_command_id=flightschedule_commands.id)
message = add_message_to_communications(timestamp=time2,
message='ping',
sender='user',
receiver='comm')
now = datetime.utcnow()
add_passover(timestamp=now - timedelta(seconds=10))
for i in range(5):
add_passover(timestamp=now + timedelta(minutes=i * 10))