All HallC run condition databases are updated with schema v2 and can now use the rcdb python library (https://pypi.org/project/rcdb/)
- Install rcdb if not done already
pip install rcdb
- Set environment variable for connection strings
setenv RCDB_CONNECTION mysql://rcdb@hallcdb.jlab.org/<database name> (csh, tcsh)
export RCDB_CONNECTION=mysql://rcdb@hallcdb.jlab.org/<database name> (bash, zsh)
If using SQLite databases, valid SQLite URL forms are:
sqlite:///:memory: (or, sqlite://)
sqlite:///relative/path/to/file.db
sqlite:////absolute/path/to/file.db
- Check if things are set properly using the command line tools. For example,
rcdb
This will print out a summary about the database contents. For more information on the CLI, see https://jeffersonlab.github.io/rcdb/#/rcdb-cli
| DB name | Experiments |
|---|---|
| prex2 | PREX2 and CREX |
| nps | NPS |
| lad | LAD |
| rsidis | R-SIDIS |
| pionct | PionCT |
| xem2 | XEM2 |
| at | nucAT |
The SQL dump files as well as SQLite databases for the past experiments can be found from databases folder.
- rcdb package (https://github.com/JeffersonLab/rcdb) is added as submodule with a specific tag. This release version is a rather old one. This was used with old schema v1.
- For updating DB entries: Master DB should be only used when making DB entries by start/end run scripts from cdaq machines. On cdaq computers, RCDB environment is set when login, and the connection string is set to the master database.
- Please use the read-only copy otherwise:
setenv RCDB_CONNECTION mysql://rcdb@hallcdb.jlab.org/c-rcdb
rcdb_edit.py: this gui allows one to update run type, comment and flag the run.