def testQueryingOracleWithValidlyFormattedArguments(self): cursor = self.mock() cursor.expects(once()).method("execute") cursor.expects(once()).method("fetchall").will(return_value([("workDir", "reloadDir", "archiveDir", "oid1")])) conn = self.mock() conn.expects(once()).method("cursor").will(return_value(cursor)) sys.modules["cx_Oracle"] = self.mock() sys.modules["cx_Oracle"].expects(once()).method("connect").will(return_value(conn)) connection_factory = factory.cxoraConnectionFactory(username="******", password="******", hostname="localhost", db="mock") dt = DatabaseTemplate(connection_factory) dt.query(""" SELECT impcarrcfg.paystat_work_dir, impcarrcfg.paystat_reload_dir, impcarrcfg.paystat_archive_dir, impcarrcfg.oid FROM impcarrcfg, carr, lklabelsys WHERE (lklabelsys.oid = impcarrcfg.lklabelsys_oid) and (carr.oid = impcarrcfg.carr_oid ) and (carr.oid = :carr_oid and lklabelsys.oid = :lklabelsys_oid) """, {'carr_oid':5, 'lklabelsys_oid':5}, testSupportClasses.ImpFilePropsRowMapper()) del(sys.modules["cx_Oracle"])
def testQueryingOracleWithValidlyFormattedArguments(self): cursor = self.mock() cursor.expects(once()).method("execute") cursor.expects(once()).method("fetchall").will(return_value([("workDir", "reloadDir", "archiveDir", "oid1")])) conn = self.mock() conn.expects(once()).method("cursor").will(return_value(cursor)) conn.expects(once()).method("close") sys.modules["cx_Oracle"] = self.mock() sys.modules["cx_Oracle"].expects(once()).method("connect").will(return_value(conn)) connection_factory = factory.cxoraConnectionFactory(username="******", password="******", hostname="localhost", db="mock") dt = DatabaseTemplate(connection_factory) dt.query(""" SELECT impcarrcfg.paystat_work_dir, impcarrcfg.paystat_reload_dir, impcarrcfg.paystat_archive_dir, impcarrcfg.oid FROM impcarrcfg, carr, lklabelsys WHERE (lklabelsys.oid = impcarrcfg.lklabelsys_oid) and (carr.oid = impcarrcfg.carr_oid ) and (carr.oid = :carr_oid and lklabelsys.oid = :lklabelsys_oid) """, {'carr_oid':5, 'lklabelsys_oid':5}, testSupportClasses.ImpFilePropsRowMapper()) del(sys.modules["cx_Oracle"])
def testConnectingToOracle(self): sys.modules["cx_Oracle"] = self.mock() sys.modules["cx_Oracle"].expects(once()).method("connect") connection_factory = factory.cxoraConnectionFactory(username="******", password="******", hostname="localhost", db="mock") connection = connection_factory.connect() del(sys.modules["cx_Oracle"])
def testInsertingIntoOracleWithInvalidlyFormattedArgumentsWithInsertApi(self): sys.modules["cx_Oracle"] = self.mock() connection_factory = factory.cxoraConnectionFactory(username="******", password="******", hostname="localhost", db="mock") dt = DatabaseTemplate(connection_factory) self.assertRaises(InvalidArgumentType, dt.insert_and_return_id, "INSERT INTO T_UNIT (F_UNIT_PK, F_UNIT_ID, F_NAME) VALUES (?, ?, ?)", (1,1,1)) del(sys.modules["cx_Oracle"])
def testQueryingOracleWithInvalidlyFormattedArguments(self): sys.modules["cx_Oracle"] = self.mock() connection_factory = factory.cxoraConnectionFactory(username="******", password="******", hostname="localhost", db="mock") dt = DatabaseTemplate(connection_factory) self.assertRaises(InvalidArgumentType, dt.query, """ SELECT impcarrcfg.paystat_work_dir, impcarrcfg.paystat_reload_dir, impcarrcfg.paystat_archive_dir, impcarrcfg.oid FROM impcarrcfg, carr, lklabelsys WHERE (lklabelsys.oid = impcarrcfg.lklabelsys_oid) and (carr.oid = impcarrcfg.carr_oid ) and (carr.oid = ? and lklabelsys.oid = ?) """, (5, 5), testSupportClasses.ImpFilePropsRowMapper()) del(sys.modules["cx_Oracle"])