import sqlalchemy

import sqlalchemy.orm

import config

import datetime

engine = sqlalchemy.create_engine(config.URI)

metadata = sqlalchemy.MetaData(bind=engine)

session = sqlalchemy.orm.scoped_session(sqlalchemy.orm.sessionmaker(bind=engine))

query = session.query_property()

class Model(object):

    query = query

def tableFactory(tablename):

    """Return a class type"""

    class LoadedTable(Model):

        pass

    LoadedTable.__name__ = tablename

    return LoadedTable

class Logger:

    def __init__(self, tablename):

        """This method loads a table from the database and maps it to LoadedTable class.

        The loaded table is available through the "lt" data member."""

        table = sqlalchemy.Table(tablename, metadata, autoload=True)

        self.lt = tableFactory(tablename)

        sqlalchemy.orm.mapper(self.lt, table)