1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
This directory contains the test suite for python-oracledb.
1. The schemas and SQL objects that are referenced in the test suite can be
created by running the Python script [create_schema.py][1]. The script
requires administrative privileges and will prompt for these credentials as
well as the names of the schemas that will be created, unless a number of
environment variables are set as documented in the Python script
[test_env.py][2]. Run the script using the following command:
python create_schema.py
2. Run the test suite by issuing the following command in the top-level
directory of your oracledb installation:
tox
This will build the module in an independent environment and run the test
suite using the module that was just built in that environment.
Alternatively, you can use the currently installed build of oracledb and
run the following command instead:
python -m unittest discover -v -s tests
You may also run each of the test scripts independently, as in:
python test_1000_module.py
3. After running the test suite, the schemas can be dropped by running the
Python script [drop_schema.py][3]. The script requires administrative
privileges and will prompt for these credentials as well as the names of
the schemas that will be dropped, unless a number of environment variables
are set as documented in the Python script [test_env.py][2]. Run the
script using the following command:
python drop_schema.py
4. Enable tests that require extra configuration
The following test(s) are automatically skipped if their required
environment variable(s) and setup is not available.
4.1 test_5000_externalauth.py
This test aims to test the usage of external authentication.
- Set the PYO_TEST_EXTERNAL_USER environment variable to the externally
identified user that will be connected using external authentication.
- Set up external authentication. See
[Connecting Using External Authentication][4] for creating an
Oracle Wallet or enabling OS authentication.
- Run the following SQL commands as a user with administrative
privileges (such as SYSTEM or ADMIN) to allow the external user to
connect to the database and behave as proxy for testing external
authentication with proxy:
grant create session to <External User>;
alter user <Schema Owner> grant connect through <External User>;
[1]: https://github.com/oracle/python-oracledb/blob/main/tests/create_schema.py
[2]: https://github.com/oracle/python-oracledb/blob/main/tests/test_env.py
[3]: https://github.com/oracle/python-oracledb/blob/main/tests/drop_schema.py
[4]: https://python-oracledb.readthedocs.io/en/latest/user_guide/connection_handling.html#connecting-using-external-authentication
|
