Re: [Modeling-users] mdl_generate_DB_schema.py

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

Tom Hallman <hal...@dm...> wrote:
> Hey all,
>=20
>    I'm having some trouble with the mdl_generate_DB_schema.py script. As I
> understand it, the -c (or --stdout) option should send output to stdout, =
as
> opposed to just creating the DB. However, when I run it as such:
>=20
> --------------------
> hallmant@jael:~/Modeling$ ls
> mytest.xml
> hallmant@serv:~/Modeling$ mdl_generate_DB_schema.py -c mytest.xml
>=20
> hallmant@serv:~/Modeling$
> --------------------
>=20
>    You can see that nothing is getting outputted (as far as I can tell.) =
Is
> this a bug in the script or am I doing something wrong?

You're not doing anything wrong: you need to give a command, ie
something to generate. For example,

  hallmant@serv:~/Modeling$ mdl_generate_DB_schema.py -c -TPSF mytest.xml

should give you the sql statements creating the database. See --help for
more options.

  BTW you're also right when suggesting this is a bug, the script should
  at least inform you that a db-generation command is needed, this will
  be fixed in the next release. Thanks for reporting.


Oh, and last: I see you're using a xml model, are you using the ZModeler
or another mean? Did you consider using PyModels instead?  Usually
people tend to think PyModels are easier to create and manipulate,
that's why I'm pointing this out, just in case you didn't notice that
option.


-- S=E9bastien.