def setUp(self):
        Base.metadata.create_all()

        instrument = Instrument()
        instrument.ticker = 'MyTicker'
        instrument.asset_class = 'MyAssetClass'
        instrument.name = 'MyName'
        instrument.currency = 'USD'
        instrument.type = 'MyType'
        instrument.transactions_fees = 0.
        instrument.point_value = 1
        instrument.exchange = 'MyExchange'
        instrument.rolling_month = 'H'
        
        market_data = MarketData()
        market_data.instrument = instrument
        market_data.type = DataType.CLOSE
        market_data.date = datetime(2000,1,3)
        market_data.value = 100.
        
        session = Session()
        
        instrument_dao = InstrumentDAO()
        instrument_dao.save(session, instrument)
        
        market_data_dao = MarketDataDAO()
        market_data_dao.save(session, market_data)
        
        
        self.instrument_service = InstrumentService() 
    logger.info('Starting instrument creation ...')
    
    session = Session()
    
    Base.metadata.create_all()
    
    instrument_dao = InstrumentDAO()
    
    try:
        
        ad = instrument_dao.get_by_ticker(session, 'AD')
        if not ad:
            ad = Instrument()
        ad.ticker = 'AD'
        ad.name = 'Australian Dollar'
        ad.asset_class = 'Currencies'
        ad.transactions_fees = .00005
        instrument_dao.save(session, ad)
    
        bo = instrument_dao.get_by_ticker(session, 'BO')
        if not bo:
            bo = Instrument()
        bo.ticker = 'BO'
        bo.name = 'Soybean Oil'
        bo.asset_class = 'Grains'
        bo.transactions_fees = .015
        instrument_dao.save(session, bo)

        bp = instrument_dao.get_by_ticker(session, 'BP')
        if not bp:
            bp = Instrument()