1/* 2 * Copyright (C) 2021 Huawei Device Co., Ltd. 3 * Licensed under the Apache License, Version 2.0 (the "License"); 4 * you may not use this file except in compliance with the License. 5 * You may obtain a copy of the License at 6 * 7 * http://www.apache.org/licenses/LICENSE-2.0 8 * 9 * Unless required by applicable law or agreed to in writing, software 10 * distributed under the License is distributed on an "AS IS" BASIS, 11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 12 * See the License for the specific language governing permissions and 13 * limitations under the License. 14 */ 15import {describe, beforeAll, beforeEach, afterEach, afterAll, it, expect} from 'deccjsunit/index' 16import dataRdb from '@ohos.data.rdb' 17 18const TAG = "[RDB_JSKITS_TEST]" 19const CREATE_TABLE_TEST = "CREATE TABLE IF NOT EXISTS test (" + "id INTEGER PRIMARY KEY AUTOINCREMENT, " + "data1 text," + "data2 long, " + "data3 double," + "data4 blob)"; 20 21const STORE_CONFIG = { 22 name: "Resultset.db", 23} 24var rdbStore = undefined; 25 26describe('rdbResultSetTest', function () { 27 beforeAll(async function () { 28 console.info(TAG + 'beforeAll') 29 rdbStore = await dataRdb.getRdbStore(STORE_CONFIG, 1); 30 await rdbStore.executeSql(CREATE_TABLE_TEST, null); 31 await createTest(); 32 }) 33 34 beforeEach(async function () { 35 console.info(TAG + 'beforeEach') 36 }) 37 38 afterEach(function () { 39 console.info(TAG + 'afterEach') 40 }) 41 42 afterAll(async function () { 43 console.info(TAG + 'afterAll') 44 rdbStore = null 45 await dataRdb.deleteRdbStore("Resultset.db"); 46 }) 47 // insert data 48 async function createTest() { 49 console.log(TAG + "createTest data start"); 50 { 51 var u8 = new Uint8Array([1, 2, 3]) 52 const valueBucket = { 53 "data1": "hello", 54 "data2": 10, 55 "data3": 1.0, 56 "data4": u8, 57 } 58 await rdbStore.insert("test", valueBucket) 59 } 60 { 61 var u8 = new Uint8Array([3, 4, 5]) 62 const valueBucket = { 63 "data1": "2", 64 "data2": -5, 65 "data3": 2.5, 66 "data4": u8, 67 } 68 await rdbStore.insert("test", valueBucket) 69 } 70 { 71 var u8 = new Uint8Array(0) 72 const valueBucket = { 73 "data1": "hello world", 74 "data2": 3, 75 "data3": 1.8, 76 "data4": u8, 77 } 78 await rdbStore.insert("test", valueBucket) 79 } 80 console.log(TAG + "createTest data end"); 81 } 82 83 function random(min, max) { 84 return Math.floor(Math.random() * (max - min)) + min; 85 } 86 87 function createUint8Array(length) { 88 let i = 0 89 let index = 0 90 let temp = null 91 let u8 = new Uint8Array(length) 92 length = typeof (length) === 'undefined' ? 9 : length 93 for (i = 1; i <= length; i++) { 94 u8[i - 1] = i 95 } 96 for (i = 1; i <= length; i++) { 97 index = parseInt(Math.random() * (length - i)) + i 98 if (index != i) { 99 temp = u8[i - 1] 100 u8[i - 1] = u8[index - 1] 101 u8[index - 1] = temp 102 } 103 } 104 return u8; 105 } 106 107 async function createBigData(size) { 108 await rdbStore.executeSql("DELETE FROM test"); 109 let u8 = createUint8Array(32768); 110 let valueBucketArray = new Array(); 111 for (let i = 0; i < size; i++) { 112 valueBucketArray.push({ 113 "data1": "test" + i, 114 "data2": 18, 115 "data3": 100.5, 116 "data4": u8, 117 }); 118 } 119 await rdbStore.batchInsert("test", valueBucketArray); 120 } 121 122 /** 123 * @tc.name resultSet getBlob normal test 124 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0010 125 * @tc.desc resultSet getBlob normal test 126 */ 127 it('testGetBlob0001', 0, async function (done) { 128 console.log(TAG + "************* testGetBlob0001 start *************"); 129 let predicates = await new dataRdb.RdbPredicates("test") 130 let resultSet = await rdbStore.query(predicates) 131 try { 132 { 133 expect(true).assertEqual(resultSet.goToFirstRow()) 134 const id = resultSet.getLong(resultSet.getColumnIndex("id")) 135 const data4 = resultSet.getBlob(resultSet.getColumnIndex("data4")) 136 console.log(TAG + "id=" + id + ", data4=" + data4); 137 expect(1).assertEqual(data4[0]); 138 expect(2).assertEqual(data4[1]); 139 expect(3).assertEqual(data4[2]); 140 } 141 resultSet.close(); 142 expect(true).assertEqual(resultSet.isClosed) 143 } catch (e) { 144 expect(null).assertFail(); 145 } 146 resultSet = null 147 done(); 148 console.log(TAG + "************* testGetBlob0001 end *************"); 149 }) 150 151 /** 152 * @tc.name resultSet getBlob normal test 153 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0011 154 * @tc.desc resultSet getBlob normal test 155 */ 156 it('testGetBlob0002', 0, async function (done) { 157 console.log(TAG + "************* testGetBlob0002 start *************"); 158 let predicates = await new dataRdb.RdbPredicates("test") 159 let resultSet = await rdbStore.query(predicates) 160 try { 161 { 162 expect(true).assertEqual(resultSet.goToFirstRow()) 163 expect(true).assertEqual(resultSet.goToNextRow()) 164 const id = resultSet.getLong(resultSet.getColumnIndex("id")) 165 const data4 = resultSet.getBlob(resultSet.getColumnIndex("data4")) 166 console.log(TAG + "id=" + id + ", data4=" + data4); 167 expect(3).assertEqual(data4[0]); 168 expect(4).assertEqual(data4[1]); 169 expect(5).assertEqual(data4[2]); 170 } 171 resultSet.close(); 172 expect(true).assertEqual(resultSet.isClosed) 173 } catch (e) { 174 expect(null).assertFail(); 175 } 176 resultSet = null 177 done(); 178 console.log(TAG + "************* testGetBlob0002 end *************"); 179 }) 180 181 /** 182 * @tc.name resultSet getBlob normal test 183 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0012 184 * @tc.desc resultSet getBlob normal test 185 */ 186 it('testGetBlob0003', 0, async function (done) { 187 console.log(TAG + "************* testGetBlob0003 start *************"); 188 let predicates = await new dataRdb.RdbPredicates("test") 189 let resultSet = await rdbStore.query(predicates) 190 try { 191 { 192 expect(true).assertEqual(resultSet.goToFirstRow()) 193 expect(true).assertEqual(resultSet.goToNextRow()) 194 expect(true).assertEqual(resultSet.goToNextRow()) 195 const id = resultSet.getLong(resultSet.getColumnIndex("id")) 196 const data4 = resultSet.getBlob(resultSet.getColumnIndex("data4")) 197 console.log(TAG + "id=" + id + ", data4=" + data4); 198 expect("").assertEqual("" + data4); 199 } 200 resultSet.close(); 201 expect(true).assertEqual(resultSet.isClosed) 202 } catch (e) { 203 expect(null).assertFail(); 204 } 205 resultSet = null 206 done(); 207 console.log(TAG + "************* testGetBlob0003 end *************"); 208 }) 209 210 /** 211 * @tc.name resultSet isStarted normal test 212 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0020 213 * @tc.desc resultSet isStarted normal test 214 */ 215 it('testIsStarted0001', 0, async function (done) { 216 console.log(TAG + "************* testIsStarted0001 start *************"); 217 let predicates = await new dataRdb.RdbPredicates("test") 218 let resultSet = await rdbStore.query(predicates) 219 try { 220 expect(false).assertEqual(resultSet.isStarted) 221 } catch (e) { 222 expect(null).assertFail(); 223 } 224 resultSet = null 225 done(); 226 console.log(TAG + "************* testIsStarted0001 end *************"); 227 }) 228 229 /** 230 * @tc.name resultSet isStarted normal test 231 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0021 232 * @tc.desc resultSet isStarted normal test 233 */ 234 it('testIsStarted0002', 0, async function (done) { 235 console.log(TAG + "************* testIsStarted0002 start *************"); 236 let predicates = await new dataRdb.RdbPredicates("test") 237 let resultSet = await rdbStore.query(predicates) 238 try { 239 resultSet.goTo(1) 240 expect(true).assertEqual(resultSet.isStarted) 241 } catch (e) { 242 expect(null).assertFail(); 243 } 244 resultSet = null 245 done(); 246 console.log(TAG + "************* testIsStarted0002 end *************"); 247 }) 248 249 /** 250 * @tc.name resultSet isStarted normal test 251 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0022 252 * @tc.desc resultSet isStarted normal test 253 */ 254 it('testIsStarted0003', 0, async function (done) { 255 console.log(TAG + "************* testIsStarted0003 start *************"); 256 let predicates = await new dataRdb.RdbPredicates("test") 257 let resultSet = await rdbStore.query(predicates) 258 try { 259 expect(true).assertEqual(resultSet.goToNextRow()) 260 expect(true).assertEqual(resultSet.isStarted) 261 expect(false).assertEqual(resultSet.goToPreviousRow()) 262 expect(true).assertEqual(resultSet.isStarted) 263 } catch (e) { 264 expect(null).assertFail(); 265 } 266 resultSet = null 267 done(); 268 console.log(TAG + "************* testIsStarted0003 end *************"); 269 }) 270 271 /** 272 * @tc.name resultSet isStarted with no result test 273 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0023 274 * @tc.desc resultSet isStarted with no result test 275 */ 276 it('testIsStarted0004', 0, async function (done) { 277 console.log(TAG + "************* testIsStarted0004 start *************"); 278 let predicates = await new dataRdb.RdbPredicates("test") 279 let resultSet = await rdbStore.query(predicates) 280 try { 281 expect(true).assertEqual(resultSet.goToNextRow()) 282 expect(true).assertEqual(resultSet.isStarted) 283 expect(true).assertEqual(resultSet.isStarted) 284 } catch (e) { 285 expect(null).assertFail(); 286 } 287 resultSet = null 288 done(); 289 console.log(TAG + "************* testIsStarted0004 end *************"); 290 }) 291 292 293 /** 294 * @tc.name resultSet isEnded normal test 295 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0030 296 * @tc.desc resultSet isEnded normal test 297 */ 298 it('testIsEnded0001', 0, async function (done) { 299 console.log(TAG + "************* testIsEnded0001 start *************"); 300 let predicates = await new dataRdb.RdbPredicates("test") 301 let resultSet = await rdbStore.query(predicates) 302 try { 303 expect(true).assertEqual(resultSet.goToFirstRow()) 304 expect(false).assertEqual(resultSet.isEnded) 305 } catch (e) { 306 expect(null).assertFail(); 307 } 308 resultSet = null 309 done(); 310 console.log(TAG + "************* testIsEnded0001 end *************"); 311 }) 312 313 /** 314 * @tc.name resultSet isEnded normal test 315 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0031 316 * @tc.desc resultSet isEnded normal test 317 */ 318 it('testIsEnded0002', 0, async function (done) { 319 console.log(TAG + "************* testIsEnded0002 start *************"); 320 let predicates = await new dataRdb.RdbPredicates("test") 321 let resultSet = await rdbStore.query(predicates) 322 try { 323 expect(true).assertEqual(resultSet.goToLastRow()) 324 expect(false).assertEqual(resultSet.isEnded) 325 } catch (e) { 326 expect(null).assertFail(); 327 } 328 resultSet = null 329 done(); 330 console.log(TAG + "************* testIsEnded0002 end *************"); 331 }) 332 333 /** 334 * @tc.name resultSet isEnded normal test 335 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0032 336 * @tc.desc resultSet isEnded normal test 337 */ 338 it('testIsEnded0003', 0, async function (done) { 339 console.log(TAG + "************* testIsEnded0003 start *************"); 340 let predicates = await new dataRdb.RdbPredicates("test") 341 let resultSet = await rdbStore.query(predicates) 342 try { 343 resultSet.goToRow(3) 344 expect(true).assertEqual(resultSet.isEnded) 345 } catch (e) { 346 expect(null).assertFail(); 347 } 348 resultSet = null 349 done(); 350 console.log(TAG + "************* testIsEnded0003 end *************"); 351 }) 352 353 /** 354 * @tc.name resultSet isEnded normal test 355 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0033 356 * @tc.desc resultSet isEnded normal test 357 */ 358 it('testIsEnded0004', 0, async function (done) { 359 console.log(TAG + "************* testIsEnded0004 start *************"); 360 let predicates = await new dataRdb.RdbPredicates("test") 361 let resultSet = await rdbStore.query(predicates) 362 try { 363 resultSet.goToRow(3) 364 expect(true).assertEqual(resultSet.isEnded) 365 expect(true).assertEqual(resultSet.isEnded) 366 } catch (e) { 367 expect(null).assertFail(); 368 } 369 resultSet = null 370 done(); 371 console.log(TAG + "************* testIsEnded0004 end *************"); 372 }) 373 374 /** 375 * @tc.name resultSet rowCount normal test 376 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0040 377 * @tc.desc resultSet rowCount normal test 378 */ 379 it('testRowCount0001', 0, async function (done) { 380 console.log(TAG + "************* testRowCount0001 start *************"); 381 let predicates = await new dataRdb.RdbPredicates("test") 382 let resultSet = await rdbStore.query(predicates) 383 try { 384 expect(3).assertEqual(resultSet.rowCount) 385 } catch (e) { 386 expect(null).assertFail(); 387 } 388 resultSet = null 389 done(); 390 console.log(TAG + "************* testRowCount0001 end *************"); 391 }) 392 393 /** 394 * @tc.name resultSet rowCount with no result test 395 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0041 396 * @tc.desc resultSet rowCount with no result test 397 */ 398 it('testRowCount0002', 0, async function (done) { 399 console.log(TAG + "************* testRowCount0002 start *************"); 400 let predicates = await new dataRdb.RdbPredicates("test") 401 predicates.equalTo("name", "wangwu"); 402 let resultSet = await rdbStore.query(predicates) 403 try { 404 expect(-1).assertEqual(resultSet.rowCount) 405 } catch (e) { 406 expect(null).assertFail(); 407 } 408 resultSet = null 409 done(); 410 console.log(TAG + "************* testRowCount0002 end *************"); 411 }) 412 413 /** 414 * @tc.name resultSet rowCount test 415 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0042 416 * @tc.desc resultSet rowCount test 417 */ 418 it('testRowCount0003', 0, async function (done) { 419 console.log(TAG + "************* testRowCount0003 start *************"); 420 let predicates = await new dataRdb.RdbPredicates("test") 421 predicates.equalTo("data1", "hello"); 422 let resultSet = await rdbStore.query(predicates) 423 try { 424 expect(1).assertEqual(resultSet.rowCount) 425 } catch (e) { 426 expect(null).assertFail(); 427 } 428 resultSet = null 429 done(); 430 console.log(TAG + "************* testRowCount0003 end *************"); 431 }) 432 433 /** 434 * @tc.name resultSet rowCount test 435 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0043 436 * @tc.desc resultSet rowCount test 437 */ 438 it('testRowCount0004', 0, async function (done) { 439 console.log(TAG + "************* testRowCount0004 start *************"); 440 let predicates = await new dataRdb.RdbPredicates("test") 441 predicates.equalTo("data1", "hello"); 442 predicates.equalTo("data2", 3); 443 let resultSet = await rdbStore.query(predicates) 444 try { 445 expect(0).assertEqual(resultSet.rowCount) 446 } catch (e) { 447 expect(null).assertFail(); 448 } 449 resultSet = null 450 done(); 451 console.log(TAG + "************* testRowCount0003 end *************"); 452 }) 453 454 /** 455 * @tc.name resultSet getLong test 456 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0050 457 * @tc.desc resultSet getLong test 458 */ 459 it('testGetLong0001', 0, async function (done) { 460 console.log(TAG + "************* testGetLong0001 start *************"); 461 let predicates = await new dataRdb.RdbPredicates("test") 462 let resultSet = await rdbStore.query(predicates) 463 try { 464 { 465 expect(true).assertEqual(resultSet.goToFirstRow()) 466 const id = resultSet.getLong(resultSet.getColumnIndex("id")) 467 const data2 = resultSet.getLong(resultSet.getColumnIndex("data2")) 468 console.log(TAG + "id=" + id + ", data2=" + data2); 469 expect(10).assertEqual(data2); 470 } 471 resultSet.close(); 472 expect(true).assertEqual(resultSet.isClosed) 473 } catch (e) { 474 expect(null).assertFail(); 475 } 476 resultSet = null 477 done(); 478 console.log(TAG + "************* testGetLong0001 end *************"); 479 }) 480 481 /** 482 * @tc.name resultSet getLong test 483 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0051 484 * @tc.desc resultSet getLong test 485 */ 486 it('testGetLong0002', 0, async function (done) { 487 console.log(TAG + "************* testGetLong0002 start *************"); 488 let predicates = await new dataRdb.RdbPredicates("test") 489 let resultSet = await rdbStore.query(predicates) 490 try { 491 { 492 expect(true).assertEqual(resultSet.goToFirstRow()) 493 expect(true).assertEqual(resultSet.goToNextRow()) 494 const data1 = resultSet.getLong(resultSet.getColumnIndex("data1")) 495 expect(2).assertEqual(data1); 496 } 497 resultSet.close(); 498 expect(true).assertEqual(resultSet.isClosed) 499 } catch (e) { 500 expect(null).assertFail(); 501 } 502 resultSet = null 503 done(); 504 console.log(TAG + "************* testGetLong0002 end *************"); 505 }) 506 507 /** 508 * @tc.name resultSet getLong test 509 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0052 510 * @tc.desc resultSet getLong test 511 */ 512 it('testGetLong0003', 0, async function (done) { 513 console.log(TAG + "************* testGetLong0003 start *************"); 514 let predicates = await new dataRdb.RdbPredicates("test") 515 let resultSet = await rdbStore.query(predicates) 516 try { 517 { 518 expect(true).assertEqual(resultSet.goToFirstRow()) 519 expect(true).assertEqual(resultSet.goToNextRow()) 520 const data2 = resultSet.getLong(resultSet.getColumnIndex("data2")) 521 expect(-5).assertEqual(data2); 522 } 523 resultSet.close(); 524 expect(true).assertEqual(resultSet.isClosed) 525 } catch (e) { 526 expect(null).assertFail(); 527 } 528 resultSet = null 529 done(); 530 console.log(TAG + "************* testGetLong0003 end *************"); 531 }) 532 533 /** 534 * @tc.name resultSet getString test 535 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0060 536 * @tc.desc resultSet getString test 537 */ 538 it('testGetString0001', 0, async function (done) { 539 console.log(TAG + "************* testGetString0001 start *************"); 540 let predicates = await new dataRdb.RdbPredicates("test") 541 let resultSet = await rdbStore.query(predicates) 542 { 543 expect(true).assertEqual(resultSet.goToFirstRow()) 544 const data1 = resultSet.getString(resultSet.getColumnIndex("data1")) 545 expect("hello").assertEqual(data1); 546 } 547 resultSet = null 548 done(); 549 console.log(TAG + "************* testGetString0001 end *************"); 550 }) 551 552 /** 553 * @tc.name resultSet getString test 554 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0061 555 * @tc.desc resultSet getString test 556 */ 557 it('testGetString0002', 0, async function (done) { 558 console.log(TAG + "************* testGetString0002 start *************"); 559 let predicates = await new dataRdb.RdbPredicates("test") 560 let resultSet = await rdbStore.query(predicates) 561 { 562 expect(true).assertEqual(resultSet.goToFirstRow()) 563 const data2 = resultSet.getString(resultSet.getColumnIndex("data2")) 564 expect("10").assertEqual(data2); 565 } 566 resultSet = null 567 done(); 568 console.log(TAG + "************* testGetString0002 end *************"); 569 }) 570 571 /** 572 * @tc.name resultSet getString test 573 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0062 574 * @tc.desc resultSet getString test 575 */ 576 it('testGetString0003', 0, async function (done) { 577 console.log(TAG + "************* testGetString0003 start *************"); 578 let predicates = await new dataRdb.RdbPredicates("test") 579 let resultSet = await rdbStore.query(predicates) 580 { 581 expect(true).assertEqual(resultSet.goToFirstRow()) 582 expect(true).assertEqual(resultSet.goToNextRow()) 583 const data3 = resultSet.getString(resultSet.getColumnIndex("data3")) 584 expect("2.5").assertEqual(data3); 585 } 586 resultSet = null 587 done(); 588 console.log(TAG + "************* testGetString0003 end *************"); 589 }) 590 591 /** 592 * @tc.name resultSet getString test 593 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0063 594 * @tc.desc resultSet getString test 595 */ 596 it('testGetString0004', 0, async function (done) { 597 console.log(TAG + "************* testGetString0004 start *************"); 598 let predicates = await new dataRdb.RdbPredicates("test") 599 let resultSet = await rdbStore.query(predicates) 600 { 601 expect(true).assertEqual(resultSet.goToFirstRow()) 602 expect(true).assertEqual(resultSet.goToNextRow()) 603 expect(true).assertEqual(resultSet.goToNextRow()) 604 const data1 = resultSet.getString(resultSet.getColumnIndex("data1")) 605 const data2 = resultSet.getString(resultSet.getColumnIndex("data2")) 606 const data3 = resultSet.getString(resultSet.getColumnIndex("data3")) 607 expect("hello world").assertEqual(data1); 608 expect("3").assertEqual(data2); 609 expect("1.8").assertEqual(data3); 610 } 611 resultSet = null 612 done(); 613 console.log(TAG + "************* testGetString0004 end *************"); 614 }) 615 616 /** 617 * @tc.name resultSet isClosed test 618 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0070 619 * @tc.desc resultSet isClosed test 620 */ 621 it('testIsClosed0001', 0, async function (done) { 622 console.log(TAG + "************* testIsClosed0001 start *************"); 623 let predicates = await new dataRdb.RdbPredicates("test") 624 let resultSet = await rdbStore.query(predicates) 625 626 expect(3).assertEqual(resultSet.rowCount) 627 resultSet.close(); 628 expect(true).assertEqual(resultSet.isClosed) 629 630 resultSet = null 631 done(); 632 console.log(TAG + "************* testIsClosed0001 end *************"); 633 }) 634 635 /** 636 * @tc.name resultSet isClosed with not close test 637 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0071 638 * @tc.desc resultSet isClosed with not close test 639 */ 640 it('testIsClosed0002', 0, async function (done) { 641 console.log(TAG + "************* testIsClosed0002 start *************"); 642 let predicates = await new dataRdb.RdbPredicates("test") 643 let resultSet = await rdbStore.query(predicates) 644 expect(false).assertEqual(resultSet.isClosed) 645 646 resultSet = null 647 done(); 648 console.log(TAG + "************* testIsClosed0002 end *************"); 649 }) 650 651 /** 652 * @tc.name resultSet isClosed with not close test 653 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0072 654 * @tc.desc resultSet isClosed with not close test 655 */ 656 it('testIsClosed0003', 0, async function (done) { 657 console.log(TAG + "************* testIsClosed0003 start *************"); 658 let predicates = await new dataRdb.RdbPredicates("test") 659 predicates.equalTo("name", "wangwu"); 660 let resultSet = await rdbStore.query(predicates) 661 expect(false).assertEqual(resultSet.isClosed) 662 663 resultSet = null 664 done(); 665 console.log(TAG + "************* testIsClosed0003 end *************"); 666 }) 667 668 /** 669 * @tc.name resultSet columnCount test 670 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0080 671 * @tc.desc resultSet columnCount test 672 */ 673 it('testColumnCount0001', 0, async function (done) { 674 console.log(TAG + "************* testColumnCount0001 start *************"); 675 { 676 let predicates = await new dataRdb.RdbPredicates("test") 677 let resultSet = await rdbStore.query(predicates) 678 expect(5).assertEqual(resultSet.columnCount); 679 resultSet = null; 680 done(); 681 console.log(TAG + "************* testColumnCount0001 end *************"); 682 } 683 }) 684 685 /** 686 * @tc.name resultSet columnCount test 687 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0081 688 * @tc.desc resultSet columnCount test 689 */ 690 it('testColumnCount0002', 0, async function (done) { 691 console.log(TAG + "************* testColumnCount0002 start *************"); 692 { 693 let predicates = await new dataRdb.RdbPredicates("test") 694 predicates.equalTo("name", "wangwu"); 695 let resultSet = await rdbStore.query(predicates) 696 expect(0).assertEqual(resultSet.columnCount); 697 resultSet = null; 698 done(); 699 console.log(TAG + "************* testColumnCount0002 end *************"); 700 } 701 }) 702 703 /** 704 * @tc.name resultSet rowIndex test 705 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0090 706 * @tc.desc resultSet rowIndex test 707 */ 708 it('testRowIndex0001', 0, async function (done) { 709 console.log(TAG + "************* testRowIndex0001 *************"); 710 { 711 let predicates = await new dataRdb.RdbPredicates("test") 712 let resultSet = await rdbStore.query(predicates) 713 { 714 expect(true).assertEqual(resultSet.goToFirstRow()) 715 expect(0).assertEqual(resultSet.rowIndex) 716 } 717 718 resultSet = null; 719 done(); 720 console.log(TAG + "************* testRowIndex0001 end *************"); 721 } 722 }) 723 724 /** 725 * @tc.name resultSet rowIndex at last row test 726 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0091 727 * @tc.desc resultSet rowIndex at last row test 728 */ 729 it('testRowIndex0002', 0, async function (done) { 730 console.log(TAG + "************* testRowIndex0002 *************"); 731 { 732 let predicates = await new dataRdb.RdbPredicates("test") 733 let resultSet = await rdbStore.query(predicates) 734 { 735 expect(true).assertEqual(resultSet.goToLastRow()) 736 expect(2).assertEqual(resultSet.rowIndex) 737 } 738 739 resultSet = null; 740 done(); 741 console.log(TAG + "************* testRowIndex0002 end *************"); 742 } 743 }) 744 745 /** 746 * @tc.name resultSet goToFirstRow normal test 747 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0100 748 * @tc.desc resultSet goToFirstRow normal test 749 */ 750 it('testGoToFirstRow0001', 0, async function (done) { 751 console.log(TAG + "************* testGoToFirstRow0001 start *************"); 752 753 let predicates = await new dataRdb.RdbPredicates("test") 754 let resultSet = await rdbStore.query(predicates) 755 try { 756 expect(true).assertEqual(resultSet.goToFirstRow()) 757 resultSet.close(); 758 } catch (e) { 759 expect(null).assertFail(); 760 } 761 resultSet = null 762 done(); 763 console.log(TAG + "************* testGoToFirstRow0001 end *************"); 764 }) 765 766 /** 767 * @tc.name resultSet goToFirstRow with no result test 768 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0101 769 * @tc.desc resultSet goToFirstRow with no result test 770 */ 771 it('testGoToFirstRow0002', 0, async function (done) { 772 console.log(TAG + "************* testGoToFirstRow0002 start *************"); 773 774 let predicates = await new dataRdb.RdbPredicates("test") 775 predicates.equalTo("name", "wangwu"); 776 let resultSet = await rdbStore.query(predicates) 777 try { 778 expect(false).assertEqual(resultSet.goToFirstRow()) 779 } catch (e) { 780 expect(null).assertFail(); 781 } 782 resultSet = null 783 done(); 784 console.log(TAG + "************* testGoToFirstRow0002 end *************"); 785 }) 786 787 /** 788 * @tc.name resultSet goToFirstRow test 789 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0102 790 * @tc.desc resultSet goToFirstRow test 791 */ 792 it('testGoToFirstRow0003', 0, async function (done) { 793 console.log(TAG + "************* testGoToFirstRow0003 start *************"); 794 795 let predicates = await new dataRdb.RdbPredicates("test") 796 let resultSet = await rdbStore.query(predicates) 797 try { 798 expect(true).assertEqual(resultSet.goToFirstRow()) 799 expect(true).assertEqual(resultSet.goToNextRow()) 800 expect(true).assertEqual(resultSet.goToFirstRow()) 801 } catch (e) { 802 expect(null).assertFail(); 803 } 804 resultSet = null 805 done(); 806 console.log(TAG + "************* testGoToFirstRow0003 end *************"); 807 }) 808 809 /** 810 * @tc.name resultSet goToLastRow test 811 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0110 812 * @tc.desc resultSet goToFirstRow test 813 */ 814 it('testGoToLastRow0001', 0, async function (done) { 815 console.log(TAG + "************* testGoToLastRow0001 start *************"); 816 { 817 let predicates = await new dataRdb.RdbPredicates("test") 818 let resultSet = await rdbStore.query(predicates) 819 { 820 expect(true).assertEqual(resultSet.goToLastRow()) 821 } 822 resultSet = null; 823 done(); 824 console.log(TAG + "************* testGoToLastRow0001 end *************"); 825 } 826 }) 827 828 /** 829 * @tc.name resultSet goToLastRow with no result test 830 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0111 831 * @tc.desc resultSet goToLastRow with no result test 832 */ 833 it('testGoToLastRow0002', 0, async function (done) { 834 console.log(TAG + "************* testGoToLastRow0002 start *************"); 835 { 836 let predicates = await new dataRdb.RdbPredicates("test") 837 predicates.equalTo("name", "wangwu"); 838 let resultSet = await rdbStore.query(predicates) 839 { 840 expect(false).assertEqual(resultSet.goToLastRow()) 841 } 842 resultSet = null; 843 done(); 844 console.log(TAG + "************* testGoToLastRow0002 end *************"); 845 } 846 }) 847 848 /** 849 * @tc.name resultSet goToLastRow test 850 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0112 851 * @tc.desc resultSet goToLastRow test 852 */ 853 it('testGoToLastRow0003', 0, async function (done) { 854 console.log(TAG + "************* testGoToLastRow0003 start *************"); 855 { 856 let predicates = await new dataRdb.RdbPredicates("test") 857 let resultSet = await rdbStore.query(predicates) 858 { 859 expect(true).assertEqual(resultSet.goToLastRow()) 860 expect(true).assertEqual(resultSet.goToPreviousRow()) 861 expect(true).assertEqual(resultSet.goToLastRow()) 862 } 863 resultSet = null; 864 done(); 865 console.log(TAG + "************* testGoToLastRow0003 end *************"); 866 } 867 }) 868 869 /** 870 * @tc.name resultSet goToNextRow test 871 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0120 872 * @tc.desc resultSet goToNextRow test 873 */ 874 it('testGoToNextRow0001', 0, async function (done) { 875 console.log(TAG + "************* testGoToNextRow0001 start *************"); 876 { 877 let predicates = await new dataRdb.RdbPredicates("test") 878 let resultSet = await rdbStore.query(predicates) 879 { 880 expect(true).assertEqual(resultSet.goToNextRow()) 881 } 882 resultSet = null; 883 done(); 884 console.log(TAG + "************* testGoToNextRow0001 end *************"); 885 } 886 }) 887 888 /** 889 * @tc.name resultSet goToNextRow with no result test 890 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0121 891 * @tc.desc resultSet goToNextRow with no result test 892 */ 893 it('testGoToNextRow0002', 0, async function (done) { 894 console.log(TAG + "************* testGoToNextRow0002 start *************"); 895 { 896 let predicates = await new dataRdb.RdbPredicates("test") 897 predicates.equalTo("name", "wangwu"); 898 let resultSet = await rdbStore.query(predicates) 899 { 900 expect(false).assertEqual(resultSet.goToNextRow()) 901 } 902 resultSet = null; 903 done(); 904 console.log(TAG + "************* testGoToNextRow0002 end *************"); 905 } 906 }) 907 908 /** 909 * @tc.name resultSet goToNextRow test 910 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0122 911 * @tc.desc resultSet goToNextRow test 912 */ 913 it('testGoToNextRow0003', 0, async function (done) { 914 console.log(TAG + "************* testGoToNextRow0003 start *************"); 915 { 916 let predicates = await new dataRdb.RdbPredicates("test") 917 let resultSet = await rdbStore.query(predicates) 918 { 919 expect(true).assertEqual(resultSet.goToFirstRow()) 920 expect(true).assertEqual(resultSet.goToNextRow()) 921 expect(true).assertEqual(resultSet.goToPreviousRow()) 922 expect(true).assertEqual(resultSet.goToNextRow()) 923 } 924 resultSet = null; 925 done(); 926 console.log(TAG + "************* testGoToNextRow0003 end *************"); 927 } 928 }) 929 930 /** 931 * @tc.name resultSet goToNextRow after last row test 932 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0123 933 * @tc.desc resultSet goToNextRow after last row test 934 */ 935 it('testGoToNextRow0004', 0, async function (done) { 936 console.log(TAG + "************* testGoToNextRow0004 start *************"); 937 { 938 let predicates = await new dataRdb.RdbPredicates("test") 939 let resultSet = await rdbStore.query(predicates) 940 { 941 expect(true).assertEqual(resultSet.goToLastRow()) 942 expect(false).assertEqual(resultSet.goToNextRow()) 943 } 944 resultSet = null; 945 done(); 946 console.log(TAG + "************* testGoToNextRow0004 end *************"); 947 } 948 }) 949 950 /** 951 * @tc.name resultSet goToPreviousRow test 952 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0130 953 * @tc.desc resultSet goToPreviousRow test 954 */ 955 it('testGoToPreviousRow0001', 0, async function (done) { 956 console.log(TAG + "************* testGoToPreviousRow0001 start *************"); 957 { 958 let predicates = await new dataRdb.RdbPredicates("test") 959 let resultSet = await rdbStore.query(predicates) 960 { 961 expect(false).assertEqual(resultSet.goToPreviousRow()) 962 } 963 resultSet = null; 964 done(); 965 console.log(TAG + "************* testGoToPreviousRow0001 end *************"); 966 } 967 }) 968 969 /** 970 * @tc.name resultSet goToPreviousRow with no result test 971 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0131 972 * @tc.desc resultSet goToPreviousRow with no result test 973 */ 974 it('testGoToPreviousRow0002', 0, async function (done) { 975 console.log(TAG + "************* testGoToPreviousRow0002 start *************"); 976 { 977 let predicates = await new dataRdb.RdbPredicates("test") 978 predicates.equalTo("name", "wangwu"); 979 let resultSet = await rdbStore.query(predicates) 980 { 981 expect(false).assertEqual(resultSet.goToPreviousRow()) 982 } 983 resultSet = null; 984 done(); 985 console.log(TAG + "************* testGoToPreviousRow0002 end *************"); 986 } 987 }) 988 989 /** 990 * @tc.name resultSet goToPreviousRow test 991 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0132 992 * @tc.desc resultSet goToPreviousRow test 993 */ 994 it('testGoToPreviousRow0003', 0, async function (done) { 995 console.log(TAG + "************* testGoToPreviousRow0003 start *************"); 996 { 997 let predicates = await new dataRdb.RdbPredicates("test") 998 let resultSet = await rdbStore.query(predicates) 999 { 1000 expect(true).assertEqual(resultSet.goToFirstRow()) 1001 expect(true).assertEqual(resultSet.goToNextRow()) 1002 expect(true).assertEqual(resultSet.goToPreviousRow()) 1003 } 1004 resultSet = null; 1005 done(); 1006 console.log(TAG + "************* testGoToPreviousRow0003 end *************"); 1007 } 1008 }) 1009 1010 /** 1011 * @tc.name resultSet goToPreviousRow after last row test 1012 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0133 1013 * @tc.desc resultSet goToPreviousRow after last row test 1014 */ 1015 it('testGoToPreviousRow0004', 0, async function (done) { 1016 console.log(TAG + "************* testGoToPreviousRow0004 start *************"); 1017 { 1018 let predicates = await new dataRdb.RdbPredicates("test") 1019 let resultSet = await rdbStore.query(predicates) 1020 { 1021 expect(true).assertEqual(resultSet.goToLastRow()) 1022 expect(true).assertEqual(resultSet.goToPreviousRow()) 1023 } 1024 resultSet = null; 1025 done(); 1026 console.log(TAG + "************* testGoToPreviousRow0004 end *************"); 1027 } 1028 }) 1029 1030 /** 1031 * @tc.name resultSet goTo test 1032 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0140 1033 * @tc.desc resultSet goTo test 1034 */ 1035 it('testGoTo0001', 0, async function (done) { 1036 console.log(TAG + "************* testGoTo0001 start *************"); 1037 { 1038 let predicates = await new dataRdb.RdbPredicates("test") 1039 let resultSet = await rdbStore.query(predicates) 1040 { 1041 expect(true).assertEqual(resultSet.goToFirstRow()) 1042 resultSet.goTo(1) 1043 expect(1).assertEqual(resultSet.rowIndex) 1044 } 1045 resultSet = null; 1046 done(); 1047 console.log(TAG + "************* testGoTo0001 end *************"); 1048 } 1049 }) 1050 1051 /** 1052 * @tc.name resultSet goTo with no result test 1053 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0141 1054 * @tc.desc resultSet goTo with no result test 1055 */ 1056 it('testGoTo0002', 0, async function (done) { 1057 console.log(TAG + "************* testGoTo0002 start *************"); 1058 { 1059 let predicates = await new dataRdb.RdbPredicates("test") 1060 predicates.equalTo("name", "wangwu"); 1061 let resultSet = await rdbStore.query(predicates) 1062 { 1063 resultSet.goTo(1) 1064 expect(-1).assertEqual(resultSet.rowIndex) 1065 } 1066 resultSet = null; 1067 done(); 1068 console.log(TAG + "************* testGoTo0002 end *************"); 1069 } 1070 }) 1071 1072 /** 1073 * @tc.name resultSet goTo test 1074 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0142 1075 * @tc.desc resultSet goTo test 1076 */ 1077 it('testGoTo0003', 0, async function (done) { 1078 console.log(TAG + "************* testGoTo0003 start *************"); 1079 { 1080 let predicates = await new dataRdb.RdbPredicates("test") 1081 let resultSet = await rdbStore.query(predicates) 1082 { 1083 expect(true).assertEqual(resultSet.goToFirstRow()) 1084 expect(true).assertEqual(resultSet.goToNextRow()) 1085 resultSet.goTo(1) 1086 expect(2).assertEqual(resultSet.rowIndex) 1087 } 1088 resultSet = null; 1089 done(); 1090 console.log(TAG + "************* testGoTo0003 end *************"); 1091 } 1092 }) 1093 1094 /** 1095 * @tc.name resultSet goTo after last row test 1096 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0143 1097 * @tc.desc resultSet goTo after last row test 1098 */ 1099 it('testGoTo0004', 0, async function (done) { 1100 console.log(TAG + "************* testGoTo0004 start *************"); 1101 { 1102 let predicates = await new dataRdb.RdbPredicates("test") 1103 let resultSet = await rdbStore.query(predicates) 1104 { 1105 expect(true).assertEqual(resultSet.goToLastRow()) 1106 resultSet.goTo(5) 1107 expect(3).assertEqual(resultSet.rowIndex) 1108 } 1109 resultSet = null; 1110 done(); 1111 console.log(TAG + "************* testGoTo0004 end *************"); 1112 } 1113 }) 1114 1115 /** 1116 * @tc.name resultSet goToRow test 1117 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0150 1118 * @tc.desc resultSet goToRow test 1119 */ 1120 it('testGoToRow0001', 0, async function (done) { 1121 console.log(TAG + "************* testGoToRow0001 start *************"); 1122 { 1123 let predicates = await new dataRdb.RdbPredicates("test") 1124 let resultSet = await rdbStore.query(predicates) 1125 { 1126 expect(true).assertEqual(resultSet.goToFirstRow()) 1127 resultSet.goToRow(1) 1128 expect(1).assertEqual(resultSet.rowIndex) 1129 } 1130 resultSet = null; 1131 done(); 1132 console.log(TAG + "************* testGoToRow0001 end *************"); 1133 } 1134 }) 1135 1136 /** 1137 * @tc.name resultSet goToRow with no result test 1138 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0151 1139 * @tc.desc resultSet goToRow with no result test 1140 */ 1141 it('testGoToRow0002', 0, async function (done) { 1142 console.log(TAG + "************* testGoToRow0002 start *************"); 1143 { 1144 let predicates = await new dataRdb.RdbPredicates("test") 1145 predicates.equalTo("name", "wangwu"); 1146 let resultSet = await rdbStore.query(predicates) 1147 { 1148 resultSet.goToRow(1) 1149 expect(-1).assertEqual(resultSet.rowIndex) 1150 } 1151 resultSet = null; 1152 done(); 1153 console.log(TAG + "************* testGoToRow0002 end *************"); 1154 } 1155 }) 1156 1157 /** 1158 * @tc.name resultSet goToRow test 1159 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0152 1160 * @tc.desc resultSet goToRow test 1161 */ 1162 it('testGoToRow0003', 0, async function (done) { 1163 console.log(TAG + "************* testGoToRow0003 start *************"); 1164 { 1165 let predicates = await new dataRdb.RdbPredicates("test") 1166 let resultSet = await rdbStore.query(predicates) 1167 { 1168 expect(true).assertEqual(resultSet.goToFirstRow()) 1169 expect(true).assertEqual(resultSet.goToNextRow()) 1170 expect(true).assertEqual(resultSet.goToNextRow()) 1171 resultSet.goToRow(1) 1172 expect(1).assertEqual(resultSet.rowIndex) 1173 } 1174 resultSet = null; 1175 done(); 1176 console.log(TAG + "************* testGoToRow0003 end *************"); 1177 } 1178 }) 1179 1180 /** 1181 * @tc.name resultSet goToRow after last row test 1182 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0153 1183 * @tc.desc resultSet goToRow after last row test 1184 */ 1185 it('testGoToRow0004', 0, async function (done) { 1186 console.log(TAG + "************* testGoToRow0004 start *************"); 1187 { 1188 let predicates = await new dataRdb.RdbPredicates("test") 1189 let resultSet = await rdbStore.query(predicates) 1190 { 1191 expect(true).assertEqual(resultSet.goToLastRow()) 1192 resultSet.goToRow(5) 1193 expect(3).assertEqual(resultSet.rowIndex) 1194 } 1195 resultSet = null; 1196 done(); 1197 console.log(TAG + "************* testGoToRow0004 end *************"); 1198 } 1199 }) 1200 1201 /** 1202 * @tc.name resultSet isAtFirstRow test 1203 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0160 1204 * @tc.desc resultSet isAtFirstRow test 1205 */ 1206 it('testIsAtFirstRow0001', 0, async function (done) { 1207 console.log(TAG + "************* testIsAtFirstRow0001 start *************"); 1208 { 1209 let predicates = await new dataRdb.RdbPredicates("test") 1210 let resultSet = await rdbStore.query(predicates) 1211 { 1212 expect(true).assertEqual(resultSet.goToFirstRow()) 1213 expect(true).assertEqual(resultSet.isAtFirstRow) 1214 } 1215 resultSet = null; 1216 done(); 1217 console.log(TAG + "************* testIsAtFirstRow0001 end *************"); 1218 } 1219 }) 1220 1221 /** 1222 * @tc.name resultSet isAtFirstRow with no result test 1223 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0161 1224 * @tc.desc resultSet isAtFirstRow with no result test 1225 */ 1226 it('testIsAtFirstRow0002', 0, async function (done) { 1227 console.log(TAG + "************* testIsAtFirstRow0002 start *************"); 1228 { 1229 let predicates = await new dataRdb.RdbPredicates("test") 1230 predicates.equalTo("name", "wangwu"); 1231 let resultSet = await rdbStore.query(predicates) 1232 { 1233 expect(false).assertEqual(resultSet.isAtFirstRow) 1234 } 1235 resultSet = null; 1236 done(); 1237 console.log(TAG + "************* testIsAtFirstRow0002 end *************"); 1238 } 1239 }) 1240 1241 /** 1242 * @tc.name resultSet isAtFirstRow test 1243 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0162 1244 * @tc.desc resultSet isAtFirstRow test 1245 */ 1246 it('testIsAtFirstRow0003', 0, async function (done) { 1247 console.log(TAG + "************* testIsAtFirstRow0003 start *************"); 1248 { 1249 let predicates = await new dataRdb.RdbPredicates("test") 1250 let resultSet = await rdbStore.query(predicates) 1251 { 1252 expect(true).assertEqual(resultSet.goToFirstRow()) 1253 expect(true).assertEqual(resultSet.goToNextRow()) 1254 expect(false).assertEqual(resultSet.isAtFirstRow) 1255 } 1256 resultSet = null; 1257 done(); 1258 console.log(TAG + "************* testIsAtFirstRow0003 end *************"); 1259 } 1260 }) 1261 1262 /** 1263 * @tc.name resultSet isAtFirstRow after last row test 1264 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0163 1265 * @tc.desc resultSet isAtFirstRow after last row test 1266 */ 1267 it('testIsAtFirstRow0004', 0, async function (done) { 1268 console.log(TAG + "************* testIsAtFirstRow0004 start *************"); 1269 { 1270 let predicates = await new dataRdb.RdbPredicates("test") 1271 let resultSet = await rdbStore.query(predicates) 1272 { 1273 expect(true).assertEqual(resultSet.goToLastRow()) 1274 expect(false).assertEqual(resultSet.isAtFirstRow) 1275 } 1276 resultSet = null; 1277 done(); 1278 console.log(TAG + "************* testIsAtFirstRow0004 end *************"); 1279 } 1280 }) 1281 1282 /** 1283 * @tc.name resultSet isAtFirstRow test 1284 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0165 1285 * @tc.descresultSet isAtFirstRow test 1286 */ 1287 it('testIsAtFirstRow0005', 0, async function (done) { 1288 console.log(TAG + "************* testIsAtFirstRow0005 start *************"); 1289 { 1290 let predicates = await new dataRdb.RdbPredicates("test") 1291 let resultSet = await rdbStore.query(predicates) 1292 { 1293 resultSet.goTo(1) 1294 resultSet.goTo(0) 1295 expect(true).assertEqual(resultSet.isAtFirstRow) 1296 } 1297 resultSet = null; 1298 done(); 1299 console.log(TAG + "************* testIsAtFirstRow0005 end *************"); 1300 } 1301 }) 1302 1303 /** 1304 * @tc.name resultSet isAtFirstRow test 1305 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0166 1306 * @tc.descresultSet isAtFirstRow test 1307 */ 1308 it('testIsAtFirstRow0006', 0, async function (done) { 1309 console.log(TAG + "************* testIsAtFirstRow0006 start *************"); 1310 { 1311 let predicates = await new dataRdb.RdbPredicates("test") 1312 let resultSet = await rdbStore.query(predicates) 1313 { 1314 resultSet.goTo(1) 1315 expect(true).assertEqual(resultSet.isAtFirstRow) 1316 expect(true).assertEqual(resultSet.isAtFirstRow) 1317 } 1318 resultSet = null; 1319 done(); 1320 console.log(TAG + "************* testIsAtFirstRow0006 end *************"); 1321 } 1322 }) 1323 1324 /** 1325 * @tc.name resultSet isAtLastRow test 1326 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0170 1327 * @tc.desc resultSet isAtLastRow test 1328 */ 1329 it('testIsAtLastRow0001', 0, async function (done) { 1330 console.log(TAG + "************* testIsAtLastRow0001 start *************"); 1331 { 1332 let predicates = await new dataRdb.RdbPredicates("test") 1333 let resultSet = await rdbStore.query(predicates) 1334 { 1335 expect(true).assertEqual(resultSet.goToFirstRow()) 1336 expect(false).assertEqual(resultSet.isAtLastRow) 1337 } 1338 resultSet = null; 1339 done(); 1340 console.log(TAG + "************* testIsAtLastRow0001 end *************"); 1341 } 1342 }) 1343 1344 /** 1345 * @tc.name resultSet isAtLastRow with no result test 1346 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0171 1347 * @tc.desc resultSet isAtLastRow with no result test 1348 */ 1349 it('testIsAtLastRow0002', 0, async function (done) { 1350 console.log(TAG + "************* testIsAtLastRow0002 start *************"); 1351 { 1352 let predicates = await new dataRdb.RdbPredicates("test") 1353 predicates.equalTo("name", "wangwu"); 1354 let resultSet = await rdbStore.query(predicates) 1355 { 1356 expect(false).assertEqual(resultSet.isAtLastRow) 1357 } 1358 resultSet = null; 1359 done(); 1360 console.log(TAG + "************* testIsAtLastRow0002 end *************"); 1361 } 1362 }) 1363 1364 /** 1365 * @tc.name resultSet isAtLastRow test 1366 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0172 1367 * @tc.desc resultSet isAtLastRow test 1368 */ 1369 it('testIsAtLastRow0003', 0, async function (done) { 1370 console.log(TAG + "************* testIsAtLastRow0003 start *************"); 1371 { 1372 let predicates = await new dataRdb.RdbPredicates("test") 1373 let resultSet = await rdbStore.query(predicates) 1374 { 1375 expect(true).assertEqual(resultSet.goToFirstRow()) 1376 expect(true).assertEqual(resultSet.goToNextRow()) 1377 expect(false).assertEqual(resultSet.isAtLastRow) 1378 } 1379 resultSet = null; 1380 done(); 1381 console.log(TAG + "************* testIsAtLastRow0003 end *************"); 1382 } 1383 }) 1384 1385 /** 1386 * @tc.name resultSet isAtLastRow after last row test 1387 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0173 1388 * @tc.desc resultSet isAtLastRow after last row test 1389 */ 1390 it('testIsAtLastRow0004', 0, async function (done) { 1391 console.log(TAG + "************* testIsAtLastRow0004 start *************"); 1392 { 1393 let predicates = await new dataRdb.RdbPredicates("test") 1394 let resultSet = await rdbStore.query(predicates) 1395 { 1396 expect(true).assertEqual(resultSet.goToLastRow()) 1397 expect(true).assertEqual(resultSet.isAtLastRow) 1398 } 1399 resultSet = null; 1400 done(); 1401 console.log(TAG + "************* testIsAtLastRow0004 end *************"); 1402 } 1403 }) 1404 1405 /** 1406 * @tc.name resultSet isAtLastRow test 1407 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0174 1408 * @tc.desc resultSet isAtLastRow test 1409 */ 1410 it('testIsAtLastRow0005', 0, async function (done) { 1411 console.log(TAG + "************* testIsAtLastRow0005 start *************"); 1412 { 1413 let predicates = await new dataRdb.RdbPredicates("test") 1414 let resultSet = await rdbStore.query(predicates) 1415 { 1416 resultSet.goToRow(2) 1417 expect(true).assertEqual(resultSet.isAtLastRow) 1418 expect(true).assertEqual(resultSet.isAtLastRow) 1419 } 1420 resultSet = null; 1421 done(); 1422 console.log(TAG + "************* testIsAtLastRow0005 end *************"); 1423 } 1424 }) 1425 1426 /** 1427 * @tc.name resultSet getDouble test 1428 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0180 1429 * @tc.desc resultSet getDouble test 1430 */ 1431 it('testGetDouble0001', 0, async function (done) { 1432 console.log(TAG + "************* testGetDouble0001 start *************"); 1433 { 1434 let predicates = await new dataRdb.RdbPredicates("test") 1435 let resultSet = await rdbStore.query(predicates) 1436 { 1437 resultSet.goTo(1) 1438 const data3 = resultSet.getDouble(resultSet.getColumnIndex("data3")) 1439 expect(1.0).assertEqual(data3) 1440 } 1441 resultSet = null; 1442 done(); 1443 console.log(TAG + "************* testGetDouble0001 end *************"); 1444 } 1445 }) 1446 1447 /** 1448 * @tc.name resultSet getDouble test 1449 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0181 1450 * @tc.desc resultSet getDouble test 1451 */ 1452 it('testGetDouble0002', 0, async function (done) { 1453 console.log(TAG + "************* testGetDouble0002 start *************"); 1454 { 1455 let predicates = await new dataRdb.RdbPredicates("test") 1456 let resultSet = await rdbStore.query(predicates) 1457 { 1458 resultSet.goTo(2) 1459 const data3 = resultSet.getDouble(resultSet.getColumnIndex("data3")) 1460 expect(2.5).assertEqual(data3) 1461 } 1462 resultSet = null; 1463 done(); 1464 console.log(TAG + "************* testGetDouble0002 end *************"); 1465 } 1466 }) 1467 1468 /** 1469 * @tc.name resultSet getDouble test 1470 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0182 1471 * @tc.desc resultSet getDouble test 1472 */ 1473 it('testGetDouble0003', 0, async function (done) { 1474 console.log(TAG + "************* testGetDouble0003 start *************"); 1475 { 1476 let predicates = await new dataRdb.RdbPredicates("test") 1477 let resultSet = await rdbStore.query(predicates) 1478 { 1479 resultSet.goTo(3) 1480 const data3 = resultSet.getDouble(resultSet.getColumnIndex("data3")) 1481 expect(1.8).assertEqual(data3) 1482 } 1483 resultSet = null; 1484 done(); 1485 console.log(TAG + "************* testGetDouble0003 end *************"); 1486 } 1487 }) 1488 1489 /** 1490 * @tc.name resultSet getDouble test 1491 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0183 1492 * @tc.desc resultSet getDouble test 1493 */ 1494 it('testGetDouble0004', 0, async function (done) { 1495 console.log(TAG + "************* testGetDouble0004 start *************"); 1496 { 1497 let predicates = await new dataRdb.RdbPredicates("test") 1498 let resultSet = await rdbStore.query(predicates) 1499 { 1500 resultSet.goTo(1) 1501 const data2 = resultSet.getDouble(resultSet.getColumnIndex("data2")) 1502 expect(10).assertEqual(data2) 1503 } 1504 resultSet = null; 1505 done(); 1506 console.log(TAG + "************* testGetDouble0004 end *************"); 1507 } 1508 }) 1509 1510 /** 1511 * @tc.name resultSet isColumnNull test 1512 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0190 1513 * @tc.desc resultSet isColumnNull test 1514 */ 1515 it('testIsColumnNull0001', 0, async function (done) { 1516 console.log(TAG + "************* testIsColumnNull0001 start *************"); 1517 { 1518 let predicates = await new dataRdb.RdbPredicates("test") 1519 let resultSet = await rdbStore.query(predicates) 1520 { 1521 expect(true).assertEqual(resultSet.goToFirstRow()) 1522 expect(true).assertEqual(resultSet.goToNextRow()) 1523 expect(true).assertEqual(resultSet.goToNextRow()) 1524 const isColumnNull1 = resultSet.isColumnNull(resultSet.getColumnIndex("data1")) 1525 expect(false).assertEqual(isColumnNull1) 1526 } 1527 resultSet = null; 1528 done(); 1529 console.log(TAG + "************* testIsColumnNull0001 end *************"); 1530 } 1531 }) 1532 1533 /** 1534 * @tc.name resultSet isColumnNull test 1535 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0191 1536 * @tc.desc resultSet isColumnNull test 1537 */ 1538 it('testIsColumnNull0002', 0, async function (done) { 1539 console.log(TAG + "************* testIsColumnNull0002 start *************"); 1540 { 1541 let predicates = await new dataRdb.RdbPredicates("test") 1542 let resultSet = await rdbStore.query(predicates) 1543 { 1544 expect(true).assertEqual(resultSet.goToFirstRow()) 1545 expect(true).assertEqual(resultSet.goToNextRow()) 1546 expect(true).assertEqual(resultSet.goToNextRow()) 1547 const isColumnNull4 = resultSet.isColumnNull(resultSet.getColumnIndex("data4")) 1548 expect(true).assertEqual(isColumnNull4) 1549 } 1550 resultSet = null; 1551 done(); 1552 console.log(TAG + "************* testIsColumnNull0002 end *************"); 1553 } 1554 }) 1555 1556 /** 1557 * @tc.name resultSet isColumnNull test 1558 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0192 1559 * @tc.desc resultSet isColumnNull test 1560 */ 1561 it('testIsColumnNull0003', 0, async function (done) { 1562 console.log(TAG + "************* testIsColumnNull0003 start *************"); 1563 { 1564 let predicates = await new dataRdb.RdbPredicates("test") 1565 let resultSet = await rdbStore.query(predicates) 1566 try { 1567 resultSet.goToRow(5) 1568 expect(false).assertEqual(resultSet.isColumnNull(1)); 1569 } catch (err) { 1570 console.info("catch err: goToRow failed, err: code=" + err.code + " message=" + err.message) 1571 } 1572 resultSet = null; 1573 done(); 1574 console.log(TAG + "************* testIsColumnNull0003 end *************"); 1575 } 1576 }) 1577 /** 1578 * @tc.name resultSet isColumnNull test 1579 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0193 1580 * @tc.desc resultSet isColumnNull test 1581 */ 1582 it('testIsColumnNull0004', 0, async function (done) { 1583 console.log(TAG + "************* testIsColumnNull0004 start *************"); 1584 { 1585 let predicates = await new dataRdb.RdbPredicates("test") 1586 let resultSet = await rdbStore.query(predicates) 1587 { 1588 resultSet.goToRow(2) 1589 expect(false).assertEqual(resultSet.isColumnNull(1)) 1590 expect(true).assertEqual(resultSet.isColumnNull(4)) 1591 } 1592 resultSet = null; 1593 done(); 1594 console.log(TAG + "************* testIsColumnNull0004 end *************"); 1595 } 1596 }) 1597 1598 /** 1599 * @tc.name resultSet getColumnIndex test 1600 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0200 1601 * @tc.desc resultSet getColumnIndex test 1602 */ 1603 it('testGetColumnIndex0001', 0, async function (done) { 1604 console.log(TAG + "************* testGetColumnIndex0001 start *************"); 1605 { 1606 let predicates = await new dataRdb.RdbPredicates("test") 1607 let resultSet = await rdbStore.query(predicates) 1608 expect(true).assertEqual(resultSet.goToFirstRow()) 1609 expect(1).assertEqual(resultSet.getColumnIndex("data1")) 1610 1611 resultSet = null; 1612 done(); 1613 console.log(TAG + "************* testGetColumnIndex0001 end *************"); 1614 } 1615 }) 1616 1617 /** 1618 * @tc.name resultSet getColumnIndex test 1619 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0201 1620 * @tc.desc resultSet getColumnIndex test 1621 */ 1622 it('testGetColumnIndex0002', 0, async function (done) { 1623 console.log(TAG + "************* testGetColumnIndex0002 start *************"); 1624 { 1625 let predicates = await new dataRdb.RdbPredicates("test") 1626 predicates.equalTo("name", "wangwu"); 1627 let resultSet = await rdbStore.query(predicates) 1628 expect(-1).assertEqual(resultSet.getColumnIndex("data1")) 1629 1630 resultSet = null; 1631 done(); 1632 console.log(TAG + "************* testGetColumnIndex0002 end *************"); 1633 } 1634 }) 1635 1636 /** 1637 * @tc.name resultSet getColumnIndex test 1638 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0202 1639 * @tc.desc resultSet getColumnIndex test 1640 */ 1641 it('testGetColumnIndex0003', 0, async function (done) { 1642 console.log(TAG + "************* testGetColumnIndex0003 start *************"); 1643 { 1644 let predicates = await new dataRdb.RdbPredicates("test") 1645 let resultSet = await rdbStore.query(predicates) 1646 expect(-1).assertEqual(resultSet.getColumnIndex("dataX")) 1647 1648 resultSet = null; 1649 done(); 1650 console.log(TAG + "************* testGetColumnIndex0003 end *************"); 1651 } 1652 }) 1653 1654 /** 1655 * @tc.name resultSet getColumnIndex test 1656 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0203 1657 * @tc.desc resultSet getColumnIndex test 1658 */ 1659 it('testGetColumnIndex0004', 0, async function (done) { 1660 console.log(TAG + "************* testGetColumnIndex0004 start *************"); 1661 { 1662 let predicates = await new dataRdb.RdbPredicates("test") 1663 let resultSet = await rdbStore.query(predicates) 1664 try{ 1665 expect(-1).assertEqual(resultSet.getColumnIndex("")) 1666 } catch(err) { 1667 expect("401").assertEqual(err.code) 1668 } 1669 resultSet = null 1670 done() 1671 console.log(TAG + "************* testGetColumnIndex0004 end *************"); 1672 } 1673 }) 1674 1675 /** 1676 * @tc.name resultSet getColumnName test 1677 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0210 1678 * @tc.desc resultSet getColumnName test 1679 */ 1680 it('testGetColumnName0001', 0, async function (done) { 1681 console.log(TAG + "************* testGetColumnIndex0001 start *************"); 1682 { 1683 let predicates = await new dataRdb.RdbPredicates("test") 1684 let resultSet = await rdbStore.query(predicates) 1685 1686 expect("data1").assertEqual(resultSet.getColumnName(1)) 1687 expect("data4").assertEqual(resultSet.getColumnName(4)) 1688 1689 resultSet = null; 1690 done(); 1691 console.log(TAG + "************* testGetColumnName0001 end *************"); 1692 } 1693 }) 1694 1695 /** 1696 * @tc.name resultSet getColumnName test 1697 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0211 1698 * @tc.desc resultSet getColumnName test 1699 */ 1700 it('testGetColumnName0002', 0, async function (done) { 1701 console.log(TAG + "************* testGetColumnName0002 start *************"); 1702 { 1703 let predicates = await new dataRdb.RdbPredicates("test") 1704 predicates.equalTo("name", "wangwu"); 1705 let resultSet = await rdbStore.query(predicates) 1706 1707 expect("").assertEqual(resultSet.getColumnName(1)) 1708 expect("").assertEqual(resultSet.getColumnName(4)) 1709 1710 resultSet = null; 1711 done(); 1712 console.log(TAG + "************* testGetColumnName0002 end *************"); 1713 } 1714 }) 1715 1716 /** 1717 * @tc.name resultSet getColumnName test 1718 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0212 1719 * @tc.desc resultSet getColumnName test 1720 */ 1721 it('testGetColumnName0003', 0, async function (done) { 1722 console.log(TAG + "************* testGetColumnName0003 start *************"); 1723 { 1724 let predicates = await new dataRdb.RdbPredicates("test") 1725 let resultSet = await rdbStore.query(predicates) 1726 1727 expect("").assertEqual(resultSet.getColumnName(10)) 1728 1729 resultSet = null; 1730 done(); 1731 console.log(TAG + "************* testGetColumnName0003 end *************"); 1732 } 1733 }) 1734 1735 /** 1736 * @tc.name resultSet getColumnName test 1737 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0213 1738 * @tc.desc resultSet getColumnName test 1739 */ 1740 it('testGetColumnName0004', 0, async function (done) { 1741 console.log(TAG + "************* testGetColumnName0004 start *************"); 1742 { 1743 let predicates = await new dataRdb.RdbPredicates("test") 1744 predicates.equalTo("name", "wangwu"); 1745 let resultSet = await rdbStore.query(predicates) 1746 1747 expect("").assertEqual(resultSet.getColumnName(10)) 1748 1749 resultSet = null; 1750 done(); 1751 console.log(TAG + "************* testGetColumnName0004 end *************"); 1752 } 1753 }) 1754 1755 /** 1756 * @tc.name resultSet close test 1757 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0220 1758 * @tc.desc resultSet close test 1759 */ 1760 it('testClose0001', 0, async function (done) { 1761 console.log(TAG + "************* testClose0001 start *************"); 1762 { 1763 let predicates = await new dataRdb.RdbPredicates("test") 1764 let resultSet = await rdbStore.query(predicates) 1765 resultSet.goToRow(1) 1766 resultSet.close() 1767 expect(true).assertEqual(resultSet.isClosed) 1768 1769 resultSet = null; 1770 done(); 1771 console.log(TAG + "************* testClose0001 end *************"); 1772 } 1773 }) 1774 1775 /** 1776 * @tc.name resultSet close test 1777 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0221 1778 * @tc.desc resultSet close test 1779 */ 1780 it('testClose0002', 0, async function (done) { 1781 console.log(TAG + "************* testClose0002 start *************"); 1782 { 1783 let predicates = await new dataRdb.RdbPredicates("test") 1784 predicates.equalTo("name", "wangwu"); 1785 let resultSet = await rdbStore.query(predicates) 1786 resultSet.close() 1787 expect(true).assertEqual(resultSet.isClosed) 1788 1789 resultSet = null; 1790 done(); 1791 console.log(TAG + "************* testClose0002 end *************"); 1792 } 1793 }) 1794 1795 /** 1796 * @tc.name big resultSet data test 1797 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0222 1798 * @tc.desc big resultSet data test 1799 */ 1800 it('testBigData0001', 0, async function (done) { 1801 console.log(TAG + "************* testBigData0001 start *************"); 1802 { 1803 await createBigData(500); 1804 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 1805 let count = resultSet.rowCount; 1806 expect(500).assertEqual(count); 1807 1808 resultSet.goToFirstRow(); 1809 let i = 0; 1810 while (resultSet.isEnded == false) { 1811 expect("test" + i++).assertEqual(resultSet.getString(1)) 1812 resultSet.goToNextRow(); 1813 } 1814 1815 resultSet.close() 1816 expect(true).assertEqual(resultSet.isClosed) 1817 resultSet = null; 1818 done(); 1819 console.log(TAG + "************* testBigData0001 end *************"); 1820 } 1821 }) 1822 1823 /** 1824 * @tc.name big resultSet data test 1825 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0223 1826 * @tc.desc big resultSet data test 1827 */ 1828 it('testBigData0002', 0, async function (done) { 1829 console.log(TAG + "************* testBigData0002 start *************"); 1830 { 1831 await createBigData(500); 1832 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 1833 let count = resultSet.rowCount; 1834 expect(500).assertEqual(count); 1835 1836 resultSet.goToLastRow(); 1837 let i = resultSet.rowCount; 1838 while (i >= 1) { 1839 expect("test" + --i).assertEqual(resultSet.getString(1)) 1840 resultSet.goToPreviousRow(); 1841 } 1842 1843 resultSet.close() 1844 expect(true).assertEqual(resultSet.isClosed) 1845 resultSet = null; 1846 done(); 1847 console.log(TAG + "************* testBigData0002 end *************"); 1848 } 1849 }) 1850 1851 /** 1852 * @tc.name big resultSet data test 1853 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0224 1854 * @tc.desc big resultSet data test 1855 */ 1856 it('testBigData0003', 0, async function (done) { 1857 console.log(TAG + "************* testBigData0003 start *************"); 1858 { 1859 await createBigData(500); 1860 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 1861 let count = resultSet.rowCount; 1862 expect(500).assertEqual(count); 1863 1864 let rows = [62, 80, 59, 121, 45, 99, 42, 104, 41, 105, 499, 248]; 1865 for (const i of rows) { 1866 resultSet.goToRow(i); 1867 expect("test" + i).assertEqual(resultSet.getString(1)) 1868 } 1869 1870 resultSet.close() 1871 expect(true).assertEqual(resultSet.isClosed) 1872 resultSet = null; 1873 done(); 1874 console.log(TAG + "************* testBigData0003 end *************"); 1875 } 1876 }) 1877 1878 /** 1879 * @tc.name big resultSet data test 1880 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0225 1881 * @tc.desc big resultSet data test 1882 */ 1883 it('testBigData0004', 0, async function (done) { 1884 console.log(TAG + "************* testBigData0004 start *************"); 1885 { 1886 await createBigData(0); 1887 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 1888 let count = resultSet.rowCount; 1889 expect(0).assertEqual(count); 1890 1891 resultSet.goToFirstRow(); 1892 expect(false).assertEqual(resultSet.isStarted); 1893 1894 let rows = [1, 2, 0, -1, -2]; 1895 for (const i of rows) { 1896 resultSet.goToRow(i); 1897 expect(false).assertEqual(resultSet.isStarted); 1898 } 1899 1900 resultSet.close() 1901 expect(true).assertEqual(resultSet.isClosed) 1902 resultSet = null; 1903 done(); 1904 console.log(TAG + "************* testBigData0004 end *************"); 1905 } 1906 }) 1907 1908 /** 1909 * @tc.name big resultSet data test 1910 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0226 1911 * @tc.desc big resultSet data test 1912 */ 1913 it('testBigData0005', 0, async function (done) { 1914 console.log(TAG + "************* testBigData0005 start *************"); 1915 { 1916 await createBigData(1); 1917 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 1918 let count = resultSet.rowCount; 1919 expect(1).assertEqual(count); 1920 1921 resultSet.goToFirstRow(); 1922 expect(true).assertEqual(resultSet.isStarted); 1923 expect("test0").assertEqual(resultSet.getString(1)) 1924 1925 let rows = [1, 2, -1, -2]; 1926 try{ 1927 for (const i of rows) { 1928 resultSet.goToRow(i) 1929 expect(true).assertEqual(resultSet.isStarted) 1930 expect("").assertEqual(resultSet.getString(1)) 1931 } 1932 } catch(err) { 1933 expect("14800012").assertEqual(err.code) 1934 } 1935 resultSet.close() 1936 expect(true).assertEqual(resultSet.isClosed) 1937 resultSet = null; 1938 done(); 1939 console.log(TAG + "************* testBigData0005 end *************"); 1940 } 1941 }) 1942 1943 /** 1944 * @tc.name big resultSet data test 1945 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0227 1946 * @tc.desc big resultSet data test 1947 */ 1948 it('testBigData0006', 0, async function (done) { 1949 console.log(TAG + "************* testBigData0006 start *************"); 1950 { 1951 await createBigData(2); 1952 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 1953 let count = resultSet.rowCount; 1954 expect(2).assertEqual(count); 1955 1956 resultSet.goToFirstRow(); 1957 expect(true).assertEqual(resultSet.isStarted); 1958 1959 let rows = [0, 1]; 1960 for (const i of rows) { 1961 resultSet.goToRow(i); 1962 expect(true).assertEqual(resultSet.isStarted); 1963 expect("test" + i).assertEqual(resultSet.getString(1)) 1964 } 1965 1966 rows = [2, 3, 4, -1, -2]; 1967 try{ 1968 for (const i of rows) { 1969 resultSet.goToRow(i); 1970 expect(true).assertEqual(resultSet.isStarted); 1971 expect("").assertEqual(resultSet.getString(1)) 1972 } 1973 } catch(err) { 1974 expect("14800012").assertEqual(err.code) 1975 } 1976 1977 resultSet.close() 1978 expect(true).assertEqual(resultSet.isClosed) 1979 resultSet = null; 1980 done(); 1981 console.log(TAG + "************* testBigData0006 end *************"); 1982 } 1983 }) 1984 1985 /** 1986 * @tc.name big resultSet data test 1987 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0228 1988 * @tc.desc big resultSet data test 1989 */ 1990 it('testBigData0007', 0, async function (done) { 1991 console.log(TAG + "************* testBigData0007 start *************"); 1992 { 1993 await createBigData(500); 1994 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 1995 let count = resultSet.rowCount; 1996 expect(500).assertEqual(count); 1997 1998 let rows = [62, 80, 59, 121, 45, -1, 99, 42, 104, 41, 105, 499, 248]; 1999 for (const i of rows) { 2000 resultSet.goToRow(i); 2001 if (i > 0 ) { 2002 expect("test" + i).assertEqual(resultSet.getString(1)) 2003 } else { 2004 expect("test45").assertEqual(resultSet.getString(1)) 2005 } 2006 } 2007 2008 resultSet.close() 2009 expect(true).assertEqual(resultSet.isClosed) 2010 resultSet = null; 2011 done(); 2012 console.log(TAG + "************* testBigData0007 end *************"); 2013 } 2014 }) 2015 2016 /** 2017 * @tc.name big resultSet data test 2018 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0229 2019 * @tc.desc big resultSet data test 2020 */ 2021 it('testBigData0008', 0, async function (done) { 2022 console.log(TAG + "************* testBigData0008 start *************"); 2023 { 2024 await createBigData(200); 2025 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 2026 let count = resultSet.rowCount; 2027 expect(200).assertEqual(count); 2028 2029 let i = 0; 2030 while (resultSet.goToNextRow() == 0) { 2031 expect("test" + i++).assertEqual(resultSet.getString(1)) 2032 } 2033 2034 resultSet.close() 2035 expect(true).assertEqual(resultSet.isClosed) 2036 resultSet = null; 2037 done(); 2038 console.log(TAG + "************* testBigData0008 end *************"); 2039 } 2040 }) 2041 2042 /** 2043 * @tc.name big resultSet data test 2044 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0230 2045 * @tc.desc big resultSet data test 2046 */ 2047 it('testBigData0009', 0, async function (done) { 2048 console.log(TAG + "************* testBigData0009 start *************"); 2049 { 2050 await createBigData(200); 2051 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 2052 let count = resultSet.rowCount; 2053 expect(200).assertEqual(count); 2054 2055 let i = 0; 2056 while (i < 200) { 2057 resultSet.goToRow(i); 2058 expect("test" + i).assertEqual(resultSet.getString(1)) 2059 i++; 2060 } 2061 2062 resultSet.close() 2063 expect(true).assertEqual(resultSet.isClosed) 2064 resultSet = null; 2065 done(); 2066 console.log(TAG + "************* testBigData0009 end *************"); 2067 } 2068 }) 2069 2070 /** 2071 * @tc.name big resultSet data test 2072 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0231 2073 * @tc.desc big resultSet data test 2074 */ 2075 it('testBigData0010', 0, async function (done) { 2076 console.log(TAG + "************* testBigData0010 start *************"); 2077 { 2078 await createBigData(200); 2079 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 2080 let count = resultSet.rowCount; 2081 expect(200).assertEqual(count); 2082 2083 resultSet.goToFirstRow(); 2084 let i = 0; 2085 while (resultSet.isEnded == false) { 2086 expect("test" + i++).assertEqual(resultSet.getString(1)) 2087 resultSet.goToNextRow(); 2088 } 2089 2090 i = 0; 2091 while (i < 200) { 2092 resultSet.goToRow(i); 2093 expect("test" + i).assertEqual(resultSet.getString(1)) 2094 i++; 2095 } 2096 2097 resultSet.close() 2098 expect(true).assertEqual(resultSet.isClosed) 2099 resultSet = null; 2100 done(); 2101 console.log(TAG + "************* testBigData0010 end *************"); 2102 } 2103 }) 2104 2105 /** 2106 * @tc.name big resultSet data test 2107 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0232 2108 * @tc.desc big resultSet data test 2109 */ 2110 it('testBigData0011', 0, async function (done) { 2111 console.log(TAG + "************* testBigData0011 start *************"); 2112 { 2113 await createBigData(200); 2114 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 2115 let count = resultSet.rowCount; 2116 expect(200).assertEqual(count); 2117 2118 let i = 0; 2119 while (i < 200) { 2120 resultSet.goToRow(i); 2121 expect("test" + i).assertEqual(resultSet.getString(1)) 2122 i++; 2123 } 2124 2125 resultSet.goToFirstRow(); 2126 i = 0; 2127 while (resultSet.isEnded == false) { 2128 expect("test" + i++).assertEqual(resultSet.getString(1)) 2129 resultSet.goToNextRow(); 2130 } 2131 2132 resultSet.close() 2133 expect(true).assertEqual(resultSet.isClosed) 2134 resultSet = null; 2135 done(); 2136 console.log(TAG + "************* testBigData0011 end *************"); 2137 } 2138 }) 2139 2140 /** 2141 * @tc.name big resultSet data test 2142 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0232 2143 * @tc.desc big resultSet data test 2144 */ 2145 it('testBigData0012', 0, async function (done) { 2146 console.log(TAG + "************* testBigData0012 start *************"); 2147 { 2148 await createBigData(1); 2149 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 2150 let count = resultSet.rowCount; 2151 expect(1).assertEqual(count); 2152 2153 let i = 0; 2154 resultSet.goToNextRow(); 2155 expect("test0").assertEqual(resultSet.getString(1)) 2156 2157 resultSet.close() 2158 expect(true).assertEqual(resultSet.isClosed) 2159 resultSet = null; 2160 done(); 2161 console.log(TAG + "************* testBigData0012 end *************"); 2162 } 2163 }) 2164 2165 /** 2166 * @tc.name big resultSet data test 2167 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0232 2168 * @tc.desc big resultSet data test 2169 */ 2170 it('testBigData0013', 0, async function (done) { 2171 console.log(TAG + "************* testBigData0013 start *************"); 2172 { 2173 await createBigData(200); 2174 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 2175 let count = resultSet.rowCount; 2176 expect(200).assertEqual(count); 2177 2178 resultSet.goToFirstRow(); 2179 let i = 0; 2180 while (resultSet.isEnded == false) { 2181 expect("test" + i++).assertEqual(resultSet.getString(1)) 2182 resultSet.goToNextRow(); 2183 } 2184 2185 resultSet.goToRow(1); 2186 expect("test1").assertEqual(resultSet.getString(1)) 2187 2188 resultSet.goToRow(5); 2189 expect("test5").assertEqual(resultSet.getString(1)) 2190 2191 resultSet.close() 2192 expect(true).assertEqual(resultSet.isClosed) 2193 resultSet = null; 2194 done(); 2195 console.log(TAG + "************* testBigData0013 end *************"); 2196 } 2197 }) 2198 2199 /** 2200 * @tc.name big resultSet data test 2201 * @tc.number SUB_DDM_AppDataFWK_JSRDB_ResultSet_0233 2202 * @tc.desc big resultSet data test 2203 */ 2204 it('testBigData0014', 0, async function (done) { 2205 console.log(TAG + "************* testBigData0014 start *************"); 2206 { 2207 await createBigData(5); 2208 let resultSet = await rdbStore.querySql("SELECT * FROM test"); 2209 let count = resultSet.rowCount; 2210 expect(5).assertEqual(count); 2211 2212 resultSet.goToFirstRow(); 2213 let i = 0; 2214 while (resultSet.isEnded == false) { 2215 expect("test" + i++).assertEqual(resultSet.getString(1)) 2216 resultSet.goToNextRow(); 2217 } 2218 2219 i = 0; 2220 while (i < 5) { 2221 resultSet.goToRow(i); 2222 expect("test" + i).assertEqual(resultSet.getString(1)) 2223 i++; 2224 } 2225 2226 resultSet.close() 2227 expect(true).assertEqual(resultSet.isClosed) 2228 resultSet = null; 2229 done(); 2230 console.log(TAG + "************* testBigData0014 end *************"); 2231 } 2232 }) 2233 console.log(TAG + "*************Unit Test End*************"); 2234})