Changeset 20310

Timestamp:

Oct 21, 2008, 4:39:15 PM (18 years ago)

Author:

bills

Message:

add hostname to pzDownloadImfile

Location:

trunk

Files:

• dbconfig/changes.txt (modified) (1 diff)
• dbconfig/tasks.md (modified) (2 diffs)
• ippScripts/scripts/summit_copy.pl (modified) (1 diff)
• ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)
• ippTools/src/pztool.c (modified) (2 diffs)
• ippTools/src/pztoolConfig.c (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -678 +678 @@
 
 * 1.1.46
+ALTER TABLE pzDownloadImfile ADD COLUMN hostname varchar(64) after epoch;

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.156 2008-10-13 21:57:05 eugene Exp $
+# $Id: tasks.md,v 1.157 2008-10-22 02:39:15 bills Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -77 +77 @@
     fault       S16         0       # Key NOT NULL
     epoch       UTC         0001-01-01T00:00:00Z
+    hostname    STR         64
 END
 

trunk/ippScripts/scripts/summit_copy.pl

@@ -108 +108 @@
 $command .= " -uri $filename";
 $command .= " -workdir $workdir";
+$command .= " -hostname $host";
 $command .= " -end_stage $end_stage" if defined $end_stage;
 $command .= " -dbname $dbname" if defined $dbname;

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -59 +59 @@
     fault SMALLINT NOT NULL,
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    hostname VARCHAR(64),
     PRIMARY KEY(exp_name, camera, telescope, class, class_id),
     KEY(fault),

trunk/ippTools/src/pztool.c

@@ -397 +397 @@
     PXOPT_LOOKUP_STR(class_id, config->args, "-class_id", true, false);
     PXOPT_LOOKUP_STR(uri, config->args, "-uri", true, false);
+    PXOPT_LOOKUP_STR(hostname, config->args, "-hostname", false, false);
     PXOPT_LOOKUP_BOOL(row_lock, config->args, "-row_lock", false);
 
@@ -455 +456 @@
             uri,
             code,
-            NULL    // epoch
+            NULL,    // epoch
+            hostname
     )) {
         psError(PS_ERR_UNKNOWN, false, "database error");

trunk/ippTools/src/pztoolConfig.c

@@ -94 +94 @@
     psMetadataAddStr(copydoneArgs, PS_LIST_TAIL, "-end_stage",  0,        "define the end goal processing step", NULL);
     psMetadataAddStr(copydoneArgs, PS_LIST_TAIL, "-label",  0,        "define the label for the chip stage", NULL);
+    psMetadataAddStr(copydoneArgs, PS_LIST_TAIL, "-hostname",  0,     "define the host that copied the image", NULL);
     psMetadataAddS16(copydoneArgs, PS_LIST_TAIL, "-code",  0,            "set fault code", 0);
     psMetadataAddBool(copydoneArgs, PS_LIST_TAIL, "-row_lock", 0,     "lock pzDownImfile rows while advancing an exposure", false);