[Modeling-users] few misc issues with sqlite adaptor

[Mario R. <ma...@ru...>]

Hi,

a few points, encountered when trying to make a pymodel,
running the mdl_* scripts, and using SQLite adaptor:


1. when running mdl_validate_model on a pymodel that
does not hard-wire an adaptorname:

  * Warning(s):
    - Can't find concrete adaptor: can't check SQL types


2. when running mdl_validate_model on a model that
uses "text" as externalType (using SQLite adaptor):

  * Error(s):
    - Invalid SQL type: 'text' (valid for this adaptor: ['char', 'date', 
'varchar', 'timestamp', 'time', 'int', 'integer', 'float', 'numeric'])


3. When running mdl_* utility scripts, the main cfg (pointed to by env
var MDL_DB_CONNECTIONS_CFG) is not taken into account.
Same goes for when an Adaptorname.cfg is made available in the
same directory as the pymodel.


4. When running mdl_generate_DB utility script, and specifying a
--admin-dsn on the command line, and the db name in this dsn is
different than the db name specified in the pymodel, then an empty
file with the dsn_db name is created, and a proper sqlite db fis
created in a file with the pymodel_db name.


Cheers, mario