Changes between Version 14 and Version 15 of OracleTestSetup


Ignore:
Timestamp:
Apr 22, 2011, 12:13:21 PM (14 years ago)
Author:
Ramiro Morales
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • OracleTestSetup

    v14 v15  
    248248=====================================
    249249
    250 An Oracle instance allows the existence of only one database. This is somewhat different from what we could be accustomed from working with other RDBMS. For more details see the `relevant Oracle documentation`_.
     250An Oracle instance allows the existence of only one database. This is somewhat different from what we could be accustomed to from working with other RDBMS. For more details see the `relevant Oracle documentation`_.
    251251
    252252*Oracle XE* allows the existence of only one database instance (named ``'xe'``). So, when the Django ORM testing code needs to test multi-DB functionality added in version 1.2, the Django Oracle backend implements that by creating what is know as *tablespaces*. The overall scheme of things is like this:
     
    254254For every DB alias defined in ``DATABASES``:
    255255
    256 * The ``'NAME'`` variable value specifies the name of the DB we ask the Oracle engine for ('xe' in the case of XE). AFAIK This can be further controlled by using the ``tnsnames`` infrastructure.
     256* The ``'NAME'`` variable value specifies always the same name of the DB we ask the Oracle engine for ('xe' in the case of XE). AFAIK This can be further controlled by using the ``tnsnames`` infrastructure.
    257257* Both a data tablespace and a temporary data tablespace are created.
    258 * The names of such tablespaces are derived from the value of the ``NAME`` var (the data tablespace gets a name prefixed by ``'test_'`` and the temporary tablespace one prefixed by ``'test_'`` and suffixed by ``'_tmp'``.
    259 * But their names can also be overridden by the ``'TEST_TBLSPACE'`` and ``'TEST_TBLSPACE_TMP'`` vars, respectively.
     258* The names of such tablespaces are derived from the value of the ``NAME`` var (the data tablespace gets a name prefixed by ``'test_'`` and the temporary tablespace one prefixed by ``'test_'`` and suffixed by ``'_tmp'`` (but their names can also be overridden by the ``'TEST_TBLSPACE'`` and ``'TEST_TBLSPACE_TMP'`` vars, respectively.)
    260259* For these tablespaces, a temporary user is created beforehand that has full ownership and control over them.
    261 * The username of such user isn't the same as the ``'USER'`` var, is derived from it by adding a ``'test_'`` prefix. It can be overridden with the value of the ``'TEST_USER'`` var.
     260* The username of such user isn't the same as the ``'USER'`` var, it is derived from it by adding a ``'test_'`` prefix. It can be overridden with the value of the ``'TEST_USER'`` var.
    262261* The password assigned to that user is hardcoded, but can be overridden by the value of the ``'TEST_PASSWD'`` var.
    263262* The tablespaces and the user are removed when test execution finishes.
     
    281280* 30 GiB hard disk.
    282281
    283 Platform is GNU/Debian Linux 5.0 aka *Lenny* (stable as of Nov 2010) because it still is in
     282Platform is GNU/Debian Linux 5.0 aka *Lenny* because it still is in
    284283its support period. As a bonus it includes Python 2.4 in pre-packaged form.
    285284
Back to Top