On Tue, Apr 22, 2008 at 12:11 AM, Chris Curvey <[EMAIL PROTECTED]> wrote: > > I'm going to apologize in advance for such a poorly-phrased request > for help. Here goes. > > I have an app that contains code like this: > > rowset = m.Rowset(orig_job=job, orig_row_in_job=i+1) > e.session.flush() > > print "rowset.id = %s" % rowset.id > ads = m.AdDeliveryStage(job=job, rowset=rowset) > print "ads.rowset = %s" % ads.rowset > print "ads.rowset_id = %s" % ads.rowset_id > #ads.rowset_id = rowset.id > > it runs fine on my development box. It runs fine on my integration > box. it fails on the production box where I'm trying to install it, > *unless* I comment out that last line. It "fails" because the value > of rowset_id is not set on my ad_delivery_stage table if the last line > is commented out. (ad_delivery_stage.job_id is fine, however). > > I've checked versions, and things seem to be in shape there. I'm > running the head revision (320) of elixir's trunk. I'm running SQL > Alchemy 0.4.5. The only difference I can find is that on my > integration box, I installed elixir with "python setup.py develop". > That did not work on my production box (elixir could not be found, and > I could not figure out why), so I installed elixir with "python > setup.py install". > > Has anyone seen anything like this? I'm trying to put together a > demonstration script, but I'm having no luck duplicating the problem.
Nope.You do flush after that last line, right? What is the result of those prints? Also, if you turn on echo on your engine (metadata.bind.echo=True), what are the SQL queries generated? -- Gaëtan de Menten http://openhex.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
