Difference: DannowitzLog (31 vs. 32)

Revision 322012-10-19 - BryanDannowitz

Line: 1 to 1
 
META TOPICPARENT name="BryanDannowitz"

Dannowitz TWiki Logbook

Line: 840 to 840
  </>
<--/twistyPlugin-->
Added:
>
>

October 2012

<--/twistyPlugin twikiMakeVisibleInline-->

Run Summary

  • Started new schema called "summary" that could hold several compilations of information
  • Created a RunSummary table that is identical to the form of the Run tables
  • Wrote a small bash script that fills it with all the rows of the Run tables from all the other run_% schemas

#!/bin/bash
for i in {726..2173}
do
  mysql -h e906-gat2.fnal.gov -u root --password='[WITHHELD]' summary -e "INSERT INTO RunSummary SELECT * FROM run_00${i}_R001.Run"
done

Now, one can query to see which sets of runs use a certain type of target, or see which runs used a certain trigger, etc.

CODA Write-Up

Today I began writing up the general structure of these cryptic CODA files so that someone looking to understand it might have a starting resource, as none yet exists.

CODA Write-Up

<--/twistyPlugin-->
  -- BryanDannowitz - 2012-02-06
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback