Changeset 3224 for trunk/archive/psdb/test.c
- Timestamp:
- Feb 14, 2005, 9:57:53 PM (21 years ago)
- File:
-
- 1 edited
-
trunk/archive/psdb/test.c (modified) (8 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/archive/psdb/test.c
r3223 r3224 30 30 { 31 31 psMetadata *md; 32 psMetadataItem *item; 33 34 md = psMetadataAlloc(); 35 item = psMetadataItemAlloc("foo", PS_TYPE_S32, PS_META_PRIMITIVE, "Primary Key"); 36 psMetadataAddItem(md, item, 0); 37 psFree(item); 38 item = psMetadataItemAlloc("bar", PS_TYPE_BOOL,PS_META_PRIMITIVE, "Key"); 39 psMetadataAddItem(md, item, 1); 40 psFree(item); 41 item = psMetadataItemAlloc("baz", PS_TYPE_F64, PS_META_PRIMITIVE, NULL); 42 psMetadataAddItem(md, item, 2); 43 psFree(item); 44 item = psMetadataItemAlloc("boing", PS_TYPE_PTR, PS_META_STR, NULL, "60"); 45 psMetadataAddItem(md, item, 3); 46 psFree(item); 32 33 md = psMetadataAlloc(); 34 psMetadataAdd(md, 0, "foo", PS_TYPE_S32, PS_META_PRIMITIVE, "Primary Key"); 35 psMetadataAdd(md, 1, "bar", PS_TYPE_BOOL,PS_META_PRIMITIVE, "Key"); 36 psMetadataAdd(md, 2, "baz", PS_TYPE_F64, PS_META_PRIMITIVE, NULL); 37 psMetadataAdd(md, 3, "boing", PS_TYPE_PTR, PS_META_STR, NULL, "60"); 47 38 48 39 OK(psDBCreateTable(dbh, "bar", md), "psDBCreateTable()"); … … 56 47 { 57 48 psMetadata *md; 58 psMetadataItem *item; 59 60 md = psMetadataAlloc(); 61 item = psMetadataItemAlloc("hair", PS_TYPE_F32, PS_META_PRIMITIVE, NULL); 62 psMetadataAddItem(md, item, 0); 63 psFree(item); 49 50 md = psMetadataAlloc(); 51 psMetadataAdd(md, 0, "hair", PS_TYPE_F32, PS_META_PRIMITIVE, NULL); 52 64 53 psDBCreateTable(dbh, "yak", md); 54 65 55 psFree(md); 66 56 } … … 69 59 { 70 60 psMetadata *md; 71 psMetadataItem *item; 72 73 md = psMetadataAlloc(); 74 item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "100"); 75 psMetadataAddItem(md, item, 3); 76 psFree(item); 61 62 md = psMetadataAlloc(); 63 psMetadataAdd(md, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "100"); 64 77 65 psDBCreateTable(dbh, "horse", md); 66 78 67 psFree(md); 79 68 } … … 122 111 123 112 md = psMetadataAlloc(); 124 item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "red"); 125 psMetadataAddItem(md, item, 0); 126 psFree(item); 113 psMetadataAdd(md, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "red"); 127 114 128 115 resultSet = psDBSelectRows(dbh, "horse", md); … … 150 137 { 151 138 psMetadata *md; 152 psMetadataItem *item; 153 154 md = psMetadataAlloc(); 155 item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 156 psMetadataAddItem(md, item, 0); 157 psFree(item); 139 140 md = psMetadataAlloc(); 141 psMetadataAdd(md, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 158 142 159 143 OK(psDBInsertOneRow(dbh, "horse", md),"psDBInsertOneRow()"); … … 166 150 psArray *rowSet; 167 151 psMetadata *row; 168 psMetadataItem *field;169 152 170 153 rowSet = psArrayAlloc(3); … … 172 155 173 156 row = psMetadataAlloc(); 174 field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 175 psMetadataAddItem(row, field, 0); 176 psFree(field); 157 psMetadataAdd(row, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 177 158 psArrayAdd(rowSet, 0, row); 178 // psFree(row); 159 // FIXME 160 // psFree(row); 179 161 180 162 row = psMetadataAlloc(); 181 field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, ""); 182 psMetadataAddItem(row, field, 0); 183 psFree(field); 163 psMetadataAdd(row, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, ""); 184 164 psArrayAdd(rowSet, 0, row); 185 // psFree(row); 165 // FIXME 166 // psFree(row); 186 167 187 168 row = psMetadataAlloc(); 188 field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 189 psMetadataAddItem(row, field, 0); 190 psFree(field); 169 psMetadataAdd(row, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 191 170 psArrayAdd(rowSet, 0, row); 192 // psFree(row); 171 // FIXME 172 // psFree(row); 193 173 194 174 OK(psDBInsertRows(dbh, "horse", rowSet), "psDBInsertRows()"); … … 229 209 psMetadata *where; 230 210 psMetadata *value; 231 psMetadataItem *item;232 211 psU64 rowsAffected; 233 212 234 213 where = psMetadataAlloc(); 235 item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 236 psMetadataAddItem(where, item, 0); 237 psFree(item); 214 psMetadataAdd(where, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 238 215 239 216 value = psMetadataAlloc(); 240 item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "HOT pink"); 241 psMetadataAddItem(value, item, 0); 242 psFree(item); 217 psMetadataAdd(value, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "HOT pink"); 243 218 244 219 rowsAffected = psDBUpdateRows(dbh, "horse", where, value);
Note:
See TracChangeset
for help on using the changeset viewer.
