[ogsa-dai svn] SF.net SVN: ogsa-dai:[448] ogsa-dai/trunk/extensions

[<eth...@us...>]

Revision: 448
          http://ogsa-dai.svn.sourceforge.net/ogsa-dai/?rev=448&view=rev
Author:   etheocha
Date:     2010-01-27 16:31:17 +0000 (Wed, 27 Jan 2010)

Log Message:
-----------
The views grammas and the vies.messages file

Added Paths:
-----------
    ogsa-dai/trunk/extensions/views/
    ogsa-dai/trunk/extensions/views/server/
    ogsa-dai/trunk/extensions/views/server/src/
    ogsa-dai/trunk/extensions/views/server/src/main/
    ogsa-dai/trunk/extensions/views/server/src/main/grammar/
    ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.g
    ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.tokens
    ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.g
    ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.tokens
    ogsa-dai/trunk/extensions/views/server/src/main/resources/
    ogsa-dai/trunk/extensions/views/server/src/main/resources/SQL92Query.stg
    ogsa-dai/trunk/extensions/views/server/src/main/resources/views_messages.properties

Added: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.g
===================================================================
--- ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.g	                        (rev 0)
+++ ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.g	2010-01-27 16:31:17 UTC (rev 448)
@@ -0,0 +1,172 @@
+grammar SQL92Query;
+
+options {
+	output = AST;
+	ASTLabelType = CommonTree;
+	backtrack=true;
+}
+
+tokens {
+	STATEMENT;
+	QUERY;
+	SETOP;
+	ORDER;
+	SELECT_LIST;
+	FROM_LIST;
+	WHERE;
+	GROUP_BY;
+	HAVING;
+	RELATION;
+	COLUMN;
+	FUNCTION;
+	NOT;
+	SET;
+	TABLECOLUMN;
+	RIGHT_OUTER_JOIN;
+	LEFT_OUTER_JOIN;
+	FULL_OUTER_JOIN;
+	JOIN;
+	IS_NULL;
+}
+
+statement
+	:	query_expression order_by? -> ^(STATEMENT query_expression order_by?);
+query_expression
+	:	query_term (set_op^ query_term)*
+	;
+query_term
+	:	query ( 'INTERSECT'^? query)*;
+set_op	:	(setop='UNION' | setop='EXCEPT') 'ALL'? -> ^($setop 'ALL'?);
+
+	
+query	:	sub_query
+	|	'SELECT' set_quantifier? select_list 'FROM' table_expression ('WHERE' s1=search_condition)? ('GROUP BY' column_list)? ('HAVING' s2=search_condition)?
+		 	-> ^(QUERY ^(SELECT_LIST set_quantifier? select_list) ^(FROM_LIST table_expression) ^(WHERE $s1)? ^(GROUP_BY column_list)? ^(HAVING $s2)?)
+	;
+set_quantifier
+	:	'DISTINCT' | 'ALL';
+sub_query
+	:	'('! query_expression ')'!;
+
+select_list
+	:	'*' -> ^(COLUMN '*')
+	| 	derived_column (','! derived_column)*;
+derived_column
+	:	value_expression ('AS' ID)? -> ^(COLUMN value_expression ID?)
+	|	'NULL' 'AS' ID -> ^(COLUMN 'NULL' ID);
+	
+order_by:	'ORDER' 'BY' sort_specification (',' sort_specification)* -> ^(ORDER sort_specification+);
+sort_specification
+	:	column_name | INT;
+	
+value_expression
+	:	string_value_expression
+	|	numeric_value_expression 
+	;
+numeric_value_expression
+	: 	factor (('+'|'-')^ factor)* ;
+	
+factor	:	numeric_primary (('*'|'/')^ numeric_primary)*;
+
+numeric_primary
+	: 	('+'^|'-'^)? value_expression_primary; 
+value_expression_primary 
+	:	'('! value_expression ')'!
+	|	'COUNT' '(' '*' ')' -> ^(FUNCTION 'COUNT' '*')
+	| 	column_name
+	| 	literal
+	| 	(name='AVG' | name='MAX' | name='MIN' | name='SUM' | name='COUNT') ('DISTINCT'|'ALL')? '(' value_expression ')' 
+			-> ^(FUNCTION $name value_expression)
+	| 	sub_query
+	;
+
+literal	:	INT | FLOAT | NUMERIC | STRING | datetime | interval;
+datetime
+	:	('DATE' | 'TIMESTAMP' | 'TIME')^ STRING;
+interval:	
+		'INTERVAL'^ STRING ('YEAR' | 'MONTH' | 'DAY' | 'HOUR' | 'MINUTE' | 'SECOND');
+
+string_value_expression
+	:	(column_name | STRING) ('||'^ (column_name | STRING))+
+	;
+	
+table_expression
+	:	table_reference
+	;
+table_reference
+	:	table (','! table_reference)*
+	;
+table 	:	non_join_table (join_type^ non_join_table 'ON'! search_condition)*;
+
+join_type
+	:	'RIGHT' 'OUTER'? 'JOIN' -> RIGHT_OUTER_JOIN 
+	|	'LEFT' 'OUTER'? 'JOIN' -> LEFT_OUTER_JOIN
+	|	'FULL' 'OUTER'? 'JOIN' -> FULL_OUTER_JOIN
+	| 	'INNER'? 'JOIN' -> JOIN
+	;
+
+non_join_table
+	:	table_name correlation_specification? -> ^(RELATION table_name correlation_specification?)
+	| 	sub_query correlation_specification? -> ^(RELATION sub_query correlation_specification)
+	;
+	
+search_condition
+	:	boolean_factor ('OR'^ boolean_factor)*;
+boolean_factor
+	:	boolean_term ('AND'^ boolean_term)*
+	;
+boolean_term
+	:	boolean_test
+	|	'NOT' boolean_term -> ^(NOT boolean_term);
+boolean_test
+	:	boolean_primary;
+boolean_primary
+	:	predicate | '('! search_condition ')'!;	
+predicate
+	:	comparison_predicate | like_predicate | in_predicate | null_predicate | exists_predicate | between_predicate;
+null_predicate
+	:	row_value 'IS' 'NULL' -> ^(IS_NULL row_value)
+	|	row_value 'IS' 'NOT' 'NULL' -> ^(NOT ^(IS_NULL row_value))
+	;
+in_predicate
+	:	row_value 'NOT' 'IN' in_predicate_tail
+			-> ^(NOT ^('IN' row_value in_predicate_tail))
+	|	row_value 'IN' in_predicate_tail
+			-> ^('IN' row_value in_predicate_tail)
+	;
+in_predicate_tail
+	:	sub_query 
+	| 	'(' (value_expression (',' value_expression)*) ')' -> ^(SET value_expression*) ;
+between_predicate
+	:	value=row_value 'BETWEEN' btw1=row_value 'AND' btw2=row_value 
+			-> ^('BETWEEN' $value $btw1 $btw2)
+	|	value=row_value 'NOT' 'BETWEEN' btw1=row_value 'AND' btw2=row_value
+			-> ^(NOT ^('BETWEEN' $value $btw1 $btw2));
+exists_predicate
+	:	'EXISTS'^ sub_query;
+comparison_predicate
+	:	row_value ('=' | '<>' | '!=' | '<' | '>' | '>=' | '<=')^ ('ALL'|'SOME'|'ANY')? row_value;
+like_predicate
+	:	row_value 'LIKE'^ row_value
+	|	v1=row_value 'NOT' 'LIKE' v2=row_value -> ^(NOT ^('LIKE' $v1 $v2));
+
+row_value
+	:	value_expression | 'NULL' | 'DEFAULT' | sub_query;
+
+correlation_specification
+	:	('AS'!)? ID;	
+table_name
+	:	ID;
+column_list
+	:	column_name (','! column_name)*;
+column_name
+	:	(tableid=ID'.')?columnid=ID -> ^(TABLECOLUMN $tableid? $columnid);
+
+ID	:	('a'..'z' | 'A'..'Z') ( ('a'..'z' | 'A'..'Z') | ('0'..'9') | '_' )* 
+	|	'`' (~('\''|'\n'|'\r'|'`')) ( (~('\''|'\n'|'\r'|'`')) )* '`' ;
+FLOAT	:	('0'..'9')+ '.' ('0'..'9')+ ;
+INT	:	('0'..'9')+ ;
+NUMERIC	:	(INT | FLOAT) 'E' INT ;
+STRING	:	'"' (~('"'|'\n'|'\r'))*  '"'
+	|	'\'' (~('\''|'\n'|'\r'))*  '\'';
+WS	:	(' ' | '\t' | '\r' | '\n' ) {skip();} ;


