Q: How to build architecure for my DB autotesting project using Spring JDBCTemplate and JUNIT5 on Java I want to build automation testing application for data warehouse project.
I have:

*

*links to several DBs, all Oracle, named like ${FT/UAT/PROD}${INSTANCE_ENUM};


*each link has several schemas and tables/views in it, schemas like ONDATA_000, names like PREFIX_TABLE_NAME;


*each schema consists of several types of tables, there are near 20 types of very similar tables, each having it's own test approach;


*for example I've in schema ONDATA_000 table with a name P_TABLE; So, in Oracle PL/SQL I can connect through Oracle SQL Developer to ONDATA_000.P_TABLE and write queries like "SELECT * FROM ONDATA_000.P_TABLE";
for this type of a table I've test cases like:



*

*Check if this table exists;

*Check if actual and documentation count of columns are similar;

*Check if actual and documentation map(column names, data types and length) of columns are similar;

*Check if primary keys are equal in actual table and special table METADATA.TABLE_P_KEYS;

*Check if foreign keys are equal in actual table and special table METADATA.TABLE_F_KEYS;

*Check if foreign keys are actual links (another table have F key equal to this table);
... and many more such as those;
These test cases now in .sql files, marked down by ${TEST_CASE_NUMBER} and could be parsed.

I want to connect to data source (I've several of them with description in class DataSources with info like DriverClassName, Url, Username, Password), then I want to make a queries which are test cases actually, parametirezed by table schema and table name, launching each test case sequentially, then close the connection; finally I want to trace a results to the report;
Could you please help me with building architecture of this TAF? I am thinking myself for a days and do not have much of an experience with Spring.
