Re: [sqlalchemy] Creating one-to-many relationship: child class returns empty list after trying to enter data

2013-08-10 Thread Simon King
On 10 Aug 2013, at 03:42, csdr...@gmail.com wrote: This is driving me a little crazy so hopefully someone here can help. This is my first time working with sqlalchemy (v0.8). Python is v2.7.2 and MySQL is v14.14. The (heavily) summarized code is as follows: class Price(Base):

Re: [sqlalchemy] Why no Raw Query Builder?

2013-08-10 Thread Taba Taba
Thank you so much. Another question: $this-select(col1); if(1 0) { $this-select(col2, col3); } *$this-from(tbl)-where(1 = 1);* if( 2 1) { *$this-where(2 1);* } $this-left_outer_join(tbl2, tbl2.t_id = tbl.id); // output: SELECT col1, col2, col3 // FROM tbl // LEFT OUTER JOIN tbl2 //

Re: [sqlalchemy] Creating one-to-many relationship: child class returns empty list after trying to enter data

2013-08-10 Thread csdrane
Thank you! That worked. On Saturday, August 10, 2013 5:39:31 AM UTC-4, Simon King wrote: On 10 Aug 2013, at 03:42, csd...@gmail.com javascript: wrote: This is driving me a little crazy so hopefully someone here can help. This is my first time working with sqlalchemy (v0.8). Python is

Re: [sqlalchemy] update using query - joint table inheritance

2013-08-10 Thread Michael Bayer
On Aug 9, 2013, at 10:45 PM, Mark Eastwood markeastwoo...@gmail.com wrote: It is easier to describe in code than in words. absolutely, this is much preferred. Can anyone please tell me if there is something that I am doing wrong? is this a bug with sqlalchemy? it's kind of a bug, yes,

Re: [sqlalchemy] Why no Raw Query Builder?

2013-08-10 Thread Claudio Freire
On Sat, Aug 10, 2013 at 11:31 AM, Taba Taba betak...@gmail.com wrote: Thank you so much. Another question: $this-select(col1); if(1 0) { $this-select(col2, col3); } $this-from(tbl)-where(1 = 1); if( 2 1) { $this-where(2 1); } $this-left_outer_join(tbl2, tbl2.t_id = tbl.id);

Re: [sqlalchemy] update using query - joint table inheritance

2013-08-10 Thread Mark Eastwood
Hi Michael, Thankyou very much for your reply, which is exactly what I needed. I also saw the new ticket that was raised for documentation of this, thankyou zzzeek. Mark -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this