Re: [SQLObject] SQLObject / Oracle

[Dirk E. <D....@ex...>]

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
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

-- 
--------------------------------------------------------------------------
Dirk Evers                               Bioinformatics Research Scientist
Exelixis Deutschland                              Fon: +49 (0)7071-9655-16
Spemannstr. 35                                    Fax: +49 (0)7071-9655-96
D-72076 Tuebingen, Germany                   URL: http://www.exelixis.com/
--------------------------------------------------------------------------