HYTOS

# _*_ coding: utf-8 _*_

import sqlite3

from flask import Flask

app = Flask(__name__)

DATABASE = 'C:\\ProgramData\\Digital PID\\App.db'

def get_db():

    db = getattr(Flask, '_database', None)

    if db is None:

        db = Flask._database = sqlite3.connect(DATABASE)

        db.row_factory = make_dicts

    return db

def query_db(query, args=(), one=False):

    cur = get_db().execute(query, args)

    rv = cur.fetchall()

    cur.close()

    return (rv[0] if rv else None) if one else rv

def make_dicts(cursor, row):

    return dict((cursor.description[idx][0], value)

                for idx, value in enumerate(row))

@app.teardown_appcontext

def close_connection(exception):

    db = getattr(Flask, '_database', None)

    if db is not None:

        db.close()

        Flask._database = None

    app.logger.debug('close connection')

@app.route('/')

def hello_world():

    configs = None

    for config in query_db('select * from Configuration'):

        if configs is None:

            configs = config['Section'] + ',' + config['Key'] + ',' + config['Value']

        else:

            configs += config['Section'] + ',' + config['Key'] + ',' + config['Value'] + '\n'

    return configs

@app.route('/main')

def main():

    return 'Main Page'

@app.route('/user/id/<int:userId>')

def showUserProfileById(userId):

    return 'USER ID : %d' % userId

@app.route('/user/<username>')

def showUserProfile(username):

    app.logger.debug('RETRIEVE DATA - USER ID : %s' % username)

    app.logger.debug('RETRIEVE DATA - Check Compelete')

    app.logger.warn('RETRIEVE DATA - Warning... User Not Found.')

    app.logger.error('RETRIEVE DATA - ERR! User unauthenification.')

    return 'USER : %s' % username

if __name__ == '__main__':

    app.run()