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 += '<p>' + "Env:\n" + str(env) + '</p>'
      
    tables = list(v[0] for v in request.connection.query_list('SHOW TABLES'))
    content += '<p>DB tables: ' + ', '.join(tables) + '</p>'
    
    rows = request.connection.query_dict('SELECT * FROM %T', 'test')
    content += '<p>Rows of test table: ' + str(rows) + '</p>'
          
    return request.complete_content(content)