On Monday, 4 March 2013 11:57:01 UTC-7, Michael Bayer wrote:
>
> Have you looked at SQLSoup ? This library already does exactly what
> you're looking for.
>
> https://sqlsoup.readthedocs.org/en/latest/
>
>
wow! yeah that does do what I'm looking for.
However, I'm mapping to tables that do not have primary keys defined. So
with SQLSoup, I get:
sqlsoup.SQLSoupError: table 'cpgIslandExt' does not have a primary key
defined
I got the same in sqlalchemy if I don't explicitly add the name column to
the db. Any way around this?
> For the most part, I have this working. However, the example in the gist
> shows that:
>
> len(g.cpgIslandExt.all()) != g.cpgIslandExt.count()
>
>
> What does your SQL echo output say? Looking at the queries (and the rows
> returned, if you use echo='debug') will illustrate what's being sent.
>
> A typical reason why all() returns fewer rows is when the query returns
> duplicate primary key identities - returned objects are uniqued on identity
> as they are received. The fact that the "name" column is being hardcoded
> in your base model as the sole "primary key" for all mappings is the likely
> cause of this even being possible. The reflection process already knows
> how to yield the primary key constraints defined on each table so you'd
> best rely upon that.
>
>
>
>
>
>
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
