def test_delete_flightschedule(self): timestamp = datetime.datetime.fromtimestamp(1570749472) commands = { 'ping': (0,False), 'get-hk':(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) command1 = 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=command1.id ) with self.client: response = self.client.delete(f'api/flightschedules/{flightschedule.id}') self.assertEqual(response.status_code, 200) self.assertEqual(FlightSchedules.query.filter_by(id=flightschedule.id).first(), None) self.assertEqual( FlightScheduleCommands.query.filter_by(id=flightschedule_commands.id).first(), None )
def test_add_flight_schedule(self): timestamp = datetime.fromtimestamp(1570749472) flightschedule = add_flight_schedule(creation_date=timestamp, upload_date=timestamp, status=2, execution_time=timestamp) self.assertTrue(flightschedule.id) self.assertEqual(timestamp, flightschedule.creation_date) self.assertEqual(timestamp, flightschedule.upload_date)
def test_add_command_to_flight_schedule(self): timestamp = datetime.fromtimestamp(1570749472) command = add_telecommand(command_name='ping', num_arguments=0, is_dangerous=False) 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) self.assertTrue(flightschedule_commands.id) self.assertEqual(flightschedule_commands.timestamp, timestamp) self.assertEqual(flightschedule_commands.command_id, command.id) self.assertEqual(flightschedule_commands.flightschedule_id, flightschedule.id)
def test_patch_flight_schedule(self): timestamp = datetime.datetime.fromtimestamp(1570749472) commands = { 'ping': (0,False), 'get-hk':(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) command1 = Telecommands.query.filter_by(command_name='ping').first() command2 = Telecommands.query.filter_by(command_name='get-hk').first() flightschedule = add_flight_schedule( creation_date=timestamp, upload_date=timestamp, status=2, execution_time=timestamp) flightschedule_commands1 = add_command_to_flightschedule( timestamp=timestamp, flightschedule_id=flightschedule.id, command_id=command1.id ) flightschedule_commands2 = add_command_to_flightschedule( timestamp=timestamp, flightschedule_id=flightschedule.id, command_id=command2.id ) post_data = json.dumps(fake_patch_update_as_dict(timestamp)) with self.client: response = self.client.patch( f'api/flightschedules/{flightschedule.id}', data=post_data, content_type='application/json' ) response_data = json.loads(response.data.decode()) self.assertEqual(response.status_code, 200) self.assertEqual(len(response_data['data']['commands']), 3) self.assertEqual(response_data['data']['commands'][0]['command']['command_id'], 2) self.assertEqual(response_data['data']['commands'][2]['command']['command_id'], 1)
def test_add_arg_to_flightschedule_command(self): timestamp = datetime.fromtimestamp(1570749472) command = add_telecommand(command_name='turn-on', num_arguments=1, is_dangerous=False) 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) command_arg = add_arg_to_flightschedulecommand( index=0, argument='5', flightschedule_command_id=flightschedule_commands.id) self.assertTrue(command_arg.id) self.assertEqual(command_arg.index, 0) self.assertEqual(command_arg.argument, '5') self.assertEqual(command_arg.flightschedulecommand_id, flightschedule_commands.id)
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 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 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))