[sqlalchemy] Re: guessing sql joins from object level

2006-12-15 Thread che
Hi, Michael Bayer написа: SA can form joins between tables automatically if the tables express the proper foreign key relationship between each other, and if there is no ambiguity in that relationship; i.e. table A and table B have only one ForeignKeyConstraint (or single ForeignKey)

[sqlalchemy] Re: guessing sql joins from object level

2006-12-15 Thread Michael Bayer
a.join(b).join(c).join(d).join(e). just do a little experimentation, it'll reveal a lot. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: SA ORM delete efficiency

2006-12-15 Thread ml
This is a duplicate mail (due to a recent SMTP problems). Don't reply. DS ml píše v Po 11. 12. 2006 v 23:13 +0100: Hi! I have a little questions about how does the SA work: Example: I borrowed a model from SA documentation example User/Address. My mapper is

[sqlalchemy] Re: Again MySQL/unicode - roundtrip failed

2006-12-15 Thread Stefan Meretz
On 2006-12-13 22:38, Shannon -jj Behrens wrote: My memory is that MySQLdb recently changed a bunch of stuff and that it was a simple logic bug. You mean, that just the entire logic is reversed? This would explain, why reading is working (from Mike's Mail): def convert_result_value(self,

[sqlalchemy] dump sqlalchemy-mapped object to xml

2006-12-15 Thread [EMAIL PROTECTED]
Greetings, I need to dump a sqlalchemy-mapped object to XML, like it implemented in pyxslt for SQLObject. So, the questions are: 1) how to separate columns and properties from the other mapped object's attributes properly - I need columns, properties and backrefs (surprised, but backrefs work

[sqlalchemy] Re: PGBigInteger behaving like Integer

2006-12-15 Thread Michael Bayer
the INTEGER column coming out is a bug, i just checked in 2167 for that. for the SERIAL column i just checked the pg docs and noticed that youre expecting BIGSERIAL, so I put a little conditional in for that in rev 2168. you should now get CREATE TABLE company ( company_id BIGSERIAL NOT

[sqlalchemy] Re: dump sqlalchemy-mapped object to xml

2006-12-15 Thread Michael Bayer
youd have to map it back to the mapper's list of props. PropertyLoader, which is a certain type of MapperProperty, has a flag is_backref indicating this. getattr(class_mapper(someclass).props[attributename], 'is_backref', False) --~--~-~--~~~---~--~~ You

[sqlalchemy] Re: Again MySQL/unicode - roundtrip failed

2006-12-15 Thread Shannon -jj Behrens
On 12/15/06, Stefan Meretz [EMAIL PROTECTED] wrote: On 2006-12-13 22:38, Shannon -jj Behrens wrote: My memory is that MySQLdb recently changed a bunch of stuff and that it was a simple logic bug. You mean, that just the entire logic is reversed? This would explain, why reading is working

[sqlalchemy] Re: PGBigInteger behaving like Integer

2006-12-15 Thread Sanjay
Thanks! Again I am overwhelmed by the excellant response!! sanjay --~--~-~--~~~---~--~~ 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

[sqlalchemy] error on insert multi record

2006-12-15 Thread tocer
Hi: I'm using SA 2.8. I met a strange error. following is a piece of code: flight.insert().execute(*(_insdict.values())) it run without error. but after runing, some data in flight table is wrong, another is right. So I change the code: for d in _insdict.itervalues():

[sqlalchemy] Re: error on insert multi record

2006-12-15 Thread Michael Bayer
never seen this issue before. if it persists, post a full test case to the list. --~--~-~--~~~---~--~~ 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