Property changes on: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.g
___________________________________________________________________
Added: svn:executable
   + *

Added: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.tokens
===================================================================
--- ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.tokens	                        (rev 0)
+++ ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.tokens	2010-01-27 16:31:17 UTC (rev 448)
@@ -0,0 +1,89 @@
+TABLECOLUMN=18
+SELECT_LIST=8
+FROM_LIST=9
+RIGHT_OUTER_JOIN=19
+STATEMENT=4
+GROUP_BY=11
+WS=29
+FULL_OUTER_JOIN=21
+STRING=28
+FLOAT=26
+QUERY=5
+RELATION=13
+SETOP=6
+LEFT_OUTER_JOIN=20
+ORDER=7
+FUNCTION=15
+IS_NULL=23
+INT=25
+HAVING=12
+SET=17
+COLUMN=14
+JOIN=22
+NOT=16
+NUMERIC=27
+ID=24
+WHERE=10
+'MAX'=53
+'<'=84
+'>'=85
+'DISTINCT'=39
+'COUNT'=51
+'-'=49
+'!='=83
+'>='=86
+'INTERSECT'=30
+'MINUTE'=64
+'<='=87
+'||'=66
+'='=81
+'SUM'=55
+'OUTER'=69
+'DATE'=56
+'AS'=44
+'WHERE'=36
+'GROUP BY'=37
+'TIME'=58
+'.'=92
+'DAY'=62
+'<>'=82
+'*'=42
+'SELECT'=34
+'HAVING'=38
+'YEAR'=60
+'LEFT'=71
+'OR'=74
+'SOME'=88
+'EXCEPT'=32
+'DEFAULT'=91
+'ORDER'=46
+'FROM'=35
+','=43
+'NOT'=76
+'IS'=77
+'MONTH'=61
+'INTERVAL'=59
+'NULL'=45
+'/'=50
+'RIGHT'=68
+'ON'=67
+'ANY'=89
+'BY'=47
+'UNION'=31
+'HOUR'=63
+')'=41
+'MIN'=54
+'AVG'=52
+'ALL'=33
+'IN'=78
+'SECOND'=65
+'LIKE'=90
+'AND'=75
+'JOIN'=70
+'BETWEEN'=79
+'('=40
+'FULL'=72
+'EXISTS'=80
+'+'=48
+'TIMESTAMP'=57
+'INNER'=73


