Re: [Modeling-users] few misc issues with sqlite adaptor

[Sebastien B. <sbi...@us...>]

Mario Ruggier <ma...@ru...> wrote:
> a few points, encountered when trying to make a pymodel,
> running the mdl_* scripts, and using SQLite adaptor:
>=20
> 1. when running mdl_validate_model on a pymodel that
> does not hard-wire an adaptorname:
>=20
>   * Warning(s):
>     - Can't find concrete adaptor: can't check SQL types

True, when it cannot be found they cannot be checked, so we warn the
user.

> 2. when running mdl_validate_model on a model that
> uses "text" as externalType (using SQLite adaptor):
>=20
>   * Error(s):
>     - Invalid SQL type: 'text' (valid for this adaptor: ['char', 'date',
> 'varchar', 'timestamp', 'time', 'int', 'integer', 'float', 'numeric'])

Should be fixed.

> 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.

True, no matter where a .cfg is, if it's pointed to by MDL_DB_CONNECTIONS_C=
FG
it should taken into account. This is a bug.

> 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.

Ok, this could be checked by mdl_generate_DB.

  Could you add bug reports for each of these three items? I'll probably
  look at them this week-end. And thanks for reporting!

-- S=E9bastien.