[sqlalchemy] execute Stored procedure.

2017-06-27 Thread Vigneshrajan
Is it is possible to execute stored procedure in connection.execute() function? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See

[sqlalchemy] Trouble with ordering_list extension

2017-06-27 Thread Andy Green
Hi All, I'm having some trouble using an OrderingList as a relationship "collection_class". I suspect there is a bug in the implementation of the `__reduce__` function on the OrderingList class. I'm using SQLAlchemy version 1.1.11. Posting a MWE or my actual code is going to take a fair bit

[sqlalchemy] Re: Wierdness with JSONB / Python dictionary

2017-06-27 Thread Andrew M
I can also replicate it with JSON, with a table defined as follows: class Test(Base): __tablename__ = 'test' id = Column(INT, primary_key=True, index=True) json = Column(JSON, default={}) And running the following code: p0 = Test() p1 = Test() session.add(p0) session.add(p1)

[sqlalchemy] Wierdness with JSONB / Python dictionary

2017-06-27 Thread Andrew M
Hi, I'm getting some unexpected results when using a JSONB column to store the results of a Python dictionary. I have defined a column as follows: rrp_i8n = Column(JSONB, default={}) What I'm finding is that the method of setting the value is critical (when it should not be). Test case as