Home
last modified time | relevance | path

Searched refs:salary (Results 1 - 22 of 22) sorted by relevance

/foundation/distributeddatamgr/relational_store/test/js/relationalstore/unittest/src/
H A DRdbstorePredicatesJoinBJsunit.test.js28 + "mgr INTEGER, joinDate TEXT, salary REAL, bonus REAL, deptId INTEGER,"
108 {id:1001, eName:"SunWuKong", jobId:4, mgr:1004, joinDate:"2000-12-17", salary:8000.00, bonus:null, deptId:20},
109 {id:1002, eName:"LuJunYi", jobId:3, mgr:1006, joinDate:"2001-02-20", salary:16000.00, bonus:3000.00, deptId:30},
110 {id:1003, eName:"LinChong", jobId:3, mgr:1006, joinDate:"2001-02-22", salary:12500.00, bonus:5000.00, deptId:30},
111 {id:1004, eName:"TangCeng", jobId:2, mgr:1009, joinDate:"2001-04-02", salary:29750.00, bonus:null, deptId:20},
112 {id:1005, eName:"LiKui", jobId:4, mgr:1006, joinDate:"2001-09-28", salary:12500.00, bonus:14000.00, deptId:30},
113 {id:1006, eName:"SongJiang", jobId:2, mgr:1009, joinDate:"2001-05-01", salary:28500.00, bonus:null, deptId:30},
114 {id:1007, eName:"LiuBei", jobId:2, mgr:1009, joinDate:"2001-09-01", salary:24500.00, bonus:null, deptId:10},
115 {id:1008, eName:"ZhuBaJie", jobId:4, mgr:1004, joinDate:"2007-04-19", salary:30000.00, bonus:null, deptId:20},
116 {id:1009, eName:"LuoGuanZhong", jobId:1, mgr:null, joinDate:"2001-11-17", salary
[all...]
H A DRdbstorePredicatesComplexFiledJsunit.test.js21 "name TEXT, " + "age INTEGER, " + "salary REAL, " + "adddate DATE)";
53 const valueBucket1 = { id: 1, name: "ZhangSan", age: 20, salary: 100.51, adddate: '2022-09-01' }
55 const valueBucket2 = { id: 2, name: "LiSi", age: 21, salary: 120.61, adddate: '2022-09-01' }
57 const valueBucket3 = { id: 3, name: "WangWu", age: 22, salary: 130.71, adddate: '2022-09-02' }
59 const valueBucket4 = { id: 4, name: "SunLiu", age: 23, salary: 160.81, adddate: '2022-09-02' }
61 const valueBucket5 = { id: 5, name: "MaQi", age: 24, salary: 170.91, adddate: '2022-09-02' }
H A DRdbstoreInsertJsunit.test.js22 "name TEXT NOT NULL, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
70 "salary": 100.5,
79 "salary": 100.5,
88 "salary": 100.5,
103 const salary = resultSet.getDouble(resultSet.getColumnIndex("salary"))
105 console.log(TAG + "id=" + id + ", name=" + name + ", age=" + age + ", salary=" + salary + ", blobType=" + blobType);
109 expect(100.5).assertEqual(salary)
136 "salary"
[all...]
H A DRdbstoreInsertSyncJsUnit.test.js22 "name TEXT NOT NULL, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
70 "salary": 100.5,
79 "salary": 100.5,
88 "salary": 100.5,
103 const salary = resultSet.getDouble(resultSet.getColumnIndex("salary"))
105 console.log(TAG + "id=" + id + ", name=" + name + ", age=" + age + ", salary=" + salary + ", blobType=" + blobType);
109 expect(100.5).assertEqual(salary)
136 "salary"
[all...]
H A DRdbstoreUpdateSyncJsunit.test.js23 "name TEXT UNIQUE, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
66 "salary": 100.5,
80 "salary": 200.5,
96 const salary = await resultSet.getDouble(resultSet.getColumnIndex("salary"))
102 await expect(200.5).assertEqual(salary);
136 "salary": 100.5,
183 "salary": 100.5,
221 "salary": 100.5,
261 "salary"
[all...]
H A DRdbstoreUpdateJsunit.test.js23 "name TEXT UNIQUE, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
66 "salary": 100.5,
80 "salary": 200.5,
96 const salary = await resultSet.getDouble(resultSet.getColumnIndex("salary"))
102 await expect(200.5).assertEqual(salary);
136 "salary": 100.5,
183 "salary": 100.5,
221 "salary": 100.5,
261 "salary"
[all...]
H A DRdbstoreCallBackJsunit.test.js23 "name TEXT NOT NULL, age INTEGER, salary REAL, blobType BLOB)";
73 "salary": 100.5,
85 const salary = resultSet.getDouble(resultSet.getColumnIndex("salary"))
90 expect(100.5).assertEqual(salary);
H A DRdbstorePromiseJsunit.test.js23 "name TEXT NOT NULL, age INTEGER, salary REAL, blobType BLOB)";
69 "salary": 100.5,
81 const salary = resultSet.getDouble(resultSet.getColumnIndex("salary"))
86 expect(100.5).assertEqual(salary);
H A DRdbstoreStoreExcuteSqlJsunit.test.js22 "name TEXT NOT NULL, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
66 "salary": 100.5,
76 "salary": 100.5,
86 "salary": 100.5,
120 "salary": 100.5,
130 "salary": 100.5,
140 "salary": 100.5,
175 "salary": 100.5,
185 "salary": 100.5,
195 "salary"
[all...]
H A DRdbStoreTransaction.test.js24 "name TEXT NOT NULL, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
74 "salary": 100.5,
112 "salary": 100.5,
155 "salary": 100.5,
165 "salary": 25,
179 const salary = resultSet.getLong(resultSet.getColumnIndex("salary"))
180 expect(25).assertEqual(salary);
210 "salary": 100.5,
273 "salary"
[all...]
/foundation/distributeddatamgr/relational_store/test/js/rdb/unittest/src/
H A DRdbstorePredicatesJoinBJsunit.test.js27 + "mgr INTEGER, joinDate TEXT, salary REAL, bonus REAL, deptId INTEGER,"
105 {id:1001, eName:"SunWuKong", jobId:4, mgr:1004, joinDate:"2000-12-17", salary:8000.00, bonus:null, deptId:20},
106 {id:1002, eName:"LuJunYi", jobId:3, mgr:1006, joinDate:"2001-02-20", salary:16000.00, bonus:3000.00, deptId:30},
107 {id:1003, eName:"LinChong", jobId:3, mgr:1006, joinDate:"2001-02-22", salary:12500.00, bonus:5000.00, deptId:30},
108 {id:1004, eName:"TangCeng", jobId:2, mgr:1009, joinDate:"2001-04-02", salary:29750.00, bonus:null, deptId:20},
109 {id:1005, eName:"LiKui", jobId:4, mgr:1006, joinDate:"2001-09-28", salary:12500.00, bonus:14000.00, deptId:30},
110 {id:1006, eName:"SongJiang", jobId:2, mgr:1009, joinDate:"2001-05-01", salary:28500.00, bonus:null, deptId:30},
111 {id:1007, eName:"LiuBei", jobId:2, mgr:1009, joinDate:"2001-09-01", salary:24500.00, bonus:null, deptId:10},
112 {id:1008, eName:"ZhuBaJie", jobId:4, mgr:1004, joinDate:"2007-04-19", salary:30000.00, bonus:null, deptId:20},
113 {id:1009, eName:"LuoGuanZhong", jobId:1, mgr:null, joinDate:"2001-11-17", salary
[all...]
H A DRdbstorePredicatesComplexFiledJsunit.test.js20 "name TEXT, " + "age INTEGER, " + "salary REAL, " + "adddate DATE)";
50 const valueBucket1 = { id: 1, name: "ZhangSan", age: 20, salary: 100.51, adddate: '2022-09-01' }
52 const valueBucket2 = { id: 2, name: "LiSi", age: 21, salary: 120.61, adddate: '2022-09-01' }
54 const valueBucket3 = { id: 3, name: "WangWu", age: 22, salary: 130.71, adddate: '2022-09-02' }
56 const valueBucket4 = { id: 4, name: "SunLiu", age: 23, salary: 160.81, adddate: '2022-09-02' }
58 const valueBucket5 = { id: 5, name: "MaQi", age: 24, salary: 170.91, adddate: '2022-09-02' }
H A DRdbstoreInsertJsunit.test.js21 "name TEXT NOT NULL, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
65 "salary": 100.5,
74 "salary": 100.5,
83 "salary": 100.5,
98 const salary = resultSet.getDouble(resultSet.getColumnIndex("salary"))
100 console.log(TAG + "id=" + id + ", name=" + name + ", age=" + age + ", salary=" + salary + ", blobType=" + blobType);
104 expect(100.5).assertEqual(salary)
130 "salary"
[all...]
H A DRdbstoreStoreExcuteSqlJsunit.test.js20 "name TEXT NOT NULL, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
61 "salary": 100.5,
71 "salary": 100.5,
81 "salary": 100.5,
113 "salary": 100.5,
123 "salary": 100.5,
133 "salary": 100.5,
165 "salary": 100.5,
175 "salary": 100.5,
185 "salary"
[all...]
H A DRdbstoreUpdateJsunit.test.js20 "name TEXT UNIQUE, " + "age INTEGER, " + "salary REAL, " + "blobType BLOB)";
61 "salary": 100.5,
72 "salary": 200.5,
88 const salary = await resultSet.getDouble(resultSet.getColumnIndex("salary"))
94 await expect(200.5).assertEqual(salary);
121 "salary": 100.5,
163 "salary": 100.5,
195 "salary": 100.5,
232 "salary"
[all...]
/foundation/distributeddatamgr/relational_store/test/native/rdb/unittest/
H A Drdb_predicates_join_b_test.cpp67 std::string("mgr INTEGER, joinDate TEXT, salary REAL, bonus REAL, deptId INTEGER,") +
293 double salary; in HWTEST_F() local
294 EXPECT_EQ(E_OK, allDataTypes->GetDouble(5, salary)); in HWTEST_F()
295 EXPECT_EQ(8000.00, salary); in HWTEST_F()
339 columns.push_back("t1.salary"); in HWTEST_F()
354 double salary; in HWTEST_F() local
355 EXPECT_EQ(E_OK, allDataTypes->GetDouble(2, salary)); in HWTEST_F()
356 EXPECT_EQ(8000.00, salary); in HWTEST_F()
377 clauses.push_back("t1.salary BETWEEN t2.losalary AND t2.hisalary"); in HWTEST_F()
386 columns.push_back("t1.salary"); in HWTEST_F()
396 double salary; HWTEST_F() local
455 double salary; HWTEST_F() local
[all...]
H A Dcommon.h30 double salary; member
42 double salary; member
H A Dcommon.cpp29 value.PutDouble("salary", rowData.salary); in SetRowData()
63 value.PutDouble("salary", rowDatas.salary); in SetRowDatas()
H A Drdb_transaction_test.cpp53 "age INTEGER, salary REAL, blobType "
440 values.PutDouble("salary", 100.5); in HWTEST_F()
469 double salary = 100.5; in HWTEST_F() local
476 values.PutDouble("salary", salary + i); in HWTEST_F()
505 double salary = 100.5; in HWTEST_F() local
509 RowData rowData1 = { id + i, name, age + i, salary + i, blob }; in HWTEST_F()
526 RowData rowData2 = { id + i, name, age + i, salary + i, blob }; in HWTEST_F()
H A Drdb_store_rekey_test.cpp75 "salary "
211 double salary = 100.5; in InsertData() local
215 values.PutDouble("salary", salary); in InsertData()
H A Drdb_update_test.cpp57 + std::string("salary REAL, ")
119 values.PutDouble("salary", 200.5); in HWTEST_F()
161 values.PutDouble("salary", 300.5); in HWTEST_F()
199 values.PutDouble("salary", 100.5); in HWTEST_F()
270 values.PutDouble("salary", 200.5); in HWTEST_F()
475 values.PutDouble("salary", 300.5); in HWTEST_F()
524 values.PutDouble("salary", 300.5); in HWTEST_F()
573 values.PutDouble("salary", 300.5); in HWTEST_F()
623 values.PutDouble("salary", 300.5); in HWTEST_F()
672 values.PutDouble("salary", 300. in HWTEST_F()
[all...]
/foundation/distributeddatamgr/relational_store/test/native/relational_store_test/unittest/
H A Drelational_store_test.cpp58 "name TEXT NOT NULL, age INTEGER, salary "
286 values.PutDouble("salary", 100.5); in HWTEST_F()
296 values.PutDouble("salary", 200.5); in HWTEST_F()
306 values.PutDouble("salary", 300.5); in HWTEST_F()
361 values.PutDouble("salary", 100.5); in HWTEST_F()
371 values.PutDouble("salary", 200.5); in HWTEST_F()
381 values.PutDouble("salary", 300.5); in HWTEST_F()
458 values.PutDouble("salary", 100.5); in HWTEST_F()
494 ret = resultSet->GetColumnIndex("salary", columnIndex); in HWTEST_F()
677 values.PutDouble("salary", 100. in HWTEST_F()
[all...]

Completed in 11 milliseconds