Difference between revisions of "Keys in the ODB /Logger/SQL subtree"

From MidasWiki
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>
  
'''Type:''' BOOL
 
 
'''Default:'''  "n"
 
  
 
 
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/Username''</span> ==
+
== <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:'''   <experiment name>  
+
</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>
  
'''Type:''' STRING
 
 
'''Default:'''  Runlog 
 
  
 
 
 
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

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

is created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.