Package net.sf.jsqlparser.schema

Examples of net.sf.jsqlparser.schema.Column

50
51
52
53
54
55
56
57
58
59
60
61
    buffer.append("INSERT INTO ");
    buffer.append(insert.getTable().getWholeTableName());
    if (insert.getColumns() != null) {
      buffer.append("(");
      for (Iterator iter = insert.getColumns().iterator(); iter.hasNext();) {
        Column column = (Column) iter.next();
        buffer.append(column.getColumnName());
        if (iter.hasNext()) {
          buffer.append(", ");
        }
      }
      buffer.append(")");
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    buffer.append("REPLACE " + replace.getTable().getWholeTableName());
    if (replace.getItemsList() != null) {
      if (replace.getColumns() != null) {
        buffer.append(" (");
        for (int i = 0; i < replace.getColumns().size(); i++) {
          Column column = (Column) replace.getColumns().get(i);
          buffer.append(column.getWholeColumnName());
          if (i < replace.getColumns().size() - 1) {
            buffer.append(", ");
          }
        }
        buffer.append(") ");
      } else {
        buffer.append(" ");
      }

    } else {
      buffer.append(" SET ");
      for (int i = 0; i < replace.getColumns().size(); i++) {
        Column column = (Column) replace.getColumns().get(i);
        buffer.append(column.getWholeColumnName() + "=");

        Expression expression = (Expression) replace.getExpressions().get(i);
        expression.accept(expressionVisitor);
        if (i < replace.getColumns().size() - 1) {
          buffer.append(", ");
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
   * Test of addColumn method, of class SelectUtils.
   */
  @Test
  public void testAddExpr() throws JSQLParserException {
    Select select = (Select) CCJSqlParserUtil.parse("select a from mytable");
    SelectUtils.addExpression(select, new Column("b"));
    assertEquals("SELECT a, b FROM mytable", select.toString());
   
    Addition add = new Addition();
    add.setLeftExpression(new LongValue(5));
    add.setRightExpression(new LongValue(6));
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
 
  @Test
  public void testAddJoin() throws JSQLParserException {
    Select select = (Select)CCJSqlParserUtil.parse("select a from mytable");
    final EqualsTo equalsTo = new EqualsTo();
    equalsTo.setLeftExpression(new Column("a"));
    equalsTo.setRightExpression(new Column("b"));
    Join addJoin = SelectUtils.addJoin(select, new Table("mytable2"), equalsTo);
    addJoin.setLeft(true);
    assertEquals("SELECT a FROM mytable LEFT JOIN mytable2 ON a = b", select.toString());
  }
View Full Code Here
72
73
74
75
76
77
78
79
    assertEquals("SELECT a FROM mytable LEFT JOIN mytable2 ON a = b", select.toString());
  }
 
  @Test
  public void testBuildSelectFromTableAndExpressions() {
    Select select = SelectUtils.buildSelectFromTableAndExpressions(new Table("mytable"), new Column("a"), new Column("b"));
    assertEquals("SELECT a, b FROM mytable", select.toString());
  }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
    buffer.append("REPLACE ").append(replace.getTable().getFullyQualifiedName());
    if (replace.getItemsList() != null) {
      if (replace.getColumns() != null) {
        buffer.append(" (");
        for (int i = 0; i < replace.getColumns().size(); i++) {
          Column column = replace.getColumns().get(i);
          buffer.append(column.getFullyQualifiedName());
          if (i < replace.getColumns().size() - 1) {
            buffer.append(", ");
          }
        }
        buffer.append(") ");
      } else {
        buffer.append(" ");
      }

    } else {
      buffer.append(" SET ");
      for (int i = 0; i < replace.getColumns().size(); i++) {
        Column column = replace.getColumns().get(i);
        buffer.append(column.getFullyQualifiedName()).append("=");

        Expression expression = replace.getExpressions().get(i);
        expression.accept(expressionVisitor);
        if (i < replace.getColumns().size() - 1) {
          buffer.append(", ");
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
    public void deParse(Update update) {
        buffer.append("UPDATE ").append(PlainSelect.getStringList(update.getTables(), true, false)).append(" SET ");

        if (!update.isUseSelect()) {
            for (int i = 0; i < update.getColumns().size(); i++) {
                Column column = update.getColumns().get(i);
                buffer.append(column.getFullyQualifiedName()).append(" = ");

                Expression expression = update.getExpressions().get(i);
                expression.accept(expressionVisitor);
                if (i < update.getColumns().size() - 1) {
                    buffer.append(", ");
                }
            }
        } else {
            if (update.isUseColumnsBrackets()) {
                buffer.append("(");
            }
            for (int i = 0; i < update.getColumns().size(); i++) {
                if (i != 0) {
                    buffer.append(", ");
                }
                Column column = update.getColumns().get(i);
                buffer.append(column.getFullyQualifiedName());
            }
            if (update.isUseColumnsBrackets()) {
                buffer.append(")");
            }
            buffer.append(" = ");
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
        buffer.append("INSERT INTO ");
        buffer.append(insert.getTable().getFullyQualifiedName());
        if (insert.getColumns() != null) {
            buffer.append(" (");
            for (Iterator<Column> iter = insert.getColumns().iterator(); iter.hasNext();) {
                Column column = iter.next();
                buffer.append(column.getColumnName());
                if (iter.hasNext()) {
                    buffer.append(", ");
                }
            }
            buffer.append(")");
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
        qualifiedItems = new ArrayList(cols.length);

        for (int i = 0; i < cols.length; i++) {
            String colName = cols[i].getName();

            Column column = new Column();
            column.setTable(qt);
            column.setColumnName(colName);

            SelectExpressionItem item = new SelectExpressionItem();
            item.setExpression(column);

            qualifiedItems.add(item);
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
65
            // clause,
            // replace its table by the original one to get rid of the alias
            qualifiedTable = unaliasedTable;
        }

        Column qualifiedColumn = new Column();

        qualifiedColumn.setColumnName(columnName);
        qualifiedColumn.setTable(qualifiedTable);

        return qualifiedColumn;
    }
View Full Code Here
TOP

Related Classes of net.sf.jsqlparser.schema.Column

  • com.alimama.mdrill.jdbc.SqlParser
  • com.linkedin.helix.josql.ZNRecordQueryProcessor
  • estimators.SelingerSelectivityEstimatorTest
  • net.sf.jsqlparser.parser.CCJSqlParser
  • net.sf.jsqlparser.util.deparser.InsertDeParser
  • net.sf.jsqlparser.util.deparser.ReplaceDeParser
  • net.sf.jsqlparser.util.deparser.SelectDeParser
  • net.sf.jsqlparser.util.deparser.UpdateDeParser
  • net.sf.jsqlparser.util.SelectUtilsTest
  • optimizers.cost.ProjGlobalCollectTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.