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:
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
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,
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 =
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
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),
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.