#How to install sqlite on flask code#

before_request ( before_request ) viewsbp. conn = get_db_connection ( db_name ) # close db connection after request def after_request ( response ): if g. db.database import get_db_connection # pylint: disable=invalid-name viewsbp = Blueprint ( 'viewsbp', _name_, url_prefix = '/' ) # get a db connection before request def before_request (): # Retrieve database settings from application configuration db_name = current_app. There are two important additions to the _init_.py file above:įrom contextlib import closing from flask import Blueprint, current_app, g, redirect, render_template, request, url_for from.

get_root_path ( 'container/conf/db/schema.sql' ) create_db ( db_name ) execute_schema_sql ( db_name, schema_file_path ) return qflask viewsbp ) # create db by loading schema db_name = qflask. route ( '/debug' ) def debug (): return 'Pong!' # Import additional endpoints. # The endpoint function should contain a trivial implementation # that returns a simple confirmation response message. create_log () # To enable app health checking, the QRadar App Framework # requires every Flask app to define a /debug endpoint. q_url_for, 'q_url_for' ) # Initialize logging. format ( qradar_app_id ) return resp # Register q_url_for function for use with Jinja2 templates. get_app_id () # Create unique session cookie name for this app. qflask = Flask ( _name_ ) # Retrieve QRadar app id. def create_app (): # Create a Flask instance. db.database import create_db, execute_schema_sql from flask import Flask from qpylib import qpylib # Flask application factory.

#How to install sqlite on flask code#

connect ( db_path ) return conn Create the Python Initialisation CodeĮdit the Python initialisation code in app/_init_.py to include loading the custom configuration and initialising the SQLite database by executing the SQL schema: join ( DB_STORAGE_PATH, db_name ) conn = sqlite3. commit () # Get db connection to sqlite database using the parameter provided def get_db_connection ( db_name ): db_path = os. get_store_path ( 'db' ) # Create the database specified in the parameters provided def create_db ( db_name ): get_db_connection ( db_name ) # Execute the specified sql file against the database in the parameters provided def execute_schema_sql ( db_name, schema_file_path ): conn = get_db_connection ( db_name ) with conn : with open ( schema_file_path, mode = 'r' ) as schema_file : cur = conn. Import os import sqlite3 from contextlib import closing from qpylib import qpylib DB_STORAGE_PATH = qpylib.