from ConfigParser import ConfigParser
import logging
import Mapping
import socket
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

logger = logging.getLogger("database")

def configureLogging():
    logging.basicConfig(level=logging.DEBUG)
    logging.getLogger("sqlalchemy").setLevel(logging.INFO)
    logging.getLogger("sqlalchemy.orm").setLevel(logging.WARN)

def createSession():
    databaseUrl = loadDatabaseUrl()
    engine = create_engine(databaseUrl,echo=True)
    Mapping.createMapping(engine)
    SessionMaker = sessionmaker(bind = engine)
    session = SessionMaker()
    return session

def loadDatabaseUrl():
    hostname = socket.gethostname()
    filename = "database-%s.ini" % hostname
    logger.debug("loading database configuration from " + filename)

    parser = ConfigParser();
    parser.read(filename)
    return parser.get("database", "url")