telosystools

Open full view…

How do I specify multiple schemas in dbcfg file?

gvman
Tue, 16 Jun 2020 13:35:15 GMT

There are many schema elements in my database. I would like to generate code for entities in specific list of schema, for example, lookup schema, public schema and refdata schema. I tried the following setting, it did not work. I tried it with delimiters such as comma, pipe symbol, space and so on with the same result, i.e. no tables were identified. --- <metadata catalog="" schema="lookup,public,refdata" table-name-pattern="%" table-types="TABLE VIEW " table-name-exclude="geography_columns|geometry_columns|spatial_ref_sys " table-name-include="" /> --- Please help.

Telosys Team
Thu, 18 Jun 2020 09:51:14 GMT

As table name unicity is guaranteed only in each schema Telosys uses one model for each schema. In your case you just have to define N databases in the file "databases.dbcfg" (in fact "db" means "db schema") For example : <db id = "1" for "schema 1" <db id = "2" for "schema 2" Thereby you will obtain multiple models (one for each db schema) and it's not a problem as a Telosys project can deal with N models. For code generation you will apply the same bundles of templates for all your models.

gvman
Tue, 23 Jun 2020 08:39:34 GMT

Thanks very much. Regards.

gvman
Tue, 23 Jun 2020 08:39:45 GMT

Thanks very much. Regards.