Difference between revisions of "Keys in the ODB /Logger/Runlog/SQL subtree"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | ==== Links ==== | ||
| + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | ||
| + | * [[Keys in the ODB /Logger tree| /Logger tree]] | ||
| + | * [[Logging to a mySQL database]] | ||
| + | * [[/Logger ODB tree #Example | example tree]] | ||
| + | * [[mlogger]] | ||
| + | </div> | ||
| + | |||
| + | ---------------- | ||
| + | <br> | ||
The ODB <span style="color: purple;">''/Logger/SQL''</span> ODB subtree is a subdirectory of the [[/Logger ODB tree]]. The The ODB <span style="color: purple;">''/Logger/SQL''</span> subtree will be created by the MIDAS logger ([[mlogger]]) - see [[Logging to a mySQL database]]. | The ODB <span style="color: purple;">''/Logger/SQL''</span> ODB subtree is a subdirectory of the [[/Logger ODB tree]]. The The ODB <span style="color: purple;">''/Logger/SQL''</span> subtree will be created by the MIDAS logger ([[mlogger]]) - see [[Logging to a mySQL database]]. | ||
| − | + | <br> | |
----- | ----- | ||
| − | + | <br> | |
== <span style="color: purple;">''/Logger/SQL/Create Database''</span> == | == <span style="color: purple;">''/Logger/SQL/Create Database''</span> == | ||
| − | + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | |
| − | '''Type:''' BOOL | + | * '''Type:''' BOOL |
| − | + | * '''Default:''' "n" | |
| − | '''Default:''' "n" | + | </div> |
| − | + | ||
| − | |||
If this flag is set, the SQL database will be created. | If this flag is set, the SQL database will be created. | ||
| − | + | <br> | |
| − | |||
| − | |||
| − | |||
----- | ----- | ||
| + | <br> | ||
== <span style="color: purple;">''/Logger/SQL/Write Data''</span> == | == <span style="color: purple;">''/Logger/SQL/Write Data''</span> == | ||
| + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | ||
| + | * '''Type:''' BOOL | ||
| + | * '''Default:''' "n" | ||
| + | </div> | ||
| − | |||
| − | |||
| − | |||
| Line 31: | Line 39: | ||
[[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]]. | ||
| − | + | <br> | |
| − | |||
| − | |||
| − | |||
----- | ----- | ||
| + | <br> | ||
== <span style="color: purple;">''/Logger/SQL/Hostname''</span> == | == <span style="color: purple;">''/Logger/SQL/Hostname''</span> == | ||
| − | + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | |
| − | '''Type:''' STRING | + | * '''Type:''' STRING |
| − | + | * '''Default:''' "localhost" | |
| − | '''Default:''' localhost | + | </div> |
The name of the host where the SQL database is located. | The name of the host where the SQL database is located. | ||
| − | + | <br> | |
| − | |||
| − | |||
----- | ----- | ||
| + | <br> | ||
== <span style="color: purple;">''/Logger/SQL/Username''</span> == | == <span style="color: purple;">''/Logger/SQL/Username''</span> == | ||
| − | + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | |
| − | '''Type:''' STRING | + | * '''Type:''' STRING |
| − | + | * '''Default:''' "root" | |
| − | '''Default:''' root | + | </div> |
| − | |||
Username for access to the SQL Database. | Username for access to the SQL Database. | ||
| − | + | <br> | |
| − | |||
| − | |||
| − | |||
----- | ----- | ||
| + | <br> | ||
| − | == <span style="color: purple;">''/Logger/SQL/ | + | == <span style="color: purple;">''/Logger/SQL/Password''</span> == |
| − | + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | |
| − | '''Type:''' STRING | + | * '''Type:''' STRING |
| − | + | * '''Default:''' | |
| − | '''Default:''' | + | </div> |
| − | + | ||
(Encoded) Password for access to the SQL Database. | (Encoded) Password for access to the SQL Database. | ||
| − | + | <br> | |
| − | |||
| − | |||
| − | |||
| − | |||
----- | ----- | ||
| − | + | <br> | |
== <span style="color: purple;">''/Logger/SQL/Database''</span> == | == <span style="color: purple;">''/Logger/SQL/Database''</span> == | ||
| − | + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | |
| − | '''Type:''' STRING | + | * '''Type:''' STRING |
| − | + | * '''Default:''' <experiment name> | |
| − | '''Default:''' | + | </div> |
Name of the SQL Database (predefined as the name of the experiment in ODB Key [[/Experiment/Name]]). | Name of the SQL Database (predefined as the name of the experiment in ODB Key [[/Experiment/Name]]). | ||
| − | + | <br> | |
----- | ----- | ||
| − | + | <br> | |
== <span style="color: purple;">''/Logger/SQL/Table''</span> == | == <span style="color: purple;">''/Logger/SQL/Table''</span> == | ||
| + | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | ||
| + | * '''Type:''' STRING | ||
| + | * '''Default:''' "Runlog" | ||
| + | </div> | ||
| − | |||
| − | |||
| − | |||
Name of the Table in the SQL Database. | Name of the Table in the SQL Database. | ||
| − | + | <br> | |
| − | |||
----- | ----- | ||
| − | + | <br> | |
== <span style="color: purple;">''/Logger/SQL/Links BOR''</span> == | == <span style="color: purple;">''/Logger/SQL/Links BOR''</span> == | ||
| − | '''Type:''' DIR | + | * '''Type:''' DIR |
| Line 127: | Line 125: | ||
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. | ||
| − | + | <br> | |
----- | ----- | ||
| − | + | <br> | |
== <span style="color: purple;">''/Logger/SQL/Links EOR''</span> == | == <span style="color: purple;">''/Logger/SQL/Links EOR''</span> == | ||
| − | '''Type:''' DIR | + | * '''Type:''' DIR |
Revision as of 14:29, 14 August 2013
Links
The ODB /Logger/SQL ODB subtree is a subdirectory of the /Logger ODB tree. The The ODB /Logger/SQL subtree will be created by the MIDAS logger (mlogger) - see Logging to a mySQL database.
/Logger/SQL/Create Database
- Type: BOOL
- Default: "n"
If this flag is set, the SQL database will be created.
/Logger/SQL/Write Data
- Type: BOOL
- Default: "n"
If this flag 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.
/Logger/SQL/Hostname
- Type: STRING
- Default: "localhost"
The name of the host where the SQL database is located.
/Logger/SQL/Username
- Type: STRING
- Default: "root"
Username for access to the SQL Database.
/Logger/SQL/Password
- Type: STRING
- Default:
(Encoded) Password for access to the SQL Database.
/Logger/SQL/Database
- Type: STRING
- Default: <experiment name>
Name of the SQL Database (predefined as the name of the experiment in ODB Key /Experiment/Name).
/Logger/SQL/Table
- Type: STRING
- Default: "Runlog"
Name of the Table in the SQL Database.
/Logger/SQL/Links BOR
- Type: DIR
This directory contains links to parameters in the ODB that are to be saved in the SQL Database at Begin-of-run. The links
- Run number ( linked to /Runinfo/Run number )
- Start time ( linked to /Runinfo/Start time)
are created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.
/Logger/SQL/Links EOR
- Type: DIR
This directory 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.