[sqlalchemy] Re: sqlalchemy rocks my socks off!

2011-01-15 Thread Eric Ongerth
+1 On Jan 13, 5:08 pm, rdlowrey rdlow...@gmail.com wrote: To Michael Bayer: sqlalchemy simplifies my life every day and makes me vastly more productive! Many thanks. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send

[sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Tvrtko
On Jan 15, 11:56 am, Tvrtko qvx3...@gmail.com wrote: First, let me say that I'm using sqlalchemy version 0.5.8. We have a large and complex application and changing to sa 0.6 is expensive, so I would like, if possible, to find a solution for 0.5. I'm using sqlalchemy since version 0.1.

[sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Tvrtko
I've drilled down all the way up to `mapper._save_obj()`. I examined the `state.dict` for `qitem`. Good case: qitem state dict = {'campaign': Campaign 233, u'Test', 'campaign_id': 233, ...} And for the bad case: qitem state dict = {'campaign': Campaign 234, u'Test', 'campaign_id':

[sqlalchemy] one to may Commit

2011-01-15 Thread borisov
Hello. A have this model. How to make Order() and Orderitems() objects during one commit() I'm trying no = Order() noi = Orderitem() no.orderitems.append(noi) Session.add(no) Session.commit() but get an error IntegrityError: (IntegrityError) null value in column order_id violates not-null

Re: [sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Michael Bayer
So, you have A-B, an exception occurs, you do the rollback, then you're somehow trying to continue on within the web request ? The code examples here are out of context snippets and I don't see any exception handling happening so they don't really tell me much.When the flush fails, the

[sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Tvrtko
On Jan 15, 4:35 pm, Michael Bayer mike...@zzzcomputing.com wrote: So, you have A-B, an exception occurs, you do the rollback, then you're somehow trying to continue on within the web request ?     The code examples here are out of context snippets and I don't see any exception handling

Re: [sqlalchemy] one to may Commit

2011-01-15 Thread Michael Bayer
More information is needed. Test case, psycopg2, SQLA 0.6.6, works fine: from sqlalchemy import * from sqlalchemy.orm import * metadata= MetaData() orders_table = Table('orders', metadata, Column('id', Integer, primary_key=True, autoincrement=True), Column('created', DateTime,

Re: [sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Michael Bayer
On Jan 15, 2011, at 11:10 AM, Tvrtko wrote: On Jan 15, 4:35 pm, Michael Bayer mike...@zzzcomputing.com wrote: So, you have A-B, an exception occurs, you do the rollback, then you're somehow trying to continue on within the web request ? The code examples here are out of context

[sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Tvrtko
This is my first such case in 5-6 years of using the SA. Usually the problem was with my code. This could also be the case now, but it escapes me where I made a mistake. Thank you for your time. I will consider this closed for now and move on using a workaround of explicitly populating

Re: [sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Michael Bayer
On Jan 15, 2011, at 11:53 AM, Tvrtko wrote: This is my first such case in 5-6 years of using the SA. Usually the problem was with my code. This could also be the case now, but it escapes me where I made a mistake. not suggesting you made a mistake. suggesting that some artifact of your

[sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Tvrtko
On Jan 15, 5:57 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jan 15, 2011, at 11:53 AM, Tvrtko wrote: This is my first such case in 5-6 years of using the SA. Usually the problem was with my code. This could also be the case now, but it escapes me where I made a mistake. not

[sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Tvrtko
On Jan 15, 5:53 pm, Tvrtko qvx3...@gmail.com wrote: This is my first such case in 5-6 years of using the SA. Usually the problem was with my code. This could also be the case now, but it escapes me where I made a mistake. Thank you for your time. I will consider this closed for now and move

Re: [sqlalchemy] Re: Objects are wrongly getting removed/expunged from session

2011-01-15 Thread Michael Bayer
On Jan 15, 2011, at 8:37 PM, Tvrtko wrote: On Jan 15, 5:53 pm, Tvrtko qvx3...@gmail.com wrote: This is my first such case in 5-6 years of using the SA. Usually the problem was with my code. This could also be the case now, but it escapes me where I made a mistake. Thank you for your

[sqlalchemy] attributes.get_history() from mapper extension's before_update()

2011-01-15 Thread Kent
Is it safe trust attributes.get_history(instance, attrname) from mapper extension's before_update()? I assume this is not reset until later? Kent -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Pass query with as parameter (avoid creating a method and hardcoding a query)

2011-01-15 Thread Hector Blanco
Hello list... I would like to allow the users to perform certain queries without me (or well... my server) knowing in advance what those queries are going to be (without hard-coding the query). For instance: I have a “Product” class. One of it's fields is manufacturer and another is model class