Changeset 42572

Timestamp:

Dec 28, 2023, 8:47:15 AM (3 years ago)

Author:

eugene

Message:

adding xcskytool C and sql code

Location:

branches/eam_branches/ipp-20230313/ippTools

Files:

• share/Makefile.am (modified) (1 diff)
• share/pxadmin_create_tables.sql (modified) (1 diff)
• share/xcskytool_definebyquery.sql (added)
• share/xcskytool_definebyquery_inputs.sql (added)
• share/xcskytool_definebyquery_select.sql (added)
• share/xcskytool_definebyquery_select_by_dg.sql (added)
• share/xcskytool_definexccalrun.sql (added)
• share/xcskytool_export_input.sql (added)
• share/xcskytool_export_result.sql (added)
• share/xcskytool_export_run.sql (added)
• share/xcskytool_export_xccalresult.sql (added)
• share/xcskytool_export_xccalrun.sql (added)
• share/xcskytool_inputs.sql (added)
• share/xcskytool_pendingxccalrun.sql (added)
• share/xcskytool_result.sql (added)
• share/xcskytool_revert.sql (added)
• share/xcskytool_revert_update.sql (added)
• share/xcskytool_revertxccal.sql (added)
• share/xcskytool_todo.sql (added)
• share/xcskytool_xccalresult.sql (added)
• src/Makefile.am (modified) (3 diffs)
• src/xcskytool.c (added)
• src/xcskytool.h (added)
• src/xcskytoolConfig.c (added)

branches/eam_branches/ipp-20230313/ippTools/share/Makefile.am

@@ -564 +564 @@
         xcstacktool_pendingcleanuprun.sql \
         xcstacktool_pendingcleanupskyfile.sql \
-        xcstacktool_donecleanup.sql
-
-
+        xcstacktool_donecleanup.sql \
+        xcskytool_definebyquery_select.sql \
+        xcskytool_definebyquery_select_by_dg.sql \
+        xcskytool_definebyquery_inputs.sql \
+        xcskytool_definexccalrun.sql \
+        xcskytool_pendingxccalrun.sql \
+        xcskytool_revertxccal.sql \
+        xcskytool_xccalresult.sql \
+        xcskytool_export_run.sql \
+        xcskytool_export_input.sql \
+        xcskytool_export_result.sql \
+        xcskytool_export_xccalrun.sql \
+        xcskytool_export_xccalresult.sql \
+        xcskytool_inputs.sql \
+        xcskytool_todo.sql \
+        xcskytool_result.sql \
+        xcskytool_revert.sql \
+        xcskytool_revert_update.sql

branches/eam_branches/ipp-20230313/ippTools/share/pxadmin_create_tables.sql

