Changeset 3224
- Timestamp:
- Feb 14, 2005, 9:57:53 PM (21 years ago)
- Location:
- trunk/archive/psdb
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/archive/psdb/psDB.c
r3223 r3224 8 8 * @author Joshua Hoblitt 9 9 * 10 * @version $Revision: 1.2 5$ $Name: not supported by cvs2svn $11 * @date $Date: 2005-02-15 07: 28:50$10 * @version $Revision: 1.26 $ $Name: not supported by cvs2svn $ 11 * @date $Date: 2005-02-15 07:57:53 $ 12 12 * 13 13 * Copyright 2005 Joshua Hoblitt, University of Hawaii … … 352 352 psArray *resultSet; // return array 353 353 int i; // field index 354 psMetadataItem *item; // field of a row355 354 psMetadata *md; // a row 356 355 psHash *mysqlToSQLTable; // type lookup table … … 448 447 449 448 // add new field to row 450 item = psMetadataItemAlloc(field[i].name, pType, type, NULL, data); 451 psMetadataAddItem(md, item, i); 452 psFree(item); 449 psMetadataAdd(md, i, field[i].name, pType, type, NULL, data); 453 450 454 451 psFree(data); … … 592 589 psU32 fieldCount; 593 590 psMetadata *table; 594 psMetadataItem *item;595 591 psU32 pType; 596 592 psU32 i; … … 615 611 // PS_META_UNKNOWN -> PS_META_ARRAY ? 616 612 column = psDBSelectColumn(dbh, tableName, field[i].name, 0); 617 item = psMetadataItemAlloc(field[i].name, PS_TYPE_PTR, PS_META_UNKNOWN, "psArray", column); 618 psMetadataAddItem(table, item, 0); 613 psMetadataAdd(table, 0, field[i].name, PS_TYPE_PTR, PS_META_UNKNOWN, "psArray", column); 619 614 // FIXME 620 615 //psFree(column); 621 psFree(item);622 616 } else { 623 617 column = psDBSelectColumnNum(dbh, tableName, field[i].name, pType, 0); 624 item = psMetadataItemAlloc(field[i].name, PS_TYPE_PTR, PS_META_VEC, "psVector", column); 625 psMetadataAddItem(table, item, 0); 618 psMetadataAdd(table, 0, field[i].name, PS_TYPE_PTR, PS_META_VEC, "psVector", column); 626 619 // FIXME 627 620 //psFree(column); 628 psFree(item);629 621 } 630 622 } -
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.
