Examples of SQLParser

adipe.translate.sql.parser.SqlParser
com.facebook.presto.sql.parser.SqlParser
com.foundationdb.sql.parser.SQLParser
com.jengine.orm.db.query.parser.SqlParser
com.salesforce.phoenix.parse.SQLParser
SQL Parser for Phoenix @author jtaylor @since 0.1
org.apache.beehive.controls.system.jdbc.parser.SqlParser
The SqlParser class is a thread-safe class which parses a string containing a SQL statement with JdbcControl substitituion delimiters. It is important to note that the SQL is not parsed/validated - only the sections within the SQL string which are delimited by '{' and '}' are parsed.
Parsing is accomplished using the JavaCC grammar file SqlGrammer.jj. As the string is parsed it is broken into fragments by the parser. Any portion of the string which is not between '{' and '}' delimiters becomes a LiteralFragment. The portions of the SQL string which fall between the start and end delimiters are categorized as either JdbcFragment, ReflectionFragment, or SqlSubstitutionFragment.
Fragments which subclass SqlFragmentContainer may contain other fragments as children. Fragements subclassed from SqlFragment my not contain child fragments. Upon completion of parsing a SqlStatement is returned to the caller. The SqlStatement contains the heirarchary of fragments which have been derived from the orignal SQL string.
The parser will also cache all SqlStatements which contain non-volitale SQL. Only SqlEscapeFragments contain volitile SQL at this point.
org.apache.phoenix.parse.SQLParser
SQL Parser for Phoenix @since 0.1
org.apache.tajo.engine.parser.SQLParser
org.eigenbase.sql.parser.SqlParser
A SqlParser parses a SQL statement.
org.jiql.util.SQLParser
org.tamacat.dao.rdb.internal.SQLParser
org.tmatesoft.sqljet.core.internal.lang.SqlParser

Examples of org.tamacat.dao.rdb.internal.SQLParser

    user.setValue(User.USER_ID, "admin");
    user.setValue(User.PASSWORD, "test");
    query.addUpdateColumn(User.USER_ID);
    query.addUpdateColumn(User.PASSWORD);
    query.addWhere("and", 
      new SQLParser().value(User.USER_ID, Condition.EQUAL, "admin"));
    assertEquals(
      "UPDATE users SET password='test' WHERE users.user_id='admin'",
      query.getUpdateSQL(user));
  }

View Full Code Here

