Re: [sqlalchemy] column_property order_by error

2015-02-03 Thread Kevin S
UTC-5, Michael Bayer wrote: the workaround, or using git master? Kevin S kevin...@gmail.com javascript: wrote: Yes, that does fix the issue. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop

[sqlalchemy] column_property order_by error

2015-02-02 Thread Kevin S
I apologize up front for not being able to provide a reproducible example of my problem. We have built a web app in sqlalchemy for read-only access of our production database. We are in the process of migrating from one database architecture (Sybase) to another (Postgres). The goal is to have

Re: [sqlalchemy] column_property order_by error

2015-02-02 Thread Kevin S
Yes, that does fix the issue. -- 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] relationship join with same table twice

2014-12-08 Thread Kevin S
I am trying to construct a filter against a table that has two references to the same child table. But I am completely confused how to go about it. I've seen lots of examples for using aliases, but I have not been able to get any to work. So I'll just try to give my example simply, and ask what

[sqlalchemy] boolean column_property using exists

2014-11-05 Thread Kevin S
I've seen slight variations on this topic, but not exactly what I'm looking for. I want to use a column_property (or something like it) to map the existence of some Child relationship. Say for example, I have two summary pages in a web app. One for displaying rows of Parent objects, and one

Re: [sqlalchemy] Lazy load collection from a batch of objects with one query

2014-11-04 Thread Kevin S
I don't know that the 3rd party extension does this. Sent from my iPhone On Nov 3, 2014, at 2:52 PM, Kevin S kevin...@gmail.com javascript: wrote: Ok, I think I understand some of the reasoning behind not wanting to implement such a feature. I think this is fine, because I don't need

Re: [sqlalchemy] Lazy load collection from a batch of objects with one query

2014-11-04 Thread Kevin S
/DisjointEagerLoading, which illustrates how to use set_committed_value() which you’ll want to use if you’re implementing loading. On Nov 4, 2014, at 7:19 AM, Kevin S kevin...@gmail.com javascript: wrote: Yes, I would say that is an acceptable solution to me. My current attempt, which I

Re: [sqlalchemy] Lazy load collection from a batch of objects with one query

2014-11-03 Thread Kevin S
AM, Kevin S kevin...@gmail.com javascript: wrote: I think I've seen this sort of functionality in Hibernate, where it tries to optimize if you are going to access some lazy loaded property on a collection of objects. It can load them in batches, as opposed to one query for every

[sqlalchemy] Lazy load collection from a batch of objects with one query

2014-11-01 Thread Kevin S
I think I've seen this sort of functionality in Hibernate, where it tries to optimize if you are going to access some lazy loaded property on a collection of objects. It can load them in batches, as opposed to one query for every object. So, I'm asking if there is any way to do something like

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-20 Thread Kevin S
and the sybase-pyodbc dialects that suggest why that argument is valid for one, but not the other... Any hints? On Wednesday, June 19, 2013 4:35:51 PM UTC-4, Michael Bayer wrote: On Jun 19, 2013, at 3:07 PM, Kevin S kevin...@gmail.com javascript: wrote: Unfortunately, we cannot switch off of Sybase

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-19 Thread Kevin S
to NOT grab the GIL? From my brief reading it sounded like c extensions are supposed to get around GIL issues, but again I am naive on the subject. On Sunday, June 16, 2013 1:10:03 PM UTC-4, Michael Bayer wrote: On Jun 16, 2013, at 12:55 PM, Kevin S kevin...@gmail.com javascript: wrote: I can try

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-16 Thread Kevin S
, Kevin S kevin...@gmail.com javascript: wrote: I am running into a problem while developing a flask application using flask-sqlalchemy. Now, I'm not even 100% sure my problem is sqlalchemy related, but I don't know how to debug this particular issue. To start, I have a sybase

[sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-14 Thread Kevin S
I am running into a problem while developing a flask application using flask-sqlalchemy. Now, I'm not even 100% sure my problem is sqlalchemy related, but I don't know how to debug this particular issue. To start, I have a sybase database that I want to see if I can build a report generating

[sqlalchemy] complex many to many relationship

2013-03-27 Thread Kevin S
Setup: I have been learning SQL Alchemy to build a prototype (proof of concept) Flask app for our internal website. We want to replace our current site, which is made entirely of slow python CGIs and raw SQL. Our database (Postgres) is fairly large, but has some unusual table relationships, and

Re: [sqlalchemy] complex many to many relationship

2013-03-27 Thread Kevin S
classes to define them. On Wednesday, March 27, 2013 12:48:23 PM UTC-4, Simon King wrote: On Wed, Mar 27, 2013 at 4:13 PM, Kevin S kevin...@gmail.com javascript: wrote: Setup: I have been learning SQL Alchemy to build a prototype (proof of concept) Flask app for our internal website. We

Re: [sqlalchemy] complex many to many relationship

2013-03-27 Thread Kevin S
': 2, '@param_1': 215} That does not make sense as SQL and just returns a random marker. On Wednesday, March 27, 2013 1:05:26 PM UTC-4, Kevin S wrote: Thanks. I have it working for the Marker to Reference_Assoc relationship: Marker.referenceAssocs = relationship(ReferenceAssoc

Re: [sqlalchemy] complex many to many relationship

2013-03-27 Thread Kevin S
that referenceAssoc is not for a marker but for some other type. It should not bring back any markers. On Wednesday, March 27, 2013 1:14:43 PM UTC-4, Kevin S wrote: Also, is it appropriate to define a backref here? It returns wrong data. When I get a ReferenceAssoc object and get its marker