Changes between Version 1 and Version 2 of ippToPsps_Database

Timestamp:

Mar 7, 2012, 12:06:30 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -22 +22 @@
 
 == The {{{config}}} table ==
-== The {{{box}}} table ==
+
 == The {{{clients}}} table ==
-== The {{{config}}} table ==
-== The {{{detection}}} table ==
-== The {{{stack}}} table ==
-== The {{{stripe}}} table ==
+
+Whenever an {{{ippToPsps}}} program is started, it registers with this table in the database. It does this by storing its hostname, PID and program name as shown here:
+
+{{{
++---------------------+------------+-------+--------+--------+--------+--------+---------------------+-----+
+| started             | type       | pid   | host   | config | paused | killed | timestamp           | id  |
++---------------------+------------+-------+--------+--------+--------+--------+---------------------+-----+
+| 2012-03-06 22:22:09 | queue.py   | 15477 | ipp007 | new3pi |      0 |      0 | 2012-03-06 22:25:13 | 171 | 
+| 2012-03-06 16:44:03 | loader.py  | 15510 | ipp033 | new3pi |      0 |      1 | 2012-03-07 07:25:51 | 166 | 
+| 2012-03-05 16:54:26 | loader.py  | 25131 | ipp005 | new3pi |      0 |      0 | 2012-03-07 09:43:34 |  94 | 
+| 2012-03-07 09:01:28 | pollOdm.py |  9202 | ipp006 | new3pi |      0 |      0 | 2012-03-07 10:20:11 | 174 | 
+| 2012-03-07 09:05:09 | loader.py  | 25782 | ipp005 | new3pi |      0 |      0 | 2012-03-07 10:48:13 | 175 | 
++---------------------+------------+-------+--------+--------+--------+--------+---------------------+-----+
+}}}
+
+== The queue tables ==
+
+The {{{queue.py}}} program is in charge of queuing up unprocessed items (be they stacks, detections or whatever). It populates the tables below so that the {{{loader.py}}} programs can get to work.
+
+=== The {{{box}}} table ===
+=== The {{{stripe}}} table ===
+=== The {{{pending}}} table ===
 
 
 
+== The batch tables ==
+=== The {{{batch}}} table ===
+=== The {{{detection}}} table ===
+=== The {{{stack}}} table ===
+
+
+