Changeset 3188 for trunk/archive/psdb/test.c

Timestamp:

Feb 10, 2005, 10:56:41 AM (21 years ago)

Author:

jhoblitt

Message:

add psDBUpdateRows() (incomplete)
add psDBGenerateSetSQL()
add psDBGenerateUpdateRowSQL()

File:

• trunk/archive/psdb/test.c (modified) (4 diffs)

trunk/archive/psdb/test.c

@@ -147 +147 @@
     }
 
-    //psDBInsertOneRow();
+    // psDBInsertOneRow();
     {
         psMetadata      *md;
@@ -162 +162 @@
     }
 
-    //psDBInsertRows();
+    // psDBInsertRows();
     {
         psArray         *rowSet;
@@ -197 +197 @@
     }
 
-    //psDBDumpRows();
+    // psDBDumpRows();
     {
         psArray         *resultSet;
@@ -206 +206 @@
     }
 
+    // psDBUpdateRows();
+    {
+        psMetadata      *where;
+        psMetadata      *value;
+        psMetadataItem  *item;
+        psU64           rowsAffected;
+
+        where = psMetadataAlloc();
+        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 
+        psMetadataAddItem(where, item, 0);
+        psFree(item);
+
+        value = psMetadataAlloc();
+        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "HOT pink"); 
+        psMetadataAddItem(value, item, 0);
+        psFree(item);
+
+        rowsAffected = psDBUpdateRows(dbh, "horse", where, value);
+        psFree(where);
+        psFree(value);
+
+        OK(rowsAffected, "psDBUpdateRows()");
+    }
+    
     // cleanup other tests
-    psDBDropTable(dbh, "horse");
+    // psDBDropTable(dbh, "horse");
     psDBDropTable(dbh, "yak");