Re: [SQLObject] SQLObject / Oracle

[Andy T. <an...@ha...>]

Dirk Evers wrote:

> Hi,
> 
> I also started to work on an Oracle version of SQLObject a few days ago,
> also using cx_Oracle.
> 
> Problems I encountered are the slice notation
> access to tables, because Oracle does not have anything like 
> LIMIT and OFFSET. Workarounds need a more complex SQL statement with
> the original statement included as a sub-select. Not very nice!
> This makes it necessary to overload functions at a higher level in SQLObject
> -- i.e. queryForSelect -- because the added statement is not just an added suffix.
> (Haven't implemented this yet.)
> Moreover, Oracle does not know anything like AUTOINCREMENT for the PRIMARY KEY
> statement, which makes things a tad more complicated. I used sequences to
> implement this. I was just about to start on the columnsFromSchema functions
> when I read your email. :-)
> 
> John, let's compare our code changes to SQLObject and take it from there.
> I would be very happy to see an Oracle version of SQLObject come to production
> very fast!
> 
> Regards
> Dirk Evers
> 
> 
> On Mon, Sep 29, 2003 at 11:41:58PM -0500, John Dell'Aquila wrote:
> 
>>I just discovered SQLObject and was excited to kick the tires. Unfortunately
>>I don't use any of the supported databases, so I hacked together an Oracle
>>connection using cx_Oracle.
>>
>>I don't fully understand the framework yet but I've managed to get all the
>>column types working. I also implemented referential integrity constraints
>>on ForeignKey columns since I want the tables to be safe for use from the
>>database side as well. I also want to get columnsFromSchema implemented if I
>>can figure out what's going on from the Postgres implementation.
>>
>>So far SQLObject looks very cool. The metaclass implementation definitely
>>gives me the best "feel" of all the ORMs I've looked at -- very Pythonic.
>>
>>Is any one else workng on an Oracle implementation? Are there any plans to
>>refactor the hooks for adding new backends?
>>
>>- John Dell'Aquila
>>

Whilst I don't have much time to help develop the code I'd be more than 
happy to help you test it. Mail me off list if/when you need a guinea pig.

Regards,
Andy
-- 
--------------------------------------------------------------------------------
 From the desk of Andrew J Todd esq - http://www.halfcooked.com/