Changeset 17852 for trunk/Ohana/src/opihi/cmd.data/dbselect.c

Timestamp:

May 29, 2008, 10:49:58 AM (18 years ago)

Author:

eugene

Message:

add support for multiple data types

File:

• trunk/Ohana/src/opihi/cmd.data/dbselect.c (modified) (2 diffs)

trunk/Ohana/src/opihi/cmd.data/dbselect.c

@@ -5 +5 @@
 int dbselect (int argc, char **argv) {
   
+  time_t seconds;
   int i, j, Nbytes, Ncols, Nrows;
   char *query;
@@ -81 +82 @@
     for (i = 0; i < Ncols; i++) {
       if (row[i]) {
-        vec[i][0].elements[j] = atof (row[i]);
+        switch (fields[i].type) {
+          case FIELD_TYPE_TINY:
+          case FIELD_TYPE_SHORT:
+          case FIELD_TYPE_LONG:
+          case FIELD_TYPE_INT24:
+          case FIELD_TYPE_LONGLONG:
+          case FIELD_TYPE_DECIMAL:
+          case FIELD_TYPE_FLOAT:
+          case FIELD_TYPE_DOUBLE:
+            vec[i][0].elements[j] = atof (row[i]);
+            break;
+          case FIELD_TYPE_TIME:
+          case FIELD_TYPE_DATE:
+          case FIELD_TYPE_DATETIME:
+            seconds = ohana_date_to_sec (row[i]);
+            vec[i][0].elements[j] = ohana_sec_to_mjd (seconds);
+            break;
+          default:
+            vec[i][0].elements[j] = NAN;
+        }
       } else {
         vec[i][0].elements[j] = NAN;