ReactOS  0.4.15-dev-5463-g138eb58
insert.c
Go to the documentation of this file.
1 /*
2  * Implementation of the Microsoft Installer (msi.dll)
3  *
4  * Copyright 2004 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 #include "windef.h"
24 #include "winbase.h"
25 #include "winerror.h"
26 #include "wine/debug.h"
27 #include "msi.h"
28 #include "msiquery.h"
29 #include "objbase.h"
30 #include "objidl.h"
31 #include "msipriv.h"
32 #include "winnls.h"
33 
34 #include "query.h"
35 
37 
38 
39 /* below is the query interface to a table */
40 
41 typedef struct tagMSIINSERTVIEW
42 {
50 
52 {
54 
55  TRACE("%p %d %d %p\n", iv, row, col, val );
56 
57  return ERROR_FUNCTION_FAILED;
58 }
59 
60 /*
61  * msi_query_merge_record
62  *
63  * Merge a value_list and a record to create a second record.
64  * Replace wildcard entries in the valuelist with values from the record
65  */
67 {
68  MSIRECORD *merged;
69  DWORD wildcard_count = 1, i;
70 
71  merged = MSI_CreateRecord( fields );
72  for( i=1; i <= fields; i++ )
73  {
74  if( !vl )
75  {
76  TRACE("Not enough elements in the list to insert\n");
77  goto err;
78  }
79  switch( vl->val->type )
80  {
81  case EXPR_SVAL:
82  TRACE( "field %lu -> %s\n", i, debugstr_w(vl->val->u.sval) );
83  MSI_RecordSetStringW( merged, i, vl->val->u.sval );
84  break;
85  case EXPR_IVAL:
86  MSI_RecordSetInteger( merged, i, vl->val->u.ival );
87  break;
88  case EXPR_WILDCARD:
89  if( !rec )
90  goto err;
91  MSI_RecordCopyField( rec, wildcard_count, merged, i );
92  wildcard_count++;
93  break;
94  default:
95  ERR("Unknown expression type %d\n", vl->val->type);
96  }
97  vl = vl->next;
98  }
99 
100  return merged;
101 err:
102  msiobj_release( &merged->hdr );
103  return NULL;
104 }
105 
106 /* checks to see if the column order specified in the INSERT query
107  * matches the column order of the table
108  */
110 {
111  LPCWSTR a, b;
112  UINT i;
113 
114  for (i = 1; i <= col_count; i++)
115  {
116  iv->sv->ops->get_column_info(iv->sv, i, &a, NULL, NULL, NULL);
117  iv->table->ops->get_column_info(iv->table, i, &b, NULL, NULL, NULL);
118 
119  if (wcscmp( a, b )) return FALSE;
120  }
121  return TRUE;
122 }
123 
124 /* rearranges the data in the record to be inserted based on column order,
125  * and pads the record for any missing columns in the INSERT query
126  */
128 {
129  MSIRECORD *padded;
130  UINT col_count, val_count;
131  UINT r, i, colidx;
132  LPCWSTR a, b;
133 
134  r = iv->table->ops->get_dimensions(iv->table, NULL, &col_count);
135  if (r != ERROR_SUCCESS)
136  return r;
137 
138  val_count = MSI_RecordGetFieldCount(*values);
139 
140  /* check to see if the columns are arranged already
141  * to avoid unnecessary copying
142  */
143  if (col_count == val_count && msi_columns_in_order(iv, col_count))
144  return ERROR_SUCCESS;
145 
146  padded = MSI_CreateRecord(col_count);
147  if (!padded)
148  return ERROR_OUTOFMEMORY;
149 
150  for (colidx = 1; colidx <= val_count; colidx++)
151  {
152  r = iv->sv->ops->get_column_info(iv->sv, colidx, &a, NULL, NULL, NULL);
153  if (r != ERROR_SUCCESS)
154  goto err;
155 
156  for (i = 1; i <= col_count; i++)
157  {
158  r = iv->table->ops->get_column_info(iv->table, i, &b, NULL,
159  NULL, NULL);
160  if (r != ERROR_SUCCESS)
161  goto err;
162 
163  if (!wcscmp( a, b ))
164  {
165  MSI_RecordCopyField(*values, colidx, padded, i);
166  break;
167  }
168  }
169  }
170  msiobj_release(&(*values)->hdr);
171  *values = padded;
172  return ERROR_SUCCESS;
173 
174 err:
175  msiobj_release(&padded->hdr);
176  return r;
177 }
178 
180 {
181  UINT r, i, col_count, type;
182 
183  r = iv->table->ops->get_dimensions( iv->table, NULL, &col_count );
184  if (r != ERROR_SUCCESS)
185  return FALSE;
186 
187  for (i = 1; i <= col_count; i++)
188  {
189  r = iv->table->ops->get_column_info(iv->table, i, NULL, &type,
190  NULL, NULL);
191  if (r != ERROR_SUCCESS)
192  return FALSE;
193 
194  if (!(type & MSITYPE_KEY))
195  continue;
196 
197  if (MSI_RecordIsNull(row, i))
198  return TRUE;
199  }
200 
201  return FALSE;
202 }
203 
205 {
207  UINT r, row = -1, col_count = 0;
208  MSIVIEW *sv;
209  MSIRECORD *values = NULL;
210 
211  TRACE("%p %p\n", iv, record );
212 
213  sv = iv->sv;
214  if( !sv )
215  return ERROR_FUNCTION_FAILED;
216 
217  r = sv->ops->execute( sv, 0 );
218  TRACE("sv execute returned %x\n", r);
219  if( r )
220  return r;
221 
222  r = sv->ops->get_dimensions( sv, NULL, &col_count );
223  if( r )
224  goto err;
225 
226  /*
227  * Merge the wildcard values into the list of values provided
228  * in the query, and create a record containing both.
229  */
230  values = msi_query_merge_record( col_count, iv->vals, record );
231  if( !values )
232  goto err;
233 
234  r = msi_arrange_record( iv, &values );
235  if( r != ERROR_SUCCESS )
236  goto err;
237 
238  /* rows with NULL primary keys are inserted at the beginning of the table */
239  if( row_has_null_primary_keys( iv, values ) )
240  row = 0;
241 
242  r = iv->table->ops->insert_row( iv->table, values, row, iv->bIsTemp );
243 
244 err:
245  if( values )
246  msiobj_release( &values->hdr );
247 
248  return r;
249 }
250 
251 
252 static UINT INSERT_close( struct tagMSIVIEW *view )
253 {
255  MSIVIEW *sv;
256 
257  TRACE("%p\n", iv);
258 
259  sv = iv->sv;
260  if( !sv )
261  return ERROR_FUNCTION_FAILED;
262 
263  return sv->ops->close( sv );
264 }
265 
266 static UINT INSERT_get_dimensions( struct tagMSIVIEW *view, UINT *rows, UINT *cols )
267 {
269  MSIVIEW *sv;
270 
271  TRACE("%p %p %p\n", iv, rows, cols );
272 
273  sv = iv->sv;
274  if( !sv )
275  return ERROR_FUNCTION_FAILED;
276 
277  return sv->ops->get_dimensions( sv, rows, cols );
278 }
279 
281  UINT *type, BOOL *temporary, LPCWSTR *table_name )
282 {
284  MSIVIEW *sv;
285 
286  TRACE("%p %d %p %p %p %p\n", iv, n, name, type, temporary, table_name );
287 
288  sv = iv->sv;
289  if( !sv )
290  return ERROR_FUNCTION_FAILED;
291 
292  return sv->ops->get_column_info( sv, n, name, type, temporary, table_name );
293 }
294 
295 static UINT INSERT_modify( struct tagMSIVIEW *view, MSIMODIFY eModifyMode, MSIRECORD *rec, UINT row)
296 {
298 
299  TRACE("%p %d %p\n", iv, eModifyMode, rec );
300 
301  return ERROR_FUNCTION_FAILED;
302 }
303 
305 {
307  MSIVIEW *sv;
308 
309  TRACE("%p\n", iv );
310 
311  sv = iv->sv;
312  if( sv )
313  sv->ops->delete( sv );
314  msiobj_release( &iv->db->hdr );
315  msi_free( iv );
316 
317  return ERROR_SUCCESS;
318 }
319 
320 static const MSIVIEWOPS insert_ops =
321 {
323  NULL,
324  NULL,
325  NULL,
326  NULL,
327  NULL,
328  NULL,
329  NULL,
331  INSERT_close,
336  NULL,
337  NULL,
338  NULL,
339  NULL,
340  NULL,
341 };
342 
343 static UINT count_column_info( const column_info *ci )
344 {
345  UINT n = 0;
346  for ( ; ci; ci = ci->next )
347  n++;
348  return n;
349 }
350 
352  column_info *columns, column_info *values, BOOL temp )
353 {
354  MSIINSERTVIEW *iv = NULL;
355  UINT r;
356  MSIVIEW *tv = NULL, *sv = NULL;
357 
358  TRACE("%p\n", iv );
359 
360  /* there should be one value for each column */
361  if ( count_column_info( columns ) != count_column_info(values) )
362  return ERROR_BAD_QUERY_SYNTAX;
363 
364  r = TABLE_CreateView( db, table, &tv );
365  if( r != ERROR_SUCCESS )
366  return r;
367 
368  r = SELECT_CreateView( db, &sv, tv, columns );
369  if( r != ERROR_SUCCESS )
370  {
371  if( tv )
372  tv->ops->delete( tv );
373  return r;
374  }
375 
376  iv = msi_alloc_zero( sizeof *iv );
377  if( !iv )
378  return ERROR_FUNCTION_FAILED;
379 
380  /* fill the structure */
381  iv->view.ops = &insert_ops;
382  msiobj_addref( &db->hdr );
383  iv->table = tv;
384  iv->db = db;
385  iv->vals = values;
386  iv->bIsTemp = temp;
387  iv->sv = sv;
388  *view = (MSIVIEW*) iv;
389 
390  return ERROR_SUCCESS;
391 }
void msiobj_addref(MSIOBJECTHDR *info)
Definition: handle.c:217
static UINT INSERT_modify(struct tagMSIVIEW *view, MSIMODIFY eModifyMode, MSIRECORD *rec, UINT row)
Definition: insert.c:295
UINT MSI_RecordSetStringW(MSIRECORD *, UINT, LPCWSTR) DECLSPEC_HIDDEN
Definition: record.c:597
UINT MSI_RecordCopyField(MSIRECORD *, UINT, MSIRECORD *, UINT) DECLSPEC_HIDDEN
Definition: record.c:166
#define ERROR_SUCCESS
Definition: deptool.c:10
UINT INSERT_CreateView(MSIDATABASE *db, MSIVIEW **view, LPCWSTR table, column_info *columns, column_info *values, BOOL temp)
Definition: insert.c:351
const WCHAR * LPCWSTR
Definition: xmlstorage.h:185
UINT TABLE_CreateView(MSIDATABASE *db, LPCWSTR name, MSIVIEW **view) DECLSPEC_HIDDEN
Definition: table.c:2189
static UINT INSERT_get_column_info(struct tagMSIVIEW *view, UINT n, LPCWSTR *name, UINT *type, BOOL *temporary, LPCWSTR *table_name)
Definition: insert.c:280
UINT(* get_dimensions)(struct tagMSIVIEW *view, UINT *rows, UINT *cols)
Definition: msipriv.h:306
#define TRUE
Definition: types.h:120
MSIOBJECTHDR hdr
Definition: msipriv.h:151
GLdouble GLdouble GLdouble r
Definition: gl.h:2055
GLboolean GLenum GLenum GLvoid * values
Definition: glext.h:5666
GLdouble n
Definition: glext.h:7729
struct _column_info * next
Definition: msipriv.h:226
static void msi_free(void *mem)
Definition: msipriv.h:1159
UINT(* execute)(struct tagMSIVIEW *view, MSIRECORD *record)
Definition: msipriv.h:293
static UINT INSERT_execute(struct tagMSIVIEW *view, MSIRECORD *record)
Definition: insert.c:204
static void * msi_alloc_zero(size_t len) __WINE_ALLOC_SIZE(1)
Definition: msipriv.h:1148
UINT MSI_RecordSetInteger(MSIRECORD *, UINT, int) DECLSPEC_HIDDEN
Definition: record.c:280
#define ERROR_FUNCTION_FAILED
Definition: winerror.h:985
#define FALSE
Definition: types.h:117
unsigned int BOOL
Definition: ntddk_ex.h:94
BOOL MSI_RecordIsNull(MSIRECORD *, UINT) DECLSPEC_HIDDEN
Definition: record.c:321
#define a
Definition: ke_i.h:78
MSIVIEW * sv
Definition: insert.c:47
#define debugstr_w
Definition: kernel32.h:32
static const MSIVIEWOPS insert_ops
Definition: insert.c:320
UINT SELECT_CreateView(MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table, const column_info *columns) DECLSPEC_HIDDEN
Definition: select.c:423
static UINT INSERT_close(struct tagMSIVIEW *view)
Definition: insert.c:252
int MSIMODIFY
Definition: winemsi.idl:33
#define b
Definition: ke_i.h:79
GLuint GLfloat * val
Definition: glext.h:7180
static BOOL row_has_null_primary_keys(MSIINSERTVIEW *iv, MSIRECORD *row)
Definition: insert.c:179
GLboolean GLboolean GLboolean b
Definition: glext.h:6204
#define TRACE(s)
Definition: solgame.cpp:4
const MSIVIEWOPS * ops
Definition: msipriv.h:355
unsigned long DWORD
Definition: ntddk_ex.h:95
UINT(* close)(struct tagMSIVIEW *view)
Definition: msipriv.h:298
MSIVIEW view
Definition: insert.c:43
BOOL bIsTemp
Definition: insert.c:46
static BOOL msi_columns_in_order(MSIINSERTVIEW *iv, UINT col_count)
Definition: insert.c:109
static UINT msi_arrange_record(MSIINSERTVIEW *iv, MSIRECORD **values)
Definition: insert.c:127
MSIRECORD * msi_query_merge_record(UINT fields, const column_info *vl, MSIRECORD *rec)
Definition: insert.c:66
#define MSITYPE_KEY
Definition: msipriv.h:52
int msiobj_release(MSIOBJECTHDR *info)
Definition: handle.c:241
static UINT count_column_info(const column_info *ci)
Definition: insert.c:343
#define EXPR_WILDCARD
Definition: query.h:54
MSIRECORD * MSI_CreateRecord(UINT) DECLSPEC_HIDDEN
Definition: record.c:76
static UINT INSERT_get_dimensions(struct tagMSIVIEW *view, UINT *rows, UINT *cols)
Definition: insert.c:266
#define err(...)
#define ERR(fmt,...)
Definition: debug.h:110
_Check_return_ _CRTIMP int __cdecl wcscmp(_In_z_ const wchar_t *_Str1, _In_z_ const wchar_t *_Str2)
UINT(* delete)(struct tagMSIVIEW *)
Definition: msipriv.h:324
struct expr * val
Definition: msipriv.h:225
GLsizei GLenum const GLvoid GLsizei GLenum GLbyte GLbyte GLbyte GLdouble GLdouble GLdouble GLfloat GLfloat GLfloat GLint GLint GLint GLshort GLshort GLshort GLubyte GLubyte GLubyte GLuint GLuint GLuint GLushort GLushort GLushort GLbyte GLbyte GLbyte GLbyte GLdouble GLdouble GLdouble GLdouble GLfloat GLfloat GLfloat GLfloat GLint GLint GLint GLint GLshort GLshort GLshort GLshort GLubyte GLubyte GLubyte GLubyte GLuint GLuint GLuint GLuint GLushort GLushort GLushort GLushort GLboolean const GLdouble const GLfloat const GLint const GLshort const GLbyte const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLdouble const GLfloat const GLfloat const GLint const GLint const GLshort const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort const GLdouble const GLfloat const GLint const GLshort GLenum GLenum GLenum GLfloat GLenum GLint GLenum GLenum GLenum GLfloat GLenum GLenum GLint GLenum GLfloat GLenum GLint GLint GLushort GLenum GLenum GLfloat GLenum GLenum GLint GLfloat const GLubyte GLenum GLenum GLenum const GLfloat GLenum GLenum const GLint GLenum GLint GLint GLsizei GLsizei GLint GLenum GLenum const GLvoid GLenum GLenum const GLfloat GLenum GLenum const GLint GLenum GLenum const GLdouble GLenum GLenum const GLfloat GLenum GLenum const GLint GLsizei GLuint GLfloat GLuint GLbitfield GLfloat GLint GLuint GLboolean GLenum GLfloat GLenum GLbitfield GLenum GLfloat GLfloat GLint GLint const GLfloat GLenum GLfloat GLfloat GLint GLint GLfloat GLfloat GLint GLint const GLfloat GLint GLfloat GLfloat GLint GLfloat GLfloat GLint GLfloat GLfloat const GLdouble const GLfloat const GLdouble const GLfloat GLint i
Definition: glfuncs.h:248
WINE_DEFAULT_DEBUG_CHANNEL(msidb)
static calc_node_t temp
Definition: rpn_ieee.c:38
static UINT INSERT_fetch_int(struct tagMSIVIEW *view, UINT row, UINT col, UINT *val)
Definition: insert.c:51
unsigned int UINT
Definition: ndis.h:50
#define NULL
Definition: types.h:112
struct tagMSIINSERTVIEW MSIINSERTVIEW
MSIVIEW * table
Definition: insert.c:44
static UINT INSERT_delete(struct tagMSIVIEW *view)
Definition: insert.c:304
UINT(* get_column_info)(struct tagMSIVIEW *view, UINT n, LPCWSTR *name, UINT *type, BOOL *temporary, LPCWSTR *table_name)
Definition: msipriv.h:313
Definition: name.c:38
column_info * vals
Definition: insert.c:48
GLuint GLuint GLsizei GLenum type
Definition: gl.h:1545
GLboolean GLboolean GLboolean GLboolean a
Definition: glext.h:6204
MSIOBJECTHDR hdr
Definition: msipriv.h:108
MSIDATABASE * db
Definition: insert.c:45
#define ERROR_BAD_QUERY_SYNTAX
Definition: winerror.h:973
UINT MSI_RecordGetFieldCount(const MSIRECORD *rec) DECLSPEC_HIDDEN
Definition: record.c:108
#define ERROR_OUTOFMEMORY
Definition: deptool.c:13
struct png_info_def *typedef unsigned char **typedef struct png_info_def *typedef struct png_info_def *typedef struct png_info_def *typedef unsigned char ** row
Definition: typeof.h:78
UINT(* insert_row)(struct tagMSIVIEW *view, MSIRECORD *record, UINT row, BOOL temporary)
Definition: msipriv.h:283