Property changes on: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92Query.tokens
___________________________________________________________________
Added: svn:executable
   + *

Added: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.g
===================================================================
--- ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.g	                        (rev 0)
+++ ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.g	2010-01-27 16:31:17 UTC (rev 448)
@@ -0,0 +1,141 @@
+tree grammar SQL92QueryWalker;
+
+options {
+	tokenVocab = SQL92Query;
+	ASTLabelType = CommonTree;
+	backtrack = true;
+	output = template;
+}
+
+
+statement
+	:	^(STATEMENT query_expression o+=order_by?) -> statement(query={$query_expression.st}, order_by={$o});
+
+order_by:	^(ORDER (s+=sort_specification)+) -> order_by(columns={$s});
+
+query_expression
+	:	^((op='UNION' | op='EXCEPT') (all='ALL')? v1=query_expression v2=query_expression) 
+			-> set_op(op={$op}, value1={$v1.st}, value2={$v2.st}, all={$all})
+	|	^(op='INTERSECT' v1=query_expression v2=query_expression) 
+			-> set_op(op={$op}, value1={$v1.st}, value2={$v2.st})
+	|	query -> {$query.st}
+	;
+	
+query	:	^(QUERY ^(SELECT_LIST (sq='DISTINCT' | sq='ALL')? select_list) ^(FROM_LIST (t+=table)+) (^(WHERE wh+=search_condition))? (^(GROUP_BY c+=column_name+))? (^(HAVING hav+=search_condition))?)
+			-> query(select_list={$select_list.st}, from_list={$t}, where={$wh}, group_by={$c}, having={$hav}, set_quantifier={$sq})
+	;
+
+select_list
+	:	^(COLUMN s='*')    -> emitstr(str={$s})
+	| 	(c+=column_def)+   -> column_list(columns={$c})
+	;
+column_def
+	:	^(COLUMN value_expression)    -> {$value_expression.st}
+	| 	^(COLUMN value_expression ID) -> expr_as(expression={$value_expression.st}, alias={$ID})
+	|	^(COLUMN 'NULL' ID) -> expr_as(expression={"NULL"}, alias={$ID});
+sort_specification
+	:	column_name  -> {$column_name.st} 
+	|	INT          -> emitstr(str={$INT});
+	
+value_expression
+	:	numeric_value_expression -> {$numeric_value_expression.st}
+	|	string_value_expression  -> {$string_value_expression.st}
+	;
+numeric_value_expression
+	: 	^((op='+' | op='-' ) v1=numeric_value_expression v2=numeric_value_expression) 
+			-> bin_expr_paren(op={$op}, value1={$v1.st}, value2={$v2.st})
+	| 	^((op='/' | op='*') v1=numeric_value_expression v2=numeric_value_expression) 
+			-> bin_expr(op={$op}, value1={$v1.st}, value2={$v2.st})
+	|	numeric_primary -> {$numeric_primary.st}
+	;
+	
+numeric_primary
+	: 	^(op=('+' | '-') value_expression_primary) -> unary_expr(op={$op}, value={$value_expression_primary.st})
+	|	value_expression_primary -> {$value_expression_primary.st}; 
+value_expression_primary 
+	:	^(FUNCTION name='COUNT' param='*') -> function(name={$name}, param={$param})
+	|	^(FUNCTION (name='AVG' | name='MAX' | name='MIN' | name='SUM' | name='COUNT') ('DISTINCT'|'ALL')? p=value_expression) 
+			-> function(name={$name}, param={$p.st})
+	| 	column_name -> {$column_name.st}
+	|	literal -> {$literal.st}
+	| 	query_expression -> paren(str={$query_expression.st})
+	;
+	
+literal	:	INT -> emitstr(str={$INT.text})
+	|	FLOAT  -> emitstr(str={$FLOAT.text})
+	|	NUMERIC -> emitstr(str={$NUMERIC.text})
+	|	STRING -> emitstr(str={$STRING.text})
+	| 	datetime -> {$datetime.st}
+	| 	interval -> {$interval.st}
+	;	
+
+string_value_expression
+	:	^(op='||' v1=string_primary v2=string_primary) -> bin_expr(op={$op}, value1={$v1.st}, value2={$v2.st});
+string_primary
+	:	column_name -> {$column_name.st}
+	| 	STRING -> emitstr(str={$STRING.text});
+	
+datetime
+	:	^((op='DATE' | op='TIME' | op='TIMESTAMP') STRING) -> unary_expr(op={$op}, value={$STRING})
+	;
+interval:	^('INTERVAL' STRING (f='YEAR' | f='MONTH' | f='DAY' | f='HOUR' | f='MINUTE' | f='SECOND'))
+			-> interval(value={$STRING}, field={$f});
+	
+table 	:	^(RIGHT_OUTER_JOIN t1=table t2=table search_condition) -> join(type={"RIGHT"}, table1={$t1.st}, table2={$t2.st}, condition={$search_condition.st})
+	| 	^(LEFT_OUTER_JOIN  t1=table t2=table search_condition) -> join(type={"LEFT"}, table1={$t1.st}, table2={$t2.st}, condition={$search_condition.st})
+	|	^(FULL_OUTER_JOIN  t1=table t2=table search_condition) -> join(type={"FULL"}, table1={$t1.st}, table2={$t2.st}, condition={$search_condition.st})
+	|	^(JOIN             t1=table t2=table search_condition) -> join(type={""}, table1={$t1.st}, table2={$t2.st}, condition={$search_condition.st})
+	| 	non_join_table -> {$non_join_table.st}
+	;
+
+non_join_table
+	:	^(RELATION table_name) -> {$table_name.st} 
+	|	^(RELATION table_name ID) -> expr_as(expression={$table_name.st}, alias={$ID})
+	| 	^(RELATION query_expression ID) -> subquery(query={$query_expression.st}, alias={$ID})
+	;
+	
+search_condition
+	:	^((op='OR' ) s1=search_condition s2=search_condition) -> bin_expr_paren(op={$op}, value1={$s1.st}, value2={$s2.st})
+	|	^((op='AND') s1=search_condition s2=search_condition) -> bin_expr(op={$op}, value1={$s1.st}, value2={$s2.st})
+	|	boolean_term -> {$boolean_term.st}
+	;
+boolean_term
+	:	predicate -> {$predicate.st}
+	|	^(op=NOT predicate)  -> unary_expr(op={$op.text}, value={$predicate.st})
+	;
+predicate
+	:	comparison_predicate -> {$comparison_predicate.st}
+	|	like_predicate       -> {$like_predicate.st}
+	| 	in_predicate         -> {$in_predicate.st}
+	| 	null_predicate       -> {$null_predicate.st}
+	| 	exists_predicate     -> {$exists_predicate.st}
+	|	between_predicate    -> {$between_predicate.st}
+	;
+null_predicate
+	:	^(IS_NULL row_value) -> unary_expr(op={$row_value.st}, value={"IS NULL"});
+in_predicate
+	:	^(op='IN' row_value in_predicate_tail) ->  bin_expr(op={$op}, value1={$row_value.st}, value2={$in_predicate_tail.st});
+in_predicate_tail
+	:	query_expression -> paren(str={$query_expression.st})
+	| 	^(SET (e+=value_expression)+) -> set(expr={$e});
+between_predicate
+	:	^('BETWEEN' val=row_value gt=row_value lt=row_value) -> between(value={$val.st}, greater_than={$gt.st}, less_than={$lt.st});
+exists_predicate
+	:	^(name='EXISTS' query_expression) -> function(name={$name}, param={$query_expression.st});
+comparison_predicate
+	:	^((op='=' | op='<>' | op='!=' | op='<' | op='>' | op='>=' | op='<=') v1=row_value v2=row_value) 
+			-> bin_expr(op={$op}, value1={$v1.st}, value2={$v2.st});
+like_predicate
+	:	^(op='LIKE' v1=row_value v2=row_value) -> bin_expr(op={$op}, value1={$v1.st}, value2={$v2.st});
+
+row_value
+	:	value_expression  -> {$value_expression.st}
+	| 	str='NULL'        -> emitstr(str={$str})
+	| 	str='DEFAULT'     -> emitstr(str={$str})
+	| 	query_expression  -> {$query_expression.st};
+
+table_name
+	:	ID -> emitstr(str={$ID});
+column_name
+	:	^(TABLECOLUMN ID)        -> emitstr(str={$ID})
+	|	^(TABLECOLUMN t=ID c=ID) -> column_name(table={$t}, name={$c});


