On May 9, 2013, at 6:32 AM, Wolfgang Meiners <wolfgangmeiner...@web.de> wrote:
>
> Now i want to run everything inside the schema 'test'. Two questions arises:
> 1) How can i create schema test automatically when it does not exist?
> This should be somehow related to
> Base.metadata.create_all(engine)
you'd use a DDL("CREATE SCHEMA <foo>") that's attached to the "before_create"
event of the MetaData object.
>
> 2) If i create schema test by hand and uncomment the line
> #Base.metadata.schema='test'
> i get an errormessage because the DDL does not use schema test:
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation "valid"
> does not exist
you'd need to refer to the table "valid" as "myschema.valid" within the
definition of your stored procedure.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
