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

Timestamp:

Feb 9, 2005, 2:02:16 PM (21 years ago)

Author:

jhoblitt

Message:

add psDBInsertRows()
change mysqlType typdef to use enum_field_types
test tweaks

File:

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

trunk/archive/psdb/test.c

@@ -48 +48 @@
 
     psFree(md);
+    
+    // setup horses table for later tests
+    {
+        psMetadata      *md;
+        psMetadataItem  *item;
+
+        md = psMetadataAlloc();
+        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "100");
+        psMetadataAddItem(md, item, 3);
+        psFree(item);
+        psDBCreateTable(dbh, "horses", md);
+        psFree(md);
+    }
 
     // psDBSelectColumn()
@@ -103 +116 @@
     psFree(md);
 
+    //psDBInsertRows();
+
+    {
+        psArray         *rowSet;
+        psMetadata      *row;
+        psMetadataItem  *field;
+
+        rowSet = psArrayAlloc(3);
+        rowSet->n = 0;
+
+        row = psMetadataAlloc();
+        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 
+        psMetadataAddItem(row, field, 0);
+        psFree(field);
+        psArrayAdd(rowSet, 0, row);
+        psFree(row);
+
+        row = psMetadataAlloc();
+        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, ""); 
+        psMetadataAddItem(row, field, 0);
+        psFree(field);
+        psArrayAdd(rowSet, 0, row);
+        psFree(row);
+
+        row = psMetadataAlloc();
+        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 
+        psMetadataAddItem(row, field, 0);
+        psFree(field);
+        psArrayAdd(rowSet, 0, row);
+        psFree(row);
+
+        if (psDBInsertRows(dbh, "horses", rowSet)) {
+            printf("psDBInsertRows() succeeded\n");
+        }
+
+        psFree(rowSet);
+    }
+
     //psDBDumpRows();
     resultSet = psDBDumpRows(dbh, "horses");
     psFree(resultSet);
+
+    // cleanup other tests
+    psDBDropTable(dbh, "horses");
 
     // close db