Add Oracle support

[vasily.ivanov@…]

Now if DATABASE_ENGINE is oracle South fails with the following error:

There is no South database module for the engine 'oracle' (tried with south.db.oracle). Please either choose a supported one, or check for SOUTH_DATABASE_ADAPTER settings, or remove South from INSTALLED_APPS.

I'd be more than happy to add Oracle support if you tell me where to start.

[andrew]

Please do! The basic steps are:

• Make a new south.db.oracle module; it should contain a DatabaseOperations? class which inherits from the one in south.db.generic (see the various other backends' ones)
• Start overriding settings and SQL strings so they are correct. The generic operations will probably work for many things, but rename column, changing indexes, etc., will probably need changing. Some settings can be altered directly on the class properties - for example, MySQL sets has_ddl_transactions = False (which makes South be extra-careful), and overrides some of the SQL template strings.

Pop on IRC (there's details on it in the support section) and chat to me there, I can guide you through any issues you might have.

[anonymous]

is this still targeted for 0.7? what is the expected release date for 0.7?

thanks

[andrew]

It's targeted for 0.7 since it's a feature I'd like to write, but at the moment I don't have access to an Oracle database nor has someone offered to help write it, so it's on hold until either of those comes true.

[anonymous]

gotcha. I've never installed an oracle DB, thought it would be fairly easy but I suppose not.

is there any way to watch this ticket other than an RSS feed?

...i'm also looking at trying out South for my Django app..if I get it going successfully I'll let you know.

[andrew]

Stick your name in the cc: field (don't worry, Trac will obscure the last part of your email address to the internet at large), and you'll get emails.

[codecraig@…]

cool thanks

[ilya.roitburg@…]

implementation of migration for Oracle DB

[ilya.roitburg@…]

Please, find attached module that I use for migration of two Django applications in my company (we use Oracle). Yet it works for ours application, I'm sure it does not prove code correctness and does not cover all test cases. Anyway, I thought you might find it useful.

Best Regards,

[andrew]

Ah, excellent - I'll take a look over it later.

[vasily.ivanov@…]

Ilya, you're the champ! Спасибо! :-)

[andrew]

Module merged into trunk in [2e55249be457]. I'll try and get an Oracle install set up so I can maintain the code.