Changeset 10008

Timestamp:

Nov 15, 2006, 2:38:48 PM (20 years ago)

Author:

jhoblitt

Message:

implement database store support for psU32 & psU64s

File:

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

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.112 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-11-15 03:49:43 $
+ *  @version $Revision: 1.113 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-11-16 00:38:48 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
@@ -1086 +1086 @@
         // string
         switch (item->type) {
+        case PS_TYPE_U32: {
+                bind[i].length  = 0;
+                bind[i].buffer  = &item->data.U32;
+                bind[i].is_null = psDBIsPTypeNaN(item->type, &item->data.U32)
+                                  ? (my_bool *)&isNull
+                                  : NULL;
+                break;
+            }
+        case PS_TYPE_U64: {
+                bind[i].length  = 0;
+                bind[i].buffer  = &item->data.U64;
+                bind[i].is_null = psDBIsPTypeNaN(item->type, &item->data.U64)
+                                  ? (my_bool *)&isNull
+                                  : NULL;
+                break;
+            }
         case PS_TYPE_S32: {
                 bind[i].length  = 0;
@@ -1195 +1211 @@
                 psError(PS_ERR_BAD_PARAMETER_TYPE , true,
                         "FIXME: Only type of "
+                        "PS_TYPE_U32 (PS_DATA_S32), "
+                        "PS_TYPE_U64 (PS_DATA_S64), "
                         "PS_TYPE_S32 (PS_DATA_S32), "
                         "PS_TYPE_S64 (PS_DATA_S64), "
@@ -1280 +1298 @@
     while ((item = psListGetAndIncrement(cursor))) {
         switch (item->type) {
+        case PS_DATA_U32:
+        case PS_DATA_U64:
         case PS_DATA_S32:
         case PS_DATA_S64:
@@ -1855 +1875 @@
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_S32, "INT");
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_S64, "BIGINT");
-        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U8,  "UNSIGNED TINYINT");
-        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U16, "UNSIGNED SMALLINT");
-        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U32, "UNSIGNED INT");
-        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U64, "UNSIGNED BIGINT");
+        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U8,  "TINYINT UNSIGNED");
+        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U16, "SMALLINT UNSIGNED");
+        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U32, "INT UNSIGNED" );
+        psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_U64, "BIGINT UNSIGNED");
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_F32, "FLOAT");
         psDBAddToLookupTable(pTypeToSQLlookupTable, PS_TYPE_F64, "DOUBLE");