Changes between Version 27 and Version 28 of ippToPsps_Database

Timestamp:

Apr 10, 2012, 1:11:35 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -112 +112 @@
 === The {{{pending}}} table ===
 
+the {{{pending}}} table is first populated by {{{queue.py}}} then read by instances {{{loader.py}}}. It consists of unique stage_ids for each batch type that has been queues for each box on the sky, as shown here:
 
+{{{
++--------+------------+----------+
+| box_id | batch_type | stage_id |
++--------+------------+----------+
+|  44579 | OB         |    93141 | 
+|  44579 | OB         |    93142 | 
+|  44579 | OB         |    93143 | 
+|  44579 | OB         |    93144 | 
+|  44579 | OB         |    93145 | 
+|  44579 | OB         |    93146 | 
+|  44579 | OB         |    93147 | 
+|  44579 | OB         |    93148 | 
+|  44579 | OB         |    93149 | 
+|  44579 | OB         |    93150 | 
+|  44579 | OB         |    93151 | 
+|  44579 | OB         |    93152 | 
+|  44579 | OB         |    93153 |
+etc
+}}}
+ 
+A foreign key constraint on {{{box_id}}} with the {{{box}}} table means that entries will be deleted automatically if a box definition is removed from the {{{box}}} table.
 
+Also, {{{loader.py}}} instances will remove rows from this table as they begin to process them. If they fail to process the item in question for whatever reason, it will be re-queued the next time {{{queue.py}}} is run.
 == The batch tables ==
 === The {{{batch}}} table ===