dll/win32/msi/database.c

   1 /*
   2  * Implementation of the Microsoft Installer (msi.dll)
   3  *
   4  * Copyright 2002,2003,2004,2005 Mike McCormack for CodeWeavers
   5  *
   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.
  10  *
  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.
  15  *
  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
  19  */
  20
  21 #include <stdarg.h>
  22
  23 #define COBJMACROS
  24 #define NONAMELESSUNION
  25
  26 #include "windef.h"
  27 #include "winbase.h"
  28 #include "winreg.h"
  29 #include "winnls.h"
  30 #include "wine/debug.h"
  31 #include "wine/unicode.h"
  32 #include "msi.h"
  33 #include "msiquery.h"
  34 #include "msipriv.h"
  35 #include "objidl.h"
  36 #include "objbase.h"
  37 #include "msiserver.h"
  38 #include "query.h"
  39
  40 #include "initguid.h"
  41
  42 WINE_DEFAULT_DEBUG_CHANNEL(msi);
  43
  44 /*
  45  *  .MSI  file format
  46  *
  47  *  An .msi file is a structured storage file.
  48  *  It contains a number of streams.
  49  *  A stream for each table in the database.
  50  *  Two streams for the string table in the database.
  51  *  Any binary data in a table is a reference to a stream.
  52  */
  53
  54 #define IS_INTMSIDBOPEN(x)      (((ULONG_PTR)(x) >> 16) == 0)
  55
  56 typedef struct tagMSITRANSFORM {
  57     struct list entry;
  58     IStorage *stg;
  59 } MSITRANSFORM;
  60
  61 typedef struct tagMSISTREAM {
  62     struct list entry;
  63     IStream *stm;
  64 } MSISTREAM;
  65
  66 static UINT find_open_stream( MSIDATABASE *db, LPCWSTR name, IStream **stm )
  67 {
  68     MSISTREAM *stream;
  69
  70     LIST_FOR_EACH_ENTRY( stream, &db->streams, MSISTREAM, entry )
  71     {
  72         HRESULT r;
  73         STATSTG stat;
  74
  75         r = IStream_Stat( stream->stm, &stat, 0 );
  76         if( FAILED( r ) )
  77         {
  78             WARN("failed to stat stream r = %08x!\n", r);
  79             continue;
  80         }
  81
  82         if( !lstrcmpW( name, stat.pwcsName ) )
  83         {
  84             TRACE("found %s\n", debugstr_w(name));
  85             *stm = stream->stm;
  86             CoTaskMemFree( stat.pwcsName );
  87             return ERROR_SUCCESS;
  88         }
  89
  90         CoTaskMemFree( stat.pwcsName );
  91     }
  92
  93     return ERROR_FUNCTION_FAILED;
  94 }
  95
  96 static UINT clone_open_stream( MSIDATABASE *db, LPCWSTR name, IStream **stm )
  97 {
  98     IStream *stream;
  99
 100     if (find_open_stream( db, name, &stream ) == ERROR_SUCCESS)
 101     {
 102         HRESULT r;
 103         LARGE_INTEGER pos;
 104
 105         r = IStream_Clone( stream, stm );
 106         if( FAILED( r ) )
 107         {
 108             WARN("failed to clone stream r = %08x!\n", r);
 109             return ERROR_FUNCTION_FAILED;
 110         }
 111
 112         pos.QuadPart = 0;
 113         r = IStream_Seek( *stm, pos, STREAM_SEEK_SET, NULL );
 114         if( FAILED( r ) )
 115         {
 116             IStream_Release( *stm );
 117             return ERROR_FUNCTION_FAILED;
 118         }
 119
 120         return ERROR_SUCCESS;
 121     }
 122
 123     return ERROR_FUNCTION_FAILED;
 124 }
 125
 126 UINT db_get_raw_stream( MSIDATABASE *db, LPCWSTR stname, IStream **stm )
 127 {
 128     HRESULT r;
 129
 130     TRACE("%s\n", debugstr_w(stname));
 131
 132     if (clone_open_stream( db, stname, stm ) == ERROR_SUCCESS)
 133         return ERROR_SUCCESS;
 134
 135     r = IStorage_OpenStream( db->storage, stname, NULL,
 136                              STGM_READ | STGM_SHARE_EXCLUSIVE, 0, stm );
 137     if( FAILED( r ) )
 138     {
 139         MSITRANSFORM *transform;
 140
 141         LIST_FOR_EACH_ENTRY( transform, &db->transforms, MSITRANSFORM, entry )
 142         {
 143             TRACE("looking for %s in transform storage\n", debugstr_w(stname) );
 144             r = IStorage_OpenStream( transform->stg, stname, NULL,
 145                                      STGM_READ | STGM_SHARE_EXCLUSIVE, 0, stm );
 146             if (SUCCEEDED(r))
 147                 break;
 148         }
 149     }
 150
 151     if( SUCCEEDED(r) )
 152     {
 153         MSISTREAM *stream;
 154
 155         stream = msi_alloc( sizeof(MSISTREAM) );
 156         if( !stream )
 157             return ERROR_NOT_ENOUGH_MEMORY;
 158
 159         stream->stm = *stm;
 160         IStream_AddRef( *stm );
 161         list_add_tail( &db->streams, &stream->entry );
 162     }
 163
 164     return SUCCEEDED(r) ? ERROR_SUCCESS : ERROR_FUNCTION_FAILED;
 165 }
 166
 167 UINT read_raw_stream_data( MSIDATABASE *db, LPCWSTR stname,
 168                               USHORT **pdata, UINT *psz )
 169 {
 170     HRESULT r;
 171     UINT ret = ERROR_FUNCTION_FAILED;
 172     VOID *data;
 173     ULONG sz, count;
 174     IStream *stm = NULL;
 175     STATSTG stat;
 176     LPWSTR encname;
 177
 178     encname = encode_streamname( FALSE, stname );
 179     r = db_get_raw_stream( db, encname, &stm );
 180     msi_free( encname );
 181
 182     if( r != ERROR_SUCCESS)
 183         return ret;
 184
 185     r = IStream_Stat(stm, &stat, STATFLAG_NONAME );
 186     if( FAILED( r ) )
 187     {
 188         WARN("open stream failed r = %08x!\n", r);
 189         goto end;
 190     }
 191
 192     if( stat.cbSize.QuadPart >> 32 )
 193     {
 194         WARN("Too big!\n");
 195         goto end;
 196     }
 197
 198     sz = stat.cbSize.QuadPart;
 199     data = msi_alloc( sz );
 200     if( !data )
 201     {
 202         WARN("couldn't allocate memory r=%08x!\n", r);
 203         ret = ERROR_NOT_ENOUGH_MEMORY;
 204         goto end;
 205     }
 206
 207     r = IStream_Read(stm, data, sz, &count );
 208     if( FAILED( r ) || ( count != sz ) )
 209     {
 210         msi_free( data );
 211         WARN("read stream failed r = %08x!\n", r);
 212         goto end;
 213     }
 214
 215     *pdata = data;
 216     *psz = sz;
 217     ret = ERROR_SUCCESS;
 218
 219 end:
 220     IStream_Release( stm );
 221
 222     return ret;
 223 }
 224
 225 static void free_transforms( MSIDATABASE *db )
 226 {
 227     while( !list_empty( &db->transforms ) )
 228     {
 229         MSITRANSFORM *t = LIST_ENTRY( list_head( &db->transforms ),
 230                                       MSITRANSFORM, entry );
 231         list_remove( &t->entry );
 232         IStorage_Release( t->stg );
 233         msi_free( t );
 234     }
 235 }
 236
 237 static void free_streams( MSIDATABASE *db )
 238 {
 239     while( !list_empty( &db->streams ) )
 240     {
 241         MSISTREAM *s = LIST_ENTRY( list_head( &db->streams ),
 242                                    MSISTREAM, entry );
 243         list_remove( &s->entry );
 244         IStream_Release( s->stm );
 245         msi_free( s );
 246     }
 247 }
 248
 249 void append_storage_to_db( MSIDATABASE *db, IStorage *stg )
 250 {
 251     MSITRANSFORM *t;
 252
 253     t = msi_alloc( sizeof *t );
 254     t->stg = stg;
 255     IStorage_AddRef( stg );
 256     list_add_tail( &db->transforms, &t->entry );
 257
 258     /* the transform may add or replace streams */
 259     free_streams( db );
 260 }
 261
 262 static VOID MSI_CloseDatabase( MSIOBJECTHDR *arg )
 263 {
 264     MSIDATABASE *db = (MSIDATABASE *) arg;
 265
 266     msi_free(db->path);
 267     free_cached_tables( db );
 268     free_streams( db );
 269     free_transforms( db );
 270     msi_destroy_stringtable( db->strings );
 271     IStorage_Release( db->storage );
 272     if (db->deletefile)
 273     {
 274         DeleteFileW( db->deletefile );
 275         msi_free( db->deletefile );
 276     }
 277     if (db->localfile)
 278     {
 279         DeleteFileW( db->localfile );
 280         msi_free( db->localfile );
 281     }
 282 }
 283
 284 UINT MSI_OpenDatabaseW(LPCWSTR szDBPath, LPCWSTR szPersist, MSIDATABASE **pdb)
 285 {
 286     IStorage *stg = NULL;
 287     HRESULT r;
 288     MSIDATABASE *db = NULL;
 289     UINT ret = ERROR_FUNCTION_FAILED;
 290     LPCWSTR szMode, save_path;
 291     STATSTG stat;
 292     BOOL created = FALSE;
 293     WCHAR path[MAX_PATH];
 294
 295     static const WCHAR szTables[]  = { '_','T','a','b','l','e','s',0 };
 296
 297     TRACE("%s %s\n",debugstr_w(szDBPath),debugstr_w(szPersist) );
 298
 299     if( !pdb )
 300         return ERROR_INVALID_PARAMETER;
 301
 302     if (szPersist - MSIDBOPEN_PATCHFILE >= MSIDBOPEN_READONLY &&
 303         szPersist - MSIDBOPEN_PATCHFILE <= MSIDBOPEN_CREATEDIRECT)
 304     {
 305         TRACE("Database is a patch\n");
 306         szPersist -= MSIDBOPEN_PATCHFILE;
 307     }
 308
 309     save_path = szDBPath;
 310     szMode = szPersist;
 311     if( !IS_INTMSIDBOPEN(szPersist) )
 312     {
 313         if (!CopyFileW( szDBPath, szPersist, FALSE ))
 314             return ERROR_OPEN_FAILED;
 315
 316         szDBPath = szPersist;
 317         szPersist = MSIDBOPEN_TRANSACT;
 318         created = TRUE;
 319     }
 320
 321     if( szPersist == MSIDBOPEN_READONLY )
 322     {
 323         r = StgOpenStorage( szDBPath, NULL,
 324               STGM_DIRECT|STGM_READ|STGM_SHARE_DENY_WRITE, NULL, 0, &stg);
 325     }
 326     else if( szPersist == MSIDBOPEN_CREATE || szPersist == MSIDBOPEN_CREATEDIRECT )
 327     {
 328         /* FIXME: MSIDBOPEN_CREATE should case STGM_TRANSACTED flag to be
 329          * used here: */
 330         r = StgCreateDocfile( szDBPath,
 331               STGM_CREATE|STGM_DIRECT|STGM_READWRITE|STGM_SHARE_EXCLUSIVE, 0, &stg);
 332         if( r == ERROR_SUCCESS )
 333         {
 334             IStorage_SetClass( stg, &CLSID_MsiDatabase );
 335             /* create the _Tables stream */
 336             r = write_stream_data(stg, szTables, NULL, 0, TRUE);
 337             if (SUCCEEDED(r))
 338                 r = msi_init_string_table( stg );
 339         }
 340         created = TRUE;
 341     }
 342     else if( szPersist == MSIDBOPEN_TRANSACT )
 343     {
 344         /* FIXME: MSIDBOPEN_TRANSACT should case STGM_TRANSACTED flag to be
 345          * used here: */
 346         r = StgOpenStorage( szDBPath, NULL,
 347               STGM_DIRECT|STGM_READWRITE|STGM_SHARE_EXCLUSIVE, NULL, 0, &stg);
 348     }
 349     else if( szPersist == MSIDBOPEN_DIRECT )
 350     {
 351         r = StgOpenStorage( szDBPath, NULL,
 352               STGM_DIRECT|STGM_READWRITE|STGM_SHARE_EXCLUSIVE, NULL, 0, &stg);
 353     }
 354     else
 355     {
 356         ERR("unknown flag %p\n",szPersist);
 357         return ERROR_INVALID_PARAMETER;
 358     }
 359
 360     if( FAILED( r ) || !stg )
 361     {
 362         FIXME("open failed r = %08x for %s\n", r, debugstr_w(szDBPath));
 363         return ERROR_FUNCTION_FAILED;
 364     }
 365
 366     r = IStorage_Stat( stg, &stat, STATFLAG_NONAME );
 367     if( FAILED( r ) )
 368     {
 369         FIXME("Failed to stat storage\n");
 370         goto end;
 371     }
 372
 373     if ( !IsEqualGUID( &stat.clsid, &CLSID_MsiDatabase ) &&
 374          !IsEqualGUID( &stat.clsid, &CLSID_MsiPatch ) &&
 375          !IsEqualGUID( &stat.clsid, &CLSID_MsiTransform ) )
 376     {
 377         ERR("storage GUID is not a MSI database GUID %s\n",
 378              debugstr_guid(&stat.clsid) );
 379         goto end;
 380     }
 381
 382     db = alloc_msiobject( MSIHANDLETYPE_DATABASE, sizeof (MSIDATABASE),
 383                               MSI_CloseDatabase );
 384     if( !db )
 385     {
 386         FIXME("Failed to allocate a handle\n");
 387         goto end;
 388     }
 389
 390     if (!strchrW( save_path, '\\' ))
 391     {
 392         GetCurrentDirectoryW( MAX_PATH, path );
 393         lstrcatW( path, szBackSlash );
 394         lstrcatW( path, save_path );
 395     }
 396     else
 397         lstrcpyW( path, save_path );
 398
 399     db->path = strdupW( path );
 400
 401     if( TRACE_ON( msi ) )
 402         enum_stream_names( stg );
 403
 404     db->storage = stg;
 405     db->mode = szMode;
 406     if (created)
 407         db->deletefile = strdupW( szDBPath );
 408     list_init( &db->tables );
 409     list_init( &db->transforms );
 410     list_init( &db->streams );
 411
 412     db->strings = msi_load_string_table( stg, &db->bytes_per_strref );
 413     if( !db->strings )
 414         goto end;
 415
 416     ret = ERROR_SUCCESS;
 417
 418     msiobj_addref( &db->hdr );
 419     IStorage_AddRef( stg );
 420     *pdb = db;
 421
 422 end:
 423     if( db )
 424         msiobj_release( &db->hdr );
 425     if( stg )
 426         IStorage_Release( stg );
 427
 428     return ret;
 429 }
 430
 431 UINT WINAPI MsiOpenDatabaseW(LPCWSTR szDBPath, LPCWSTR szPersist, MSIHANDLE *phDB)
 432 {
 433     MSIDATABASE *db;
 434     UINT ret;
 435
 436     TRACE("%s %s %p\n",debugstr_w(szDBPath),debugstr_w(szPersist), phDB);
 437
 438     ret = MSI_OpenDatabaseW( szDBPath, szPersist, &db );
 439     if( ret == ERROR_SUCCESS )
 440     {
 441         *phDB = alloc_msihandle( &db->hdr );
 442         if (! *phDB)
 443             ret = ERROR_NOT_ENOUGH_MEMORY;
 444         msiobj_release( &db->hdr );
 445     }
 446
 447     return ret;
 448 }
 449
 450 UINT WINAPI MsiOpenDatabaseA(LPCSTR szDBPath, LPCSTR szPersist, MSIHANDLE *phDB)
 451 {
 452     HRESULT r = ERROR_FUNCTION_FAILED;
 453     LPWSTR szwDBPath = NULL, szwPersist = NULL;
 454
 455     TRACE("%s %s %p\n", debugstr_a(szDBPath), debugstr_a(szPersist), phDB);
 456
 457     if( szDBPath )
 458     {
 459         szwDBPath = strdupAtoW( szDBPath );
 460         if( !szwDBPath )
 461             goto end;
 462     }
 463
 464     if( !IS_INTMSIDBOPEN(szPersist) )
 465     {
 466         szwPersist = strdupAtoW( szPersist );
 467         if( !szwPersist )
 468             goto end;
 469     }
 470     else
 471         szwPersist = (LPWSTR)(DWORD_PTR)szPersist;
 472
 473     r = MsiOpenDatabaseW( szwDBPath, szwPersist, phDB );
 474
 475 end:
 476     if( !IS_INTMSIDBOPEN(szPersist) )
 477         msi_free( szwPersist );
 478     msi_free( szwDBPath );
 479
 480     return r;
 481 }
 482
 483 static LPWSTR msi_read_text_archive(LPCWSTR path)
 484 {
 485     HANDLE file;
 486     LPSTR data = NULL;
 487     LPWSTR wdata = NULL;
 488     DWORD read, size = 0;
 489
 490     file = CreateFileW( path, GENERIC_READ, FILE_SHARE_READ, NULL, OPEN_EXISTING, 0, NULL );
 491     if (file == INVALID_HANDLE_VALUE)
 492         return NULL;
 493
 494     size = GetFileSize( file, NULL );
 495     data = msi_alloc( size + 1 );
 496     if (!data)
 497         goto done;
 498
 499     if (!ReadFile( file, data, size, &read, NULL ))
 500         goto done;
 501
 502     data[size] = '\0';
 503     wdata = strdupAtoW( data );
 504
 505 done:
 506     CloseHandle( file );
 507     msi_free( data );
 508     return wdata;
 509 }
 510
 511 static void msi_parse_line(LPWSTR *line, LPWSTR **entries, DWORD *num_entries)
 512 {
 513     LPWSTR ptr = *line, save;
 514     DWORD i, count = 1;
 515
 516     *entries = NULL;
 517
 518     /* stay on this line */
 519     while (*ptr && *ptr != '\n')
 520     {
 521         /* entries are separated by tabs */
 522         if (*ptr == '\t')
 523             count++;
 524
 525         ptr++;
 526     }
 527
 528     *entries = msi_alloc(count * sizeof(LPWSTR));
 529     if (!*entries)
 530         return;
 531
 532     /* store pointers into the data */
 533     for (i = 0, ptr = *line; i < count; i++)
 534     {
 535         while (*ptr && *ptr == '\r') ptr++;
 536         save = ptr;
 537
 538         while (*ptr && *ptr != '\t' && *ptr != '\n' && *ptr != '\r') ptr++;
 539
 540         /* NULL-separate the data */
 541         if (*ptr == '\n' || *ptr == '\r')
 542         {
 543             while (*ptr == '\n' || *ptr == '\r')
 544                 *(ptr++) = '\0';
 545         }
 546         else if (*ptr)
 547             *ptr++ = '\0';
 548
 549         (*entries)[i] = save;
 550     }
 551
 552     /* move to the next line if there's more, else EOF */
 553     *line = ptr;
 554
 555     if (num_entries)
 556         *num_entries = count;
 557 }
 558
 559 static LPWSTR msi_build_createsql_prelude(LPWSTR table)
 560 {
 561     LPWSTR prelude;
 562     DWORD size;
 563
 564     static const WCHAR create_fmt[] = {'C','R','E','A','T','E',' ','T','A','B','L','E',' ','`','%','s','`',' ','(',' ',0};
 565
 566     size = sizeof(create_fmt)/sizeof(create_fmt[0]) + lstrlenW(table) - 2;
 567     prelude = msi_alloc(size * sizeof(WCHAR));
 568     if (!prelude)
 569         return NULL;
 570
 571     sprintfW(prelude, create_fmt, table);
 572     return prelude;
 573 }
 574
 575 static LPWSTR msi_build_createsql_columns(LPWSTR *columns_data, LPWSTR *types, DWORD num_columns)
 576 {
 577     LPWSTR columns, p;
 578     LPCWSTR type;
 579     DWORD sql_size = 1, i, len;
 580     WCHAR expanded[128], *ptr;
 581     WCHAR size[10], comma[2], extra[30];
 582
 583     static const WCHAR column_fmt[] = {'`','%','s','`',' ','%','s','%','s','%','s','%','s',' ',0};
 584     static const WCHAR size_fmt[] = {'(','%','s',')',0};
 585     static const WCHAR type_char[] = {'C','H','A','R',0};
 586     static const WCHAR type_int[] = {'I','N','T',0};
 587     static const WCHAR type_long[] = {'L','O','N','G',0};
 588     static const WCHAR type_object[] = {'O','B','J','E','C','T',0};
 589     static const WCHAR type_notnull[] = {' ','N','O','T',' ','N','U','L','L',0};
 590     static const WCHAR localizable[] = {' ','L','O','C','A','L','I','Z','A','B','L','E',0};
 591
 592     columns = msi_alloc_zero(sql_size * sizeof(WCHAR));
 593     if (!columns)
 594         return NULL;
 595
 596     for (i = 0; i < num_columns; i++)
 597     {
 598         type = NULL;
 599         comma[1] = size[0] = extra[0] = '\0';
 600
 601         if (i == num_columns - 1)
 602             comma[0] = '\0';
 603         else
 604             comma[0] = ',';
 605
 606         ptr = &types[i][1];
 607         len = atolW(ptr);
 608         extra[0] = '\0';
 609
 610         switch (types[i][0])
 611         {
 612             case 'l':
 613                 lstrcpyW(extra, type_notnull);
 614             case 'L':
 615                 lstrcatW(extra, localizable);
 616                 type = type_char;
 617                 sprintfW(size, size_fmt, ptr);
 618                 break;
 619             case 's':
 620                 lstrcpyW(extra, type_notnull);
 621             case 'S':
 622                 type = type_char;
 623                 sprintfW(size, size_fmt, ptr);
 624                 break;
 625             case 'i':
 626                 lstrcpyW(extra, type_notnull);
 627             case 'I':
 628                 if (len <= 2)
 629                     type = type_int;
 630                 else if (len == 4)
 631                     type = type_long;
 632                 else
 633                 {
 634                     WARN("invalid int width %u\n", len);
 635                     msi_free(columns);
 636                     return NULL;
 637                 }
 638                 break;
 639             case 'v':
 640                 lstrcpyW(extra, type_notnull);
 641             case 'V':
 642                 type = type_object;
 643                 break;
 644             default:
 645                 ERR("Unknown type: %c\n", types[i][0]);
 646                 msi_free(columns);
 647                 return NULL;
 648         }
 649
 650         sprintfW(expanded, column_fmt, columns_data[i], type, size, extra, comma);
 651         sql_size += lstrlenW(expanded);
 652
 653         p = msi_realloc(columns, sql_size * sizeof(WCHAR));
 654         if (!p)
 655         {
 656             msi_free(columns);
 657             return NULL;
 658         }
 659         columns = p;
 660
 661         lstrcatW(columns, expanded);
 662     }
 663
 664     return columns;
 665 }
 666
 667 static LPWSTR msi_build_createsql_postlude(LPWSTR *primary_keys, DWORD num_keys)
 668 {
 669     LPWSTR postlude, keys, ptr;
 670     DWORD size, key_size, i;
 671
 672     static const WCHAR key_fmt[] = {'`','%','s','`',',',' ',0};
 673     static const WCHAR postlude_fmt[] = {'P','R','I','M','A','R','Y',' ','K','E','Y',' ','%','s',')',0};
 674
 675     for (i = 0, size = 1; i < num_keys; i++)
 676         size += lstrlenW(key_fmt) + lstrlenW(primary_keys[i]) - 2;
 677
 678     keys = msi_alloc(size * sizeof(WCHAR));
 679     if (!keys)
 680         return NULL;
 681
 682     for (i = 0, ptr = keys; i < num_keys; i++)
 683     {
 684         key_size = lstrlenW(key_fmt) + lstrlenW(primary_keys[i]) -2;
 685         sprintfW(ptr, key_fmt, primary_keys[i]);
 686         ptr += key_size;
 687     }
 688
 689     /* remove final ', ' */
 690     *(ptr - 2) = '\0';
 691
 692     size = lstrlenW(postlude_fmt) + size - 1;
 693     postlude = msi_alloc(size * sizeof(WCHAR));
 694     if (!postlude)
 695         goto done;
 696
 697     sprintfW(postlude, postlude_fmt, keys);
 698
 699 done:
 700     msi_free(keys);
 701     return postlude;
 702 }
 703
 704 static UINT msi_add_table_to_db(MSIDATABASE *db, LPWSTR *columns, LPWSTR *types, LPWSTR *labels, DWORD num_labels, DWORD num_columns)
 705 {
 706     UINT r = ERROR_OUTOFMEMORY;
 707     DWORD size;
 708     MSIQUERY *view;
 709     LPWSTR create_sql = NULL;
 710     LPWSTR prelude, columns_sql, postlude;
 711
 712     prelude = msi_build_createsql_prelude(labels[0]);
 713     columns_sql = msi_build_createsql_columns(columns, types, num_columns);
 714     postlude = msi_build_createsql_postlude(labels + 1, num_labels - 1); /* skip over table name */
 715
 716     if (!prelude || !columns_sql || !postlude)
 717         goto done;
 718
 719     size = lstrlenW(prelude) + lstrlenW(columns_sql) + lstrlenW(postlude) + 1;
 720     create_sql = msi_alloc(size * sizeof(WCHAR));
 721     if (!create_sql)
 722         goto done;
 723
 724     lstrcpyW(create_sql, prelude);
 725     lstrcatW(create_sql, columns_sql);
 726     lstrcatW(create_sql, postlude);
 727
 728     r = MSI_DatabaseOpenViewW( db, create_sql, &view );
 729     if (r != ERROR_SUCCESS)
 730         goto done;
 731
 732     r = MSI_ViewExecute(view, NULL);
 733     MSI_ViewClose(view);
 734     msiobj_release(&view->hdr);
 735
 736 done:
 737     msi_free(prelude);
 738     msi_free(columns_sql);
 739     msi_free(postlude);
 740     msi_free(create_sql);
 741     return r;
 742 }
 743
 744 static LPWSTR msi_import_stream_filename(LPCWSTR path, LPCWSTR name)
 745 {
 746     DWORD len;
 747     LPWSTR fullname, ptr;
 748
 749     len = lstrlenW(path) + lstrlenW(name) + 1;
 750     fullname = msi_alloc(len*sizeof(WCHAR));
 751     if (!fullname)
 752        return NULL;
 753
 754     lstrcpyW( fullname, path );
 755
 756     /* chop off extension from path */
 757     ptr = strrchrW(fullname, '.');
 758     if (!ptr)
 759     {
 760         msi_free (fullname);
 761         return NULL;
 762     }
 763     *ptr++ = '\\';
 764     lstrcpyW( ptr, name );
 765     return fullname;
 766 }
 767
 768 static UINT construct_record(DWORD num_columns, LPWSTR *types,
 769                              LPWSTR *data, LPWSTR path, MSIRECORD **rec)
 770 {
 771     UINT i;
 772
 773     *rec = MSI_CreateRecord(num_columns);
 774     if (!*rec)
 775         return ERROR_OUTOFMEMORY;
 776
 777     for (i = 0; i < num_columns; i++)
 778     {
 779         switch (types[i][0])
 780         {
 781             case 'L': case 'l': case 'S': case 's':
 782                 MSI_RecordSetStringW(*rec, i + 1, data[i]);
 783                 break;
 784             case 'I': case 'i':
 785                 if (*data[i])
 786                     MSI_RecordSetInteger(*rec, i + 1, atoiW(data[i]));
 787                 break;
 788             case 'V': case 'v':
 789                 if (*data[i])
 790                 {
 791                     UINT r;
 792                     LPWSTR file = msi_import_stream_filename(path, data[i]);
 793                     if (!file)
 794                         return ERROR_FUNCTION_FAILED;
 795
 796                     r = MSI_RecordSetStreamFromFileW(*rec, i + 1, file);
 797                     msi_free (file);
 798                     if (r != ERROR_SUCCESS)
 799                         return ERROR_FUNCTION_FAILED;
 800                 }
 801                 break;
 802             default:
 803                 ERR("Unhandled column type: %c\n", types[i][0]);
 804                 msiobj_release(&(*rec)->hdr);
 805                 return ERROR_FUNCTION_FAILED;
 806         }
 807     }
 808
 809     return ERROR_SUCCESS;
 810 }
 811
 812 static UINT msi_add_records_to_table(MSIDATABASE *db, LPWSTR *columns, LPWSTR *types,
 813                                      LPWSTR *labels, LPWSTR **records,
 814                                      int num_columns, int num_records,
 815                                      LPWSTR path)
 816 {
 817     UINT r;
 818     int i;
 819     MSIQUERY *view;
 820     MSIRECORD *rec;
 821
 822     static const WCHAR select[] = {
 823         'S','E','L','E','C','T',' ','*',' ',
 824         'F','R','O','M',' ','`','%','s','`',0
 825     };
 826
 827     r = MSI_OpenQuery(db, &view, select, labels[0]);
 828     if (r != ERROR_SUCCESS)
 829         return r;
 830
 831     while (MSI_ViewFetch(view, &rec) != ERROR_NO_MORE_ITEMS)
 832     {
 833         r = MSI_ViewModify(view, MSIMODIFY_DELETE, rec);
 834         msiobj_release(&rec->hdr);
 835         if (r != ERROR_SUCCESS)
 836             goto done;
 837     }
 838
 839     for (i = 0; i < num_records; i++)
 840     {
 841         r = construct_record(num_columns, types, records[i], path, &rec);
 842         if (r != ERROR_SUCCESS)
 843             goto done;
 844
 845         r = MSI_ViewModify(view, MSIMODIFY_INSERT, rec);
 846         if (r != ERROR_SUCCESS)
 847         {
 848             msiobj_release(&rec->hdr);
 849             goto done;
 850         }
 851
 852         msiobj_release(&rec->hdr);
 853     }
 854
 855 done:
 856     msiobj_release(&view->hdr);
 857     return r;
 858 }
 859
 860 static UINT MSI_DatabaseImport(MSIDATABASE *db, LPCWSTR folder, LPCWSTR file)
 861 {
 862     UINT r;
 863     DWORD len, i;
 864     DWORD num_labels, num_types;
 865     DWORD num_columns, num_records = 0;
 866     LPWSTR *columns, *types, *labels;
 867     LPWSTR path, ptr, data;
 868     LPWSTR **records = NULL;
 869     LPWSTR **temp_records;
 870
 871     static const WCHAR suminfo[] =
 872         {'_','S','u','m','m','a','r','y','I','n','f','o','r','m','a','t','i','o','n',0};
 873
 874     TRACE("%p %s %s\n", db, debugstr_w(folder), debugstr_w(file) );
 875
 876     if( folder == NULL || file == NULL )
 877         return ERROR_INVALID_PARAMETER;
 878
 879     len = lstrlenW(folder) + lstrlenW(szBackSlash) + lstrlenW(file) + 1;
 880     path = msi_alloc( len * sizeof(WCHAR) );
 881     if (!path)
 882         return ERROR_OUTOFMEMORY;
 883
 884     lstrcpyW( path, folder );
 885     lstrcatW( path, szBackSlash );
 886     lstrcatW( path, file );
 887
 888     data = msi_read_text_archive( path );
 889
 890     ptr = data;
 891     msi_parse_line( &ptr, &columns, &num_columns );
 892     msi_parse_line( &ptr, &types, &num_types );
 893     msi_parse_line( &ptr, &labels, &num_labels );
 894
 895     if (num_columns != num_types)
 896     {
 897         r = ERROR_FUNCTION_FAILED;
 898         goto done;
 899     }
 900
 901     records = msi_alloc(sizeof(LPWSTR *));
 902     if (!records)
 903     {
 904         r = ERROR_OUTOFMEMORY;
 905         goto done;
 906     }
 907
 908     /* read in the table records */
 909     while (*ptr)
 910     {
 911         msi_parse_line( &ptr, &records[num_records], NULL );
 912
 913         num_records++;
 914         temp_records = msi_realloc(records, (num_records + 1) * sizeof(LPWSTR *));
 915         if (!temp_records)
 916         {
 917             r = ERROR_OUTOFMEMORY;
 918             goto done;
 919         }
 920         records = temp_records;
 921     }
 922
 923     if (!strcmpW(labels[0], suminfo))
 924     {
 925         r = msi_add_suminfo( db, records, num_records, num_columns );
 926         if (r != ERROR_SUCCESS)
 927         {
 928             r = ERROR_FUNCTION_FAILED;
 929             goto done;
 930         }
 931     }
 932     else
 933     {
 934         if (!TABLE_Exists(db, labels[0]))
 935         {
 936             r = msi_add_table_to_db( db, columns, types, labels, num_labels, num_columns );
 937             if (r != ERROR_SUCCESS)
 938             {
 939                 r = ERROR_FUNCTION_FAILED;
 940                 goto done;
 941             }
 942         }
 943
 944         r = msi_add_records_to_table( db, columns, types, labels, records, num_columns, num_records, path );
 945     }
 946
 947 done:
 948     msi_free(path);
 949     msi_free(data);
 950     msi_free(columns);
 951     msi_free(types);
 952     msi_free(labels);
 953
 954     for (i = 0; i < num_records; i++)
 955         msi_free(records[i]);
 956
 957     msi_free(records);
 958
 959     return r;
 960 }
 961
 962 UINT WINAPI MsiDatabaseImportW(MSIHANDLE handle, LPCWSTR szFolder, LPCWSTR szFilename)
 963 {
 964     MSIDATABASE *db;
 965     UINT r;
 966
 967     TRACE("%x %s %s\n",handle,debugstr_w(szFolder), debugstr_w(szFilename));
 968
 969     db = msihandle2msiinfo( handle, MSIHANDLETYPE_DATABASE );
 970     if( !db )
 971     {
 972         IWineMsiRemoteDatabase *remote_database;
 973
 974         remote_database = (IWineMsiRemoteDatabase *)msi_get_remote( handle );
 975         if ( !remote_database )
 976             return ERROR_INVALID_HANDLE;
 977
 978         IWineMsiRemoteDatabase_Release( remote_database );
 979         WARN("MsiDatabaseImport not allowed during a custom action!\n");
 980
 981         return ERROR_SUCCESS;
 982     }
 983
 984     r = MSI_DatabaseImport( db, szFolder, szFilename );
 985     msiobj_release( &db->hdr );
 986     return r;
 987 }
 988
 989 UINT WINAPI MsiDatabaseImportA( MSIHANDLE handle,
 990                LPCSTR szFolder, LPCSTR szFilename )
 991 {
 992     LPWSTR path = NULL, file = NULL;
 993     UINT r = ERROR_OUTOFMEMORY;
 994
 995     TRACE("%x %s %s\n", handle, debugstr_a(szFolder), debugstr_a(szFilename));
 996
 997     if( szFolder )
 998     {
 999         path = strdupAtoW( szFolder );
1000         if( !path )
1001             goto end;
1002     }
1003
1004     if( szFilename )
1005     {
1006         file = strdupAtoW( szFilename );
1007         if( !file )
1008             goto end;
1009     }
1010
1011     r = MsiDatabaseImportW( handle, path, file );
1012
1013 end:
1014     msi_free( path );
1015     msi_free( file );
1016
1017     return r;
1018 }
1019
1020 static UINT msi_export_record( HANDLE handle, MSIRECORD *row, UINT start )
1021 {
1022     UINT i, count, len, r = ERROR_SUCCESS;
1023     const char *sep;
1024     char *buffer;
1025     DWORD sz;
1026
1027     len = 0x100;
1028     buffer = msi_alloc( len );
1029     if ( !buffer )
1030         return ERROR_OUTOFMEMORY;
1031
1032     count = MSI_RecordGetFieldCount( row );
1033     for ( i=start; i<=count; i++ )
1034     {
1035         sz = len;
1036         r = MSI_RecordGetStringA( row, i, buffer, &sz );
1037         if (r == ERROR_MORE_DATA)
1038         {
1039             char *p = msi_realloc( buffer, sz + 1 );
1040             if (!p)
1041                 break;
1042             len = sz + 1;
1043             buffer = p;
1044         }
1045         sz = len;
1046         r = MSI_RecordGetStringA( row, i, buffer, &sz );
1047         if (r != ERROR_SUCCESS)
1048             break;
1049
1050         if (!WriteFile( handle, buffer, sz, &sz, NULL ))
1051         {
1052             r = ERROR_FUNCTION_FAILED;
1053             break;
1054         }
1055
1056         sep = (i < count) ? "\t" : "\r\n";
1057         if (!WriteFile( handle, sep, strlen(sep), &sz, NULL ))
1058         {
1059             r = ERROR_FUNCTION_FAILED;
1060             break;
1061         }
1062     }
1063     msi_free( buffer );
1064     return r;
1065 }
1066
1067 static UINT msi_export_row( MSIRECORD *row, void *arg )
1068 {
1069     return msi_export_record( arg, row, 1 );
1070 }
1071
1072 static UINT msi_export_forcecodepage( HANDLE handle )
1073 {
1074     DWORD sz;
1075
1076     static const char data[] = "\r\n\r\n0\t_ForceCodepage\r\n";
1077
1078     FIXME("Read the codepage from the strings table!\n");
1079
1080     sz = lstrlenA(data) + 1;
1081     if (!WriteFile(handle, data, sz, &sz, NULL))
1082         return ERROR_FUNCTION_FAILED;
1083
1084     return ERROR_SUCCESS;
1085 }
1086
1087 static UINT MSI_DatabaseExport( MSIDATABASE *db, LPCWSTR table,
1088                LPCWSTR folder, LPCWSTR file )
1089 {
1090     static const WCHAR query[] = {
1091         's','e','l','e','c','t',' ','*',' ','f','r','o','m',' ','%','s',0 };
1092     static const WCHAR forcecodepage[] = {
1093         '_','F','o','r','c','e','C','o','d','e','p','a','g','e',0 };
1094     MSIRECORD *rec = NULL;
1095     MSIQUERY *view = NULL;
1096     LPWSTR filename;
1097     HANDLE handle;
1098     UINT len, r;
1099
1100     TRACE("%p %s %s %s\n", db, debugstr_w(table),
1101           debugstr_w(folder), debugstr_w(file) );
1102
1103     if( folder == NULL || file == NULL )
1104         return ERROR_INVALID_PARAMETER;
1105
1106     len = lstrlenW(folder) + lstrlenW(file) + 2;
1107     filename = msi_alloc(len * sizeof (WCHAR));
1108     if (!filename)
1109         return ERROR_OUTOFMEMORY;
1110
1111     lstrcpyW( filename, folder );
1112     lstrcatW( filename, szBackSlash );
1113     lstrcatW( filename, file );
1114
1115     handle = CreateFileW( filename, GENERIC_READ | GENERIC_WRITE, 0,
1116                           NULL, CREATE_ALWAYS, FILE_ATTRIBUTE_NORMAL, NULL );
1117     msi_free( filename );
1118     if (handle == INVALID_HANDLE_VALUE)
1119         return ERROR_FUNCTION_FAILED;
1120
1121     if (!lstrcmpW( table, forcecodepage ))
1122     {
1123         r = msi_export_forcecodepage( handle );
1124         goto done;
1125     }
1126
1127     r = MSI_OpenQuery( db, &view, query, table );
1128     if (r == ERROR_SUCCESS)
1129     {
1130         /* write out row 1, the column names */
1131         r = MSI_ViewGetColumnInfo(view, MSICOLINFO_NAMES, &rec);
1132         if (r == ERROR_SUCCESS)
1133         {
1134             msi_export_record( handle, rec, 1 );
1135             msiobj_release( &rec->hdr );
1136         }
1137
1138         /* write out row 2, the column types */
1139         r = MSI_ViewGetColumnInfo(view, MSICOLINFO_TYPES, &rec);
1140         if (r == ERROR_SUCCESS)
1141         {
1142             msi_export_record( handle, rec, 1 );
1143             msiobj_release( &rec->hdr );
1144         }
1145
1146         /* write out row 3, the table name + keys */
1147         r = MSI_DatabaseGetPrimaryKeys( db, table, &rec );
1148         if (r == ERROR_SUCCESS)
1149         {
1150             MSI_RecordSetStringW( rec, 0, table );
1151             msi_export_record( handle, rec, 0 );
1152             msiobj_release( &rec->hdr );
1153         }
1154
1155         /* write out row 4 onwards, the data */
1156         r = MSI_IterateRecords( view, 0, msi_export_row, handle );
1157         msiobj_release( &view->hdr );
1158     }
1159
1160 done:
1161     CloseHandle( handle );
1162     return r;
1163 }
1164
1165 /***********************************************************************
1166  * MsiExportDatabaseW        [MSI.@]
1167  *
1168  * Writes a file containing the table data as tab separated ASCII.
1169  *
1170  * The format is as follows:
1171  *
1172  * row1 : colname1 <tab> colname2 <tab> .... colnameN <cr> <lf>
1173  * row2 : coltype1 <tab> coltype2 <tab> .... coltypeN <cr> <lf>
1174  * row3 : tablename <tab> key1 <tab> key2 <tab> ... keyM <cr> <lf>
1175  *
1176  * Followed by the data, starting at row 1 with one row per line
1177  *
1178  * row4 : data <tab> data <tab> data <tab> ... data <cr> <lf>
1179  */
1180 UINT WINAPI MsiDatabaseExportW( MSIHANDLE handle, LPCWSTR szTable,
1181                LPCWSTR szFolder, LPCWSTR szFilename )
1182 {
1183     MSIDATABASE *db;
1184     UINT r;
1185
1186     TRACE("%x %s %s %s\n", handle, debugstr_w(szTable),
1187           debugstr_w(szFolder), debugstr_w(szFilename));
1188
1189     db = msihandle2msiinfo( handle, MSIHANDLETYPE_DATABASE );
1190     if( !db )
1191     {
1192         IWineMsiRemoteDatabase *remote_database;
1193
1194         remote_database = (IWineMsiRemoteDatabase *)msi_get_remote( handle );
1195         if ( !remote_database )
1196             return ERROR_INVALID_HANDLE;
1197
1198         IWineMsiRemoteDatabase_Release( remote_database );
1199         WARN("MsiDatabaseExport not allowed during a custom action!\n");
1200
1201         return ERROR_SUCCESS;
1202     }
1203
1204     r = MSI_DatabaseExport( db, szTable, szFolder, szFilename );
1205     msiobj_release( &db->hdr );
1206     return r;
1207 }
1208
1209 UINT WINAPI MsiDatabaseExportA( MSIHANDLE handle, LPCSTR szTable,
1210                LPCSTR szFolder, LPCSTR szFilename )
1211 {
1212     LPWSTR path = NULL, file = NULL, table = NULL;
1213     UINT r = ERROR_OUTOFMEMORY;
1214
1215     TRACE("%x %s %s %s\n", handle, debugstr_a(szTable),
1216           debugstr_a(szFolder), debugstr_a(szFilename));
1217
1218     if( szTable )
1219     {
1220         table = strdupAtoW( szTable );
1221         if( !table )
1222             goto end;
1223     }
1224
1225     if( szFolder )
1226     {
1227         path = strdupAtoW( szFolder );
1228         if( !path )
1229             goto end;
1230     }
1231
1232     if( szFilename )
1233     {
1234         file = strdupAtoW( szFilename );
1235         if( !file )
1236             goto end;
1237     }
1238
1239     r = MsiDatabaseExportW( handle, table, path, file );
1240
1241 end:
1242     msi_free( table );
1243     msi_free( path );
1244     msi_free( file );
1245
1246     return r;
1247 }
1248
1249 UINT WINAPI MsiDatabaseMergeA(MSIHANDLE hDatabase, MSIHANDLE hDatabaseMerge,
1250                               LPCSTR szTableName)
1251 {
1252     UINT r;
1253     LPWSTR table;
1254
1255     TRACE("(%d, %d, %s)\n", hDatabase, hDatabaseMerge,
1256           debugstr_a(szTableName));
1257
1258     table = strdupAtoW(szTableName);
1259     r = MsiDatabaseMergeW(hDatabase, hDatabaseMerge, table);
1260
1261     msi_free(table);
1262     return r;
1263 }
1264
1265 typedef struct _tagMERGETABLE
1266 {
1267     struct list entry;
1268     struct list rows;
1269     LPWSTR name;
1270     DWORD numconflicts;
1271     LPWSTR *columns;
1272     DWORD numcolumns;
1273     LPWSTR *types;
1274     DWORD numtypes;
1275     LPWSTR *labels;
1276     DWORD numlabels;
1277 } MERGETABLE;
1278
1279 typedef struct _tagMERGEROW
1280 {
1281     struct list entry;
1282     MSIRECORD *data;
1283 } MERGEROW;
1284
1285 typedef struct _tagMERGEDATA
1286 {
1287     MSIDATABASE *db;
1288     MSIDATABASE *merge;
1289     MERGETABLE *curtable;
1290     MSIQUERY *curview;
1291     struct list *tabledata;
1292 } MERGEDATA;
1293
1294 static BOOL merge_type_match(LPCWSTR type1, LPCWSTR type2)
1295 {
1296     if (((type1[0] == 'l') || (type1[0] == 's')) &&
1297         ((type2[0] == 'l') || (type2[0] == 's')))
1298         return TRUE;
1299
1300     if (((type1[0] == 'L') || (type1[0] == 'S')) &&
1301         ((type2[0] == 'L') || (type2[0] == 'S')))
1302         return TRUE;
1303
1304     return !lstrcmpW(type1, type2);
1305 }
1306
1307 static UINT merge_verify_colnames(MSIQUERY *dbview, MSIQUERY *mergeview)
1308 {
1309     MSIRECORD *dbrec, *mergerec;
1310     UINT r, i, count;
1311
1312     r = MSI_ViewGetColumnInfo(dbview, MSICOLINFO_NAMES, &dbrec);
1313     if (r != ERROR_SUCCESS)
1314         return r;
1315
1316     r = MSI_ViewGetColumnInfo(mergeview, MSICOLINFO_NAMES, &mergerec);
1317     if (r != ERROR_SUCCESS)
1318         return r;
1319
1320     count = MSI_RecordGetFieldCount(dbrec);
1321     for (i = 1; i <= count; i++)
1322     {
1323         if (!MSI_RecordGetString(mergerec, i))
1324             break;
1325
1326         if (lstrcmpW(MSI_RecordGetString(dbrec, i),
1327                      MSI_RecordGetString(mergerec, i)))
1328         {
1329             r = ERROR_DATATYPE_MISMATCH;
1330             goto done;
1331         }
1332     }
1333
1334     msiobj_release(&dbrec->hdr);
1335     msiobj_release(&mergerec->hdr);
1336     dbrec = mergerec = NULL;
1337
1338     r = MSI_ViewGetColumnInfo(dbview, MSICOLINFO_TYPES, &dbrec);
1339     if (r != ERROR_SUCCESS)
1340         return r;
1341
1342     r = MSI_ViewGetColumnInfo(mergeview, MSICOLINFO_TYPES, &mergerec);
1343     if (r != ERROR_SUCCESS)
1344         return r;
1345
1346     count = MSI_RecordGetFieldCount(dbrec);
1347     for (i = 1; i <= count; i++)
1348     {
1349         if (!MSI_RecordGetString(mergerec, i))
1350             break;
1351
1352         if (!merge_type_match(MSI_RecordGetString(dbrec, i),
1353                      MSI_RecordGetString(mergerec, i)))
1354         {
1355             r = ERROR_DATATYPE_MISMATCH;
1356             break;
1357         }
1358     }
1359
1360 done:
1361     msiobj_release(&dbrec->hdr);
1362     msiobj_release(&mergerec->hdr);
1363
1364     return r;
1365 }
1366
1367 static UINT merge_verify_primary_keys(MSIDATABASE *db, MSIDATABASE *mergedb,
1368                                       LPCWSTR table)
1369 {
1370     MSIRECORD *dbrec, *mergerec = NULL;
1371     UINT r, i, count;
1372
1373     r = MSI_DatabaseGetPrimaryKeys(db, table, &dbrec);
1374     if (r != ERROR_SUCCESS)
1375         return r;
1376
1377     r = MSI_DatabaseGetPrimaryKeys(mergedb, table, &mergerec);
1378     if (r != ERROR_SUCCESS)
1379         goto done;
1380
1381     count = MSI_RecordGetFieldCount(dbrec);
1382     if (count != MSI_RecordGetFieldCount(mergerec))
1383     {
1384         r = ERROR_DATATYPE_MISMATCH;
1385         goto done;
1386     }
1387
1388     for (i = 1; i <= count; i++)
1389     {
1390         if (lstrcmpW(MSI_RecordGetString(dbrec, i),
1391                      MSI_RecordGetString(mergerec, i)))
1392         {
1393             r = ERROR_DATATYPE_MISMATCH;
1394             goto done;
1395         }
1396     }
1397
1398 done:
1399     msiobj_release(&dbrec->hdr);
1400     msiobj_release(&mergerec->hdr);
1401
1402     return r;
1403 }
1404
1405 static LPWSTR get_key_value(MSIQUERY *view, LPCWSTR key, MSIRECORD *rec)
1406 {
1407     MSIRECORD *colnames;
1408     LPWSTR str, val;
1409     UINT r, i = 0, sz = 0;
1410     int cmp;
1411
1412     r = MSI_ViewGetColumnInfo(view, MSICOLINFO_NAMES, &colnames);
1413     if (r != ERROR_SUCCESS)
1414         return NULL;
1415
1416     do
1417     {
1418         str = msi_dup_record_field(colnames, ++i);
1419         cmp = lstrcmpW(key, str);
1420         msi_free(str);
1421     } while (cmp);
1422
1423     msiobj_release(&colnames->hdr);
1424
1425     r = MSI_RecordGetStringW(rec, i, NULL, &sz);
1426     if (r != ERROR_SUCCESS)
1427         return NULL;
1428     sz++;
1429
1430     if (MSI_RecordGetString(rec, i))  /* check record field is a string */
1431     {
1432         /* quote string record fields */
1433         const WCHAR szQuote[] = {'\'', 0};
1434         sz += 2;
1435         val = msi_alloc(sz*sizeof(WCHAR));
1436         if (!val)
1437             return NULL;
1438
1439         lstrcpyW(val, szQuote);
1440         r = MSI_RecordGetStringW(rec, i, val+1, &sz);
1441         lstrcpyW(val+1+sz, szQuote);
1442     }
1443     else
1444     {
1445         /* do not quote integer record fields */
1446         val = msi_alloc(sz*sizeof(WCHAR));
1447         if (!val)
1448             return NULL;
1449
1450         r = MSI_RecordGetStringW(rec, i, val, &sz);
1451     }
1452
1453     if (r != ERROR_SUCCESS)
1454     {
1455         ERR("failed to get string!\n");
1456         msi_free(val);
1457         return NULL;
1458     }
1459
1460     return val;
1461 }
1462
1463 static LPWSTR create_diff_row_query(MSIDATABASE *merge, MSIQUERY *view,
1464                                     LPWSTR table, MSIRECORD *rec)
1465 {
1466     LPWSTR query = NULL, clause = NULL;
1467     LPWSTR ptr = NULL, val;
1468     LPCWSTR setptr;
1469     DWORD size = 1, oldsize;
1470     LPCWSTR key;
1471     MSIRECORD *keys;
1472     UINT r, i, count;
1473
1474     static const WCHAR keyset[] = {
1475         '`','%','s','`',' ','=',' ','%','s',' ','A','N','D',' ',0};
1476     static const WCHAR lastkeyset[] = {
1477         '`','%','s','`',' ','=',' ','%','s',' ',0};
1478     static const WCHAR fmt[] = {'S','E','L','E','C','T',' ','*',' ',
1479         'F','R','O','M',' ','`','%','s','`',' ',
1480         'W','H','E','R','E',' ','%','s',0};
1481
1482     r = MSI_DatabaseGetPrimaryKeys(merge, table, &keys);
1483     if (r != ERROR_SUCCESS)
1484         return NULL;
1485
1486     clause = msi_alloc_zero(size * sizeof(WCHAR));
1487     if (!clause)
1488         goto done;
1489
1490     ptr = clause;
1491     count = MSI_RecordGetFieldCount(keys);
1492     for (i = 1; i <= count; i++)
1493     {
1494         key = MSI_RecordGetString(keys, i);
1495         val = get_key_value(view, key, rec);
1496
1497         if (i == count)
1498             setptr = lastkeyset;
1499         else
1500             setptr = keyset;
1501
1502         oldsize = size;
1503         size += lstrlenW(setptr) + lstrlenW(key) + lstrlenW(val) - 4;
1504         clause = msi_realloc(clause, size * sizeof (WCHAR));
1505         if (!clause)
1506         {
1507             msi_free(val);
1508             goto done;
1509         }
1510
1511         ptr = clause + oldsize - 1;
1512         sprintfW(ptr, setptr, key, val);
1513         msi_free(val);
1514     }
1515
1516     size = lstrlenW(fmt) + lstrlenW(table) + lstrlenW(clause) + 1;
1517     query = msi_alloc(size * sizeof(WCHAR));
1518     if (!query)
1519         goto done;
1520
1521     sprintfW(query, fmt, table, clause);
1522
1523 done:
1524     msi_free(clause);
1525     msiobj_release(&keys->hdr);
1526     return query;
1527 }
1528
1529 static UINT merge_diff_row(MSIRECORD *rec, LPVOID param)
1530 {
1531     MERGEDATA *data = param;
1532     MERGETABLE *table = data->curtable;
1533     MERGEROW *mergerow;
1534     MSIQUERY *dbview = NULL;
1535     MSIRECORD *row = NULL;
1536     LPWSTR query = NULL;
1537     UINT r = ERROR_SUCCESS;
1538
1539     if (TABLE_Exists(data->db, table->name))
1540     {
1541         query = create_diff_row_query(data->merge, data->curview, table->name, rec);
1542         if (!query)
1543             return ERROR_OUTOFMEMORY;
1544
1545         r = MSI_DatabaseOpenViewW(data->db, query, &dbview);
1546         if (r != ERROR_SUCCESS)
1547             goto done;
1548
1549         r = MSI_ViewExecute(dbview, NULL);
1550         if (r != ERROR_SUCCESS)
1551             goto done;
1552
1553         r = MSI_ViewFetch(dbview, &row);
1554         if (r == ERROR_SUCCESS && !MSI_RecordsAreEqual(rec, row))
1555         {
1556             table->numconflicts++;
1557             goto done;
1558         }
1559         else if (r != ERROR_NO_MORE_ITEMS)
1560             goto done;
1561
1562         r = ERROR_SUCCESS;
1563     }
1564
1565     mergerow = msi_alloc(sizeof(MERGEROW));
1566     if (!mergerow)
1567     {
1568         r = ERROR_OUTOFMEMORY;
1569         goto done;
1570     }
1571
1572     mergerow->data = MSI_CloneRecord(rec);
1573     if (!mergerow->data)
1574     {
1575         r = ERROR_OUTOFMEMORY;
1576         msi_free(mergerow);
1577         goto done;
1578     }
1579
1580     list_add_tail(&table->rows, &mergerow->entry);
1581
1582 done:
1583     msi_free(query);
1584     msiobj_release(&row->hdr);
1585     msiobj_release(&dbview->hdr);
1586     return r;
1587 }
1588
1589 static UINT msi_get_table_labels(MSIDATABASE *db, LPCWSTR table, LPWSTR **labels, DWORD *numlabels)
1590 {
1591     UINT r, i, count;
1592     MSIRECORD *prec = NULL;
1593
1594     r = MSI_DatabaseGetPrimaryKeys(db, table, &prec);
1595     if (r != ERROR_SUCCESS)
1596         return r;
1597
1598     count = MSI_RecordGetFieldCount(prec);
1599     *numlabels = count + 1;
1600     *labels = msi_alloc((*numlabels)*sizeof(LPWSTR));
1601     if (!*labels)
1602     {
1603         r = ERROR_OUTOFMEMORY;
1604         goto end;
1605     }
1606
1607     (*labels)[0] = strdupW(table);
1608     for (i=1; i<=count; i++ )
1609     {
1610         (*labels)[i] = strdupW(MSI_RecordGetString(prec, i));
1611     }
1612
1613 end:
1614     msiobj_release( &prec->hdr );
1615     return r;
1616 }
1617
1618 static UINT msi_get_query_columns(MSIQUERY *query, LPWSTR **columns, DWORD *numcolumns)
1619 {
1620     UINT r, i, count;
1621     MSIRECORD *prec = NULL;
1622
1623     r = MSI_ViewGetColumnInfo(query, MSICOLINFO_NAMES, &prec);
1624     if (r != ERROR_SUCCESS)
1625         return r;
1626
1627     count = MSI_RecordGetFieldCount(prec);
1628     *columns = msi_alloc(count*sizeof(LPWSTR));
1629     if (!*columns)
1630     {
1631         r = ERROR_OUTOFMEMORY;
1632         goto end;
1633     }
1634
1635     for (i=1; i<=count; i++ )
1636     {
1637         (*columns)[i-1] = strdupW(MSI_RecordGetString(prec, i));
1638     }
1639
1640     *numcolumns = count;
1641
1642 end:
1643     msiobj_release( &prec->hdr );
1644     return r;
1645 }
1646
1647 static UINT msi_get_query_types(MSIQUERY *query, LPWSTR **types, DWORD *numtypes)
1648 {
1649     UINT r, i, count;
1650     MSIRECORD *prec = NULL;
1651
1652     r = MSI_ViewGetColumnInfo(query, MSICOLINFO_TYPES, &prec);
1653     if (r != ERROR_SUCCESS)
1654         return r;
1655
1656     count = MSI_RecordGetFieldCount(prec);
1657     *types = msi_alloc(count*sizeof(LPWSTR));
1658     if (!*types)
1659     {
1660         r = ERROR_OUTOFMEMORY;
1661         goto end;
1662     }
1663
1664     *numtypes = count;
1665     for (i=1; i<=count; i++ )
1666     {
1667         (*types)[i-1] = strdupW(MSI_RecordGetString(prec, i));
1668     }
1669
1670 end:
1671     msiobj_release( &prec->hdr );
1672     return r;
1673 }
1674
1675 static void merge_free_rows(MERGETABLE *table)
1676 {
1677     struct list *item, *cursor;
1678
1679     LIST_FOR_EACH_SAFE(item, cursor, &table->rows)
1680     {
1681         MERGEROW *row = LIST_ENTRY(item, MERGEROW, entry);
1682
1683         list_remove(&row->entry);
1684         msiobj_release(&row->data->hdr);
1685         msi_free(row);
1686     }
1687 }
1688
1689 static void free_merge_table(MERGETABLE *table)
1690 {
1691     UINT i;
1692
1693     if (table->labels != NULL)
1694     {
1695         for (i = 0; i < table->numlabels; i++)
1696             msi_free(table->labels[i]);
1697
1698         msi_free(table->labels);
1699     }
1700
1701     if (table->columns != NULL)
1702     {
1703         for (i = 0; i < table->numcolumns; i++)
1704             msi_free(table->columns[i]);
1705
1706         msi_free(table->columns);
1707     }
1708
1709     if (table->types != NULL)
1710     {
1711         for (i = 0; i < table->numtypes; i++)
1712             msi_free(table->types[i]);
1713
1714         msi_free(table->types);
1715     }
1716
1717     msi_free(table->name);
1718     merge_free_rows(table);
1719
1720     msi_free(table);
1721 }
1722
1723 static UINT msi_get_merge_table (MSIDATABASE *db, LPCWSTR name, MERGETABLE **ptable)
1724 {
1725     UINT r;
1726     MERGETABLE *table;
1727     MSIQUERY *mergeview = NULL;
1728
1729     static const WCHAR query[] = {'S','E','L','E','C','T',' ','*',' ',
1730         'F','R','O','M',' ','`','%','s','`',0};
1731
1732     table = msi_alloc_zero(sizeof(MERGETABLE));
1733     if (!table)
1734     {
1735        *ptable = NULL;
1736        return ERROR_OUTOFMEMORY;
1737     }
1738
1739     r = msi_get_table_labels(db, name, &table->labels, &table->numlabels);
1740     if (r != ERROR_SUCCESS)
1741         goto err;
1742
1743     r = MSI_OpenQuery(db, &mergeview, query, name);
1744     if (r != ERROR_SUCCESS)
1745         goto err;
1746
1747     r = msi_get_query_columns(mergeview, &table->columns, &table->numcolumns);
1748     if (r != ERROR_SUCCESS)
1749         goto err;
1750
1751     r = msi_get_query_types(mergeview, &table->types, &table->numtypes);
1752     if (r != ERROR_SUCCESS)
1753         goto err;
1754
1755     list_init(&table->rows);
1756
1757     table->name = strdupW(name);
1758     table->numconflicts = 0;
1759
1760     msiobj_release(&mergeview->hdr);
1761     *ptable = table;
1762     return ERROR_SUCCESS;
1763
1764 err:
1765     msiobj_release(&mergeview->hdr);
1766     free_merge_table(table);
1767     *ptable = NULL;
1768     return r;
1769 }
1770
1771 static UINT merge_diff_tables(MSIRECORD *rec, LPVOID param)
1772 {
1773     MERGEDATA *data = param;
1774     MERGETABLE *table;
1775     MSIQUERY *dbview = NULL;
1776     MSIQUERY *mergeview = NULL;
1777     LPCWSTR name;
1778     UINT r;
1779
1780     static const WCHAR query[] = {'S','E','L','E','C','T',' ','*',' ',
1781         'F','R','O','M',' ','`','%','s','`',0};
1782
1783     name = MSI_RecordGetString(rec, 1);
1784
1785     r = MSI_OpenQuery(data->merge, &mergeview, query, name);
1786     if (r != ERROR_SUCCESS)
1787         goto done;
1788
1789     if (TABLE_Exists(data->db, name))
1790     {
1791         r = MSI_OpenQuery(data->db, &dbview, query, name);
1792         if (r != ERROR_SUCCESS)
1793             goto done;
1794
1795         r = merge_verify_colnames(dbview, mergeview);
1796         if (r != ERROR_SUCCESS)
1797             goto done;
1798
1799         r = merge_verify_primary_keys(data->db, data->merge, name);
1800         if (r != ERROR_SUCCESS)
1801             goto done;
1802     }
1803
1804     r = msi_get_merge_table(data->merge, name, &table);
1805     if (r != ERROR_SUCCESS)
1806         goto done;
1807
1808     data->curtable = table;
1809     data->curview = mergeview;
1810     r = MSI_IterateRecords(mergeview, NULL, merge_diff_row, data);
1811     if (r != ERROR_SUCCESS)
1812     {
1813         free_merge_table(table);
1814         goto done;
1815     }
1816
1817     list_add_tail(data->tabledata, &table->entry);
1818
1819 done:
1820     msiobj_release(&dbview->hdr);
1821     msiobj_release(&mergeview->hdr);
1822     return r;
1823 }
1824
1825 static UINT gather_merge_data(MSIDATABASE *db, MSIDATABASE *merge,
1826                               struct list *tabledata)
1827 {
1828     UINT r;
1829     MSIQUERY *view;
1830     MERGEDATA data;
1831
1832     static const WCHAR query[] = {'S','E','L','E','C','T',' ','*',' ',
1833         'F','R','O','M',' ','`','_','T','a','b','l','e','s','`',0};
1834
1835     r = MSI_DatabaseOpenViewW(merge, query, &view);
1836     if (r != ERROR_SUCCESS)
1837         return r;
1838
1839     data.db = db;
1840     data.merge = merge;
1841     data.tabledata = tabledata;
1842     r = MSI_IterateRecords(view, NULL, merge_diff_tables, &data);
1843
1844     msiobj_release(&view->hdr);
1845     return r;
1846 }
1847
1848 static UINT merge_table(MSIDATABASE *db, MERGETABLE *table)
1849 {
1850     UINT r;
1851     MERGEROW *row;
1852     MSIVIEW *tv;
1853
1854     if (!TABLE_Exists(db, table->name))
1855     {
1856         r = msi_add_table_to_db(db, table->columns, table->types,
1857                table->labels, table->numlabels, table->numcolumns);
1858         if (r != ERROR_SUCCESS)
1859            return ERROR_FUNCTION_FAILED;
1860     }
1861
1862     LIST_FOR_EACH_ENTRY(row, &table->rows, MERGEROW, entry)
1863     {
1864         r = TABLE_CreateView(db, table->name, &tv);
1865         if (r != ERROR_SUCCESS)
1866             return r;
1867
1868         r = tv->ops->insert_row(tv, row->data, -1, FALSE);
1869         tv->ops->delete(tv);
1870
1871         if (r != ERROR_SUCCESS)
1872             return r;
1873     }
1874
1875     return ERROR_SUCCESS;
1876 }
1877
1878 static UINT update_merge_errors(MSIDATABASE *db, LPCWSTR error,
1879                                 LPWSTR table, DWORD numconflicts)
1880 {
1881     UINT r;
1882     MSIQUERY *view;
1883
1884     static const WCHAR create[] = {
1885         'C','R','E','A','T','E',' ','T','A','B','L','E',' ',
1886         '`','%','s','`',' ','(','`','T','a','b','l','e','`',' ',
1887         'C','H','A','R','(','2','5','5',')',' ','N','O','T',' ',
1888         'N','U','L','L',',',' ','`','N','u','m','R','o','w','M','e','r','g','e',
1889         'C','o','n','f','l','i','c','t','s','`',' ','S','H','O','R','T',' ',
1890         'N','O','T',' ','N','U','L','L',' ','P','R','I','M','A','R','Y',' ',
1891         'K','E','Y',' ','`','T','a','b','l','e','`',')',0};
1892     static const WCHAR insert[] = {
1893         'I','N','S','E','R','T',' ','I','N','T','O',' ',
1894         '`','%','s','`',' ','(','`','T','a','b','l','e','`',',',' ',
1895         '`','N','u','m','R','o','w','M','e','r','g','e',
1896         'C','o','n','f','l','i','c','t','s','`',')',' ','V','A','L','U','E','S',
1897         ' ','(','\'','%','s','\'',',',' ','%','d',')',0};
1898
1899     if (!TABLE_Exists(db, error))
1900     {
1901         r = MSI_OpenQuery(db, &view, create, error);
1902         if (r != ERROR_SUCCESS)
1903             return r;
1904
1905         r = MSI_ViewExecute(view, NULL);
1906         msiobj_release(&view->hdr);
1907         if (r != ERROR_SUCCESS)
1908             return r;
1909     }
1910
1911     r = MSI_OpenQuery(db, &view, insert, error, table, numconflicts);
1912     if (r != ERROR_SUCCESS)
1913         return r;
1914
1915     r = MSI_ViewExecute(view, NULL);
1916     msiobj_release(&view->hdr);
1917     return r;
1918 }
1919
1920 UINT WINAPI MsiDatabaseMergeW(MSIHANDLE hDatabase, MSIHANDLE hDatabaseMerge,
1921                               LPCWSTR szTableName)
1922 {
1923     struct list tabledata = LIST_INIT(tabledata);
1924     struct list *item, *cursor;
1925     MSIDATABASE *db, *merge;
1926     MERGETABLE *table;
1927     BOOL conflicts;
1928     UINT r;
1929
1930     TRACE("(%d, %d, %s)\n", hDatabase, hDatabaseMerge,
1931           debugstr_w(szTableName));
1932
1933     if (szTableName && !*szTableName)
1934         return ERROR_INVALID_TABLE;
1935
1936     db = msihandle2msiinfo(hDatabase, MSIHANDLETYPE_DATABASE);
1937     merge = msihandle2msiinfo(hDatabaseMerge, MSIHANDLETYPE_DATABASE);
1938     if (!db || !merge)
1939     {
1940         r = ERROR_INVALID_HANDLE;
1941         goto done;
1942     }
1943
1944     r = gather_merge_data(db, merge, &tabledata);
1945     if (r != ERROR_SUCCESS)
1946         goto done;
1947
1948     conflicts = FALSE;
1949     LIST_FOR_EACH_ENTRY(table, &tabledata, MERGETABLE, entry)
1950     {
1951         if (table->numconflicts)
1952         {
1953             conflicts = TRUE;
1954
1955             r = update_merge_errors(db, szTableName, table->name,
1956                                     table->numconflicts);
1957             if (r != ERROR_SUCCESS)
1958                 break;
1959         }
1960         else
1961         {
1962             r = merge_table(db, table);
1963             if (r != ERROR_SUCCESS)
1964                 break;
1965         }
1966     }
1967
1968     LIST_FOR_EACH_SAFE(item, cursor, &tabledata)
1969     {
1970         MERGETABLE *table = LIST_ENTRY(item, MERGETABLE, entry);
1971         list_remove(&table->entry);
1972         free_merge_table(table);
1973     }
1974
1975     if (conflicts)
1976         r = ERROR_FUNCTION_FAILED;
1977
1978 done:
1979     msiobj_release(&db->hdr);
1980     msiobj_release(&merge->hdr);
1981     return r;
1982 }
1983
1984 MSIDBSTATE WINAPI MsiGetDatabaseState( MSIHANDLE handle )
1985 {
1986     MSIDBSTATE ret = MSIDBSTATE_READ;
1987     MSIDATABASE *db;
1988
1989     TRACE("%d\n", handle);
1990
1991     db = msihandle2msiinfo( handle, MSIHANDLETYPE_DATABASE );
1992     if( !db )
1993     {
1994         IWineMsiRemoteDatabase *remote_database;
1995
1996         remote_database = (IWineMsiRemoteDatabase *)msi_get_remote( handle );
1997         if ( !remote_database )
1998             return MSIDBSTATE_ERROR;
1999
2000         IWineMsiRemoteDatabase_Release( remote_database );
2001         WARN("MsiGetDatabaseState not allowed during a custom action!\n");
2002
2003         return MSIDBSTATE_READ;
2004     }
2005
2006     if (db->mode != MSIDBOPEN_READONLY )
2007         ret = MSIDBSTATE_WRITE;
2008     msiobj_release( &db->hdr );
2009
2010     return ret;
2011 }
2012
2013 typedef struct _msi_remote_database_impl {
2014     const IWineMsiRemoteDatabaseVtbl *lpVtbl;
2015     MSIHANDLE database;
2016     LONG refs;
2017 } msi_remote_database_impl;
2018
2019 static inline msi_remote_database_impl* mrd_from_IWineMsiRemoteDatabase( IWineMsiRemoteDatabase* iface )
2020 {
2021     return (msi_remote_database_impl *)iface;
2022 }
2023
2024 static HRESULT WINAPI mrd_QueryInterface( IWineMsiRemoteDatabase *iface,
2025                                           REFIID riid,LPVOID *ppobj)
2026 {
2027     if( IsEqualCLSID( riid, &IID_IUnknown ) ||
2028         IsEqualCLSID( riid, &IID_IWineMsiRemoteDatabase ) )
2029     {
2030         IUnknown_AddRef( iface );
2031         *ppobj = iface;
2032         return S_OK;
2033     }
2034
2035     return E_NOINTERFACE;
2036 }
2037
2038 static ULONG WINAPI mrd_AddRef( IWineMsiRemoteDatabase *iface )
2039 {
2040     msi_remote_database_impl* This = mrd_from_IWineMsiRemoteDatabase( iface );
2041
2042     return InterlockedIncrement( &This->refs );
2043 }
2044
2045 static ULONG WINAPI mrd_Release( IWineMsiRemoteDatabase *iface )
2046 {
2047     msi_remote_database_impl* This = mrd_from_IWineMsiRemoteDatabase( iface );
2048     ULONG r;
2049
2050     r = InterlockedDecrement( &This->refs );
2051     if (r == 0)
2052     {
2053         MsiCloseHandle( This->database );
2054         msi_free( This );
2055     }
2056     return r;
2057 }
2058
2059 static HRESULT WINAPI mrd_IsTablePersistent( IWineMsiRemoteDatabase *iface,
2060                                              LPCWSTR table, MSICONDITION *persistent )
2061 {
2062     msi_remote_database_impl *This = mrd_from_IWineMsiRemoteDatabase( iface );
2063     *persistent = MsiDatabaseIsTablePersistentW(This->database, table);
2064     return S_OK;
2065 }
2066
2067 static HRESULT WINAPI mrd_GetPrimaryKeys( IWineMsiRemoteDatabase *iface,
2068                                           LPCWSTR table, MSIHANDLE *keys )
2069 {
2070     msi_remote_database_impl *This = mrd_from_IWineMsiRemoteDatabase( iface );
2071     UINT r = MsiDatabaseGetPrimaryKeysW(This->database, table, keys);
2072     return HRESULT_FROM_WIN32(r);
2073 }
2074
2075 static HRESULT WINAPI mrd_GetSummaryInformation( IWineMsiRemoteDatabase *iface,
2076                                                 UINT updatecount, MSIHANDLE *suminfo )
2077 {
2078     msi_remote_database_impl *This = mrd_from_IWineMsiRemoteDatabase( iface );
2079     UINT r = MsiGetSummaryInformationW(This->database, NULL, updatecount, suminfo);
2080     return HRESULT_FROM_WIN32(r);
2081 }
2082
2083 static HRESULT WINAPI mrd_OpenView( IWineMsiRemoteDatabase *iface,
2084                                     LPCWSTR query, MSIHANDLE *view )
2085 {
2086     msi_remote_database_impl *This = mrd_from_IWineMsiRemoteDatabase( iface );
2087     UINT r = MsiDatabaseOpenViewW(This->database, query, view);
2088     return HRESULT_FROM_WIN32(r);
2089 }
2090
2091 static HRESULT WINAPI mrd_SetMsiHandle( IWineMsiRemoteDatabase *iface, MSIHANDLE handle )
2092 {
2093     msi_remote_database_impl* This = mrd_from_IWineMsiRemoteDatabase( iface );
2094     This->database = handle;
2095     return S_OK;
2096 }
2097
2098 static const IWineMsiRemoteDatabaseVtbl msi_remote_database_vtbl =
2099 {
2100     mrd_QueryInterface,
2101     mrd_AddRef,
2102     mrd_Release,
2103     mrd_IsTablePersistent,
2104     mrd_GetPrimaryKeys,
2105     mrd_GetSummaryInformation,
2106     mrd_OpenView,
2107     mrd_SetMsiHandle,
2108 };
2109
2110 HRESULT create_msi_remote_database( IUnknown *pOuter, LPVOID *ppObj )
2111 {
2112     msi_remote_database_impl *This;
2113
2114     This = msi_alloc( sizeof *This );
2115     if (!This)
2116         return E_OUTOFMEMORY;
2117
2118     This->lpVtbl = &msi_remote_database_vtbl;
2119     This->database = 0;
2120     This->refs = 1;
2121
2122     *ppObj = This;
2123
2124     return S_OK;
2125 }