[sqlalchemy] Operational Error

2011-03-03 Thread priti uikey
Hi... I am doing my 1st pylon project. I am inserting 2 values in the text boxes and clicking on the ADD(inserting these values in the database)button... Below is the error after clicking on the ADD button. What is the exact reason of this error. plz help me. OperationalError:

[sqlalchemy] Bug in mssql dialect?

2011-03-03 Thread Michael Naber
Last line is invalid t-sql. The ‘==’ should just be ‘=’. I get the problem when using mssql but not with sqlite. Saw the bug on sqa version 0.6.6, upgraded to 0.7b2 and still having issue. Please let me know if you need more info and I'll be happy to provide. Thanks, Michael Traceback (most

Re: [sqlalchemy] Bug in mssql dialect?

2011-03-03 Thread Michael Bayer
That looks certainly like a misconfigured relationship(). Not sure why SQLite would let it pass through (sqlite is in general extremely liberal), but that's clearly a literal string passed to a join expression sent to relationship as in relationship(... primaryjoin=and_(some expression,

[sqlalchemy] Unmapped Column Error

2011-03-03 Thread Doug
Hello all, I've just started using SQLAlchemy recently (and it's been great) but I have run into a problem recently. I am trying to map a table back to itself via a second many-to-many table in a declarative fashion. I have this working as so (mapper configuration): category_association =

Re: [sqlalchemy] Unmapped Column Error

2011-03-03 Thread Michael Bayer
On Mar 3, 2011, at 5:11 PM, Doug wrote: Hello all, I've just started using SQLAlchemy recently (and it's been great) but I have run into a problem recently. I am trying to map a table back to itself via a second many-to-many table in a declarative fashion. I have this working as so

[sqlalchemy] Re: Unmapped Column Error

2011-03-03 Thread Doug
Thanks for the tip Michael, that solved my problem! It now looks like: category_association = Table('BankCategoryMap', Base.metadata, Column(ParentCategoryID, Integer, ForeignKey('BankCategories.ID'), primary_key=True),

[sqlalchemy] Deadlock in iterating over a session

2011-03-03 Thread Lenza McElrath
Hello! I'm iterating over a session to look at all the objects: for obj in session: do_something_cool(obj) Yesterday this caused what looks like a deadlock in SQLAlchemy code. Here is the stack I grabbed using gdb: 1. /python2.5/sqlalchemy/orm/session.py:1353 (Session.__iter__) 2.