def setReading():
engine = db_access.get_db_engine(DB)
# Set Reading
sp = 'sensorcis.set_reading'
db_access.execute_postgreql_json_stored_procedure(engine, sp,
{'internal_id': '0000-0000-0000-0002',
'r_value_1': 18, 'r_value_2': 7, 'r_value_3': None,
'r_when': str(datetime.datetime.now()),
'duration': 15, 'latitude': 53.6478,
'longitude': -6.3597, 'altitude': None,
'user_id': 1})
def test():
engine = db_access.get_db_engine(DB)
get_app_users(engine)
# Set Reading
sp = 'sensorcis.set_reading'
sp_results = db_access.execute_postgreql_json_stored_procedure(engine, sp,
{'internal_id': '0000-0000-0000-0002',
'r_value_1': 18, 'r_value_2': 7, 'r_value_3': None,
'r_when': str(datetime.datetime.now()),
'duration': 15, 'latitude': 53.6478,
'longitude': -6.3597, 'altitude': None,
'user_id': 1})
print_rows(sp, sp_results)
reading_id = sp_results[0]['create_reading']
# Get Products
print_sp_results(engine, 'sensorcis.get_products', {'user_id': 1})
# Get Unlinked Devices
sp = 'sensorcis.get_readings_for_unlinked_devices'
sp_results = db_access.execute_postgreql_json_stored_procedure(engine, sp, {'user_id': 1})
print_rows(sp, sp_results)
# Link Device
sp = 'sensorcis.link_device'
sp_results = db_access.execute_postgreql_json_stored_procedure(engine, sp,
{'reading_id': reading_id,
'external_id': '151 D 10126',
'organisation_id': None, 'product_id': 1,
'description': None, 'user_id': 1})
print_rows(sp, sp_results)
device_id = sp_results[0]['create_device']
# Get Organisations
print_sp_results(engine, 'sensorcis.get_organisations', {'user_id': 1})
# Get Unregistered Devices
print_sp_results(engine, 'sensorcis.get_unregistered_devices', {'user_id': 1})
# Register Device
print_sp_results(engine, 'sensorcis.register_device', {'device_id': device_id, 'organisation_id': 2, 'user_id': 1})
# Get Unassigned Entities
print_sp_results(engine, 'sensorcis.get_unassigned_entities', {'user_id': 3, 'entity_type_id': 1})
# Get Registered Devices
print_sp_results(engine, 'sensorcis.get_registered_devices', {'user_id': 3})
# Assign Entity to Device
print_sp_results(engine, 'sensorcis.assign_entity_to_device', {'device_id': device_id, 'entity_id': 2,
'start_date': '2015-05-01',
'user_id': 3})
