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()