import Mapping
import sqlalchemy
import sqlalchemy.orm
import util

# Keep the connection to the database only once. The feed updater and the GUI app will
# operate on a single engine/session but this comes in handy for interactive use
engine = None
SessionMaker = None

def createSession():
    databaseUrl = util.loadDatabaseUrl()
    initEngine(databaseUrl)
    Mapping.createMapping(engine)
    initSessionMaker()
    return SessionMaker()

def initEngine(databaseUrl):
    global engine
    if engine is None:
        engine = sqlalchemy.create_engine(databaseUrl, echo=False)

def initSessionMaker():
    global SessionMaker
    if SessionMaker is None:
        SessionMaker = sqlalchemy.orm.sessionmaker(bind=engine)