@@ -2176 +2176 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- xcsky and xccal tables
+CREATE TABLE xcskyRun (
+      xcsky_id BIGINT AUTO_INCREMENT, -- unique identifier
+      state VARCHAR(64) NOT NULL,  -- state of run (new, full, etc.)
+      workdir VARCHAR(255) NOT NULL, -- working directory
+      label VARCHAR(64),             -- processing label
+      data_group VARCHAR(64),        -- group for data
+      dist_group VARCHAR(64),        -- group for distribution
+      reduction VARCHAR(64),         -- reduction class (for altering recipe)
+      note VARCHAR(255),             -- note
+      registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
+      PRIMARY KEY(xcsky_id),
+      KEY(state),
+      KEY(label),
+      KEY(data_group),
+      KEY(dist_group)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Inputs for xcsky analysis
+CREATE TABLE xcskyInput (
+      xcsky_id BIGINT,             -- static sky identifier
+      xcstack_id BIGINT,          -- stack identifier
+      PRIMARY KEY(xcsky_id,xcstack_id),
+      KEY(xcstack_id),
+      FOREIGN KEY(xcsky_id) REFERENCES xcskyRun(xcsky_id),
+      FOREIGN KEY(xcstack_id) REFERENCES xcstackSumSkyfile(xcstack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Result of static sky analysis
+CREATE TABLE xcskyResult (
+      xcsky_id BIGINT,             -- static sky identifier
+      path_base VARCHAR(255) NOT NULL, -- root name for outputs
+      dtime_phot FLOAT,                -- elapsed time for photometry
+      dtime_script FLOAT,              -- elapsed time for script
+      sources INT,                     -- number of sources
+      num_inputs INT,                  -- number of input images
+      hostname VARCHAR(64) NOT NULL,   -- host that executed script
+      good_frac FLOAT,                 -- good fraction of skycell
+      quality SMALLINT NOT NULL,       -- bad quality flag
+      fault SMALLINT NOT NULL,         -- fault code
+      PRIMARY KEY(xcsky_id),
+      KEY(good_frac),
+      KEY(fault),
+      KEY(quality),
+      FOREIGN KEY(xcsky_id) REFERENCES xcskyRun(xcsky_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE xccalRun (
+      xccal_id BIGINT AUTO_INCREMENT, -- unique identifier
+      xcsky_id BIGINT,
+      xcstack_id BIGINT,
+      state VARCHAR(64) NOT NULL,  -- state of run (new, full, etc.)
+      workdir VARCHAR(255) NOT NULL, -- working directory
+      label VARCHAR(64),             -- processing label
+      data_group VARCHAR(64),        -- group for data
+      dist_group VARCHAR(64),        -- group for distribution
+      reduction VARCHAR(64),         -- reduction class (for altering recipe)
+      registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
+      note VARCHAR(255),             -- note
+      PRIMARY KEY(xccal_id),
+      KEY(state),
+      KEY(label),
+      KEY(data_group),
+      KEY(dist_group),
+      KEY(xcsky_id),
+      KEY(xcstack_id),
+      FOREIGN KEY(xcsky_id) REFERENCES xcskyRun(xcsky_id),
+      FOREIGN KEY(xcstack_id) REFERENCES xcstackRun(xcstack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Result of sky calibration analysis
+CREATE TABLE xccalResult (
+      xccal_id BIGINT,
+      path_base VARCHAR(255) NOT NULL,
+      dtime_script FLOAT,
+      dtime_astrom FLOAT,
+      sigma_ra FLOAT,
+      sigma_dec FLOAT,
+      n_astrom INT,
+      n_detections INT,
+      n_extended INT,
+      n_forced INT,
+      zpt_obs FLOAT,
+      zpt_stdev FLOAT,
+      fwhm_major  FLOAT,
+      fwhm_minor  FLOAT,
+      quality SMALLINT NOT NULL,
+      hostname VARCHAR(64) NOT NULL,
+      software_ver VARCHAR(64),
+      fault SMALLINT NOT NULL,
+      PRIMARY KEY(xccal_id),
+      KEY(fault),
+      KEY(quality),
+      FOREIGN KEY(xccal_id) REFERENCES xccalRun(xccal_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE skycell (
     tess_id     VARCHAR(64),

branches/eam_branches/ipp-20230313/ippTools/src/Makefile.am

@@ -25 +25 @@
         staticskytool \
         xcstacktool \
+        xcskytool \
         warptool \
         receivetool \
@@ -84 +85 @@
         stacktool.h \
         xcstacktool.h \
+        xcskytool.h \
         staticskytool.h \
         warptool.h \
@@ -253 +255 @@
     xcstacktoolConfig.c
 
+xcskytool_CFLAGS = $(PSLIB_CFLAGS) $(PSMODULES_CFLAGS) $(IPPDB_CFLAGS)
+xcskytool_LDADD = $(PSLIB_LIBS) $(PSMODULES_LIBS) $(IPPDB_LIBS) libpxtools.la
+xcskytool_SOURCES = \
+    xcskytool.c \
+    xcskytoolConfig.c
+
 pxadmin_CFLAGS = $(PSLIB_CFLAGS) $(PSMODULES_CFLAGS) $(IPPDB_CFLAGS)
 pxadmin_LDADD = $(PSLIB_LIBS) $(PSMODULES_LIBS) $(IPPDB_LIBS) libpxtools.la