import sys sys.path.insert(0, '../database/database') from sql_declarative import databaseCreation from sql_insert import insertNewRow from sql_query import queryRowSpecific, queryColumn, queryRow, queryTable, queryValue, queryValueSpecific print databaseCreation() table = 'Devices' rowOne = {'name':'Hello!','ini':'ControllerOne.ini','ip':'192.168.92.69','mac':'macAddressOne'} rowTwo = {'name':'ControllerTwo','ini':'ControllerTwo.ini','ip':'192.168.92.70','mac':'macAddressTwo'} rowThree = {'name':'ControllerThree','ini':'ControllerThree.ini','ip':'192.168.92.71','mac':'macAddressThree'} rowFour = {'name':'ControllerFour','ini':'ControllerFour.ini','ip':'192.168.92.72','mac':'macAddressFour'} insertNewRow(table, rowOne) insertNewRow(table, rowTwo) insertNewRow(table, rowThree) insertNewRow(table, rowFour) tablename = 'Setpoints' setpointrow = {'tempSA':10000,'tempMA':72,'tempPA':73,'tempSA':75,'humidityRA':20,'airFlowOA':25,'coRA':30} insertNewRow(tablename, setpointrow) value =queryTable('Devices','name') print value valuetwo = queryTable('Setpoints','id') print valuetwo
def return_equipment_list(): queryResult = queryTable("Devices") #print queryResult["ControllerThree"] return jsonify(queryResult)
import sys sys.path.insert(0, '../database-files') from sql_insert import insertNewRow from sql_query import queryRowSpecific, queryColumn, queryRow, queryTable, queryValue, queryValueSpecific table = 'Devices' rowOne = {'name':'ControllerOne','ini':'ControllerOne.ini','ip':'192.168.92.69','mac':'macAddressOne'} rowTwo = {'name':'ControllerTwo','ini':'ControllerTwo.ini','ip':'192.168.92.70','mac':'macAddressTwo'} rowThree = {'name':'ControllerThree','ini':'ControllerThree.ini','ip':'192.168.92.71','mac':'macAddressThree'} rowFour = {'name':'ControllerFour','ini':'ControllerFour.ini','ip':'192.168.92.72','mac':'macAddressFour'} insertNewRow(table, rowOne) insertNewRow(table, rowTwo) insertNewRow(table, rowThree) insertNewRow(table, rowFour) tablename = 'Setpoints' setpointrow = {'tempSA':70,'tempPA':72,'tempMA':73,'tempSA':75,'humidityRA':20,'airFlowOA':21,'airFlowRA':25} insertNewRow(tablename, setpointrow) value =queryTable('Devices','name') print value
import sys sys.path.insert(0, '../database/database') from sql_query import queryTable print "Controller One:" queryResult = queryTable("controllerone", 'timestamp', 'sqlite:///../database/database/rh.db') print queryResult print "\nController Two:" queryResult = queryTable("controllertwo", 'timestamp', 'sqlite:///../database/database/rh.db') print queryResult
def return_trend_data(controller_id): print controller_id queryResult = queryTable(controller_id, 'timestamp', 'sqlite:///../../database/database/rh.db') return jsonify(queryResult)
def return_equipment_list(): queryResult = queryTable("devices", 'name', 'sqlite:///../../database/database/rh.db') #print queryResult["ControllerThree"] return jsonify(queryResult)