4 * Implementation of the Microsoft Installer (msi.dll)
6 * Copyright 2002-2004 Mike McCormack for CodeWeavers
8 * This library is free software; you can redistribute it and/or
9 * modify it under the terms of the GNU Lesser General Public
10 * License as published by the Free Software Foundation; either
11 * version 2.1 of the License, or (at your option) any later version.
13 * This library is distributed in the hope that it will be useful,
14 * but WITHOUT ANY WARRANTY; without even the implied warranty of
15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16 * Lesser General Public License for more details.
18 * You should have received a copy of the GNU Lesser General Public
19 * License along with this library; if not, write to the Free Software
20 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
33 #include "wine/list.h"
34 #include "wine/debug.h"
36 #define YYLEX_PARAM info
37 #define YYPARSE_PARAM info
39 static int sql_error(const char *str);
41 WINE_DEFAULT_DEBUG_CHANNEL(msi);
43 typedef struct tag_SQL_input
48 MSIVIEW **view; /* view structure for the resulting query */
52 static LPWSTR SQL_getstring( void *info, struct sql_str *str );
53 static INT SQL_getint( void *info );
54 static int sql_lex( void *SQL_lval, SQL_input *info );
56 static void *parser_alloc( void *info, unsigned int sz );
57 static column_info *parser_alloc_column( void *info, LPCWSTR table, LPCWSTR column );
59 static BOOL SQL_MarkPrimaryKeys( column_info *cols, column_info *keys);
61 static struct expr * EXPR_complex( void *info, struct expr *l, UINT op, struct expr *r );
62 static struct expr * EXPR_column( void *info, column_info *column );
63 static struct expr * EXPR_ival( void *info, int val );
64 static struct expr * EXPR_sval( void *info, struct sql_str * );
65 static struct expr * EXPR_wildcard( void *info );
75 column_info *column_list;
82 %token TK_ALTER TK_AND TK_BY TK_CHAR TK_COMMA TK_CREATE TK_DELETE
83 %token TK_DISTINCT TK_DOT TK_EQ TK_FREE TK_FROM TK_GE TK_GT TK_HOLD
85 %token TK_ILLEGAL TK_INSERT TK_INT
86 %token <str> TK_INTEGER
87 %token TK_INTO TK_IS TK_KEY TK_LE TK_LONG TK_LONGCHAR TK_LP TK_LT
88 %token TK_LOCALIZABLE TK_MINUS TK_NE TK_NOT TK_NULL
89 %token TK_OBJECT TK_OR TK_ORDER TK_PRIMARY TK_RP
90 %token TK_SELECT TK_SET TK_SHORT TK_SPACE TK_STAR
91 %token <str> TK_STRING
92 %token TK_TABLE TK_TEMPORARY TK_UPDATE TK_VALUES TK_WHERE TK_WILDCARD
95 * These are extra tokens used by the lexer but never seen by the
96 * parser. We put them in a rule so that the parser generator will
97 * add them to the parse.h output file.
100 %nonassoc END_OF_FILE ILLEGAL SPACE UNCLOSED_STRING COMMENT FUNCTION
103 %type <string> table id
104 %type <column_list> selcollist column column_and_type column_def table_def
105 %type <column_list> column_assignment update_assign_list constlist
106 %type <query> query from fromtable selectfrom unorderedsel
107 %type <query> oneupdate onedelete oneselect onequery onecreate oneinsert onealter
108 %type <expr> expr val column_val const_val
109 %type <column_type> column_type data_type data_type_l data_count
110 %type <integer> number alterop
112 /* Reference: http://mates.ms.mff.cuni.cz/oracle/doc/ora815nt/server.815/a67779/operator.htm */
116 %left TK_EQ TK_NE TK_LT TK_GT TK_LE TK_GE TK_LIKE
124 SQL_input* sql = (SQL_input*) info;
139 TK_INSERT TK_INTO table TK_LP selcollist TK_RP TK_VALUES TK_LP constlist TK_RP
141 SQL_input *sql = (SQL_input*) info;
142 MSIVIEW *insert = NULL;
145 r = INSERT_CreateView( sql->db, &insert, $3, $5, $9, FALSE );
150 | TK_INSERT TK_INTO table TK_LP selcollist TK_RP TK_VALUES TK_LP constlist TK_RP TK_TEMPORARY
152 SQL_input *sql = (SQL_input*) info;
153 MSIVIEW *insert = NULL;
155 INSERT_CreateView( sql->db, &insert, $3, $5, $9, TRUE );
163 TK_CREATE TK_TABLE table TK_LP table_def TK_RP
165 SQL_input* sql = (SQL_input*) info;
166 MSIVIEW *create = NULL;
170 CREATE_CreateView( sql->db, &create, $3, $5, FALSE );
175 | TK_CREATE TK_TABLE table TK_LP table_def TK_RP TK_HOLD
177 SQL_input* sql = (SQL_input*) info;
178 MSIVIEW *create = NULL;
182 CREATE_CreateView( sql->db, &create, $3, $5, TRUE );
190 TK_UPDATE table TK_SET update_assign_list TK_WHERE expr
192 SQL_input* sql = (SQL_input*) info;
193 MSIVIEW *update = NULL;
195 UPDATE_CreateView( sql->db, &update, $2, $4, $6 );
200 | TK_UPDATE table TK_SET update_assign_list
202 SQL_input* sql = (SQL_input*) info;
203 MSIVIEW *update = NULL;
205 UPDATE_CreateView( sql->db, &update, $2, $4, NULL );
215 SQL_input* sql = (SQL_input*) info;
216 MSIVIEW *delete = NULL;
218 DELETE_CreateView( sql->db, &delete, $2 );
226 TK_ALTER TK_TABLE table alterop
228 SQL_input* sql = (SQL_input*) info;
229 MSIVIEW *alter = NULL;
231 ALTER_CreateView( sql->db, &alter, $3, $4 );
250 column_def TK_PRIMARY TK_KEY selcollist
252 if( SQL_MarkPrimaryKeys( $1, $4 ) )
260 column_def TK_COMMA column_and_type
264 for( ci = $1; ci->next; ci = ci->next )
280 $$->type = $2 | MSITYPE_VALID;
289 | data_type_l TK_LOCALIZABLE
291 $$ = $1 | MSITYPE_LOCALIZABLE;
293 | data_type_l TK_TEMPORARY
295 FIXME("temporary column\n");
302 $$ |= MSITYPE_NULLABLE;
304 | data_type TK_NOT TK_NULL
313 $$ = MSITYPE_STRING | 1;
315 | TK_CHAR TK_LP data_count TK_RP
317 $$ = MSITYPE_STRING | 0x400 | $3;
337 $$ = MSITYPE_STRING | MSITYPE_VALID;
344 if( ( $1 > 255 ) || ( $1 < 0 ) )
351 unorderedsel TK_ORDER TK_BY selcollist
353 SQL_input* sql = (SQL_input*) info;
357 ORDER_CreateView( sql->db, &$$, $1, $4 );
371 | TK_SELECT TK_DISTINCT selectfrom
373 SQL_input* sql = (SQL_input*) info;
377 r = DISTINCT_CreateView( sql->db, &$$, $3 );
378 if (r != ERROR_SUCCESS)
389 SQL_input* sql = (SQL_input*) info;
395 r = SELECT_CreateView( sql->db, &$$, $2, $1 );
396 if (r != ERROR_SUCCESS)
409 | column TK_COMMA selcollist
421 | fromtable TK_WHERE expr
423 SQL_input* sql = (SQL_input*) info;
427 r = WHERE_CreateView( sql->db, &$$, $1, $3 );
428 if( r != ERROR_SUCCESS )
430 $1->ops->delete( $1 );
439 SQL_input* sql = (SQL_input*) info;
443 r = TABLE_CreateView( sql->db, $2, &$$ );
444 if( r != ERROR_SUCCESS || !$$ )
447 | TK_FROM table TK_COMMA table
449 SQL_input* sql = (SQL_input*) info;
452 /* only support inner joins on two tables */
453 r = JOIN_CreateView( sql->db, &$$, $2, $4 );
454 if( r != ERROR_SUCCESS )
468 $$ = EXPR_complex( info, $1, OP_AND, $3 );
474 $$ = EXPR_complex( info, $1, OP_OR, $3 );
478 | column_val TK_EQ val
480 $$ = EXPR_complex( info, $1, OP_EQ, $3 );
484 | column_val TK_GT val
486 $$ = EXPR_complex( info, $1, OP_GT, $3 );
490 | column_val TK_LT val
492 $$ = EXPR_complex( info, $1, OP_LT, $3 );
496 | column_val TK_LE val
498 $$ = EXPR_complex( info, $1, OP_LE, $3 );
502 | column_val TK_GE val
504 $$ = EXPR_complex( info, $1, OP_GE, $3 );
508 | column_val TK_NE val
510 $$ = EXPR_complex( info, $1, OP_NE, $3 );
514 | column_val TK_IS TK_NULL
516 $$ = EXPR_complex( info, $1, OP_ISNULL, NULL );
520 | column_val TK_IS TK_NOT TK_NULL
522 $$ = EXPR_complex( info, $1, OP_NOTNULL, NULL );
536 $$ = parser_alloc_column( info, NULL, NULL );
541 | const_val TK_COMMA constlist
543 $$ = parser_alloc_column( info, NULL, NULL );
553 | column_assignment TK_COMMA update_assign_list
561 column TK_EQ const_val
571 $$ = EXPR_ival( info, $1 );
575 | TK_MINUS number %prec TK_NEGATION
577 $$ = EXPR_ival( info, -$2 );
583 $$ = EXPR_sval( info, &$1 );
589 $$ = EXPR_wildcard( info );
598 $$ = EXPR_column( info, $1 );
607 $$ = parser_alloc_column( info, $1, $3 );
613 $$ = parser_alloc_column( info, NULL, $1 );
629 $$ = SQL_getstring( info, &$1 );
638 $$ = SQL_getint( info );
644 static void *parser_alloc( void *info, unsigned int sz )
646 SQL_input* sql = (SQL_input*) info;
649 mem = msi_alloc( sizeof (struct list) + sz );
650 list_add_tail( sql->mem, mem );
654 static column_info *parser_alloc_column( void *info, LPCWSTR table, LPCWSTR column )
658 col = parser_alloc( info, sizeof (*col) );
662 col->column = column;
671 static int sql_lex( void *SQL_lval, SQL_input *sql )
674 struct sql_str * str = SQL_lval;
679 if( ! sql->command[sql->n] )
680 return 0; /* end of input */
682 /* TRACE("string : %s\n", debugstr_w(&sql->command[sql->n])); */
683 sql->len = sqliteGetToken( &sql->command[sql->n], &token );
686 str->data = &sql->command[sql->n];
689 while( token == TK_SPACE );
691 /* TRACE("token : %d (%s)\n", token, debugstr_wn(&sql->command[sql->n], sql->len)); */
696 LPWSTR SQL_getstring( void *info, struct sql_str *strdata )
698 LPCWSTR p = strdata->data;
699 UINT len = strdata->len;
702 /* if there's quotes, remove them */
703 if( ( (p[0]=='`') && (p[len-1]=='`') ) ||
704 ( (p[0]=='\'') && (p[len-1]=='\'') ) )
709 str = parser_alloc( info, (len + 1)*sizeof(WCHAR) );
712 memcpy( str, p, len*sizeof(WCHAR) );
718 INT SQL_getint( void *info )
720 SQL_input* sql = (SQL_input*) info;
721 LPCWSTR p = &sql->command[sql->n];
724 for( i=0; i<sql->len; i++ )
726 if( '0' > p[i] || '9' < p[i] )
728 ERR("should only be numbers here!\n");
731 r = (p[i]-'0') + r*10;
737 static int sql_error( const char *str )
742 static struct expr * EXPR_wildcard( void *info )
744 struct expr *e = parser_alloc( info, sizeof *e );
747 e->type = EXPR_WILDCARD;
752 static struct expr * EXPR_complex( void *info, struct expr *l, UINT op, struct expr *r )
754 struct expr *e = parser_alloc( info, sizeof *e );
757 e->type = EXPR_COMPLEX;
765 static struct expr * EXPR_column( void *info, column_info *column )
767 struct expr *e = parser_alloc( info, sizeof *e );
770 e->type = EXPR_COLUMN;
771 e->u.sval = column->column;
776 static struct expr * EXPR_ival( void *info, int val )
778 struct expr *e = parser_alloc( info, sizeof *e );
787 static struct expr * EXPR_sval( void *info, struct sql_str *str )
789 struct expr *e = parser_alloc( info, sizeof *e );
793 e->u.sval = SQL_getstring( info, str );
798 static BOOL SQL_MarkPrimaryKeys( column_info *cols,
804 for( k = keys; k && found; k = k->next )
809 for( c = cols; c && !found; c = c->next )
811 if( lstrcmpW( k->column, c->column ) )
813 c->type |= MSITYPE_KEY;
821 UINT MSI_ParseSQL( MSIDATABASE *db, LPCWSTR command, MSIVIEW **phview,
830 sql.command = command;
838 TRACE("Parse returned %d\n", r);
842 return ERROR_BAD_QUERY_SYNTAX;
845 return ERROR_SUCCESS;