Re: [sqlalchemy] unhandled data type cx_Oracle.LOB

2015-03-17 Thread GP
Ah! I will keep track of it - for now, I will just ignore AttributeError exception. I am loving sqlalchemy, thanks for creating and maintaining it! -GP On Monday, March 16, 2015 at 11:37:36 PM UTC-4, Michael Bayer wrote: GP pandit...@gmail.com javascript: wrote: That's what I thought

Re: [sqlalchemy] unhandled data type cx_Oracle.LOB

2015-03-16 Thread GP
this? Thanks GP On Monday, March 16, 2015 at 10:08:47 PM UTC-4, Michael Bayer wrote: GP pandit...@gmail.com javascript: wrote: OK, is “cancellation_obj” a column object with CLOB as the datatype ? Yes, that's how it's defined in the database. Because of dynamic nature of the code

Re: [sqlalchemy] unhandled data type cx_Oracle.LOB

2015-03-16 Thread GP
nonsense. Thanks GP On Monday, March 16, 2015 at 3:49:32 PM UTC-4, GP wrote: Thank you Michael. auto_covert_lobs : I ran with all three possible values: True, False, and without supplying it. The results are the same. The original query is a bit more complicated than the example I gave

Re: [sqlalchemy] unhandled data type cx_Oracle.LOB

2015-03-16 Thread GP
*: select_query = select([source_table.c.contract_id, source_table.c.cancel_dt, source_table.c.cancellation_quote_obj]) So it's just matter of rewriting select query in the 'right' way. Thanks for pointing in the right direction! GP On Monday, March 16, 2015 at 4:57:28 PM UTC-4, GP wrote: I think now I

[sqlalchemy] unhandled data type cx_Oracle.LOB

2015-03-16 Thread GP
. Any help? Thanks! GP -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy

[sqlalchemy] Auto-loading With Relationships

2009-02-17 Thread Gp
We have sets of databases with several hundred tables per database. Most of these tables are linked using various foreign key relationships. Is there any sort of automatic SQL Alchemy generation? Either SQL Soup like loading or a script that gets run once that generates code for use. -Gp

[sqlalchemy] Re: Auto-loading With Relationships

2009-02-17 Thread Gp
wrote: Hi, On Tue, Feb 17, 2009 at 2:50 PM, Gp gpm...@gmail.com wrote: We have sets of databases with several hundred tables per database. Most of these tables are linked using various foreign key relationships. Is there any sort of automatic SQL Alchemy generation? Either SQL Soup like