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
import sys sys.path.insert(0, '../database/database') from sql_insert import insertNewRow from sql_declarative import databaseCreation from sql_query import queryTable import os dbfilepath = '../database/database/rh.db' ## if file exists, delete it ## if os.path.isfile(dbfilepath) is True: os.remove(dbfilepath) print 'Old file removed.' else: print 'No existing file found.' databaseCreation() table = 'devices' rowOne = {'name':'ControllerOne','ini':'ControllerOne.ini','ip':'192.168.92.69','mac':'macAddressOne'} rowTwo = {'name':'ControllerTwo','ini':'ControllerTwo.ini','ip':'192.178.92.79','mac':'macAddressTwo'} insertNewRow(table, rowOne, 'sqlite:///../database/database/rh.db') insertNewRow(table, rowTwo, 'sqlite:///../database/database/rh.db') print 'New file created.' tablename = 'setpoints' setpointrow = {'tempSA':70,'tempMA':72,'tempPA':73,'tempSA':75,'humidityRA':20,'airFlowOA':25,'coRA':30} insertNewRow(tablename, setpointrow,'sqlite:///../database/database/rh.db') # print queryTable(table,'ip','sqlite:///../database/database/rh.db')