[PATCH 3/6] msi/tests: Add more tests for MSIMODIFY_ASSIGN.
Zebediah Figura
z.figura12 at gmail.com
Tue Jan 29 23:13:37 CST 2019
Signed-off-by: Zebediah Figura <z.figura12 at gmail.com>
---
dlls/msi/tests/db.c | 172 ++++++++++++++++++++++++++++++++++++++++----
1 file changed, 160 insertions(+), 12 deletions(-)
diff --git a/dlls/msi/tests/db.c b/dlls/msi/tests/db.c
index 1cf87d835d..15b8fcb472 100644
--- a/dlls/msi/tests/db.c
+++ b/dlls/msi/tests/db.c
@@ -5171,12 +5171,7 @@ static void test_viewmodify_assign(void)
ok(r == ERROR_SUCCESS, "MsiViewExecute failed\n");
r = MsiViewFetch(hview, &hrec);
ok(r == ERROR_SUCCESS, "MsiViewFetch failed\n");
-
- r = MsiRecordGetInteger(hrec, 1);
- ok(r == 1, "Expected 1, got %d\n", r);
- r = MsiRecordGetInteger(hrec, 2);
- ok(r == 2, "Expected 2, got %d\n", r);
-
+ check_record(hrec, 2, "1", "2");
r = MsiCloseHandle(hrec);
ok(r == ERROR_SUCCESS, "failed to close record\n");
@@ -5221,12 +5216,7 @@ static void test_viewmodify_assign(void)
ok(r == ERROR_SUCCESS, "MsiViewExecute failed\n");
r = MsiViewFetch(hview, &hrec);
ok(r == ERROR_SUCCESS, "MsiViewFetch failed\n");
-
- r = MsiRecordGetInteger(hrec, 1);
- ok(r == 1, "Expected 1, got %d\n", r);
- r = MsiRecordGetInteger(hrec, 2);
- ok(r == 4, "Expected 4, got %d\n", r);
-
+ check_record(hrec, 2, "1", "4");
r = MsiCloseHandle(hrec);
ok(r == ERROR_SUCCESS, "failed to close record\n");
@@ -5238,6 +5228,164 @@ static void test_viewmodify_assign(void)
r = MsiCloseHandle(hview);
ok(r == ERROR_SUCCESS, "MsiCloseHandle failed\n");
+ r = run_query(hdb, 0, "CREATE TABLE `table2` (`A` INT, `B` INT, `C` INT, `D` INT PRIMARY KEY `A`,`B`)");
+ ok(!r, "got %u\n", r);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT * FROM `table2`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ hrec = MsiCreateRecord(4);
+ MsiRecordSetInteger(hrec, 1, 1);
+ MsiRecordSetInteger(hrec, 2, 2);
+ MsiRecordSetInteger(hrec, 3, 3);
+ MsiRecordSetInteger(hrec, 4, 4);
+ r = MsiViewModify(hview, MSIMODIFY_ASSIGN, hrec);
+ ok(!r, "got %u\n", r);
+ MsiCloseHandle(hrec);
+
+ MsiCloseHandle(hview);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT * FROM `table2`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "1", "2", "3", "4");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(r == ERROR_NO_MORE_ITEMS, "got %u\n", r);
+ MsiCloseHandle(hview);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT * FROM `table2`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ hrec = MsiCreateRecord(4);
+ MsiRecordSetInteger(hrec, 1, 1);
+ MsiRecordSetInteger(hrec, 2, 4);
+ MsiRecordSetInteger(hrec, 3, 3);
+ MsiRecordSetInteger(hrec, 4, 3);
+ r = MsiViewModify(hview, MSIMODIFY_ASSIGN, hrec);
+ ok(!r, "got %u\n", r);
+ MsiCloseHandle(hrec);
+
+ MsiCloseHandle(hview);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT * FROM `table2`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "1", "2", "3", "4");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "1", "4", "3", "3");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(r == ERROR_NO_MORE_ITEMS, "got %u\n", r);
+ MsiCloseHandle(hview);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT `B`, `C` FROM `table2`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ hrec = MsiCreateRecord(2);
+ MsiRecordSetInteger(hrec, 1, 2);
+ MsiRecordSetInteger(hrec, 2, 4);
+ r = MsiViewModify(hview, MSIMODIFY_ASSIGN, hrec);
+ ok(!r, "got %u\n", r);
+ MsiRecordSetInteger(hrec, 1, 3);
+ r = MsiViewModify(hview, MSIMODIFY_ASSIGN, hrec);
+ ok(!r, "got %u\n", r);
+ MsiCloseHandle(hrec);
+
+ MsiCloseHandle(hview);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT * FROM `table2` ORDER BY `A`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "", "2", "4", "");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "", "3", "4", "");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "1", "2", "3", "4");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "1", "4", "3", "3");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(r == ERROR_NO_MORE_ITEMS, "got %u\n", r);
+ MsiCloseHandle(hview);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT `A`, `B`, `C` FROM `table2`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ hrec = MsiCreateRecord(3);
+ MsiRecordSetInteger(hrec, 1, 1);
+ MsiRecordSetInteger(hrec, 2, 2);
+ MsiRecordSetInteger(hrec, 3, 5);
+ r = MsiViewModify(hview, MSIMODIFY_ASSIGN, hrec);
+ ok(!r, "got %u\n", r);
+ MsiCloseHandle(hrec);
+
+ MsiCloseHandle(hview);
+
+ r = MsiDatabaseOpenViewA(hdb, "SELECT * FROM `table2` ORDER BY `A`", &hview);
+ ok(!r, "got %u\n", r);
+ r = MsiViewExecute(hview, 0);
+ ok(!r, "got %u\n", r);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "", "2", "4", "");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "", "3", "4", "");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "1", "2", "5", "");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(!r, "got %u\n", r);
+ check_record(hrec, 4, "1", "4", "3", "3");
+ MsiCloseHandle(hrec);
+
+ r = MsiViewFetch(hview, &hrec);
+ ok(r == ERROR_NO_MORE_ITEMS, "got %u\n", r);
+ MsiCloseHandle(hview);
+
/* close database */
r = MsiCloseHandle( hdb );
ok(r == ERROR_SUCCESS, "MsiOpenDatabase close failed\n");
--
2.20.1
More information about the wine-devel
mailing list