Changes between Version 14 and Version 15 of OracleTestSetup
- Timestamp:
- Apr 22, 2011, 12:13:21 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OracleTestSetup
v14 v15 248 248 ===================================== 249 249 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`_.250 An 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`_. 251 251 252 252 *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: … … 254 254 For every DB alias defined in ``DATABASES``: 255 255 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. 257 257 * 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.) 260 259 * 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, i s 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. 262 261 * The password assigned to that user is hardcoded, but can be overridden by the value of the ``'TEST_PASSWD'`` var. 263 262 * The tablespaces and the user are removed when test execution finishes. … … 281 280 * 30 GiB hard disk. 282 281 283 Platform is GNU/Debian Linux 5.0 aka *Lenny* (stable as of Nov 2010)because it still is in282 Platform is GNU/Debian Linux 5.0 aka *Lenny* because it still is in 284 283 its support period. As a bonus it includes Python 2.4 in pre-packaged form. 285 284