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 */ 155