Java EExpressionType.function_t方法代码示例

import gudusoft.gsqlparser.EExpressionType; //导入方法依赖的package包/类
private void convertExpressionToCharacterPrimary( TExpression expression,
		character_primary character_primary )
{
	if ( expression.getExpressionType( ) == EExpressionType.function_t )
	{
		string_value_function stringValueFunction = new string_value_function( );
		character_primary.setString_value_function( stringValueFunction );
		convertExpressionToStringValueFunction( expression,
				stringValueFunction );
	}
	else
	{
		value_expression_primary valueExpressionPrimary = new value_expression_primary( );
		character_primary.setValue_expression_primary( valueExpressionPrimary );
		convertExpressionToValueExpressionPrimary( expression,
				valueExpressionPrimary );
	}
}
 

import gudusoft.gsqlparser.EExpressionType; //导入方法依赖的package包/类
private boolean isStringValueExpression( TExpression expression )
{
	if ( expression.getExpressionType( ) == EExpressionType.concatenate_t )
	{
		return true;
	}
	else if ( expression.getExpressionType( ) == EExpressionType.simple_constant_t )
	{
		if ( Utility.isString( expression.toString( ) ) )
		{
			return true;
		}
	}
	else if ( expression.getExpressionType( ) == EExpressionType.function_t )
	{
		String functionName = expression.getFunctionCall( )
				.getFunctionName( )
				.toString( );
		if ( Utility.isStringValueFunction( functionName ) )
		{
			return true;
		}
	}
	return false;
}
 

import gudusoft.gsqlparser.EExpressionType; //导入方法依赖的package包/类
private boolean isWindowFunctionExpression( TExpression expression )
{
	if ( expression.getExpressionType( ) == EExpressionType.function_t )
	{
		String functionName = expression.getFunctionCall( )
				.getFunctionName( )
				.toString( );
		if ( Utility.isWindowFunction( functionName ) )
		{
			return true;
		}
	}
	return false;
}
 

import gudusoft.gsqlparser.EExpressionType; //导入方法依赖的package包/类
private boolean isCastExpression( TExpression expression )
{
	if ( expression.getExpressionType( ) == EExpressionType.function_t )
	{
		String functionName = expression.getFunctionCall( )
				.getFunctionName( )
				.toString( )
				.trim( );
		if ( "CAST".equalsIgnoreCase( functionName ) )
		{
			return true;
		}
	}
	return false;
}
 

import gudusoft.gsqlparser.EExpressionType; //导入方法依赖的package包/类
private boolean isCaseAbbreviationExpression( TExpression expression )
{
	if ( expression.getExpressionType( ) == EExpressionType.function_t )
	{
		String functionName = expression.getFunctionCall( )
				.getFunctionName( )
				.toString( );
		if ( Utility.isCaseAbbreviationFunction( functionName ) )
		{
			return true;
		}
	}
	return false;
}
 

import gudusoft.gsqlparser.EExpressionType; //导入方法依赖的package包/类
private boolean isNumericValueExpression( TExpression expression )
{
	if ( expression.getExpressionType( ) == EExpressionType.arithmetic_plus_t
			|| expression.getExpressionType( ) == EExpressionType.arithmetic_minus_t
			|| expression.getExpressionType( ) == EExpressionType.arithmetic_divide_t
			|| expression.getExpressionType( ) == EExpressionType.arithmetic_times_t
			|| expression.getExpressionType( ) == EExpressionType.unary_plus_t
			|| expression.getExpressionType( ) == EExpressionType.unary_minus_t )
	{
		if ( expression.getLeftOperand( ) != null )
		{
			boolean isDateType = isDateTypeValueExpression( expression.getLeftOperand( ) );
			if ( isDateType )
				return false;
		}
		return true;
	}
	else if ( expression.getExpressionType( ) == EExpressionType.simple_constant_t )
	{
		if ( Utility.isNumber( expression.toString( ) ) )
		{
			return true;
		}
	}
	else if ( expression.getExpressionType( ) == EExpressionType.function_t )
	{
		String functionName = expression.getFunctionCall( )
				.getFunctionName( )
				.toString( );
		if ( Utility.isNumericValueFunction( functionName )
				|| Utility.isAggregateFunction( functionName ) )
		{
			return true;
		}
	}
	return false;
}
 

import gudusoft.gsqlparser.EExpressionType; //导入方法依赖的package包/类
public UpdateStmt(TUpdateSqlStatement stmt) throws NoSqlTypeException {
    super(stmt);
    this.Op = "UPDATE";
    // if the target is an alia, it means itself is an source, add it into source in checkAlias function
    this.targetTables.add(checkAlias(stmt.tables, stmt.getTargetTable()
            .getName()));

    // the first one is target, begin from second one
    for (int i = 1; i < stmt.tables.size(); i++) {
        if (stmt.tables.getTable(i).isBaseTable()) {
            this.sourceTables.add(stmt.tables.getTable(i).toString());
            //System.out.println(i+stmt.tables.getTable(i).toString());
        } else {
            this.nestedSource
                    .add(SqlParser.analyzeStmt(stmt.tables.getTable(i).subquery));
            //System.out.println(i+stmt.tables.getTable(i).toString());
        }
    }
    if (stmt.getWhereClause() != null) {
        whereClause = stmt.getWhereClause().toString();
        // if there is a select in "in" clause, this should also be a source
        // this expression can be exreamly complex, can't fit for all
        processWhere(stmt);

    }

    // check the source inside the set clause
    TResultColumn a = stmt.getResultColumnList().getResultColumn(0);
    TExpression expression = a.getExpr();
    TExpression value = expression.getRightOperand();

    value.getExpressionType();

    if( value.getExpressionType() == EExpressionType.function_t ){
        TExpressionList argList = value.getFunctionCall().getArgs();
        for(int i=0; i< argList.size(); i++){
            TExpression arg = argList.getExpression(i);
            if (arg.getExpressionType() == EExpressionType.subquery_t){
                Stmt subqury = SqlParser.analyzeStmt(arg.getSubQuery());
                this.nestedSource.add(subqury);
            }
        }
    }
}