Re: [sqlalchemy] Re: H2 database

2015-04-25 Thread Cecil Westerhof
the PostgeSQL wire protocol, so you can use the PostgreSQL database driver. Although you will probably need to tweek the dialect description that SqlAlchemy needs. So it should be doable. I have another project. :-D -- Cecil Westerhof -- You received this message because you are subscribed

[sqlalchemy] H2 database

2015-04-24 Thread Cecil Westerhof
) could pull off? -- Cecil Westerhof -- 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

[sqlalchemy] Is there a simple way to let records have the same groups as it parents

2008-08-28 Thread Cecil Westerhof
be: G2, G3, G4 and G5. When removing G2 from R1 the list for R2 should be: G2, G3, G4 and G5. (R2 has itself also group G2.) Is this possible with sqlalchemy or has this to be done by hand? -- Cecil Westerhof --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: wx and SqlAlchemy

2008-08-28 Thread Cecil Westerhof
for those. Nope. I use two databases, no engine and only one session. Maybe not optimal (I just started learning sqlalchemy and wxpython), but it is possible. -- Cecil Westerhof --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: Is there a simple way to let records have the same groups as it parents

2008-08-28 Thread Cecil Westerhof
about that. But properly this is only going to work with tables that are not to big I am afraid. Maybe I want to fancy things. -- Cecil Westerhof --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: Is there a simple way to let records have the same groups as it parents

2008-08-28 Thread Cecil Westerhof
2008/8/28 Michael Bayer [EMAIL PROTECTED]: On Aug 28, 2008, at 8:11 AM, Cecil Westerhof wrote: I was just wondering if the folowing possible. A record has severall groups connected through a N:M relation. But it also has a parent. What I would like is that all the groups from the parent

[sqlalchemy] Re: Working with several database without needing to know in which database an object resides

2008-08-27 Thread Cecil Westerhof
to the session because the engine is fetched out of the class that is mapped to a sqlalchemy.Table instance. -- Cecil Westerhof --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send

[sqlalchemy] Displaying table partly in table object

2008-08-27 Thread Cecil Westerhof
, but when the table grows, the returned array will grow also. -- Cecil Westerhof --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Re: Working with several database without needing to know in which database an object resides

2008-08-27 Thread Cecil Westerhof
2008/8/26 Cecil Westerhof [EMAIL PROTECTED]: First I had: for row in engine.execute('SELECT MIN(gewicht) AS gewicht ' ', MIN(vet) AS vet ' ', MAX(water) AS water ' ', MAX

[sqlalchemy] Re: Working with several database without needing to know in which database an object resides

2008-08-27 Thread Cecil Westerhof
# Is there a way to do this? -- Cecil Westerhof --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email

[sqlalchemy] Re: Working with several database without needing to know in which database an object resides

2008-08-27 Thread Cecil Westerhof
2008/8/27 Cecil Westerhof [EMAIL PROTECTED]: At this moment I am not working with update and delete. (Just started trying to implement something with sqlalchemy.) But when people would like to know how I am going to solve that, I can post that at the moment I am using those. (I could use

[sqlalchemy] Re: Working with several database without needing to know in which database an object resides

2008-08-27 Thread Cecil Westerhof
2008/8/27 Cecil Westerhof [EMAIL PROTECTED]: By the way is there a method to put an AS part in the select? For example: # stmt = sa.select([sa.func.max(KmStand.eindStand)]) print stmt SELECT max(kmStand.eindStand) AS max_1 FROM kmStand # I would like to have: # SELECT max

[sqlalchemy] Working with several database without needing to know in which database an object resides

2008-08-26 Thread Cecil Westerhof
and sqlalchemy.orm are allready imported and that importing again should not have -significant- consequences. Is that true? -- Cecil Westerhof --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post