2 * Implementation of the Microsoft Installer (msi.dll)
4 * Copyright 2006 Mike McCormack
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
26 #include "wine/debug.h"
35 WINE_DEFAULT_DEBUG_CHANNEL(msidb
);
37 typedef struct tagMSIALTERVIEW
46 static UINT
ALTER_fetch_int( struct tagMSIVIEW
*view
, UINT row
, UINT col
, UINT
*val
)
48 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
50 TRACE("%p %d %d %p\n", av
, row
, col
, val
);
52 return ERROR_FUNCTION_FAILED
;
55 static UINT
ALTER_fetch_stream( struct tagMSIVIEW
*view
, UINT row
, UINT col
, IStream
**stm
)
57 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
59 TRACE("%p %d %d %p\n", av
, row
, col
, stm
);
61 return ERROR_FUNCTION_FAILED
;
64 static UINT
ALTER_get_row( struct tagMSIVIEW
*view
, UINT row
, MSIRECORD
**rec
)
66 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
68 TRACE("%p %d %p\n", av
, row
, rec
);
70 return av
->table
->ops
->get_row(av
->table
, row
, rec
);
73 static UINT
ITERATE_columns(MSIRECORD
*row
, LPVOID param
)
79 static BOOL
check_column_exists(MSIDATABASE
*db
, LPCWSTR table
, LPCWSTR column
)
85 static const WCHAR query
[] = {
86 'S','E','L','E','C','T',' ','*',' ','F','R','O','M',' ',
87 '`','_','C','o','l','u','m','n','s','`',' ','W','H','E','R','E',' ',
88 '`','T','a','b','l','e','`','=','\'','%','s','\'',' ','A','N','D',' ',
89 '`','N','a','m','e','`','=','\'','%','s','\'',0
92 r
= MSI_OpenQuery(db
, &view
, query
, table
, column
);
93 if (r
!= ERROR_SUCCESS
)
96 r
= MSI_ViewExecute(view
, NULL
);
97 if (r
!= ERROR_SUCCESS
)
100 r
= MSI_ViewFetch(view
, &rec
);
101 if (r
== ERROR_SUCCESS
)
102 msiobj_release(&rec
->hdr
);
105 msiobj_release(&view
->hdr
);
106 return (r
== ERROR_SUCCESS
);
109 static UINT
alter_add_column(MSIALTERVIEW
*av
)
115 static const WCHAR szColumns
[] = {'_','C','o','l','u','m','n','s',0};
116 static const WCHAR query
[] = {
117 'S','E','L','E','C','T',' ','*',' ','F','R','O','M',' ',
118 '`','_','C','o','l','u','m','n','s','`',' ','W','H','E','R','E',' ',
119 '`','T','a','b','l','e','`','=','\'','%','s','\'',' ','O','R','D','E','R',' ',
120 'B','Y',' ','`','N','u','m','b','e','r','`',0
123 r
= TABLE_CreateView(av
->db
, szColumns
, &columns
);
124 if (r
!= ERROR_SUCCESS
)
127 if (check_column_exists(av
->db
, av
->colinfo
->table
, av
->colinfo
->column
))
128 return ERROR_BAD_QUERY_SYNTAX
;
130 r
= MSI_OpenQuery(av
->db
, &view
, query
, av
->colinfo
->table
, av
->colinfo
->column
);
131 if (r
== ERROR_SUCCESS
)
133 r
= MSI_IterateRecords(view
, NULL
, ITERATE_columns
, &colnum
);
134 msiobj_release(&view
->hdr
);
137 r
= columns
->ops
->add_column(columns
, av
->colinfo
->table
,
138 colnum
, av
->colinfo
->column
,
139 av
->colinfo
->type
, (av
->hold
== 1));
141 columns
->ops
->delete(columns
);
145 static UINT
ALTER_execute( struct tagMSIVIEW
*view
, MSIRECORD
*record
)
147 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
150 TRACE("%p %p\n", av
, record
);
153 av
->table
->ops
->add_ref(av
->table
);
154 else if (av
->hold
== -1)
156 ref
= av
->table
->ops
->release(av
->table
);
162 return alter_add_column(av
);
164 return ERROR_SUCCESS
;
167 static UINT
ALTER_close( struct tagMSIVIEW
*view
)
169 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
173 return ERROR_SUCCESS
;
176 static UINT
ALTER_get_dimensions( struct tagMSIVIEW
*view
, UINT
*rows
, UINT
*cols
)
178 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
180 TRACE("%p %p %p\n", av
, rows
, cols
);
182 return ERROR_FUNCTION_FAILED
;
185 static UINT
ALTER_get_column_info( struct tagMSIVIEW
*view
,
186 UINT n
, LPWSTR
*name
, UINT
*type
, BOOL
*temporary
,
189 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
191 TRACE("%p %d %p %p %p %p\n", av
, n
, name
, type
, temporary
, table_name
);
193 return ERROR_FUNCTION_FAILED
;
196 static UINT
ALTER_modify( struct tagMSIVIEW
*view
, MSIMODIFY eModifyMode
,
197 MSIRECORD
*rec
, UINT row
)
199 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
201 TRACE("%p %d %p\n", av
, eModifyMode
, rec
);
203 return ERROR_FUNCTION_FAILED
;
206 static UINT
ALTER_delete( struct tagMSIVIEW
*view
)
208 MSIALTERVIEW
*av
= (MSIALTERVIEW
*)view
;
212 av
->table
->ops
->delete( av
->table
);
215 return ERROR_SUCCESS
;
218 static UINT
ALTER_find_matching_rows( struct tagMSIVIEW
*view
, UINT col
,
219 UINT val
, UINT
*row
, MSIITERHANDLE
*handle
)
221 TRACE("%p, %d, %u, %p\n", view
, col
, val
, *handle
);
223 return ERROR_FUNCTION_FAILED
;
226 static const MSIVIEWOPS alter_ops
=
236 ALTER_get_dimensions
,
237 ALTER_get_column_info
,
240 ALTER_find_matching_rows
,
249 UINT
ALTER_CreateView( MSIDATABASE
*db
, MSIVIEW
**view
, LPCWSTR name
, column_info
*colinfo
, int hold
)
254 TRACE("%p %p %s %d\n", view
, colinfo
, debugstr_w(name
), hold
);
256 av
= msi_alloc_zero( sizeof *av
);
258 return ERROR_FUNCTION_FAILED
;
260 r
= TABLE_CreateView( db
, name
, &av
->table
);
261 if (r
!= ERROR_SUCCESS
)
268 colinfo
->table
= name
;
270 /* fill the structure */
271 av
->view
.ops
= &alter_ops
;
274 av
->colinfo
= colinfo
;
278 return ERROR_SUCCESS
;