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

[Ernesto R. <er...@si...>]

Hi,

I've installed modeling 0.9-pre15, with sqlite (2.8.6)

when I create the schema with mdl_generate_DB_schema.py -c then I get =
output with no semicolons (;) separating the SQL commands, and this is =
not understood by sqlite.

I modified line 99 of the script (mdl_generate_DB_schema.py) to include =
a semicolon:
        str+=3D'%s;\n'%sqlExpr.statement()

now I can do a:
  mdl_generate_DB_schema.py -c -C mymodel.py >schema.sql
  sqlite mymodel.sqlite < schema.py

Directly creating the schema (not specifying the -c option) worked =
correctly.