Changeset 36386

Timestamp:

Dec 12, 2013, 10:10:20 AM (13 years ago)

Author:

bills

Message:

Add fftool (full force tool)

Location:

branches/bills_branches/bills_201312/ippTools

Files:

• share/Makefile.am (modified) (1 diff)
• share/fftool_definebyquery.sql (added)
• share/fftool_result.sql (added)
• share/fftool_revert.sql (added)
• share/fftool_todo.sql (added)
• share/pxadmin_create_tables.sql (modified) (1 diff)
• src/Makefile.am (modified) (3 diffs)
• src/fftool.c (added)
• src/fftool.h (added)
• src/fftoolConfig.c (added)

branches/bills_branches/bills_201312/ippTools/share/Makefile.am

@@ -488 +488 @@
         releasetool_definerelgroup_select_exp_lap.sql \
         releasetool_stacksummary.sql \
-        releasetool_pendingrelgroup.sql
+        releasetool_pendingrelgroup.sql \
+        fftool_definebyquery.sql \
+        fftool_result.sql \
+        fftool_revert.sql \
+        fftool_todo.sql
 

branches/bills_branches/bills_201312/ippTools/share/pxadmin_create_tables.sql

@@ -2307 +2307 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
+CREATE TABLE fullForceRun (
+    ff_id           BIGINT NOT NULL AUTO_INCREMENT,
+    warp_id         BIGINT,
+    skycal_id       BIGINT,
+    sources_path_base VARCHAR(255),
+    state           VARCHAR(64),
+    workdir         VARCHAR(255),
+    label           VARCHAR(64),
+    data_group      VARCHAR(64),
+    dist_group      VARCHAR(64),
+    note            VARCHAR(255),
+    reduction       VARCHAR(64),
+    registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
+    PRIMARY KEY(ff_id),
+    KEY(state),
+    KEY(label),
+    KEY(data_group),
+    KEY(warp_id),
+    KEY(skycal_id),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id),
+    FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fullForceResult (
+    ff_id           BIGINT,
+    path_base       VARCHAR(255) NOT NULL,
+    dtime_script    FLOAT,
+    quality         SMALLINT NOT NULL,
+    hostname        VARCHAR(64) NOT NULL,
+    software_ver    VARCHAR(16),
+    fault           SMALLINT NOT NULL,
+    PRIMARY KEY(ff_id),
+    KEY(fault),
+    KEY(quality),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 
 -- These comment lines are here to avoid an empty query error.

branches/bills_branches/bills_201312/ippTools/src/Makefile.am

@@ -33 +33 @@
         vptool \
         sctool \
-        releasetool
+        releasetool \
+        fftool
 
 pkginclude_HEADERS = \
@@ -87 +88 @@
         vptool.h \
         sctool.h \
-        releasetool.h
+        releasetool.h \
+        fftool.h
 
 lib_LTLIBRARIES = libpxtools.la
@@ -332 +334 @@
     releasetoolConfig.c
 
+fftool_CFLAGS = $(PSLIB_CFLAGS) $(PSMODULES_CFLAGS) $(IPPDB_CFLAGS)
+fftool_LDADD = $(PSLIB_LIBS) $(PSMODULES_LIBS) $(IPPDB_LIBS) libpxtools.la
+fftool_SOURCES = \
+    fftool.c \
+    fftoolConfig.c
+
 clean-local:
         -rm -f TAGS