Re: [sqlalchemy] array types using OracleDialect

2014-02-13 Thread Amos Smith
uot;, ".join(str(v) for v in arr) + ")”) ret = session.execute(func.some_db_func(oracle_array([1,2,3,4,5]))).scalar() On Feb 13, 2014, at 1:38 PM, Amos Smith wrote: > Thanks! ... this is working nicely. > > With a bit of customization this gives me an interim solution for passi

Re: [sqlalchemy] array types using OracleDialect

2014-02-13 Thread Amos Smith
et = session.execute(func.some_db_func(a)).scalar() On Feb 13, 2014, at 1:03 PM, Amos Smith wrote: > I found the missing space before literal_processor in my earlier listing, > poor font selection hid that pretty well - still not sure why I couldn't see > that ear

Re: [sqlalchemy] array types using OracleDialect

2014-02-13 Thread Amos Smith
onmaker(bind=engine) session = sessionMaker() a = LiteralBindParam(None, ArrayType([1,2,3,4,5])) ret = session.execute(func.some_db_func(a)).scalar() print ret - Original Message - From: "Amos Smith" To: sqlalchemy@googlegroups.com Sent: Wednesday, February 12, 2014 3:57:40 PM Su

Re: [sqlalchemy] array types using OracleDialect

2014-02-12 Thread Amos Smith
I migrated to 0.9.2 as I understood the literal_processor was new feature. I always get this error from listing shown below: def literal_processor(self, dialect): ^ IndentationError: unindent does not match any outer indentation level ArrayType is obv

Re: [sqlalchemy] array types using OracleDialect

2014-02-12 Thread Amos Smith
Regarding the following: > if the type of the LiteralBindParameter implements “literal_processor()”, > that controls how the literal value is rendered into the statement. How does one implement the "literal_processor()" for a new type? Is literal_processor() method applicable for UserDefinedTy