Examples of org.tamacat.dao.rdb.internal.SQLParser

        }
        return select.toString() + from.toString() + where.toString() + orderBy.toString();
    }


    public String getInsertSQL(ORMappingSupport data) {
        SQLParser parser = new SQLParser();
        StringBuffer columns = new StringBuffer();
        StringBuffer values = new StringBuffer();
        blobIndex = 0;
        String tableName = null;
        for (RdbColumnMetaData col : updateColumns.toArray(new RdbColumnMetaData[updateColumns.size()])) {
            if (tableName == null) tableName = col.getRdbTableMetaData().getTableName();
            if (columns.length() > 0) {
                columns.append(",");
                values.append(",");
            }
            columns.append(col.getColumnName());
            if (data.isUpdate(col)) {
                values.append(parser.parseValue(col, data.getValue(col)));
            } else {
              if (col.isAutoGenerateId()) {
                String id = UniqueCodeGenerator.generate();
                  values.append(parser.parseValue(col, id));
                  data.setValue(col, id);
              } else if (col.isAutoTimestamp()) {
                values.append(parser.parseValue(col, getTimestampString()));
              } else {
                values.append(parser.parseValue(col, data.getValue(col)));
              }
            }
            if (col.getType() == RdbDataType.OBJECT) {
              blobIndex++;
            }

View Full Code Here

Examples of org.tamacat.dao.rdb.internal.SQLParser

  public void setUseAutoPrimaryKeyUpdate(boolean useAutoPrimaryKeyUpdate) {
    this.useAutoPrimaryKeyUpdate = useAutoPrimaryKeyUpdate;
  }


  public String getUpdateSQL(ORMappingSupport data) {
        SQLParser parser = new SQLParser();
        StringBuffer values = new StringBuffer();
        String tableName = null;
        blobIndex = 0;
        for (RdbColumnMetaData col : updateColumns.toArray(new RdbColumnMetaData[updateColumns.size()])) {
            if (tableName == null) tableName = col.getRdbTableMetaData().getTableName();
            if (col.isPrimaryKey()) {
              if (useAutoPrimaryKeyUpdate) {
                addWhere("and", parser.value(col, Condition.EQUAL, data.getValue(col)));
              }
                continue;
            }
            if (col.isAutoGenerateId()) continue;
            
            if (data.isUpdate(col)) {
                if (values.length() > 0) {
                    values.append(",");
                }
                values.append(parser.value(col, Condition.EQUAL, data.getValue(col))
                    .replaceFirst(tableName+".", ""));
            } else if (col.isAutoTimestamp()) {
              if (values.length() > 0) {
                    values.append(",");
                }
              values.append(parser.value(col, Condition.EQUAL, getTimestampString())
                  .replaceFirst(tableName+".", ""));
            } else if (col.getType() == RdbDataType.OBJECT) {
              if (values.length() > 0) {
                    values.append(",");
                }
              values.append(parser.value(col, Condition.EQUAL, "?"));
              blobIndex++;
            }
        }
        String query = UPDATE.replace("${TABLE}", tableName)
            .replace("${VALUES}", values.toString());

View Full Code Here

Examples of org.tamacat.dao.rdb.internal.SQLParser


        return query + where.toString();
    }


    public String getDeleteSQL(ORMappingSupport data) {
        SQLParser parser = new SQLParser();
        String tableName = null;
        if (updateColumns != null) {
          for (RdbColumnMetaData col : updateColumns.toArray(new RdbColumnMetaData[updateColumns.size()])) {
              if (tableName == null) tableName = col.getRdbTableMetaData().getTableName();
              if (! useAutoPrimaryKeyUpdate) {
                addWhere("and", parser.value(col, Condition.EQUAL, data.getValue(col)));
              } else if (col.isPrimaryKey()) {
                  addWhere("and", parser.value(col, Condition.EQUAL, data.getValue(col)));
              }
          }
        }
        if (tableName == null) {
          for (RdbTableMetaData table : tables) {

View Full Code Here

Examples of org.tamacat.dao.rdb.internal.SQLParser

    private int max;


    SQLParser parser;


    public RdbSearch() {
        parser = new SQLParser(new DefaultValueConvertFilter());
    }

View Full Code Here

Examples of org.tamacat.dao.rdb.internal.SQLParser

    public RdbSearch() {
        parser = new SQLParser(new DefaultValueConvertFilter());
    }


    public RdbSearch(ValueConvertFilter valueConvertFilter) {
        parser = new SQLParser(valueConvertFilter);
    }

View Full Code Here

Examples of org.tmatesoft.sqljet.core.internal.lang.SqlParser

    private RuleReturnScope parseTable(String sql) throws SqlJetException {
        try {
            CharStream chars = new ANTLRStringStream(sql);
            SqlLexer lexer = new SqlLexer(chars);
            CommonTokenStream tokens = new CommonTokenStream(lexer);
            SqlParser parser = new SqlParser(tokens);
            return parser.schema_create_table_stmt();
        } catch (RecognitionException re) {
            throw new SqlJetException(SqlJetErrorCode.ERROR, "Invalid sql statement: " + sql);
        }
    }

View Full Code Here

Examples of org.tmatesoft.sqljet.core.internal.lang.SqlParser

    private RuleReturnScope parseView(String sql) throws SqlJetException {
        try {
            CharStream chars = new ANTLRStringStream(sql);
            SqlLexer lexer = new SqlLexer(chars);
            CommonTokenStream tokens = new CommonTokenStream(lexer);
            SqlParser parser = new SqlParser(tokens);
            return parser.create_view_stmt();
        } catch (RecognitionException re) {
            throw new SqlJetException(SqlJetErrorCode.ERROR, "Invalid sql statement: " + sql);
        }
    }

View Full Code Here

Examples of org.tmatesoft.sqljet.core.internal.lang.SqlParser

    private RuleReturnScope parseTrigger(String sql) throws SqlJetException {
        try {
            CharStream chars = new ANTLRStringStream(sql);
            SqlLexer lexer = new SqlLexer(chars);
            CommonTokenStream tokens = new CommonTokenStream(lexer);
            SqlParser parser = new SqlParser(tokens);
            return parser.create_trigger_stmt();
        } catch (RecognitionException re) {
            throw new SqlJetException(SqlJetErrorCode.ERROR, "Invalid sql statement: " + sql);
        }
    }

View Full Code Here

Examples of org.tmatesoft.sqljet.core.internal.lang.SqlParser

    private ParserRuleReturnScope parseIndex(String sql) throws SqlJetException {
        try {
            CharStream chars = new ANTLRStringStream(sql);
            SqlLexer lexer = new SqlLexer(chars);
            CommonTokenStream tokens = new CommonTokenStream(lexer);
            SqlParser parser = new SqlParser(tokens);
            return parser.create_index_stmt();
        } catch (RecognitionException re) {
            throw new SqlJetException(SqlJetErrorCode.ERROR, "Invalid sql statement: " + sql);
        }
    }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.