Property changes on: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.g
___________________________________________________________________
Added: svn:executable
   + *

Added: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.tokens
===================================================================
--- ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.tokens	                        (rev 0)
+++ ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.tokens	2010-01-27 16:31:17 UTC (rev 448)
@@ -0,0 +1,89 @@
+TABLECOLUMN=18
+RIGHT_OUTER_JOIN=19
+FROM_LIST=9
+SELECT_LIST=8
+STATEMENT=4
+GROUP_BY=11
+WS=29
+FULL_OUTER_JOIN=21
+STRING=28
+FLOAT=26
+QUERY=5
+RELATION=13
+SETOP=6
+LEFT_OUTER_JOIN=20
+ORDER=7
+FUNCTION=15
+IS_NULL=23
+INT=25
+HAVING=12
+SET=17
+COLUMN=14
+JOIN=22
+NOT=16
+NUMERIC=27
+WHERE=10
+ID=24
+'MAX'=53
+'<'=84
+'>'=85
+'DISTINCT'=39
+'COUNT'=51
+'-'=49
+'!='=83
+'>='=86
+'INTERSECT'=30
+'MINUTE'=64
+'<='=87
+'||'=66
+'='=81
+'SUM'=55
+'OUTER'=69
+'DATE'=56
+'WHERE'=36
+'AS'=44
+'TIME'=58
+'GROUP BY'=37
+'.'=92
+'DAY'=62
+'*'=42
+'<>'=82
+'SELECT'=34
+'HAVING'=38
+'YEAR'=60
+'LEFT'=71
+'OR'=74
+'SOME'=88
+'EXCEPT'=32
+'DEFAULT'=91
+'ORDER'=46
+'FROM'=35
+','=43
+'NOT'=76
+'IS'=77
+'MONTH'=61
+'INTERVAL'=59
+'NULL'=45
+'/'=50
+'RIGHT'=68
+'ON'=67
+'ANY'=89
+'BY'=47
+'UNION'=31
+'HOUR'=63
+')'=41
+'AVG'=52
+'MIN'=54
+'IN'=78
+'ALL'=33
+'SECOND'=65
+'LIKE'=90
+'AND'=75
+'JOIN'=70
+'('=40
+'BETWEEN'=79
+'FULL'=72
+'EXISTS'=80
+'TIMESTAMP'=57
+'+'=48
+'INNER'=73


