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 = '<p>' + request.t("Hello World!") + '</p>' \
            + '<p>' + "Env:\n" + str(env) + '</p>'
      
    tables = []
    with request.connection.cursor() as cursor:
      cursor.execute('SHOW TABLES')
      for row in cursor:
        tables.append(str(list(row.values())[0]))
    content += '<p> DB tables: ' + ', '.join(tables) + '</p>'
          
    return request.complete_content(content)