def main(): db = database_connection() picloud = SubClient( url=PICLOUD_SUB_URL, api_key=PICLOUD_API_KEY, client_name='THPL-Data-Logger') def on_thpl_data(data): cursor = db.cursor() cursor.callproc('thpl_data_insert', ['home', data]) cursor.close() picloud.subscribe(event='home:thpl', callback=on_thpl_data) while True: picloud.process_subscriptions()
from app.utils.database import database_connection db = database_connection() class DatabaseCursorOpen(object): def process_resource(self, req, resp, resource): resource.db = db resource.cursor = db.cursor() class DatabaseCursorClose(object): def process_response(self, req, resp, resource): resource.cursor.close()
import falcon from app.middleware.body_parser import JSONBodyParser from app.middleware.auth import AuthUser from app.utils.database import database_connection db = database_connection() middleware = [JSONBodyParser(), AuthUser()] api = falcon.API(middleware=middleware) from app import routes
def main(): db = database_connection() cursor = db.cursor() for proc in PROCS: cursor.callproc(proc)