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!") + '
' \

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

    tables = []

    with request.connection.cursor() as cursor:

      cursor.execute('SHOW TABLES')

      for row in cursor:

        tables.append(str(list(row.values())[0]))

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

    return request.complete_content(content)