New bookkeeping first prototype

User Code
=========

To try first functionalities

   newrel -t 12.3.4 12.3.4-test
   cd 12.3.4-test/
   addpkg BbkTools V00-00-01
   gmake BbkTools.bin

The useful command line tools for dataset informations:

    BbkDatasetTcl
    BbkDatasetHistory 

They can connect to the public databases at slac ral and manchester 
(see below for a description of the databases content) the underlying
connection module will deal with the configuration for the connection
and the user access rights to the databases.

Datasets for the moment have been inserted only at ral and manchester 
because they contain half of the objectivity collections series 12. The main 
functionalities of the GoodRun cvs package have been replicated as 
the possibility of creating a tcl in the way skimData does.

* BbkDatasetTcl

The command BbkDatasetTcl produces a TCL file for one or more datasets,
rather like skimData -t. A full list of datasets will be printed if
BbkDatasetTcl is run without arguments:-

  noric03> BbkDatasetTcl
  BbkDatasetTcl: 9456 datasets found:-
  repr_1999-b1-s0-r12C-on_36_AlignCal
  repr_1999-b1-s0-r12C-on_36_AllEvents10
  ...

To generate a TCL file, specify one or more of these dataset names on the
command line, eg.

  BbkDatasetTcl repr_2001-b1-s5-r12C-on_77_Jpsitoll

this is equivalent to the skimData command

  skimData -t -G repr_2001-b1-s5-r12C-on_77.txt -s Jpsitoll --tableprefix=objy

BbkDatasetTcl creates a TCL file named after the first-specified dataset
(eg. repr_2001-b1-s5-r12C-on_77_Jpsitoll.tcl). A different output file name
may be specified with the -t option (-t- prints the output on standard
output).

* BbkDatasetHistory
                        
Datasets can evolve over time, as new collections are processed; or
occasionally as old ones are determined to be bad. This evolution can be
listed with the BbkDatasetHistory command.

  noric03> BbkDatasetHistory repr_2000-b1-s0-r12C-on_36_AllEvents10
  Dataset repr_2000-b1-s0-r12C-on_36_AllEvents10
    CREATED             ADDED REMOVED  TOT_NEV TOT_LUMI INPUT_DS MAINTAINER DESCRIPTION
    =================== ===== ======= ======== ======== ======== ========== ===========
    2003/08/27 09:01:34   334       0 16810513    999.0 none     aforti     NONE
    2003/08/27 13:54:21     3       1   279570     14.3 none     aforti     NONE
    2003/08/27 14:03:20     1       1    37957     10.4 none     aforti     NONE

This dataset was created at 09:01 with 334 collections. 3 were added and 1
removed at 13:54; and 1 added and 1 removed at 14:03 - leaving 336
collections. By default, BbkDatasetTcl will return the final set of
collections (all 336 of them, in this example).

The BbkDatasetTcl -e option allows one to obtain the state of the dataset as
it was at any time in the past. Eg.

  BbkDatasetTcl -e 2003/08/27-12:00 repr_2000-b1-s0-r12C-on_36_AllEvents10

returns 334 collections. The -s option will only include collections added
since that date (cannot account for removed collections).

See the help display from BbkDatasetTcl -h and BbkDatasetHistory -h for
details of the command options.

Public Databases
================

1) slac oracle (8.1.6.0.0): 358212 SP5 data collections
Up to now it has been used to understand loading problems in oracle

2) ral mysql (3.23.54): 822045 PR data collections series 12
Public database accessible with flag --site ral

3) manchester mysql (3.23.45): 822045 PR data collections series 12
Public database accessible with flag --site man


Private Databases
=================
I mention these because this will be the equivalent of user databases

4) slac mysql (3.22.32): 822045 PR data collections series 12
Private database works from ~aforti/12.3.4-dev/.bbk configuration
with --site tersk05
Has been used as master copy for all the other mysql databases that 
have been loaded using mysql bulk loading utility.

5) manchester mysql on laptop (4.0.4-beta): 822045 PR data collections 
   series 12
Private database works with ~aforti/12.3.4-dev/.bbk configuration 
with --site proteus