Index: trunk/archive/psdb/test.c
===================================================================
--- trunk/archive/psdb/test.c	(revision 3223)
+++ trunk/archive/psdb/test.c	(revision 3224)
@@ -30,19 +30,10 @@
     {
         psMetadata      *md;
-        psMetadataItem  *item;
-
-        md = psMetadataAlloc();
-        item = psMetadataItemAlloc("foo", PS_TYPE_S32, PS_META_PRIMITIVE, "Primary Key"); 
-        psMetadataAddItem(md, item, 0);
-        psFree(item);
-        item = psMetadataItemAlloc("bar", PS_TYPE_BOOL,PS_META_PRIMITIVE, "Key"); 
-        psMetadataAddItem(md, item, 1);
-        psFree(item);
-        item = psMetadataItemAlloc("baz", PS_TYPE_F64, PS_META_PRIMITIVE, NULL);
-        psMetadataAddItem(md, item, 2);
-        psFree(item);
-        item = psMetadataItemAlloc("boing", PS_TYPE_PTR, PS_META_STR, NULL, "60");
-        psMetadataAddItem(md, item, 3);
-        psFree(item);
+
+        md = psMetadataAlloc();
+        psMetadataAdd(md, 0, "foo", PS_TYPE_S32, PS_META_PRIMITIVE, "Primary Key"); 
+        psMetadataAdd(md, 1, "bar", PS_TYPE_BOOL,PS_META_PRIMITIVE, "Key"); 
+        psMetadataAdd(md, 2, "baz", PS_TYPE_F64, PS_META_PRIMITIVE, NULL);
+        psMetadataAdd(md, 3, "boing", PS_TYPE_PTR, PS_META_STR, NULL, "60");
 
         OK(psDBCreateTable(dbh, "bar", md), "psDBCreateTable()");
@@ -56,11 +47,10 @@
     {
         psMetadata      *md;
-        psMetadataItem  *item;
-
-        md = psMetadataAlloc();
-        item = psMetadataItemAlloc("hair", PS_TYPE_F32, PS_META_PRIMITIVE, NULL);
-        psMetadataAddItem(md, item, 0);
-        psFree(item);
+
+        md = psMetadataAlloc();
+        psMetadataAdd(md, 0, "hair", PS_TYPE_F32, PS_META_PRIMITIVE, NULL);
+
         psDBCreateTable(dbh, "yak", md);
+
         psFree(md);
     }
@@ -69,11 +59,10 @@
     {
         psMetadata      *md;
-        psMetadataItem  *item;
-
-        md = psMetadataAlloc();
-        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "100");
-        psMetadataAddItem(md, item, 3);
-        psFree(item);
+
+        md = psMetadataAlloc();
+        psMetadataAdd(md, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "100");
+
         psDBCreateTable(dbh, "horse", md);
+
         psFree(md);
     }
@@ -122,7 +111,5 @@
 
         md = psMetadataAlloc();
-        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "red"); 
-        psMetadataAddItem(md, item, 0);
-        psFree(item);
+        psMetadataAdd(md, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "red"); 
 
         resultSet = psDBSelectRows(dbh, "horse", md);
@@ -150,10 +137,7 @@
     {
         psMetadata      *md;
-        psMetadataItem  *item;
-
-        md = psMetadataAlloc();
-        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 
-        psMetadataAddItem(md, item, 0);
-        psFree(item);
+
+        md = psMetadataAlloc();
+        psMetadataAdd(md, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 
 
         OK(psDBInsertOneRow(dbh, "horse", md),"psDBInsertOneRow()");
@@ -166,5 +150,4 @@
         psArray         *rowSet;
         psMetadata      *row;
-        psMetadataItem  *field;
 
         rowSet = psArrayAlloc(3);
@@ -172,23 +155,20 @@
 
         row = psMetadataAlloc();
-        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 
-        psMetadataAddItem(row, field, 0);
-        psFree(field);
+        psMetadataAdd(row, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 
         psArrayAdd(rowSet, 0, row);
-//        psFree(row);
+        // FIXME
+        // psFree(row);
 
         row = psMetadataAlloc();
-        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, ""); 
-        psMetadataAddItem(row, field, 0);
-        psFree(field);
+        psMetadataAdd(row, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, ""); 
         psArrayAdd(rowSet, 0, row);
-//        psFree(row);
+        // FIXME
+        // psFree(row);
 
         row = psMetadataAlloc();
-        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 
-        psMetadataAddItem(row, field, 0);
-        psFree(field);
+        psMetadataAdd(row, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 
         psArrayAdd(rowSet, 0, row);
-//        psFree(row);
+        // FIXME
+        // psFree(row);
 
         OK(psDBInsertRows(dbh, "horse", rowSet), "psDBInsertRows()");
@@ -229,16 +209,11 @@
         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);
+        psMetadataAdd(where, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 
 
         value = psMetadataAlloc();
-        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "HOT pink"); 
-        psMetadataAddItem(value, item, 0);
-        psFree(item);
+        psMetadataAdd(value, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "HOT pink"); 
 
         rowsAffected = psDBUpdateRows(dbh, "horse", where, value);