IZ124: Adding the global configuration of databases used by ARCo module

[aja]

[Imported from gridengine issuezilla ​http://gridengine.sunsource.net/issues/show_bug.cgi?id=124]

        Issue #:      124             Platform:     Sun           Reporter: aja (aja)
       Component:     testsuite          OS:        All
     Subcomponent:    framework       Version:      current          CC:    None defined
        Status:       RESOLVED        Priority:     P3
      Resolution:     FIXED          Issue type:    ENHANCEMENT
                                  Target milestone: milestone 1
      Assigned to:    issues@testsuite
      QA Contact:     joga
          URL:
       * Summary:     Adding the global configuration of databases used by ARCo module
   Status whiteboard:
      Attachments:

     Issue 124 blocks:
   Votes for issue 124:     Vote for this issue


   Opened: Mon Mar 26 06:43:00 -0700 2007 
------------------------


It would be good to store the information about the installed databases in the
global testsuite configuration setup.
We can provide the shared information like arco_write user & password, port
number, jdbc driver location.

We could either add this info into the host configuration, or create a new
infrastructure configuration for the databases.

   ------- Additional comments from aja Wed Jan 30 09:31:28 -0700 2008 -------
This feature is useful for testing ARCo module, and the new parameter -
the path to the file with the database configuration - is required. If
you don't specify checktree_arco as an additional checktree (testsuite
menu - item 4) Additional Testsuite's checktree directories), simply use
the default value "none".

DB config initialization:
=================
I added a new item  (13) Testsuite's global database configuration file
to the main testsuite menu.
The initial file for database configuration will be created by
specifying  the filename. All the testsuite users should use this file
then.

Adding database configuration:
=======================
From the main testsuite menu choose (26) enter testsuite setup, then
(4) Database file configuration

First of all you have to specify the database types:
1) Supported database types
---------------------------------
the following database types are supported for ARCo: specify the
required values (see table)

o oracle
    default port number: 1521
    driver: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@$db_host:$port:$db_name

o postgres
    default port number: 5432
    driver: org.postgresql.Driver
    url: jdbc:postgresql://$db_host:$port/$db_name

o mysql
    default port number: 3306
    driver: com.mysql.jdbc.Driver
    url: jdbc:mysql://$db_host:$port/$db_name

Then you can specify the databases in your cluster:
2) Testsuite cluster database list
-------------------------------------
choose the unique name for the database (in checktree_arco you will
choose the database from the list of configured databases)
then specify required parameters:
dbtype - choose from the list of supported db types
dbhost - host where the database is installed
dbport - port used for the connections to the database
dbname - database name
username - name of the write user
password - password of this user
driverpath - path to the jdbc driver