Changeset 9751 for trunk/psLib/src/db/psDB.c

Timestamp:

Oct 26, 2006, 2:07:55 PM (20 years ago)

Author:

jhoblitt

Message:

implement comparison operation selection for S32 & psTime types in psDBGenerateConditionalSQL()

File:

• trunk/psLib/src/db/psDB.c (modified) (4 diffs)

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.108 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-10-26 02:57:33 $
+ *  @version $Revision: 1.109 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-10-27 00:07:55 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
@@ -1638 +1638 @@
     }
 
+    // select the by of comparasion to use.  currently the comparision
+    // op value is only used by PS_DATA_S32 & PS_DATA_TIME
+
+    // default to exact match ('=')
+    char *op = "=";
+    if (item->comment) {
+        // arbitrary semantic, precedence is: >=, <=, >, <, = (default)
+        if (strstr(item->comment, ">=")) {
+            op = ">=";
+        } else if (strstr(item->comment, "<=")) {
+            op = "<=";
+        } else if (strstr(item->comment, ">")) {
+            op = ">";
+        } else if (strstr(item->comment, "<")) {
+            op = "<";
+        }
+    }
+
     switch (item->type) {
     case PS_DATA_S32:
-        psStringAppend(&query, "%s=%d", itemName, (int)(item->data.S32));
+        psStringAppend(&query, "%s %s %d", itemName, op, (int)(item->data.S32));
         break;
     case PS_DATA_F32:
@@ -1649 +1667 @@
         break;
     case PS_DATA_BOOL:
-        psStringAppend(&query, "%s=%d", itemName, (int)(item->data.B));
+        psStringAppend(&query, "%s = %d", itemName, (int)(item->data.B));
         break;
     case PS_DATA_STRING:
@@ -1668 +1686 @@
         }
         break;
+    case PS_DATA_TIME: {
+            psString timeStr = psTimeToISO(item->data.V);
+            psStringAppend(&query, "%s %s '%s'", itemName, op, timeStr);
+            psFree(timeStr);
+
+            break;
+        }
     default:
         psError(PS_ERR_BAD_PARAMETER_TYPE, true,