from flask import Flask, send_file, make_response, redirect, request
from ezmysql import TableDef
from configfile import ConfigFile
from requests import post as http_post
CONFIG = ConfigFile('./itapps.cfg')
DB_server = CONFIG.Get('DBServer')
DB_user = CONFIG.Get('DBUser')
DB_password = CONFIG.Get('DBPassword')
TABLES = Config.Get('DBTables').split(',')
# Configure table objects
TABLES = [{"name" : a,"def" : TableDef(DB_server,DB_user,DB_password,a)} for a in TABLES]
# Pull schema
for thisTable in DB_tables:
thisTable['schema'] = thisTable['def'].Schema()
ROOT = '/var/www/python/dbedit'
app = Flask(__name__)
@app.route('/')
def getroot():
return render_template('{}/templates/show_tables.html'.format(ROOT),tables=[a['name'] for a in DB_tables])
@app.routes('/<table>/list')
def TableList(table):
tableAr = [a for a in DB_tables if a['name'] == table]
if len(tableAr) == 1:
