Re: [Modeling-users] SQLite schema generation with -c does not use semicolons

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

        Hi Ernesto,

  Sorry for the delay in the answer.

"Ernesto Revilla" <er...@si...> wrote:
> I've installed modeling 0.9-pre15, with sqlite (2.8.6)
>=20
> when I create the schema with mdl_generate_DB_schema.py -c then I get out=
put
> with no semicolons (;) separating the SQL commands, and this is not
> understood by sqlite.
>=20
> I modified line 99 of the script (mdl_generate_DB_schema.py) to include a
> semicolon:
>         str+=3D'%s;\n'%sqlExpr.statement()
>=20
> now I can do a:
>   mdl_generate_DB_schema.py -c -C mymodel.py >schema.sql
>   sqlite mymodel.sqlite < schema.py
>=20
> Directly creating the schema (not specifying the -c option) worked
> correctly.

That's a reasonable request, I'll probably change the behaviour of the
script in the coming release when '-c' is specified --and add an option
for disabling it. Could you add a feature request to the project's RFE?

-- S=E9bastien.