Changeset 23885 for trunk/ippTools/share/receivetool_pendingfileset.sql

Timestamp:

Apr 16, 2009, 12:39:27 PM (17 years ago)

Author:

Paul Price

Message:

Modifying distribution client workflow (currently composed of receivetool and associated tables) since Bill points out that a fileset is composed of files, and we don't want to download them all serially.

File:

• trunk/ippTools/share/receivetool_pendingfileset.sql (moved) (moved from trunk/ippTools/share/receivetool_pendingrun.sql ) (1 diff)

trunk/ippTools/share/receivetool_pendingfileset.sql

@@ -1 +1 @@
 SELECT *
-FROM receiveRun
+FROM receiveFileset
 JOIN receiveSource USING(source_id)
-LEFT JOIN receiveResult USING(receive_id)
-WHERE receiveResult.receive_id IS NULL
+LEFT JOIN receiveFile USING(fileset_id)
+WHERE receiveFile.fileset_id IS NULL