Hi,
as it came up in the daily meeting: though the website button
"Search Runlist" does not work properly, the more interesting way to talk
to the database is interactively or from the shell:
E.g. in order to get a runlist for unpolarized hydrogen runs, one could
type at the shell prompt:
mysql -D BLAST_physics -e "SELECT RunNumber, GasType FROM RUN WHERE
RunNumber >= 1031 AND GasType = 'H2' AND Target = 'UNPOL' ;"
The mysql command in quotes is self-explanatory. You can also log on to
mysql by typing "mysql" and then
> use BLAST_physics;
>SELECT RunNumber, GasType FROM RUN WHERE RunNumber >= 1031 AND GasType =
'H2' AND Target = 'UNPOL' ;"
You can add any other keywords to constrain your search as you find them
in the "Configuration file" for each run in the elog webpage.
All you need is to trust the truth of the database contents, which very
much relies on how careful the shifts persons were at data taking time.
Regards,
Michael
--
+-------------------------------------+--------------------------+
| Office: | Home: |
|-------------------------------------|--------------------------|
| Dr. Michael Kohl | Michael Kohl |
| Laboratory for Nuclear Science | 5 Ibbetson Street |
| MIT-Bates Linear Accelerator Center | Somerville, MA 02143 |
| Middleton, MA 01949 | U.S.A. |
| U.S.A. | |
| - - - - - - - - - - - - | - - - - - - - - -|
| Email: kohlm@mit.edu | K.Michael.Kohl@gmx.de |
| Work: +1-617-253-9207 | Home: +1-617-629-3147 |
| Fax: +1-617-253-9599 | Mobile: +1-978-580-4190 |
| http://blast.lns.mit.edu | |
+-------------------------------------+--------------------------+
This archive was generated by hypermail 2.1.2 : Mon Feb 24 2014 - 14:07:32 EST