Keys in the ODB /Logger/Runlog/SQL subtree: Difference between revisions
No edit summary |
|||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 11: | Line 11: | ||
The ODB <span style="color: purple;">''/Logger/SQL''</span> ODB subtree is a subdirectory of the [[/Logger ODB tree]]. | The ODB <span style="color: purple;">''/Logger/Runlog/SQL''</span> ODB subtree is a subdirectory of the [[/Logger ODB tree]]. The ODB <span style="color: purple;">''/Logger/Runlog/SQL''</span> subtree will be created by the MIDAS logger ([[mlogger]]) - see [[Logging to a mySQL database]]. | ||
== Keys in the <span style="color: purple;">''/Logger/SQL subtree</span> == | == Keys in the <span style="color: purple;">''/Logger/Runlog/SQL subtree</span> == | ||
The following sections explain the purpose of the keys in this subtree. | The following sections explain the purpose of the keys in this subtree. | ||
| Line 25: | Line 25: | ||
</div> | </div> | ||
If this key in the [[#top|/Logger/SQL subtree]] is set, the SQL database will be created. | If this key in the [[#top|/Logger/Runlog/SQL subtree]] is set, the SQL database will be created. | ||
<br> | <br> | ||
| Line 40: | Line 40: | ||
If this key in the [[#top|/Logger/SQL subtree]] is set , the data will be written to the SQL database, provided the MIDAS logger ([[mlogger]]) is also set to write the data - see | If this key in the [[#top|/Logger/Runlog/SQL subtree]] is set , the data will be written to the SQL database, provided the MIDAS logger ([[mlogger]]) is also set to write the data - see | ||
[[Keys in the ODB /Logger tree #/Logger/Write data |/Logger/Write data key]]. | [[Keys in the ODB /Logger tree #/Logger/Write data |/Logger/Write data key]]. | ||
| Line 120: | Line 120: | ||
* '''Type:''' DIR | * '''Type:''' DIR | ||
This directory in the [[#top|/Logger/Runlog/SQL subtree]] contains links to parameters in the ODB that are to be saved in the SQL Database at Begin-of-run. The links | |||
* Start time ( linked to [[/Runinfo ODB tree#Start time|/Runinfo/Start time]]) | * Start time ( linked to [[/Runinfo ODB tree#Start time|/Runinfo/Start time]]) | ||
* Run number ( linked to [[/Runinfo ODB tree#Run number|/Runinfo/Run number]]) | |||
are created automatically by the MIDAS logger ([[mlogger]]) the first time it runs. The user may add other links as desired. | are created automatically by the MIDAS logger ([[mlogger]]) the first time it runs. The user may add other links as desired. | ||
| Line 132: | Line 130: | ||
----- | ----- | ||
<br> | <br> | ||
=== <span style="color: purple;">''Links EOR''</span> === | === <span style="color: purple;">''Links EOR''</span> === | ||
| Line 140: | Line 137: | ||
This directory in the [[#top|/Logger/SQL subtree]] contains links to parameters in the ODB that are to be saved in the SQL Database at End-of-run. The link | This directory in the [[#top|/Logger/Runlog/SQL subtree]] contains links to parameters in the ODB that are to be saved in the SQL Database at End-of-run. The link | ||
* Stop time ( linked to [[/Runinfo ODB tree#Stop time|/Runinfo/Stop time]] ) | * Stop time ( linked to [[/Runinfo ODB tree#Stop time|/Runinfo/Stop time]] ) | ||
| Line 147: | Line 144: | ||
[[Category: | [[Category:Logger Tree]] | ||
Latest revision as of 04:54, 11 November 2022
Links
The ODB /Logger/Runlog/SQL ODB subtree is a subdirectory of the /Logger ODB tree. The ODB /Logger/Runlog/SQL subtree will be created by the MIDAS logger (mlogger) - see Logging to a mySQL database.
Keys in the /Logger/Runlog/SQL subtree
The following sections explain the purpose of the keys in this subtree.
Create Database
- Type: BOOL
- Default: "n"
If this key in the /Logger/Runlog/SQL subtree is set, the SQL database will be created.
Write Data
- Type: BOOL
- Default: "n"
If this key in the /Logger/Runlog/SQL subtree is set , the data will be written to the SQL database, provided the MIDAS logger (mlogger) is also set to write the data - see /Logger/Write data key.
Hostname
- Type: STRING
- Default: "localhost"
This key in the /Logger/SQL subtree contains the name of the host where the SQL database is located.
Username
- Type: STRING
- Default: "root"
This key in the /Logger/SQL subtree contains the username for access to the SQL Database.
Password
- Type: STRING
- Default:
This key in the /Logger/SQL subtree contains the (encoded) password for access to the SQL Database.
Database
- Type: STRING
- Default: <experiment name>
This key in the /Logger/SQL subtree contains the name of the SQL Database (predefined as the name of the experiment in ODB Key /Experiment/Name).
Table
- Type: STRING
- Default: "Runlog"
This key in the /Logger/SQL subtree contains the name of the table in the SQL Database.
Links BOR
- Type: DIR
This directory in the /Logger/Runlog/SQL subtree contains links to parameters in the ODB that are to be saved in the SQL Database at Begin-of-run. The links
- Start time ( linked to /Runinfo/Start time)
- Run number ( linked to /Runinfo/Run number)
are created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.
Links EOR
- Type: DIR
This directory in the /Logger/Runlog/SQL subtree contains links to parameters in the ODB that are to be saved in the SQL Database at End-of-run. The link
- Stop time ( linked to /Runinfo/Stop time )
is created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.