Changeset 27175 for trunk/ippTools/share/pstamptool_datastore.sql

Timestamp:

Mar 3, 2010, 4:38:26 PM (16 years ago)

Author:

bills

Message:

Add timestamp and poll interval to pstampDataStore. Don't poll for new
requests at each data store unless the time since the last poll is greater
than the requested interval
Add label to pstampDataStore. Use it to set label for requests.
Support -label in the query modes of pstamptool.

File:

• trunk/ippTools/share/pstamptool_datastore.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_datastore.sql

@@ -1 @@
-SELECT * FROM pstampDataStore
+SELECT pstampDataStore.*
+FROM pstampDataStore
+WHERE 
+    state = 'enabled' 
+    AND TIMESTAMPDIFF(SECOND, timestamp, now()) > pollInterval