Changeset 4045
- Timestamp:
- May 27, 2005, 4:51:28 PM (21 years ago)
- Location:
- trunk/psLib/test/dataIO
- Files:
-
- 2 edited
-
tst_psDB.c (modified) (11 diffs)
-
verified/tst_psDB.stderr (modified) (11 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/psLib/test/dataIO/tst_psDB.c
r4044 r4045 9 9 * @author Aaron Culliney, MHPCC 10 10 * 11 * @version $Revision: 1.1 0$ $Name: not supported by cvs2svn $12 * @date $Date: 2005-05-28 0 1:02:08$11 * @version $Revision: 1.11 $ $Name: not supported by cvs2svn $ 12 * @date $Date: 2005-05-28 02:50:59 $ 13 13 * 14 14 * Copyright 2004-2005 Maui High Performance Computing Center, University of Hawaii … … 184 184 } 185 185 186 psMetadata *_get_ rand_row( void )186 psMetadata *_get_const_row1( void ) 187 187 { 188 188 char buf[32]; 189 snprintf(buf, 32, "% d", rand());189 snprintf(buf, 32, "%s","randrow1" ); 190 190 return _get_RowMetadata( 191 191 "key_string", "comment-string", buf, 192 "key_s32", "comment-s32", rand(), 193 "key_f32", "comment-f32", (double)rand()/RAND_MAX, 194 "key_f64", "comment-f64", (double)rand()/RAND_MAX, 195 "key_bool", "comment-bool", round((double)rand()/RAND_MAX), 192 // "key_s32", "comment-s32", rand(), 193 "key_s32", "comment-s32", 12345, 194 // "key_f32", "comment-f32", (double)rand()/RAND_MAX, 195 "key_f32", "comment-f32", 9876.5, 196 // "key_f64", "comment-f64", (double)rand()/RAND_MAX, 197 "key_f64", "comment-f64", 456.75, 198 // "key_bool", "comment-bool", round((double)rand()/RAND_MAX), 199 "key_bool", "comment-bool", true, 200 NULL, NULL, 0.0); 201 } 202 203 psMetadata *_get_const_row2( void ) 204 { 205 char buf[32]; 206 snprintf(buf, 32, "%s","randrow2"); 207 return _get_RowMetadata( 208 "key_string", "comment-string", buf, 209 // "key_s32", "comment-s32", rand(), 210 "key_s32", "comment-s32", 2345, 211 // "key_f32", "comment-f32", (double)rand()/RAND_MAX, 212 "key_f32", "comment-f32", 876.5, 213 // "key_f64", "comment-f64", (double)rand()/RAND_MAX, 214 "key_f64", "comment-f64", 56.75, 215 // "key_bool", "comment-bool", round((double)rand()/RAND_MAX), 216 "key_bool", "comment-bool", false, 196 217 NULL, NULL, 0.0); 197 218 } … … 388 409 if (!failed) { 389 410 390 row = _get_ rand_row();391 psDBInsertOneRow(dbh, table, row); 392 psFree(row); 393 394 row = _get_ rand_row();411 row = _get_const_row1(); 412 psDBInsertOneRow(dbh, table, row); 413 psFree(row); 414 415 row = _get_const_row2(); 395 416 psDBInsertOneRow(dbh, table, row); 396 417 psFree(row); … … 474 495 if (!failed) { 475 496 476 row = _get_ rand_row();477 psDBInsertOneRow(dbh, table, row); 478 psFree(row); 479 480 row = _get_ rand_row();497 row = _get_const_row1(); 498 psDBInsertOneRow(dbh, table, row); 499 psFree(row); 500 501 row = _get_const_row2(); 481 502 psDBInsertOneRow(dbh, table, row); 482 503 psFree(row); … … 548 569 if (!failed) { 549 570 550 row = _get_ rand_row();551 psDBInsertOneRow(dbh, table, row); 552 psFree(row); 553 554 row = _get_ rand_row();571 row = _get_const_row1(); 572 psDBInsertOneRow(dbh, table, row); 573 psFree(row); 574 575 row = _get_const_row2(); 555 576 psDBInsertOneRow(dbh, table, row); 556 577 psFree(row); … … 627 648 failed = ! psDBCreateTable(dbh, table, md); 628 649 if (!failed) { 629 row = _get_ rand_row();650 row = _get_const_row1(); 630 651 failed = ! psDBInsertOneRow(dbh, table, row); 631 652 psFree(row); … … 661 682 rowSet->n = 0; 662 683 663 row = _get_ rand_row();684 row = _get_const_row1(); 664 685 psArrayAdd(rowSet, 0, row); 665 686 psFree(row); 666 687 667 row = _get_ rand_row();688 row = _get_const_row2(); 668 689 psArrayAdd(rowSet, 0, row); 669 690 psFree(row); … … 734 755 if (!failed) { 735 756 736 row = _get_ rand_row();737 psDBInsertOneRow(dbh, table, row); 738 psFree(row); 739 740 row = _get_ rand_row();757 row = _get_const_row1(); 758 psDBInsertOneRow(dbh, table, row); 759 psFree(row); 760 761 row = _get_const_row2(); 741 762 psDBInsertOneRow(dbh, table, row); 742 763 psFree(row); … … 804 825 if (!failed) { 805 826 806 row = _get_ rand_row();807 psDBInsertOneRow(dbh, table, row); 808 psFree(row); 809 810 row = _get_ rand_row();827 row = _get_const_row1(); 828 psDBInsertOneRow(dbh, table, row); 829 psFree(row); 830 831 row = _get_const_row2(); 811 832 psDBInsertOneRow(dbh, table, row); 812 833 psFree(row); … … 854 875 rowSet->n = 0; 855 876 856 row = _get_ rand_row();877 row = _get_const_row1(); 857 878 psArrayAdd(rowSet, 0, row); 858 879 psFree(row); 859 880 860 row = _get_ rand_row();881 row = _get_const_row2(); 861 882 psArrayAdd(rowSet, 0, row); 862 883 psFree(row); … … 933 954 rowSet->n = 0; 934 955 935 row = _get_ rand_row();956 row = _get_const_row1(); 936 957 psArrayAdd(rowSet, 0, row); 937 958 psFree(row); 938 959 939 row = _get_ rand_row();960 row = _get_const_row2(); 940 961 psArrayAdd(rowSet, 0, row); 941 962 psFree(row); -
trunk/psLib/test/dataIO/verified/tst_psDB.stderr
r3939 r4045 68 68 psDBSelectColumn shall select data from a test table. 69 69 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 70 psDBSelectColumn: [randrow1] 71 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 72 psDBSelectColumn: [randrow2] 73 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 70 74 psDBSelectColumn: [hello world!] 71 75 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 72 psDBSelectColumn: [hello world!]73 <DATE><TIME>|<HOST>|I|TPDBSelectColumn74 psDBSelectColumn: [hello world!]75 <DATE><TIME>|<HOST>|I|TPDBSelectColumn76 76 found expected string output. 77 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 78 psDBSelectColumn: [1] 79 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 80 psDBSelectColumn: [0] 81 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 82 psDBSelectColumn: [1] 83 <DATE><TIME>|<HOST>|I|TPDBSelectColumn 84 found expected string output. 77 85 78 86 ---> TESTPOINT PASSED (psDB{dbSelectColumn} | tst_psDB.c) … … 89 97 psDBSelectColumnNum shall select data from a test table. 90 98 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 99 str=[12345] 100 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 101 str=[2345] 102 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 91 103 str=[1974] 92 104 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 93 str=[1974]94 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum95 str=[1974]96 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum97 105 found expected S32 output. 106 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 107 bool=[1] 108 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 109 bool=[0] 110 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 111 bool=[1] 112 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum 113 found expected bool output. 98 114 99 115 ---> TESTPOINT PASSED (psDB{dbSelectColumnNum} | tst_psDB.c) … … 118 134 [key_f64]=[2.71828] 119 135 <DATE><TIME>|<HOST>|I|_print_row 136 [key_bool]=[Yay] 137 <DATE><TIME>|<HOST>|I|_print_row 138 [key_s32_0]=[3] 139 <DATE><TIME>|<HOST>|I|TPDBSelectRows 140 found expected output. 141 <DATE><TIME>|<HOST>|I|TPDBSelectRows 142 found expected output. 143 <DATE><TIME>|<HOST>|I|_print_row 120 144 [key_string]=[hello world!] 121 145 <DATE><TIME>|<HOST>|I|_print_row … … 126 150 [key_f64]=[2.71828] 127 151 <DATE><TIME>|<HOST>|I|_print_row 128 [key_string]=[hello world!] 129 <DATE><TIME>|<HOST>|I|_print_row 130 [key_s32]=[1974] 131 <DATE><TIME>|<HOST>|I|_print_row 132 [key_f32]=[3.14159] 133 <DATE><TIME>|<HOST>|I|_print_row 134 [key_f64]=[2.71828] 152 [key_bool]=[Yay] 153 <DATE><TIME>|<HOST>|I|_print_row 154 [key_s32_0]=[3] 155 <DATE><TIME>|<HOST>|I|TPDBSelectRows 156 found expected output. 135 157 <DATE><TIME>|<HOST>|I|TPDBSelectRows 136 158 found expected output. … … 162 184 psDBInsertRows shall insert rows into a test table. 163 185 <DATE><TIME>|<HOST>|I|_print_row 186 [key_string]=[randrow1] 187 <DATE><TIME>|<HOST>|I|_print_row 188 [key_s32]=[12345] 189 <DATE><TIME>|<HOST>|I|_print_row 190 [key_f32]=[9876.5] 191 <DATE><TIME>|<HOST>|I|_print_row 192 [key_f64]=[456.75] 193 <DATE><TIME>|<HOST>|I|_print_row 194 [key_bool]=[Yay] 195 <DATE><TIME>|<HOST>|I|_print_row 196 [key_s32_0]=[1] 197 <DATE><TIME>|<HOST>|I|_print_row 198 [key_string]=[randrow2] 199 <DATE><TIME>|<HOST>|I|_print_row 200 [key_s32]=[2345] 201 <DATE><TIME>|<HOST>|I|_print_row 202 [key_f32]=[876.5] 203 <DATE><TIME>|<HOST>|I|_print_row 204 [key_f64]=[56.75] 205 <DATE><TIME>|<HOST>|I|_print_row 206 [key_bool]=[Nay] 207 <DATE><TIME>|<HOST>|I|_print_row 208 [key_s32_0]=[2] 209 <DATE><TIME>|<HOST>|I|_print_row 164 210 [key_string]=[hello world!] 165 211 <DATE><TIME>|<HOST>|I|_print_row … … 170 216 [key_f64]=[2.71828] 171 217 <DATE><TIME>|<HOST>|I|_print_row 172 [key_string]=[hello world!] 173 <DATE><TIME>|<HOST>|I|_print_row 174 [key_s32]=[1974] 175 <DATE><TIME>|<HOST>|I|_print_row 176 [key_f32]=[3.14159] 177 <DATE><TIME>|<HOST>|I|_print_row 178 [key_f64]=[2.71828] 179 <DATE><TIME>|<HOST>|I|_print_row 180 [key_string]=[hello world!] 181 <DATE><TIME>|<HOST>|I|_print_row 182 [key_s32]=[1974] 183 <DATE><TIME>|<HOST>|I|_print_row 184 [key_f32]=[3.14159] 185 <DATE><TIME>|<HOST>|I|_print_row 186 [key_f64]=[2.71828] 218 [key_bool]=[Yay] 219 <DATE><TIME>|<HOST>|I|_print_row 220 [key_s32_0]=[3] 221 <DATE><TIME>|<HOST>|I|TPDBInsertRows 222 found expected output. 187 223 <DATE><TIME>|<HOST>|I|TPDBInsertRows 188 224 found expected output. … … 201 237 psDBDumpRows shall dump all rows from a test table. 202 238 <DATE><TIME>|<HOST>|I|_print_row 239 [key_string]=[randrow1] 240 <DATE><TIME>|<HOST>|I|_print_row 241 [key_s32]=[12345] 242 <DATE><TIME>|<HOST>|I|_print_row 243 [key_f32]=[9876.5] 244 <DATE><TIME>|<HOST>|I|_print_row 245 [key_f64]=[456.75] 246 <DATE><TIME>|<HOST>|I|_print_row 247 [key_bool]=[Yay] 248 <DATE><TIME>|<HOST>|I|_print_row 249 [key_s32_0]=[1] 250 <DATE><TIME>|<HOST>|I|_print_row 251 [key_string]=[randrow2] 252 <DATE><TIME>|<HOST>|I|_print_row 253 [key_s32]=[2345] 254 <DATE><TIME>|<HOST>|I|_print_row 255 [key_f32]=[876.5] 256 <DATE><TIME>|<HOST>|I|_print_row 257 [key_f64]=[56.75] 258 <DATE><TIME>|<HOST>|I|_print_row 259 [key_bool]=[Nay] 260 <DATE><TIME>|<HOST>|I|_print_row 261 [key_s32_0]=[2] 262 <DATE><TIME>|<HOST>|I|_print_row 203 263 [key_string]=[hello world!] 204 264 <DATE><TIME>|<HOST>|I|_print_row … … 209 269 [key_f64]=[2.71828] 210 270 <DATE><TIME>|<HOST>|I|_print_row 211 [key_string]=[hello world!] 212 <DATE><TIME>|<HOST>|I|_print_row 213 [key_s32]=[1974] 214 <DATE><TIME>|<HOST>|I|_print_row 215 [key_f32]=[3.14159] 216 <DATE><TIME>|<HOST>|I|_print_row 217 [key_f64]=[2.71828] 218 <DATE><TIME>|<HOST>|I|_print_row 219 [key_string]=[hello world!] 220 <DATE><TIME>|<HOST>|I|_print_row 221 [key_s32]=[1974] 222 <DATE><TIME>|<HOST>|I|_print_row 223 [key_f32]=[3.14159] 224 <DATE><TIME>|<HOST>|I|_print_row 225 [key_f64]=[2.71828] 271 [key_bool]=[Yay] 272 <DATE><TIME>|<HOST>|I|_print_row 273 [key_s32_0]=[3] 274 <DATE><TIME>|<HOST>|I|TPDBDumpRows 275 found expected output. 226 276 <DATE><TIME>|<HOST>|I|TPDBDumpRows 227 277 found expected output. … … 240 290 psDBDumpCols shall dump all cols from a test table. 241 291 <DATE><TIME>|<HOST>|I|_print_row 242 [key_string]=[ ]292 [key_string]=[] 243 293 244 294 ---> TESTPOINT PASSED (psDB{dbDumpCols} | tst_psDB.c) … … 263 313 [key_f64]=[1.23457] 264 314 <DATE><TIME>|<HOST>|I|_print_row 265 [key_string]=[foobar] 266 <DATE><TIME>|<HOST>|I|_print_row 267 [key_s32]=[-18] 268 <DATE><TIME>|<HOST>|I|_print_row 269 [key_f32]=[3.33] 270 <DATE><TIME>|<HOST>|I|_print_row 271 [key_f64]=[1.23457] 272 <DATE><TIME>|<HOST>|I|_print_row 273 [key_string]=[foobar] 274 <DATE><TIME>|<HOST>|I|_print_row 275 [key_s32]=[-18] 276 <DATE><TIME>|<HOST>|I|_print_row 277 [key_f32]=[3.33] 278 <DATE><TIME>|<HOST>|I|_print_row 279 [key_f64]=[1.23457] 315 [key_bool]=[Nay] 316 <DATE><TIME>|<HOST>|I|_print_row 317 [key_s32_0]=[3] 318 <DATE><TIME>|<HOST>|I|TPDBUpdateRows 319 found expected output. 280 320 <DATE><TIME>|<HOST>|I|TPDBUpdateRows 281 321 found expected output. … … 294 334 psDBDeleteRows shall delete rows from a test table. 295 335 <DATE><TIME>|<HOST>|I|TPDBDeleteRows 296 found expected emptytable.336 found expected two-row table. 297 337 298 338 ---> TESTPOINT PASSED (psDB{dbDeleteRows} | tst_psDB.c)
Note:
See TracChangeset
for help on using the changeset viewer.
