def get_order_by_drone_id(drone_id: str) -> DroneOrder: ''' Gets current order if given drone has one. ''' return map_to_object( fetchone('SELECT protocol FROM drone_order WHERE drone_id = :drone_id', {'drone_id': drone_id}), DroneOrder)
def get_discord_id_of_drone(drone_id: str) -> str: ''' Returns the discord ID associated with a given drone ''' return map_to_object( fetchone('SELECT id FROM drone WHERE drone_id = :drone_id', {'drone_id': drone_id}), Drone)
def fetch_drone_with_drone_id(drone_id: str) -> Drone: ''' Finds a drone with the given drone_id. ''' return map_to_object( fetchone( 'SELECT id, drone_id, optimized, glitched, trusted_users, last_activity FROM drone WHERE drone_id = :drone_id', {'drone_id': drone_id}), Drone)
def fetch_storage_by_target_id(drone_id: str) -> Storage: ''' Fetch a single storage by the target_id. ''' return map_to_object( fetchone( 'SELECT id, stored_by, target_id, purpose, roles, release_time FROM storage WHERE target_id = :drone_id', {'drone_id': drone_id}), Storage)