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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  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 "objidl.h"
  29 #include "msi.h"
  30 #include "msiquery.h"
  31 #include "msipriv.h"
  32
  33
  34 #define OP_EQ       1
  35 #define OP_AND      2
  36 #define OP_OR       3
  37 #define OP_GT       4
  38 #define OP_LT       5
  39 #define OP_LE       6
  40 #define OP_GE       7
  41 #define OP_NE       8
  42 #define OP_ISNULL   9
  43 #define OP_NOTNULL  10
  44
  45 #define EXPR_COMPLEX  1
  46 #define EXPR_COLUMN   2
  47 #define EXPR_COL_NUMBER 3
  48 #define EXPR_IVAL     4
  49 #define EXPR_SVAL     5
  50 #define EXPR_UVAL     6
  51 #define EXPR_STRCMP   7
  52 #define EXPR_UTF8     8
  53 #define EXPR_WILDCARD 9
  54
  55 struct sql_str {
  56     LPCWSTR data;
  57     INT len;
  58 };
  59
  60 typedef struct _string_list
  61 {
  62     LPWSTR string;
  63     struct _string_list *next;
  64 } string_list;
  65
  66 struct complex_expr
  67 {
  68     UINT op;
  69     struct expr *left;
  70     struct expr *right;
  71 };
  72
  73 struct expr
  74 {
  75     int type;
  76     union
  77     {
  78         struct complex_expr expr;
  79         INT   ival;
  80         UINT  uval;
  81         LPWSTR sval;
  82         LPWSTR column;
  83         UINT col_number;
  84         char *utf8;
  85     } u;
  86 };
  87
  88 typedef struct _create_col_info
  89 {
  90     LPWSTR colname;
  91     UINT   type;
  92     struct _create_col_info *next;
  93 } create_col_info;
  94
  95 typedef struct _value_list
  96 {
  97     struct expr *val;
  98     struct _value_list *next;
  99 } value_list;
 100
 101 typedef struct _column_assignment
 102 {
 103     string_list *col_list;
 104     value_list *val_list;
 105 } column_assignment;
 106
 107
 108 UINT MSI_ParseSQL( MSIDATABASE *db, LPCWSTR command, MSIVIEW **phView);
 109
 110 UINT TABLE_CreateView( MSIDATABASE *db, LPCWSTR name, MSIVIEW **view );
 111
 112 UINT SELECT_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table,
 113                         string_list *columns );
 114
 115 UINT DISTINCT_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table );
 116
 117 UINT ORDER_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table );
 118 UINT ORDER_AddColumn( MSIVIEW *group, LPWSTR name );
 119
 120 UINT WHERE_CreateView( MSIDATABASE *db, MSIVIEW **view, MSIVIEW *table,
 121                        struct expr *cond );
 122
 123 UINT CREATE_CreateView( MSIDATABASE *db, MSIVIEW **view, LPWSTR table,
 124                         create_col_info *col_info, BOOL temp );
 125
 126 UINT INSERT_CreateView( MSIDATABASE *db, MSIVIEW **view, LPWSTR table,
 127                         string_list *columns, value_list *values, BOOL temp );
 128
 129 UINT UPDATE_CreateView( MSIDATABASE *db, MSIVIEW **, LPWSTR table,
 130                         column_assignment *list, struct expr *expr );
 131
 132 void delete_expr( struct expr *e );
 133 void delete_string_list( string_list *sl );
 134 void delete_value_list( value_list *vl );
 135
 136 int sqliteGetToken(const WCHAR *z, int *tokenType);
 137
 138 #endif /* __WINE_MSI_QUERY_H */