Property changes on: ogsa-dai/trunk/extensions/views/server/src/main/grammar/SQL92QueryWalker.tokens
___________________________________________________________________
Added: svn:executable
   + *

Added: ogsa-dai/trunk/extensions/views/server/src/main/resources/SQL92Query.stg
===================================================================
--- ogsa-dai/trunk/extensions/views/server/src/main/resources/SQL92Query.stg	                        (rev 0)
+++ ogsa-dai/trunk/extensions/views/server/src/main/resources/SQL92Query.stg	2010-01-27 16:31:17 UTC (rev 448)
@@ -0,0 +1,20 @@
+group SQL92Query;
+
+column_list(columns) ::= "<columns; separator=\", \">"
+emitstr(str) ::= "<str>"
+statement(query, order_by) ::= "<query> <if(order_by)><order_by><endif>"
+order_by(columns) ::= "ORDER BY <columns; separator=\", \">"
+query(select_list, from_list, where, group_by, having, set_quantifier) ::= "SELECT <if(set_quantifier)><set_quantifier><endif><select_list> FROM <from_list; separator=\", \"><where:{ w |  WHERE <w>}><if(group_by)> GROUP BY <group_by; separator=\", \"><endif><having:{h |  HAVING <h>}>"
+set_op(op, value1, value2, all) ::= "<value1> <op> <if(all)>ALL<endif> <value2>"
+unary_expr(op, value) ::= "<op> <value>"
+bin_expr(op, value1, value2) ::= "<value1> <op> <value2>"
+bin_expr_paren(op, value1, value2) ::= "(<value1> <op> <value2>)"
+paren(str) ::= "(<str>)"
+function(name, param) ::= "<name>(<param; separator=\", \">)"
+column_name(table, name) ::= "<table>.<name>"
+expr_as(expression, alias) ::= "<expression> AS <alias>"
+subquery(query, alias) ::= "(<query>) AS <alias>"
+join(type, table1, table2, condition) ::= "<table1> <type> JOIN <table2> ON <condition>"
+between(value, greater_than, less_than) ::= "<value> BETWEEN <greater_than> AND <less_than>"
+set(expr) ::= "(<expr; separator=\", \">)"
+interval(value, field) ::= "INTERVAL <value> <field>"
\ No newline at end of file


