Nevermind, I figured it out:
the -r option has to go before the "print" command (but after the "add" command)!
-Nathan
On Apr 23, 2015, at 7:32 AM, Nathan Baltzell <[log in to unmask]> wrote:
> Jeremy, can you take a look at this:
>
> I want to print the conditions using the command line tool. First, I still have to specify a detector
> else it fails with "not initialized" errors. More importantly, it appears to be picking up the wrong
> collection_id. I tried this also on some older runs where I know it used to work. Did I make a
> mistake somewhere? Isn't the command line tool still supposed to give me the same result via its
> print command as when we run reconstruction?
>
>
> llama> java hps.jar -cp hps.org.hps.conditions.cli.CommandLineTool -p ~/jlab_readonly.prop -d HPS-EngRun2015-Nominal-v0 print -r 4900 -t ecal_calibrations
>
> ….
> --------------------------------------
> id: 4
> name: ecal_calibrations
> runStart: 0
> runEnd: 0
> tableName: ecal_calibrations
> collectionId: 1
> updated: 2014-10-29 00:46:35.0
> created: 2013-09-30 17:25:21.0
> tag: dev
> createdBy: jeremym
> notes: null
> --------------------------------------
>
> ecal_channel_id pedestal noise
> 221 120.0 10.0
> 258 120.0 10.0
> 184 120.0 10.0
> 304 120.0 10.0
> …..
>
>
> Looking in the mysql db, it should be getting 26:
>
> mysql> select collection_id,run_start,run_end,table_name,notes,tag,updated from conditions;
> ***
> | 0 | 9999 | 1002 | svt_shape_fit_parameters | Shape fit calibration from run hpssvt_000738 | eng_run | 2015-04-22 21:49:18 |
> | 0 | 9999 | 1003 | svt_shape_fit_parameters | Shape fit calibration from run hpssvt_000738 | eng_run | 2015-04-22 22:12:17 |
> | 4832 | 9999 | 26 | ecal_calibrations | no-beam pedestals after all hardware changes | pass0 | 2015-04-23 07:06:42 |
> +-----------+---------+---------------+-----------------------------------+-----------------------------------------------------------------------------------+----------+---------------------+
> 294 rows in set (0.00 sec)
>
>
> mysql> select * from ecal_calibrations where collection_id=26;
> +-------+-----------------+---------------+----------+-------+
> | id | ecal_channel_id | collection_id | pedestal | noise |
> +-------+-----------------+---------------+----------+-------+
> | 11051 | 1 | 26 | 109.772 | 2.531 |
> | 11052 | 2 | 26 | 87.091 | 2.556 |
> | 11053 | 3 | 26 | 107.977 | 2.462 |
> | 11054 | 4 | 26 | 106.453 | 2.377 |
> ….
>
>
> Any Ideas?
> -Nathan
>
> ########################################################################
> Use REPLY-ALL to reply to list
>
> To unsubscribe from the HPS-SOFTWARE list, click the following link:
> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1
########################################################################
Use REPLY-ALL to reply to list
To unsubscribe from the HPS-SOFTWARE list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1
|