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