Changeset 24107 for trunk/ippTools/share/receivetool_pendingfile.sql

Timestamp:

May 7, 2009, 11:24:30 AM (17 years ago)

Author:

bills

Message:

add bytes, md5sum, etc to -pendingfile output

File:

• trunk/ippTools/share/receivetool_pendingfile.sql (modified) (2 diffs)

trunk/ippTools/share/receivetool_pendingfile.sql

@@ -6 +6 @@
     fileset,
     fileset_id,
-    file
+    file,
+    bytes,
+    md5sum,
+    file_type,
+    component
 FROM receiveFile
 JOIN receiveFileset USING(fileset_id)
@@ -12 +16 @@
 LEFT JOIN receiveResult
     ON receiveResult.file_id = receiveFile.file_id
-WHERE receiveResult.file_id IS NULL
+WHERE
+    receiveFileset.state = 'new'
+    AND receiveResult.file_id IS NULL