Changeset 33273

Timestamp:

Feb 15, 2012, 1:14:29 PM (14 years ago)

Author:

rhenders

Message:

changes to purge dvoMeta table and use dvoImages instead; not using source ID in detection table anymore either

File:

• trunk/ippToPsps/src/Dvo.c (modified) (3 diffs)

trunk/ippToPsps/src/Dvo.c

@@ -35 +35 @@
     mysql_query(this->mysql, "DELETE FROM dvoDetection");
 
-    mysql_query(this->mysql, "SELECT sourceID, externID FROM dvoMeta");
+    mysql_query(this->mysql, "SELECT SOURCE_ID, EXTERN_ID FROM dvoImages");
     MYSQL_RES* result = mysql_store_result(this->mysql);
 
@@ -61 +61 @@
 
         sprintf(sql, 
-                "UPDATE dvoMeta SET imageID = %d,flags = %d, photcode = %d WHERE sourceID = %d AND externID = %d",
+                "UPDATE dvoImages SET IMAGE_ID = %d, FLAGS = %d, PHOTCODE = %d WHERE SOURCE_ID = %d AND EXTERN_ID = %d",
                 image->imageID,
                 image->flags,
@@ -91 +91 @@
             else {
                 sprintf(sql, 
-                        "INSERT INTO dvoDetection (sourceID, imageID, ippDetectID, detectID, ippObjID, objID, flags) VALUES (%d, %d, %u, %lu, %lu, %lu, %u)",
-                        sourceID,   // sourceID
+                        "INSERT INTO dvoDetection (imageID, ippDetectID, detectID, ippObjID, objID, flags) VALUES (%d, %u, %lu, %lu, %lu, %u)",
                         image->imageID,    // imageID
                         dvoDetections[i].meas.detID,   // ippDetectID