def test_2407_heterogeneous(self): "2407 - test heterogeneous pool with user and password specified" pool = test_env.get_pool(min=2, max=8, increment=3, homogeneous=False, getmode=oracledb.SPOOL_ATTRVAL_WAIT) self.assertEqual(pool.homogeneous, 0) conn = pool.acquire() self.__verify_connection(pool.acquire(), test_env.get_main_user()) conn.close() conn = pool.acquire(test_env.get_main_user(), test_env.get_main_password()) self.__verify_connection(conn, test_env.get_main_user()) conn.close() conn = pool.acquire(test_env.get_proxy_user(), test_env.get_proxy_password()) self.__verify_connection(conn, test_env.get_proxy_user()) conn.close() user_str = "%s[%s]" % \ (test_env.get_main_user(), test_env.get_proxy_user()) conn = pool.acquire(user_str, test_env.get_main_password()) self.__verify_connection(conn, test_env.get_proxy_user(), test_env.get_main_user()) conn.close()
def test_2408_heterogenous_without_user(self): "2408 - test heterogeneous pool without user and password specified" pool = test_env.get_pool(user="", password="", min=2, max=8, increment=3, getmode=oracledb.SPOOL_ATTRVAL_WAIT, homogeneous=False) self.__verify_connection(pool.acquire(test_env.get_main_user(), test_env.get_main_password()), test_env.get_main_user()) self.__verify_connection(pool.acquire(test_env.get_proxy_user(), test_env.get_proxy_password()), test_env.get_proxy_user()) user_str = "%s[%s]" % \ (test_env.get_main_user(), test_env.get_proxy_user()) self.__verify_connection(pool.acquire(user_str, test_env.get_main_password()), test_env.get_proxy_user(), test_env.get_main_user())
# Copyright (c) 2019, Oracle and/or its affiliates. All rights reserved. #------------------------------------------------------------------------------ #------------------------------------------------------------------------------ # SetupTest.py # # Creates users and populates their schemas with the tables and packages # necessary for the cx_Oracle test suite. #------------------------------------------------------------------------------ import cx_Oracle import test_env import DropTest # connect as administrative user (usually SYSTEM or ADMIN) conn = cx_Oracle.connect(test_env.get_admin_connect_string()) # drop existing users and editions, if applicable DropTest.drop_tests(conn) # create test schemas print("Creating test schemas...") test_env.run_sql_script(conn, "SetupTest", main_user=test_env.get_main_user(), main_password=test_env.get_main_password(), proxy_user=test_env.get_proxy_user(), proxy_password=test_env.get_proxy_password()) print("Done.")