Write tests to test all DDL operations
We need a test to test all DDL operations. Starting from CREATE DB and go over all available DDL operation. This test can be based on GdaDDlCreator (or renamed equivalent). Also, it can be a good platform for test driven development for new DDL module. It may require to introduce new objects, e.g. GdaDbInfo to store information about DB itself, GdaUserInfo to store information about user. Additional control over parameters, e.g. "IF EXISTS" should be added. This is a starting list of operation we should implement for most common DBs. Items marked with (*) are subject for review and discussion.
SQLite3:
-
CREATE_TABLE -
CREATE_VIEW -
CREATE_DB -
ADD_COLUMN -
RENAME_TABLE -
DROP_VIEW -
CREATE_INDEX -
DROP_INDEX -
DROP_TABLE
PostgreSQL:
-
CREATE_DB -
CREATE_INDEX -
CREATE_ROLE -
CREATE_USER* -
CREATE_TABLE -
CREATE_VIEW -
ADD_COLUMN -
DROP_COLUMN -
DROP_DB -
DROP_INDEX -
DROP_ROLE -
DROP_USER -
DROP_TABLE -
DROP_VIEW -
RENAME_TABLE
MySQL:
-
CREATE_DB -
CREATE_TABLE -
CREATE_VIEW -
ADD_COLUMN -
DROP_COLUMN -
DROP_DB -
DROP_INDEX -
DROP_TABLE -
DROP_VIEW -
RENAME_TABLE -
COMMENT_COLUMN -
COMMENT_TABLE -
CREATE_INDEX -
CREATE_USER* -
DROP_ROLE* -
DROP_USER* -
CREATE_ROLE*
Edited by Daniel Espinosa Ortiz