c154b6c1ec6f340304f093d4106e99af9d58effb
[reactos.git] / reactos / dll / win32 / msi / query.h
1 /*
2 * Implementation of the Microsoft Installer (msi.dll)
3 *
4 * Copyright 2002 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 #ifndef __WINE_MSI_QUERY_H
22 #define __WINE_MSI_QUERY_H
23
24 //#include <stdarg.h>
25
26 //#include "windef.h"
27 //#include "winbase.h"
28 //#include "objbase.h"
29 //#include "objidl.h"
30 //#include "msi.h"
31 //#include "msiquery.h"
32 #include "msipriv.h"
33 //#include "wine/list.h"
34
35
36 #define OP_EQ 1
37 #define OP_AND 2
38 #define OP_OR 3
39 #define OP_GT 4
40 #define OP_LT 5
41 #define OP_LE 6
42 #define OP_GE 7
43 #define OP_NE 8
44 #define OP_ISNULL 9
45 #define OP_NOTNULL 10
46
47 #define EXPR_COMPLEX 1
48 #define EXPR_COLUMN 2
49 #define EXPR_COL_NUMBER 3
50 #define EXPR_IVAL 4
51 #define EXPR_SVAL 5
52 #define EXPR_UVAL 6
53 #define EXPR_STRCMP 7
54 #define EXPR_WILDCARD 9
55 #define EXPR_COL_NUMBER_STRING 10
56 #define EXPR_COL_NUMBER32 11
57 #define EXPR_UNARY 12
58
59 struct sql_str {
60 LPCWSTR data;
61 INT len;
62 };
63
64 struct complex_expr
65 {
66 UINT op;
67 struct expr *left;
68 struct expr *right;
69 };
70
71 struct tagJOINTABLE;
72 union ext_column
73 {
74 struct
75 {
76 LPCWSTR column;
77 LPCWSTR table;
78 } unparsed;
79 struct
80 {
81 UINT column;
82 struct tagJOINTABLE *table;
83 } parsed;
84 };
85
86 struct expr
87 {
88 int type;
89 union
90 {
91 struct complex_expr expr;
92 INT ival;
93 UINT uval;
94 LPCWSTR sval;
95 union ext_column column;
96 } u;
97 };
98
99 typedef struct
100 {
101 MSIDATABASE *db;
102 LPCWSTR command;
103 DWORD n, len;
104 UINT r;
105 MSIVIEW **view; /* View structure for the resulting query. This value
106 * tracks the view currently being created so we can free
107 * this view on syntax error.
108 */
109 struct list *mem;
110 } SQL_input;
111
112 UINT MSI_ParseSQL( MSIDATABASE *db, LPCWSTR command, MSIVIEW **phview,
113 struct list *mem ) DECLSPEC_HIDDEN;
114
115 UINT TABLE_CreateView( MSIDATABASE *db, LPCWSTR name, MSIVIEW **view ) DECLSPEC_HIDDEN;
116
117 UINT SELECT_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table,
118 const column_info *columns ) DECLSPEC_HIDDEN;
119
120 UINT DISTINCT_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table ) DECLSPEC_HIDDEN;
121
122 UINT ORDER_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table,
123 column_info *columns ) DECLSPEC_HIDDEN;
124
125 UINT WHERE_CreateView( MSIDATABASE *db, MSIVIEW **view, LPWSTR tables,
126 struct expr *cond ) DECLSPEC_HIDDEN;
127
128 UINT CREATE_CreateView( MSIDATABASE *db, MSIVIEW **view, LPCWSTR table,
129 column_info *col_info, BOOL hold ) DECLSPEC_HIDDEN;
130
131 UINT INSERT_CreateView( MSIDATABASE *db, MSIVIEW **view, LPCWSTR table,
132 column_info *columns, column_info *values, BOOL temp ) DECLSPEC_HIDDEN;
133
134 UINT UPDATE_CreateView( MSIDATABASE *db, MSIVIEW **view, LPWSTR table,
135 column_info *list, struct expr *expr ) DECLSPEC_HIDDEN;
136
137 UINT DELETE_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table ) DECLSPEC_HIDDEN;
138
139 UINT ALTER_CreateView( MSIDATABASE *db, MSIVIEW **view, LPCWSTR name, column_info *colinfo, int hold ) DECLSPEC_HIDDEN;
140
141 UINT STREAMS_CreateView( MSIDATABASE *db, MSIVIEW **view ) DECLSPEC_HIDDEN;
142
143 UINT STORAGES_CreateView( MSIDATABASE *db, MSIVIEW **view ) DECLSPEC_HIDDEN;
144
145 UINT DROP_CreateView( MSIDATABASE *db, MSIVIEW **view, LPCWSTR name ) DECLSPEC_HIDDEN;
146
147 int sqliteGetToken(const WCHAR *z, int *tokenType, int *skip) DECLSPEC_HIDDEN;
148
149 MSIRECORD *msi_query_merge_record( UINT fields, const column_info *vl, MSIRECORD *rec ) DECLSPEC_HIDDEN;
150
151 UINT msi_create_table( MSIDATABASE *db, LPCWSTR name, column_info *col_info,
152 MSICONDITION persistent ) DECLSPEC_HIDDEN;
153
154 #endif /* __WINE_MSI_QUERY_H */