Login | Register
My pages Projects Community openCollabNet

Discussions > dev > Fwd: Current with Oracle backend

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

current
Discussion topic

Back to topic list

Fwd: Current with Oracle backend

Reply

Author theslack
Full name Jack Neely
Date 2006-08-31 10:29:47 PDT
Message Comments?

---------- Forwarded message ----------
From: Jared Greenwald <jared.greenwald@​oracle.com>
Date: Aug 31, 2006 12:55 PM
Subject: Re: Current with Oracle backend
To: Jack Neely <jjneely at gmail dot com>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ok, I've got the oracle support in place. I created the DB by hand this
time since setting up the auto_increment -like feature in oracle is a
bit tricky. I initially ran into a problem where the cx_Oracle package
wasn't able to find the oracle api libraries, but that was fixed with an
entry in /etc/ld.so.conf.d/. This allowed a "cadmin test" against the
oracle backend.

I seem to be running into an error with the db interaction code.
Specifically, you're not using bind vars for inputting information into
the db.

Specifically, I'm thinking that all of the execution statements will
need to be re-written to use bind vars. I'm just not sure if all the db
apis support bind vars (pysqlite especially). It's def screwing up the
oracle execute statement.

- -Jared

Jack Neely wrote:
> The logger.py module that everything imports has been ported to use
> python's logging stuff.
>
> Jack
>
> On 8/30/06, Jared Greenwald <jared.greenwald@​oracle.com> wrote:
> Something I just noticed. You mentioned transitioning to the logger
> module, but in reading the pysqlite.py code, it seems to be still using
> the home-brew logger method. Is this intentional?
>
> -Jared
>
> Jack Neely wrote:
>> Yeah...in theory you could create the database by hand. You got it.
>
>> The pyc/pyo files you don't need to worry about. Python will manage
>> those as it needs. (Of course, propper RPM packaging takes a bit more
>> work, but the current spec file should work. There have been a lot of
>> changes sence 1.7.4 so not sure...)
>
>> Jack
>
>> On 8/29/06, Jared Greenwald <jared.greenwald@​oracle.com> wrote:
>> But other than just calling the initdb routine, there's really nothing
>> more to it, right? (As in, if I created the db off to the side, it
>> shouldn't matter, right? As long as it had the correct layout.)
>
>> I had previously made changes to currentdb.py (to add the new db type)
>> and created my own oracle sub-dir (of db) and created the __init__.py
>> and oracle.py files.
>
>> -Jared
>
>> Jack Neely wrote:
>>> cinstall calls current.db.currentdb​.CurrentDB().initdb(​) which calls
>>> the initdb() method of the specificDB object that is associated with
>>> that specific database, in your case Oracle.
>
>>> You may also want to see current/db/__init__.py.
>
>>> Jack
>
>>> On 8/29/06, Jared Greenwald <jared.greenwald@​oracle.com> wrote:
>>> Where is the initdb code located? I'm thinking that there might be
>> some
>>> issues with how it creates the db, but I want to check over the code
>>> first.
>
>>> Thanks for all the help. I really appreciate it.
>
>>> -Jared
>
>>> Jack Neely wrote:
>>>> Jared,
>
>>>> Yeah...you need to edit the current.conf config file, cinstall
> initdb,
>>>> create_channel, add_dir, and scan. Current will still touch the
>>>> filesystem (some files are named from a datestamp) but it knows what
>>>> to do if stuff is already there.
>
>>>> Jack
>
>>>> On 8/29/06, Jared Greenwald <jared.greenwald@​oracle.com> wrote:
>>>> Excellent. Works like a charm. If I'm going to change databases,
>> so I
>>>> need to re-configure anything other than having the schema setup? I
>>>> imagine that I'll have to create_channel, add_dir, scan, etc... to
>>>> re-setup this channel...
>
>>>> -Jared
>
>>>> Jack Neely wrote:
>>>>> Jarad,
>
>>>>> up2date --showall wont work until the initial cadmin scan. I can
>> tell
>>>>> you haven't done the scan because of this
>
>>>>> 'lastupdate': None
>
>>>>> in the logs.
>
>>>>> The scan wont work until apache has the proper permissions for
>>>>> /export/current
>
>>>>> Jack
>
>
>
>>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE9xR1u4z7Xptg​TUYRAoQ2AJ46cr8JYL9i​81lkXT8Eig1oOXnDewCg​pyJQ
yt/rzxh/0gq+kkl9HxSzhPw=
=OUkP
-----END PGP SIGNATURE-----

« Previous message in topic | 1 of 2 | Next message in topic »

Messages

Show all messages in topic

Fwd: Current with Oracle backend theslack Jack Neely 2006-08-31 10:29:47 PDT
     Re: Fwd: Current with Oracle backend Pauline Middelink <middelink at polyware dot nl> Pauline Middelink <middelink at polyware dot nl> 2006-08-31 23:39:44 PDT
Messages per page: