Customizable SetupTests.sql

[segabor]

1. Review existing enhancement requests

Current test setup SQL covers features not available on all DB versions. For test purposes I'm running an instance version 12.1.0.2 in docker with basic bundle option. And it turned out it does not support editions and proxy users.

2. Describe your new request in detail

Have test SQL script customizable or more versions (core, enhanced) for different platforms.

3. Give supporting information about tools and operating systems. Give relevant product version numbers

• Host OS: macOS Catalina 10.15.3
• Docker (latest)
• Oracle DB image: container-registry.oracle.com/database/standard:12.1.0.2

[segabor]

In addition to above request I had to add the following line to have SQL executed:

alter session set "_oracle_script"=true;

[segabor]

The patched SQL script I'm using currently

diff --git a/test/sql/SetupTest.sql b/test/sql/SetupTest.sql
index fee3c7e..90499e1 100644
--- a/test/sql/SetupTest.sql
+++ b/test/sql/SetupTest.sql
@@ -32,27 +32,28 @@ CREATE DIRECTORY &dir_name AS '&dir_path';
 alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
 alter session set nls_numeric_characters='.,';
 alter session set nls_length_semantics = byte;
+alter session set "_ORACLE_SCRIPT"=true;
 
 create user &main_user identified by &main_password
 quota unlimited on users
 default tablespace users;
 
-create user &proxy_user identified by &proxy_password;
-alter user &proxy_user grant connect through &main_user;
+-- create user &proxy_user identified by &proxy_password;
+-- alter user &proxy_user grant connect through &main_user;
 
-create user &edition_user identified by &edition_password
-quota unlimited on users
-default tablespace users;
+-- create user &edition_user identified by &edition_password
+-- quota unlimited on users
+-- default tablespace users;
 
-alter user &edition_user enable editions;
+-- alter user &edition_user enable editions;
 
-create edition &edition_name;
+-- create edition &edition_name;
 
-grant use on edition &edition_name to &edition_user;
+-- grant use on edition &edition_name to &edition_user;
 
-grant create session to &proxy_user;
+-- grant create session to &proxy_user;
 
-grant create session to &edition_user;
+-- grant create session to &edition_user;
 
 grant
     create session,

[cjbj]

I'm glad someone is running tests!

Better version portability would be good. We have that with other ODPI-C consumers (e.g. node-oracledb), partly because their test frameworks make it easier.

[segabor]

I plan to do so. I want a test DB for testing a driver. I'm fine with having a customized test setup.

[cjbj]

I'm happy to leave this open as an enhancement request.