dlls/oledb32/tests/database.c

   1 /* OLEDB Database tests
   2  *
   3  * Copyright 2012 Alistair Leslie-Hughes
   4  *
   5  * This library is free software; you can redistribute it and/or
   6  * modify it under the terms of the GNU Lesser General Public
   7  * License as published by the Free Software Foundation; either
   8  * version 2.1 of the License, or (at your option) any later version.
   9  *
  10  * This library is distributed in the hope that it will be useful,
  11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  13  * Lesser General Public License for more details.
  14  *
  15  * You should have received a copy of the GNU Lesser General Public
  16  * License along with this library; if not, write to the Free Software
  17  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
  18  */
  19 #include <stdarg.h>
  20
  21 #define COBJMACROS
  22 #define NONAMELESSUNION
  23 #define NONAMELESSSTRUCT
  24
  25 #include "windef.h"
  26 #include "winbase.h"
  27 #include "ole2.h"
  28 #include "msdadc.h"
  29 #include "msdasc.h"
  30 #include "shlobj.h"
  31 #include "initguid.h"
  32
  33 #include "wine/test.h"
  34
  35 DEFINE_GUID(CSLID_MSDAER, 0xc8b522cf,0x5cf3,0x11ce,0xad,0xe5,0x00,0xaa,0x00,0x44,0x77,0x3d);
  36
  37 static WCHAR initstring_default[] = {'D','a','t','a',' ','S','o','u','r','c','e','=','d','u','m','m','y',';',0};
  38
  39 static void test_GetDataSource(WCHAR *initstring)
  40 {
  41     IDataInitialize *datainit = NULL;
  42     IDBInitialize *dbinit = NULL;
  43     HRESULT hr;
  44
  45     trace("Data Source: %s\n", wine_dbgstr_w(initstring));
  46
  47     hr = CoCreateInstance(&CLSID_MSDAINITIALIZE, NULL, CLSCTX_INPROC_SERVER, &IID_IDataInitialize,(void**)&datainit);
  48     ok(hr == S_OK, "got %08x\n", hr);
  49
  50     /* a failure to create data source here may indicate provider is simply not present */
  51     hr = IDataInitialize_GetDataSource(datainit, NULL, CLSCTX_INPROC_SERVER, initstring, &IID_IDBInitialize, (IUnknown**)&dbinit);
  52     if(SUCCEEDED(hr))
  53     {
  54         IDBProperties *props = NULL;
  55         IMalloc *ppM = NULL;
  56
  57         hr = SHGetMalloc(&ppM);
  58         if (FAILED(hr))
  59         {
  60             ok(0, "Couldn't get IMalloc object.\n");
  61             goto end;
  62         }
  63
  64         hr = IDBInitialize_QueryInterface(dbinit, &IID_IDBProperties, (void**)&props);
  65         ok(hr == S_OK, "got %08x\n", hr);
  66         if(SUCCEEDED(hr))
  67         {
  68             ULONG cnt;
  69             DBPROPINFOSET *pInfoset;
  70             OLECHAR *ary;
  71
  72             hr = IDBProperties_GetPropertyInfo(props, 0, NULL, &cnt, &pInfoset, &ary);
  73             todo_wine ok(hr == S_OK, "got %08x\n", hr);
  74             if(hr == S_OK)
  75             {
  76                 ULONG i;
  77                 for(i =0; i < pInfoset->cPropertyInfos; i++)
  78                 {
  79                     trace("(0x%04x) '%s' %d\n", pInfoset->rgPropertyInfos[i].dwPropertyID, wine_dbgstr_w(pInfoset->rgPropertyInfos[i].pwszDescription),
  80                                              pInfoset->rgPropertyInfos[i].vtType);
  81                 }
  82
  83                 IMalloc_Free(ppM, ary);
  84             }
  85
  86             IDBProperties_Release(props);
  87         }
  88
  89         IMalloc_Release(ppM);
  90
  91 end:
  92         IDBInitialize_Release(dbinit);
  93     }
  94
  95     IDataInitialize_Release(datainit);
  96 }
  97
  98 static void test_database(void)
  99 {
 100     static WCHAR initstring_jet[] = {'P','r','o','v','i','d','e','r','=','M','i','c','r','o','s','o','f','t','.',
 101          'J','e','t','.','O','L','E','D','B','.','4','.','0',';',
 102          'D','a','t','a',' ','S','o','u','r','c','e','=','d','u','m','m','y',';',
 103          'P','e','r','s','i','s','t',' ','S','e','c','u','r','i','t','y',' ','I','n','f','o','=','F','a','l','s','e',';',0};
 104     static WCHAR initstring_lower[] = {'d','a','t','a',' ','s','o','u','r','c','e','=','d','u','m','m','y',';',0};
 105     IDataInitialize *datainit = NULL;
 106     HRESULT hr;
 107
 108     hr = CoCreateInstance(&CLSID_MSDAINITIALIZE, NULL, CLSCTX_INPROC_SERVER, &IID_IDataInitialize, (void**)&datainit);
 109     if (FAILED(hr))
 110     {
 111         win_skip("Unable to load oledb library\n");
 112         return;
 113     }
 114     IDataInitialize_Release(datainit);
 115
 116     test_GetDataSource(NULL);
 117     test_GetDataSource(initstring_jet);
 118     test_GetDataSource(initstring_default);
 119     test_GetDataSource(initstring_lower);
 120 }
 121
 122 static void test_errorinfo(void)
 123 {
 124     HRESULT hr;
 125     IUnknown *unk = NULL;
 126
 127     hr = CoCreateInstance(&CSLID_MSDAER, NULL, CLSCTX_INPROC_SERVER, &IID_IUnknown,(void**)&unk);
 128     todo_wine ok(hr == S_OK, "got %08x\n", hr);
 129     if(hr == S_OK)
 130     {
 131         IErrorInfo *errorinfo;
 132
 133         hr = IUnknown_QueryInterface(unk, &IID_IErrorInfo, (void**)&errorinfo);
 134         ok(hr == S_OK, "got %08x\n", hr);
 135         if(hr == S_OK)
 136         {
 137             IErrorInfo_Release(errorinfo);
 138         }
 139
 140         IUnknown_Release(unk);
 141     }
 142 }
 143
 144 static void test_initializationstring(void)
 145 {
 146     static WCHAR initstring_msdasql[] = {'P','r','o','v','i','d','e','r','=','M','S','D','A','S','Q','L','.','1',';',
 147          'D','a','t','a',' ','S','o','u','r','c','e','=','d','u','m','m','y', 0};
 148     static WCHAR initstring_sqloledb[] = {'P','r','o','v','i','d','e','r','=','S','Q','L','O','L','E','D','B','.','1',';',
 149          'D','a','t','a',' ','S','o','u','r','c','e','=','d','u','m','m','y', 0};
 150     IDataInitialize *datainit = NULL;
 151     IDBInitialize *dbinit = NULL;
 152     HRESULT hr;
 153     WCHAR *initstring = NULL;
 154
 155     hr = CoCreateInstance(&CLSID_MSDAINITIALIZE, NULL, CLSCTX_INPROC_SERVER, &IID_IDataInitialize,(void**)&datainit);
 156     ok(hr == S_OK, "got %08x\n", hr);
 157     if(SUCCEEDED(hr))
 158     {
 159         hr = IDataInitialize_GetDataSource(datainit, NULL, CLSCTX_INPROC_SERVER, initstring_default,
 160                                                                 &IID_IDBInitialize, (IUnknown**)&dbinit);
 161         if(SUCCEEDED(hr))
 162         {
 163             hr = IDataInitialize_GetInitializationString(datainit, (IUnknown*)dbinit, 0, &initstring);
 164             ok(hr == S_OK, "got %08x\n", hr);
 165             if(hr == S_OK)
 166             {
 167                 trace("Init String: %s\n", wine_dbgstr_w(initstring));
 168                 todo_wine ok(!lstrcmpW(initstring_msdasql, initstring) ||
 169                              !lstrcmpW(initstring_sqloledb, initstring), "got %s\n", wine_dbgstr_w(initstring));
 170                 CoTaskMemFree(initstring);
 171             }
 172
 173             IDBInitialize_Release(dbinit);
 174         }
 175
 176         IDataInitialize_Release(datainit);
 177     }
 178 }
 179
 180 START_TEST(database)
 181 {
 182     OleInitialize(NULL);
 183
 184     test_database();
 185     test_errorinfo();
 186     test_initializationstring();
 187
 188     OleUninitialize();
 189 }