def remove_ballast_from_virtual_group():
ballast_id = request.args.get('ballast_id')
virtual_group_id = request.args.get('virtual_group_id')
db = Database()
sql_string = 'DELETE FROM virtual_group_items WHERE ballast_id=' + ballast_id + ' AND virtual_group_id=' + virtual_group_id
db.execute(sql_string)
return 'http200'
def add_ballast_to_virtual_group():
ballast_id = request.args.get('ballast_id')
virtual_group_id = request.args.get('virtual_group_id')
db = Database()
sql_string = 'INSERT INTO virtual_group_items (ballast_id, virtual_group_id) VALUES (' + ballast_id + ', ' + virtual_group_id + ')'
db.execute(sql_string)
return 'http200'
def rename_virtual_group():
virtual_group_ID = request.args.get('virtual_group_id')
group_name = request.args.get('new_name')
db = Database()
sql_string = 'UPDATE virtual_group SET name="' + group_name + '" WHERE ID = ' + virtual_group_ID
db.execute(sql_string)
return 'http200'
def remove_virtual_group():
virtual_group_ID = request.args.get('virtual_group_id')
db = Database()
sql_string = 'DELETE FROM virtual_group_items WHERE virtual_group_id = ' + virtual_group_ID
db.execute(sql_string)
sql_string = 'DELETE FROM virtual_group WHERE ID = ' + virtual_group_ID
db.execute(sql_string)
return 'http200'
from classes.Table import Table
from classes.Database import Database
from classes.Metro import Metro
if len(sys.argv) != 3:
print('Please provide the agency and line number')
exit()
agency = str(sys.argv[1])
agency_sanitized = agency.replace('-', '_')
line = str(sys.argv[2])
tracking_data = Database('log.db')
table = Table(agency_sanitized, line)
tracking_data.execute(table.create())
vehicles = Metro.get_vehicles(agency, line)
server_time = int(vehicles.timestamp())
for vehicle in vehicles.parse():
if table.all_fields_present(vehicle):
tracking_data.cursor.execute(table.insert(), [
int(server_time),
int(vehicle['seconds_since_report']),
int(vehicle['id']),
float(vehicle['latitude']),
float(vehicle['longitude']),
float(vehicle['heading'])
])
tracking_data.save_and_close()
def insert_virtual_group():
group_name = request.args.get('group_name')
db = Database()
sql_string = 'INSERT INTO virtual_group (name) VALUES ("' + group_name + '")'
db.execute(sql_string)
return 'http200'
"dali_event_valid_on_wednesday INTEGER",
"dali_event_valid_on_thursday INTEGER",
"dali_event_valid_on_friday INTEGER",
"dali_event_valid_on_saturday INTEGER",
"dali_event_valid_on_sunday INTEGER",
"dali_event_valid_on_occupied INTEGER",
"dali_event_valid_on_empty INTEGER",
"dali_event_valid_on_sleep INTEGER",
"dali_event_valid_on_leaving INTEGER",
"dali_event_valid_on_going_to_sleep INTEGER",
"dali_event_valid_on_light INTEGER",
"dali_event_valid_on_dark INTEGER"]
db.insert_columns( table_name, columns)
# ********************************************************
table_name = 'dalichannels'
db.create_table(table_name)
columns = ["channel_nr INTEGER",
"channel_name TEXT DEFAULT ''",
"channel_com_port TEXT DEFAULT ''"]
db.insert_columns( table_name, columns)
data = db.select('SELECT * FROM sites')
if len(data) == 0:
db.execute('INSERT INTO sites (site_nr_of_chans, site_occupied) VALUES (1,1);')
db.insert_ballasts()
