[Modeling-users] New: Oracle Adaptor Layer

[Sebastien B. <sbi...@us...>]

        Hi all,

  I've finally installed an oracle db, and made the corresponding
  database layer. You'll find it at
  https://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D774894&grou=
p_id=3D58935&atid=3D489337

  It is made of: a patch, and a tarball archive. This is for 0.9-pre-10.

  The installation procedure is described there. It has been tested on
  linux/debian woody (3.0) with Oracle 8i (v.8.1.7.0.0) and Oracle 9i
  (v9.2.0.1.0).

  Dependencies: python db-adaptor DCOracle2 at
                http://www.zope.org/Members/matt/dco2.

  Supported sql datatypes:

     char, varchar, varchar2, nchar, nvarchar2
     number, decimal, int, integer, smallint, float, numeric, real,
     date, time

  with the additional datatypes for 9i:

     timestamp, timestamp with time zone, timestamp with local time zone

  Note 1: not all datatypes were tested, esp. timestamp[l]tz, I had no
          time for these.

  Note 2: the framework does not mess with the returned python
          attribute. For example, if you have a DATE column, you'll get
          a DCOracle1.OracleDate object. Refer to
              tests/testPackages/AuthorBooks/Book.py
          for an example on how they can be automatically converted into
          mx.DateTime objects (and back).

  Note 3: because of the format DCOracle2.OracleDate uses in a string
          context, every session is automatically altered with:
            alter session set nls_date_format =3D 'YYYY-MM-DD HH24:mi:ss'

  The only limitation wrt the other db layers is that it's not capable
  yet to create a database (i.e. create a user), so you'll have to do it
  by hand or use one of the default (system e.g.).

  If you test it, I'd like to hear for you here!

        Regards,

-- S=E9bastien.