source: mauRepo/MolesManager/trunk/src/libs/migration/tests/infodbepbtests.py @ 8409

'''
Created on 8 Mar 2012

@author: mnagni
'''
import unittest
from libs.commons_db import DbManager
from unittest import TestCase
import logging
from logging import StreamHandler  
from testconfig import INFO_DB_CONNECTION
from libs.migration.InfodbEPB import InfodbEPB
from sqlalchemy.sql.expression import text


class InfodbEPBTest(TestCase):

    def setUp(self):      
        InfodbEPBTest.infoDB = DbManager(INFO_DB_CONNECTION)        
        #InfodbEPB.overrrideDBManager(InfodbEPBTest.infoDB)
        self.logging = logging.getLogger('InfodbEPB')
        self.logging.addHandler(StreamHandler())
        self.logging.setLevel(logging.DEBUG)

    def tearDown(self):
        pass
        #self._dropAllTables()

    def runTest(self):
        self.getInfo()
    
    '''
    def getInfo(self):
        connection = InfodbEPB.getNewInfoConnection();
        query_string = text("""select id from cedainfoapp_dataentity where dataentity_id = :id""")
        records = connection.execute(query_string, id='badc.nerc.ac.uk__ATOM__dataent_11746737105518913')
        for rec in records:
            print rec['id']
        records.close()
    '''

if __name__ == "__main__":
    #import sys;sys.argv = ['', 'Test.testName']
    unittest.main()