Property changes on: ogsa-dai/trunk/extensions/views/server/src/main/resources/SQL92Query.stg
___________________________________________________________________
Added: svn:executable
   + *

Added: ogsa-dai/trunk/extensions/views/server/src/main/resources/views_messages.properties
===================================================================
--- ogsa-dai/trunk/extensions/views/server/src/main/resources/views_messages.properties	                        (rev 0)
+++ ogsa-dai/trunk/extensions/views/server/src/main/resources/views_messages.properties	2010-01-27 16:31:17 UTC (rev 448)
@@ -0,0 +1,28 @@
+# Copyright (c) The University of Edinburgh, 2007-2008.
+# LICENCE-START
+# Licensed under the Apache License, Version 2.0 (the "License");
+# you may not use this file except in compliance with the License.
+# You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software 
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+# LICENCE-END
+
+#
+# OGSA-DAI Views English language message resource bundle.
+uk.org.ogsadai.virtual.virtual.AMBIGUOUS_IDENTIFIER= The identifier {0} is ambiguous and needs to be qualified.
+uk.org.ogsadai.virtual.ANNOTATION_UNKNOWN= Annotation with key {0} is unknown.
+uk.org.ogsadai.virtual.COLUMN_UNKNOWN = Column with name {0} is unknown.
+uk.org.ogsadai.virtual.DATA_RESOURCE_INITIALIZATION = Error has occurred with resource initialization of {0}.
+uk.org.ogsadai.virtual.METADATA_INITIALIZATION = Metadata initialization error on resource {0}.
+uk.org.ogsadai.virtual.RESOURCE_DUPLICATION= A resource with this name already exists {0}.
+uk.org.ogsadai.virtual.RESOURCE_UNKNOWN=This resource {0} is unknown.
+uk.org.ogsadai.virtual.TABLE_UNKNOWN=Table {0} cannot be found.
+uk.org.ogsadai.virtual.VIEWMANAGER_INITIALIZATION=An error has occurred during the view manager initialization.
+uk.org.ogsadai.virtual.CONFIG_FILE_ERROR=Error in reading value for key {0} has occurred.
+uk.org.ogsadai.virtual.VIEW_STATEMENT_ERROR=Error in SQL View statement {0}.
\ No newline at end of file


Property changes on: ogsa-dai/trunk/extensions/views/server/src/main/resources/views_messages.properties
___________________________________________________________________
Added: svn:executable
   + *


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.