2 * Copyright (C) 2005 Mike McCormack for CodeWeavers
4 * A test program for MSI database files.
6 * This library is free software; you can redistribute it and/or
7 * modify it under the terms of the GNU Lesser General Public
8 * License as published by the Free Software Foundation; either
9 * version 2.1 of the License, or (at your option) any later version.
11 * This library is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14 * Lesser General Public License for more details.
16 * You should have received a copy of the GNU Lesser General Public
17 * License along with this library; if not, write to the Free Software
18 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
29 #include "wine/test.h"
32 * The following are defined in Windows SDK's msidefs.h
33 * but that file doesn't exist in the msvc6 header set.
35 * Some are already defined in PropIdl.h - undefine them
42 #define PID_DICTIONARY 0
43 #define PID_CODEPAGE 1
47 #define PID_KEYWORDS 5
48 #define PID_COMMENTS 6
49 #define PID_TEMPLATE 7
50 #define PID_LASTAUTHOR 8
51 #define PID_REVNUMBER 9
52 #define PID_EDITTINE 10
53 #define PID_LASTPRINTED 11
54 #define PID_CREATE_DTM 12
55 #define PID_LASTSAVE_DTM 13
56 #define PID_PAGECOUNT 14
57 #define PID_WORDCOUNT 15
58 #define PID_CHARCOUNT 16
59 #define PID_THUMBNAIL 17
60 #define PID_APPNAME 18
61 #define PID_SECURITY 19
62 #define PID_MSIVERSION PID_PAGECOUNT
63 #define PID_MSISOURCE PID_WORDCOUNT
64 #define PID_MSIRESTRICT PID_CHARCOUNT
66 static void test_suminfo(void)
68 const char *msifile = "winetest.msi";
69 MSIHANDLE hdb = 0, hsuminfo;
78 /* just MsiOpenDatabase should not create a file */
79 r = MsiOpenDatabase(msifile, MSIDBOPEN_CREATE, &hdb);
80 ok(r == ERROR_SUCCESS, "MsiOpenDatabase failed\n");
82 r = MsiGetSummaryInformation(hdb, NULL, 0, NULL);
83 ok(r == ERROR_INVALID_PARAMETER, "MsiGetSummaryInformation wrong error\n");
85 r = MsiGetSummaryInformation(hdb, NULL, 0, &hsuminfo);
86 ok(r == ERROR_SUCCESS, "MsiGetSummaryInformation failed\n");
88 r = MsiSummaryInfoGetPropertyCount(0, NULL);
89 ok(r == ERROR_INVALID_HANDLE, "getpropcount failed\n");
91 r = MsiSummaryInfoGetPropertyCount(hsuminfo, NULL);
92 ok(r == ERROR_SUCCESS, "getpropcount failed\n");
95 r = MsiSummaryInfoGetPropertyCount(hsuminfo, &count);
96 ok(r == ERROR_SUCCESS, "getpropcount failed\n");
97 ok(count == 0, "count should be zero\n");
99 r = MsiSummaryInfoGetProperty(hsuminfo, 0, NULL, NULL, NULL, 0, NULL);
100 ok(r == ERROR_SUCCESS, "getpropcount failed\n");
103 r = MsiSummaryInfoGetProperty(hsuminfo, 0, &type, NULL, NULL, 0, NULL);
104 ok(r == ERROR_SUCCESS, "getpropcount failed\n");
105 ok(type == 0, "wrong type\n");
109 r = MsiSummaryInfoGetProperty(hsuminfo, 0, &type, &val, NULL, 0, NULL);
110 ok(r == ERROR_SUCCESS, "getpropcount failed\n");
111 ok(type == 0, "wrong type\n");
112 ok(val == 1234, "wrong val\n");
117 r = MsiSummaryInfoGetProperty(hsuminfo, PID_REVNUMBER, &type, &val, NULL, buf, &sz);
118 ok(r == ERROR_SUCCESS, "getpropcount failed\n");
119 ok(buf[0]=='x', "cleared buffer\n");
120 ok(sz == 0x10, "count wasn't zero\n");
121 ok(type == VT_EMPTY, "should be empty\n");
123 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TITLE, VT_LPSTR, 0, NULL, "Mike");
124 ok(r == ERROR_FUNCTION_FAILED, "MsiSummaryInfoSetProperty wrong error\n");
126 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TITLE, VT_LPSTR, 1, NULL, "JungAh");
127 ok(r == ERROR_FUNCTION_FAILED, "MsiSummaryInfoSetProperty wrong error\n");
129 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TITLE, VT_LPSTR, 1, &ft, "Mike");
130 ok(r == ERROR_FUNCTION_FAILED, "MsiSummaryInfoSetProperty wrong error\n");
132 r = MsiSummaryInfoSetProperty(hsuminfo, PID_CODEPAGE, VT_I2, 1, &ft, "JungAh");
133 ok(r == ERROR_FUNCTION_FAILED, "MsiSummaryInfoSetProperty wrong error\n");
135 r = MsiCloseHandle(hsuminfo);
136 ok(r == ERROR_SUCCESS, "MsiCloseHandle failed\n");
138 /* try again with the update count set */
139 r = MsiGetSummaryInformation(hdb, NULL, 1, &hsuminfo);
140 ok(r == ERROR_SUCCESS, "MsiGetSummaryInformation failed\n");
142 r = MsiSummaryInfoSetProperty(hsuminfo, 0, VT_LPSTR, 1, NULL, NULL);
143 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
145 r = MsiSummaryInfoSetProperty(hsuminfo, PID_CODEPAGE, VT_LPSTR, 1, NULL, NULL);
146 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
148 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TITLE, VT_I4, 0, NULL, "Mike");
149 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
151 r = MsiSummaryInfoSetProperty(hsuminfo, PID_AUTHOR, VT_I4, 0, NULL, "JungAh");
152 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
154 r = MsiSummaryInfoSetProperty(hsuminfo, PID_KEYWORDS, VT_I2, 0, NULL, "Mike");
155 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
157 r = MsiSummaryInfoSetProperty(hsuminfo, PID_COMMENTS, VT_FILETIME, 0, NULL, "JungAh");
158 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
160 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TEMPLATE, VT_I2, 0, NULL, "Mike");
161 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
163 r = MsiSummaryInfoSetProperty(hsuminfo, PID_LASTAUTHOR, VT_LPSTR, 0, NULL, NULL);
164 ok(r == ERROR_INVALID_PARAMETER, "MsiSummaryInfoSetProperty wrong error\n");
166 r = MsiSummaryInfoSetProperty(hsuminfo, PID_LASTSAVE_DTM, VT_FILETIME, 0, NULL, NULL);
167 ok(r == ERROR_INVALID_PARAMETER, "MsiSummaryInfoSetProperty wrong error\n");
169 r = MsiSummaryInfoSetProperty(hsuminfo, PID_LASTAUTHOR, VT_LPWSTR, 0, NULL, "h\0i\0\0");
170 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
172 r = MsiSummaryInfoSetProperty(hsuminfo, PID_REVNUMBER, VT_I4, 0, NULL, "Jungah");
173 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
175 r = MsiSummaryInfoSetProperty(hsuminfo, PID_PAGECOUNT, VT_LPSTR, 1, NULL, NULL);
176 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
178 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TITLE, VT_LPSTR, 0, NULL, "Mike");
179 ok(r == ERROR_SUCCESS, "MsiSummaryInfoSetProperty failed\n");
183 r = MsiSummaryInfoGetProperty(hsuminfo, PID_TITLE, &type, NULL, NULL, buf, &sz );
184 ok(r == ERROR_MORE_DATA, "MsiSummaryInfoSetProperty failed\n");
185 ok(sz == 4, "count was wrong\n");
186 ok(type == VT_LPSTR, "type was wrong\n");
187 ok(!strcmp(buf,"M"), "buffer was wrong\n");
191 r = MsiSummaryInfoGetProperty(hsuminfo, PID_TITLE, &type, NULL, NULL, buf, &sz );
192 ok(r == ERROR_MORE_DATA, "MsiSummaryInfoSetProperty failed\n");
193 ok(sz == 4, "count was wrong\n");
194 ok(type == VT_LPSTR, "type was wrong\n");
195 ok(!strcmp(buf,"Mik"), "buffer was wrong\n");
197 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TITLE, VT_LPSTR, 0, NULL, "JungAh");
198 ok(r == ERROR_SUCCESS, "MsiSummaryInfoSetProperty failed\n");
200 r = MsiSummaryInfoSetProperty(hsuminfo, PID_CODEPAGE, VT_I2, 1, &ft, "Mike");
201 ok(r == ERROR_FUNCTION_FAILED, "MsiSummaryInfoSetProperty wrong error\n");
203 r = MsiCloseHandle(hsuminfo);
204 ok(r == ERROR_SUCCESS, "MsiCloseHandle failed\n");
206 /* try again with a higher update count */
207 r = MsiGetSummaryInformation(hdb, NULL, 10, &hsuminfo);
208 ok(r == ERROR_SUCCESS, "MsiGetSummaryInformation failed\n");
210 r = MsiSummaryInfoSetProperty(hsuminfo, PID_TITLE, VT_LPSTR, 0, NULL, "JungAh");
211 ok(r == ERROR_SUCCESS, "MsiSummaryInfoSetProperty failed\n");
213 r = MsiSummaryInfoSetProperty(hsuminfo, PID_CODEPAGE, VT_LPSTR, 1, NULL, NULL);
214 ok(r == ERROR_DATATYPE_MISMATCH, "MsiSummaryInfoSetProperty wrong error\n");
216 r = MsiSummaryInfoSetProperty(hsuminfo, PID_CODEPAGE, VT_I2, 1, NULL, NULL);
217 ok(r == ERROR_SUCCESS, "MsiSummaryInfoSetProperty wrong error\n");
219 r = MsiSummaryInfoSetProperty(hsuminfo, PID_CODEPAGE, VT_I2, 1, &ft, "Mike");
220 ok(r == ERROR_SUCCESS, "MsiSummaryInfoSetProperty wrong error\n");
222 r = MsiSummaryInfoSetProperty(hsuminfo, PID_AUTHOR, VT_LPSTR, 1, &ft, "Mike");
223 ok(r == ERROR_SUCCESS, "MsiSummaryInfoSetProperty wrong error\n");
225 r = MsiSummaryInfoPersist(hsuminfo);
226 ok(r == ERROR_SUCCESS, "MsiSummaryInfoPersist failed\n");
228 MsiDatabaseCommit(hdb);
230 r = MsiCloseHandle(hsuminfo);
231 ok(r == ERROR_SUCCESS, "MsiCloseHandle failed\n");
233 r = MsiCloseHandle(hdb);
234 ok(r == ERROR_SUCCESS, "MsiCloseHandle failed\n");
236 r = DeleteFile(msifile);
237 ok(r, "DeleteFile failed\n");
240 static const WCHAR tb[] = { 0x4840, 0x3f7f, 0x4164, 0x422f, 0x4836, 0 }; /* _Tables */
241 static const WCHAR sd[] = { 0x4840, 0x3f3f, 0x4577, 0x446c, 0x3b6a, 0x45e4, 0x4824, 0 }; /* _StringData */
242 static const WCHAR sp[] = { 0x4840, 0x3f3f, 0x4577, 0x446c, 0x3e6a, 0x44b2, 0x482f, 0 }; /* _StringPool */
244 #define LOSE_CONST(x) ((LPSTR)(UINT_PTR)(x))
246 static void test_create_database_binary(void)
248 static const CLSID CLSID_MsiDatabase =
249 { 0xc1084, 0, 0, {0xc0, 0, 0, 0, 0, 0, 0, 0x46 } };
250 static const CLSID IID_IPropertySetStorage =
251 { 0x13a, 0, 0, {0xc0, 0, 0, 0, 0, 0, 0, 0x46 } };
252 static const CLSID FMTID_SummaryInformation =
253 { 0xf29f85e0, 0x4ff9, 0x1068, {0xab, 0x91, 0x08, 0x00, 0x2b, 0x27, 0xb3, 0xd9}};
254 DWORD mode = STGM_CREATE | STGM_READWRITE | STGM_DIRECT | STGM_SHARE_EXCLUSIVE;
255 static const WCHAR msifile[] = {
256 'w','i','n','e','t','e','s','t','.','m','s','i',0 };
257 IPropertySetStorage *pss = NULL;
258 IPropertyStorage *ps = NULL;
259 IStorage *stg = NULL;
262 PROPSPEC propspec[10];
263 PROPVARIANT propvar[10];
264 USHORT data[2] = { 0, 0 };
266 r = StgCreateDocfile( msifile, mode, 0, &stg );
267 ok( r == S_OK, "failed to create database\n");
269 r = IStorage_SetClass( stg, &CLSID_MsiDatabase );
270 ok( r == S_OK, "failed to set clsid\n");
272 /* create the _StringData stream */
273 r = IStorage_CreateStream( stg, sd, STGM_WRITE | STGM_SHARE_EXCLUSIVE, 0, 0, &stm );
274 ok( r == S_OK, "failed to create stream\n");
276 IStream_Release( stm );
278 /* create the _StringPool stream */
279 r = IStorage_CreateStream( stg, sp, STGM_WRITE | STGM_SHARE_EXCLUSIVE, 0, 0, &stm );
280 ok( r == S_OK, "failed to create stream\n");
282 r = IStream_Write( stm, data, sizeof data, NULL );
283 ok( r == S_OK, "failed to write stream\n");
285 IStream_Release( stm );
287 /* create the _Tables stream */
288 r = IStorage_CreateStream( stg, tb, STGM_WRITE | STGM_SHARE_EXCLUSIVE, 0, 0, &stm );
289 ok( r == S_OK, "failed to create stream\n");
291 IStream_Release( stm );
293 r = IStorage_QueryInterface( stg, &IID_IPropertySetStorage, (void**) &pss );
294 ok( r == S_OK, "failed to set clsid\n");
296 r = IPropertySetStorage_Create( pss, &FMTID_SummaryInformation, NULL, 0, mode, &ps );
297 ok( r == S_OK, "failed to create property set\n");
299 r = IPropertyStorage_SetClass( ps, &FMTID_SummaryInformation );
300 ok( r == S_OK, "failed to set class\n");
302 PropVariantClear( &propvar[0] );
303 propspec[0].lpwstr = NULL;
304 propspec[0].ulKind = PRSPEC_PROPID;
305 propspec[0].propid = PID_TITLE;
306 propvar[0].vt = VT_LPSTR;
307 U(propvar[0]).pszVal = LOSE_CONST("test title");
309 PropVariantClear( &propvar[1] );
310 propspec[1].lpwstr = NULL;
311 propspec[1].ulKind = PRSPEC_PROPID;
312 propspec[1].propid = PID_SUBJECT;
313 propvar[1].vt = VT_LPSTR;
314 U(propvar[1]).pszVal = LOSE_CONST("msi suminfo / property storage test");
316 PropVariantClear( &propvar[2] );
317 propspec[2].lpwstr = NULL;
318 propspec[2].ulKind = PRSPEC_PROPID;
319 propspec[2].propid = PID_AUTHOR;
320 propvar[2].vt = VT_LPSTR;
321 U(propvar[2]).pszVal = LOSE_CONST("mike_m");
323 PropVariantClear( &propvar[3] );
324 propspec[3].lpwstr = NULL;
325 propspec[3].ulKind = PRSPEC_PROPID;
326 propspec[3].propid = PID_TEMPLATE;
327 propvar[3].vt = VT_LPSTR;
328 U(propvar[3]).pszVal = LOSE_CONST(";1033"); /* actually the string table's codepage */
330 PropVariantClear( &propvar[4] );
331 propspec[4].lpwstr = NULL;
332 propspec[4].ulKind = PRSPEC_PROPID;
333 propspec[4].propid = PID_REVNUMBER;
334 propvar[4].vt = VT_LPSTR;
335 U(propvar[4]).pszVal = LOSE_CONST("{913B8D18-FBB6-4CAC-A239-C74C11E3FA74}");
337 PropVariantClear( &propvar[5] );
338 propspec[5].lpwstr = NULL;
339 propspec[5].ulKind = PRSPEC_PROPID;
340 propspec[5].propid = PID_PAGECOUNT;
341 propvar[5].vt = VT_I4;
342 U(propvar[5]).lVal = 100;
344 PropVariantClear( &propvar[6] );
345 propspec[6].lpwstr = NULL;
346 propspec[6].ulKind = PRSPEC_PROPID;
347 propspec[6].propid = PID_WORDCOUNT;
348 propvar[6].vt = VT_I4;
349 U(propvar[6]).lVal = 0;
351 /* MSDN says that PID_LASTPRINTED should be a VT_FILETIME... */
352 PropVariantClear( &propvar[7] );
353 propspec[7].lpwstr = NULL;
354 propspec[7].ulKind = PRSPEC_PROPID;
355 propspec[7].propid = PID_LASTPRINTED;
356 propvar[7].vt = VT_LPSTR;
357 U(propvar[7]).pszVal = LOSE_CONST("7/1/1999 5:17");
359 r = IPropertyStorage_WriteMultiple( ps, 8, propspec, propvar, PID_FIRST_USABLE );
360 ok( r == S_OK, "failed to write properties\n");
362 IPropertyStorage_Commit( ps, STGC_DEFAULT );
364 IPropertyStorage_Release( ps );
365 IPropertySetStorage_Release( pss );
367 IStorage_Commit( stg, STGC_DEFAULT );
368 IStorage_Release( stg );
371 static void test_summary_binary(void)
373 const char *msifile = "winetest.msi";
374 MSIHANDLE hdb = 0, hsuminfo = 0;
380 DeleteFile( msifile );
382 test_create_database_binary();
384 ok( INVALID_FILE_ATTRIBUTES != GetFileAttributes(msifile), "file doesn't exist!\n");
386 /* just MsiOpenDatabase should not create a file */
387 r = MsiOpenDatabase(msifile, MSIDBOPEN_READONLY, &hdb);
388 ok(r == ERROR_SUCCESS, "MsiOpenDatabase failed\n");
390 r = MsiGetSummaryInformation(hdb, NULL, 0, &hsuminfo);
391 ok(r == ERROR_SUCCESS, "MsiGetSummaryInformation failed\n");
394 * Check what reading PID_LASTPRINTED does...
395 * The string value is written to the msi file
396 * but it appears that we're not allowed to read it back again.
397 * We can still read its type though...?
400 r = MsiSummaryInfoGetProperty(hsuminfo, PID_LASTPRINTED, &type, NULL, NULL, sval, &sz);
401 ok(r == ERROR_SUCCESS, "MsiSummaryInfoGetProperty failed\n");
402 ok( !strcmp(sval, ""), "value incorrect\n");
404 ok( type == VT_LPSTR, "type wrong\n");
405 ok( sz == 0, "length wrong\n");
408 r = MsiSummaryInfoGetProperty(hsuminfo, PID_WORDCOUNT, &type, &ival, NULL, NULL, NULL);
409 ok(r == ERROR_SUCCESS, "MsiSummaryInfoGetProperty failed\n");
410 todo_wine ok( ival == 0, "value incorrect\n");
412 /* looks like msi adds some of its own values in here */
414 r = MsiSummaryInfoGetPropertyCount( hsuminfo, &count );
415 ok(r == ERROR_SUCCESS, "getpropcount failed\n");
416 todo_wine ok(count == 10, "prop count incorrect\n");
418 MsiCloseHandle( hsuminfo );
419 MsiCloseHandle( hdb );
421 DeleteFile( msifile );
427 test_summary_binary();