-from types import StringTypes
-
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
class Alchemy:
def __init__ (self, config):
- dbname="sfa"
+ dbname = "sfa"
# will be created lazily on-demand
self._session = None
# the former PostgreSQL.py used the psycopg2 directly and was doing
except:
pass
self.engine=None
- raise Exception,"Could not connect to database %s as %s with psycopg2"%(dbname,config.SFA_DB_USER)
+ raise Exception("Could not connect to database %s as %s with psycopg2"%(dbname,config.SFA_DB_USER))
# expects boolean True: debug is ON or False: debug is OFF
def session (self):
Session=sessionmaker()
session=Session (bind=self.engine)
- logger.info('alchemy.session created session %s'%session)
+ logger.debug('alchemy.session created session %s'%session)
return session
def close_session (self, session):
- logger.info('alchemy.close_session closed session %s'%session)
+ logger.debug('alchemy.close_session closed session %s'%session)
session.close()
####################