Merge lp://staging/~jbaker/storm/oracle_support into lp://staging/storm

Proposed by Jason Baker
Status: Needs review
Proposed branch: lp://staging/~jbaker/storm/oracle_support
Merge into: lp://staging/storm
Diff against target: 1573 lines (+1287/-39)
9 files modified
README (+38/-2)
oracle_test_setup.sql (+13/-0)
storm/databases/oracle.py (+590/-0)
storm/expr.py (+1/-1)
storm/variables.py (+2/-0)
tests/databases/base.py (+32/-31)
tests/databases/oracle.py (+372/-0)
tests/store/base.py (+5/-5)
tests/store/oracle.py (+234/-0)
To merge this branch: bzr merge lp://staging/~jbaker/storm/oracle_support
Reviewer Review Type Date Requested Status
Jamu Kakar (community) Abstain
Storm Developers Pending
Review via email: mp+15442@code.staging.launchpad.net
To post a comment you must log in.
Revision history for this message
Jason Baker (jbaker) wrote :

This should be ready for merge. I've commented out the disconnection tests for now. Some parts of this are still somewhat ugly, but it's a good starting point.

Revision history for this message
Jamu Kakar (jkakar) wrote :

[1]

I've managed to get Oracle XE installed, but I'm having trouble
getting cx_Oracle in place, so I can't run the test suite yet. I'm
going to keep at it, but if you have any hints on how to get
cx_Oracle in place (on a 64-bit machine) I'd appreciate some help.
Ideally, packages for Ubuntu would be nice.

[2]

I've pushed a branch that adds some details about getting Oracle XE
installed on a 64-bit machine to the README file and makes some
cosmetic changes to make the code match the Storm coding style more
closely. Please merge:

lp:~jkakar/storm/oracle-support-tweaks

[3]

Why isn't the builtin reserved words functionality being used?

I've made a broad pass over the changeset and it looks really good.
I'd like to get the test suite running before I do a more detailed
pass.

Revision history for this message
Jason Baker (jbaker) wrote :

> [1]
>
> I've managed to get Oracle XE installed, but I'm having trouble
> getting cx_Oracle in place, so I can't run the test suite yet. I'm
> going to keep at it, but if you have any hints on how to get
> cx_Oracle in place (on a 64-bit machine) I'd appreciate some help.
> Ideally, packages for Ubuntu would be nice.

I found this blog post to be a good help: http://catherinedevlin.blogspot.com/2007/10/cxoracle-and-oracle-xe-on-ubuntu.html ... Although note that they're a little bit outdated. I don't believe it's necessary to install the XE patch.

If you can give me a specific error message, I might be able to help out.

> [2]
>
> I've pushed a branch that adds some details about getting Oracle XE
> installed on a 64-bit machine to the README file and makes some
> cosmetic changes to make the code match the Storm coding style more
> closely. Please merge:
>
> lp:~jkakar/storm/oracle-support-tweaks

I'll look at them. Thanks!

> [3]
>
> Why isn't the builtin reserved words functionality being used?

I don't recall the *exact* reason why I did that, but there was some issue with the reserved word keylist considering words to be reserved that weren't. Perhaps a better solution would be to update the reserved word list. It's a bit dated (SQL 1992).

Revision history for this message
Jason Baker (jbaker) wrote :

> lp:~jkakar/storm/oracle-support-tweaks

Erm.... This branch doesn't seem to exist. Unless of course I'm doing something wrong (which is possible).

Revision history for this message
Jamu Kakar (jkakar) wrote :

Oops, the branch was private by mistake. It should be visible now.

357. By Jason Baker

Merging in changes from trunk.

358. By Jason Baker

Merging some changes in from lp:~jkakar/storm/oracle-support-tweaks

359. By Jason Baker

Updating from trunk.

360. By Jason Baker

Making the oracle backend properly handle disconnection errors

Revision history for this message
Jason Baker (jbaker) wrote :

Where do we stand on this? I've just merged in the latest revisions from trunk and also added a bugfix that makes the disconnection tests now pass.

Revision history for this message
Jamu Kakar (jkakar) wrote :

I had spent some time looking at this a while ago. I got as far as
getting Oracle installed (which was hard on 64-bit) and then stopped
when I had to figure out how to compile cxOracle DB-API drivers. I
looked over the code, and it looks good, but want to actually be
able to run the test suite.

I've since installed a new disk in my machine, so I'll need to setup
Oracle et al. again to continue. I've been thinking that we really
need a buildbot, since getting Oracle in place is rather awkward and
most Storm developers probably won't want to do it.

Revision history for this message
Jamu Kakar (jkakar) wrote :

I haven't managed to get Oracle installed. I'm going to abstain
from reviewing this for now.

review: Abstain

Unmerged revisions

360. By Jason Baker

Making the oracle backend properly handle disconnection errors

359. By Jason Baker

Updating from trunk.

358. By Jason Baker

Merging some changes in from lp:~jkakar/storm/oracle-support-tweaks

357. By Jason Baker

Merging in changes from trunk.

356. By Jason Baker <jason@ubuntu>

Added instructions for getting started with Oracle.

355. By Jason Baker <jason@ubuntu>

Adding in a script to set up a test user in an oracle database.

354. By Jason Baker <jason@ubuntu>

Reverting the error handling back to the way it was for now. For whatever reason, this led to spurious error reports when running tests.

353. By Jason Baker <jason@ubuntu>

Temporarily commenting out the Disconnection tests until they can be fixed.

352. By Jason Baker <jason@ubuntu>

Adding an error description for cx_Oracle not being found

351. By Jason Baker <jason@ubuntu>

Merge from trunk.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
The diff is not available at this time. You can reload the page or download it.

Subscribers

People subscribed via source and target branches

to status/vote changes: