Schema support for SqlSoup

Issue #250 resolved
Former user created an issue

The attached patch adds namespace support to the SqlSoup plugin, with docs. I did not add tests because SQLite does not support namespaces (confusingly called "schema" in SQLAlchemy and in PostgreSQL).

The getattr usage is a bit ugly:

An alternative could be item syntax:

{{{>>> users = soup['my_namespace.users']('my_namespace.users').select()}}}

P.S.: a "plugin" Trac component could be useful.

Comments (10)

  1. Former user Account Deleted

    Added schema support in 1736 via

    soup.schema = myschemaname

    Per-table schema support is too clunky. One soup per schema is cleaner.

  2. Log in to comment