{{{
#!text/x-rst
========================================
Preparing an Oracle GeoDjango test setup
========================================

Since GeoDjango requires full featured Oracle installation instead of XE this document
is meant to ease up installation and testing GeoDjango parts.

==============
Prerequisities
==============

Install Oracle client and set it up as documented in https://docs.djangoproject.com/en/1.4/ref/databases/#oracle-notes
Install GeoDjango requirements as documented in https://docs.djangoproject.com/en/1.4/ref/contrib/gis/install/

======================
How to get full Oracle 
======================

Easiest way is to use Oracle VirtualBox with prebuilt Oracle installation VM.

#. Download and install **Oracle VirtualBox** from http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html or use package manager from your system.

#. Download **Oracle Developer Day** image from http://download.oracle.com/otn/other/virtualbox/dd/Oracle_Developer_Day.ova

 **NOTE: You may not use Oracle Developer Day VM for any other purposes than testing**

==============
Database setup
==============

#. Create a user and give the needed privileges::

    $ sudo su oracle
    $ sqlplus / as sysdba
    SQL> CREATE USER djangotest IDENTIFIED BY djangotest;
    SQL> GRANT DBA TO djangotest;
    SQL> quit
    $ exit

=========
Run tests
=========

#. Create geodjango_oracle.py settings file (change IP to one that is reported in VM console)::
    
    TEST_RUNNER = 'django.contrib.gis.tests.GeoDjangoTestSuiteRunner'

    DATABASES = {
    	'default' : {
    		'ENGINE' : 'django.contrib.gis.db.backends.oracle',
   		'PORT' : '1521',
    		'HOST' : '192.168.56.101',
    		'NAME' : 'orcl',
    		'USER' : 'djangotest',
    		'PASSWORD' : 'djangotest',
        },
    }

#. Run tests::

    django-admin.py test --settings=geodjango_oracle
}}}