Changes between Version 20 and Version 21 of PS1_IPP_Czarlog_20190401

Timestamp:

Apr 4, 2019, 12:02:44 PM (7 years ago)

Author:

mhuber

Comment:

--

PS1_IPP_Czarlog_20190401

@@ -237 +237 @@
  Mark will re-queue the exposures that did not go through before, during the day.
 
+{{{
+mysql -hscidbm -uX -pX gpc1 -B -e ' select exp_name,date_format(dateobs,"%Y%m%d"),date_format(dateobs,"%m"),date_format(dateobs,"%d"),date_format(dateobs,"%Y"),exp_time,obs_mode,filter,comment from rawExp where comment like "%3PI%" and ( dateobs like "2019-%" or dateobs like "2018-12-%" ) and filter like "%" and obs_mode="BRIGHT"  and exp_id not in ( select exp_id from chipRun join rawExp using (exp_id) where filter like "%" and comment like "%3PI%" and ( dateobs like "2018-12-%" or dateobs like "2019-%" ) and obs_mode="BRIGHT" ) ; ' | grep -v exp_name | awk '{print "chiptool -definebyquery -set_label Bright3Pi.nightlyscience  -set_workdir neb://@HOST@.0/gpc1/Bright3Pi.nt/"$5"/"$3"/"$4" -set_data_group Bright3Pi."$2" -set_dist_group BRIGHT.WS -set_tess_id RINGS.V3 -set_end_stage warp -dbname gpc1 -exp_name "$1}'
+}}}
+
 
 === Friday : 2019.04.05 ===