The gda-list-server-op-5.0 tool lists available DDL operations for one or all of the installed
providers. For each type of operation (and each provider), the named parameters are also displayed.
See the General words about DDL queries for more information
about possible operations and usage. This tool has got several options, use the --help
option
to list them all.
For example listing all the possible operations (for all the providers) is:
[prompt]> gda-list-server-op-5.0 -l Using XML descriptions in /usr/share/libgda-5.0 Existing operation types: CREATE_DB DROP_DB CREATE_TABLE DROP_TABLE RENAME_TABLE ADD_COLUMN DROP_COLUMN CREATE_INDEX DROP_INDEX
Listing all the operations supported by the SQLite provider (notice that the SQLite provider does not support the DROP_COLUMN operation as SQLite does not support it):
[prompt]> gda-list-server-op-5.0 -l -p SQLite Using XML descriptions in /usr/share/libgda-5.0 For provider SQLite Existing operation types for provider 'SQLite': CREATE_DB DROP_DB CREATE_TABLE DROP_TABLE RENAME_TABLE ADD_COLUMN CREATE_INDEX DROP_INDEX
Listing all the possible parameters for the MySQL provider and for the DROP_COLUMN operation:
[prompt]> gda-list-server-op-5.0 -o DROP_COLUMN -p MySQL Using XML descriptions in /usr/share/libgda-5.0 For provider MySQL Description for type: DROP_COLUMN <?xml version="1.0"?> <server_op> <path id="/COLUMN_DESC_P" node_type="PARAMLIST" name="Column's description"/> <path id="/COLUMN_DESC_P/TABLE_NAME" node_type="PARAMETER" gdatype="gchararray" name="Table" descr="Table's name"/> <path id="/COLUMN_DESC_P/COLUMN_NAME" node_type="PARAMETER" gdatype="gchararray" name="Field name"/> </server_op>
Listing all the possible parameters for the all the installed providers and for the DROP_COLUMN operation:
[prompt]> gda-list-server-op-5.0 -o DROP_COLUMN Using XML descriptions in /usr/share/libgda-5.0 Description for type: DROP_COLUMN <?xml version="1.0"?> <server_op> <path id="/COLUMN_DESC_P" node_type="PARAMLIST"> <prov prov_name="mysql" name="Column's description"/> <prov prov_name="postgres" name="Column's description"/> </path> <path id="/COLUMN_DESC_P/TABLE_NAME" node_type="PARAMETER" gdatype="gchararray"> <prov prov_name="mysql" name="Table" descr="Table's name"/> <prov prov_name="postgres" name="Table" descr="Table's name"/> </path> <path id="/COLUMN_DESC_P/COLUMN_NAME" node_type="PARAMETER" gdatype="gchararray"> <prov prov_name="mysql" name="Field name"/> <prov prov_name="postgres" name="Field name"/> </path> <path id="/COLUMN_DESC_P/REFERENCED_ACTION" node_type="PARAMETER" gdatype="gchararray"> <prov prov_name="postgres" name="References" descr="What to do with references on the column to delete"/> </path> </server_op>