Databases Reference
In-Depth Information
Directory
Description
src/sql/ utils
The scripts to extract the current sources of the database
objects are stored here. They can be downloaded from
http://www.opal-consulting.de/tools
.
src/sql/
<db schema 1>
All DDL scripts that we don't want to have automatically
generated or which cannot be automatically generated will be
placed here. All other statements will be automatically
extracted by the scripts (located in
src/sql/ utils
) and copied
to the directory
src/sql/
<db schema 1>
generated
.
src/sql/
<db schema 1>
generated
The scripts to automatically extract all sources from the
database (located in
src/sql/ utils
) will copy the generated
sources into this directory.
src/…
Any other source files in any technology, if required. This
approach is extensible.
test
We are not yet using automated unit and regression testing on
our applications, but typically we would place all relevant files
for the test in this directory and possible subdirectories.
patch
This is the top-level directory for all patches. A patch is typically
an incremental change to a specific version. The first patch
indicates the base release.
patch/
<version>
Patch for a specific version, e.g.
1.0.0.4
.
patch/
<version>
/apex
patch/
<version>
/apex/workspace image
patch/
<version>
/apex/app image
patch/
<version>
/apex/plugin
patch/
<version>
/apex custom
patch/
<version>
/sql
patch/
<version>
/sql/
<db schema 1>
patch/
<version>
/sql/
<db schema 2>
All subdirectories for the patch are structured in the same way
as the source tree.
After explaining the overall structure of the file system we will have a more detailed look at the sql
scripts in their respective directories.
In the directory
patch/
<version>
/sql
we will find a patch install script for every database schema we
install a patch in (e.g.,
patch
<db schema 1>
.sql
or in terms of our sample application
patch fm.sql
).
These scripts can be run in sqlplus. The sql files in the directory
patch/
<version>
/sql/
<db schema
1>
have to adhere to a naming scheme as well:
