from config import config

from server import Server

from request import Request

from db.holder import Holder as ConnectionHolder

import template.common

server = Server(config)

def application(env, start_response):

  request = Request(server, env, start_response)

  readonly = request.method == 'GET'

  with ConnectionHolder(request.server.dbpool, readonly = readonly) as conn:

    request.connection = conn

    request.template = template.common.instance

    content = request.t("Hello World!")

    content += '
' + "Env:\n" + str(env) + '
'

    tables = list(v[0] for v in request.connection.query_list('SHOW TABLES'))

    content += '
DB tables: ' + ', '.join(tables) + '
'

    rows = request.connection.query_dict('SELECT * FROM %T', 'test')

    content += '
Rows of test table: ' + str(rows) + '
'

    return request.complete_content(content)