Re: [sqlalchemy] double data insert in many-to-many relations

2010-09-01 Thread Francisco Souza
and two association tables: messages_users_receiving and messages_users_sending. So you configure two many to many relationships with different secondary tables. Cheers, Francisco Souza Software developer at Giran and also full time Open source evangelist at full time English: http

Re: [sqlalchemy] Re: double data insert in many-to-many relations

2010-09-01 Thread Francisco Souza
? If a message is sent only by a user, you should have a many to one relationship between message and user (the sender), and a many to many relationshop between the same tables (the receivers, that can be one or more users). Best regards, Francisco Souza Software developer at Giran and also full time

Re: [sqlalchemy] alchemy-migrate with DeclarativeBase

2010-06-17 Thread Francisco Souza
I know is that MySQL supports transactions only when you are working with InnoDB engine. Best wishes, Francisco Souza Software developer at Giran and also full time Open source evangelist at full time http://www.franciscosouza.com.br Twitter: @franciscosouza (27) 3026 0264 -- You received

Re: [sqlalchemy] Using update()

2010-06-16 Thread Francisco Souza
Hi :) Take a look at this sample: http://paste.pocoo.org/show/226056/ The update is performed in the line 42. update() is a query operation :) See official docs: http://www.sqlalchemy.org/docs/reference/orm/query.html#sqlalchemy.orm.query.Query.update Best regards, Francisco Souza Software