source: mauRepo/MolesManager/trunk/src/MolesManager/dataaccess.py @ 8014

'''
Created on 3 Nov 2011

@author: mnagni
'''
from MolesManager.settings import MOLES3DB
from ea_model.iso_19103_2005_schema_language.basic_types.primitive.date_and_time.date import Date
from ea_model.ceda_moles.ceda_observation.ceda_observation import CEDA_Observation


def _buildFilter(key, keyValue):
    return '%s = \'%s\'' % (key, keyValue)

def _checkSession(session):
    if session is None:
        return MOLES3DB.getSession()
    else:
        return session

def doInsert(toStoreInstance, session = None): 
    session = _checkSession(session)
    session.add(toStoreInstance)
    session.commit()

def getCEDA_ObservationById(id, session = None):     
    session = _checkSession(session)
    res = session.query(CEDA_Observation).filter(*[_buildFilter('mo_observation_id', id)])
    print(res)
    return res.all()

def getDateById(id, session = None):     
    session = _checkSession(session)
    res = session.query(Date).filter(*[_buildFilter('date_id', id)])
    print(res)
    return res.all()