Package net.sf.jsqlparser.statement.select

Examples of net.sf.jsqlparser.statement.select.Select

56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
  }

  @Test
  public void testVisit_PlainSelect_addition() throws JSQLParserException {
    String sql = "select a,b,c from test";
    Select select = (Select) parserManager.parse(new StringReader(sql));
    ConnectExpressionsVisitor instance = new ConnectExpressionsVisitor("testexpr") {
      @Override
      protected BinaryExpression createBinaryExpression() {
        return new Addition();
      }
    };
    select.getSelectBody().accept(instance);

    assertEquals("SELECT a + b + c AS testexpr FROM test", select.toString());
  }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
   * Test of visit method, of class AddAliasesVisitor.
   */
  @Test
  public void testVisit_PlainSelect() throws JSQLParserException {
    String sql = "select a,b,c from test";
    Select select = (Select) parserManager.parse(new StringReader(sql));
    final AddAliasesVisitor instance = new AddAliasesVisitor();
    select.getSelectBody().accept(instance);

    assertEquals("SELECT a AS A1, b AS A2, c AS A3 FROM test", select.toString());
  }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
  }

  @Test
  public void testVisit_PlainSelect_duplicates() throws JSQLParserException {
    String sql = "select a,b as a1,c from test";
    Select select = (Select) parserManager.parse(new StringReader(sql));
    final AddAliasesVisitor instance = new AddAliasesVisitor();
    select.getSelectBody().accept(instance);

    assertEquals("SELECT a AS A2, b AS a1, c AS A3 FROM test", select.toString());
  }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
  }

  @Test
  public void testVisit_PlainSelect_expression() throws JSQLParserException {
    String sql = "select 3+4 from test";
    Select select = (Select) parserManager.parse(new StringReader(sql));
    final AddAliasesVisitor instance = new AddAliasesVisitor();
    select.getSelectBody().accept(instance);

    assertEquals("SELECT 3 + 4 AS A1 FROM test", select.toString());
  }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
   * Test of visit method, of class AddAliasesVisitor.
   */
  @Test
  public void testVisit_SetOperationList() throws JSQLParserException {
    String sql = "select 3+4 from test union select 7+8 from test2";
    Select setOpList = (Select) parserManager.parse(new StringReader(sql));
    final AddAliasesVisitor instance = new AddAliasesVisitor();
    setOpList.getSelectBody().accept(instance);

    assertEquals("(SELECT 3 + 4 AS A1 FROM test) UNION (SELECT 7 + 8 AS A1 FROM test2)", setOpList.toString());
  }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
  /**
   * 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));
    SelectUtils.addExpression(select, add);
   
    assertEquals("SELECT a, b, 5 + 6 FROM mytable", select.toString());
  }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
    assertEquals("SELECT a, b, 5 + 6 FROM mytable", select.toString());
  }
 
  @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
78
79
80
81
82
83
84
85
    assertEquals("SELECT a, b FROM mytable", select.toString());
  }
 
  @Test
  public void testBuildSelectFromTable() {
    Select select = SelectUtils.buildSelectFromTable(new Table("mytable"));
    assertEquals("SELECT * FROM mytable", select.toString());
  }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
    assertEquals("SELECT * FROM mytable", select.toString());
  }
 
  @Test
  public void testBuildSelectFromTableAndParsedExpression() throws JSQLParserException {
    Select select = SelectUtils.buildSelectFromTableAndExpressions(new Table("mytable"), "a+b", "test");
    assertEquals("SELECT a + b, test FROM mytable", select.toString());
   
    assertTrue(((SelectExpressionItem)((PlainSelect)select.getSelectBody()).getSelectItems().get(0)).getExpression() instanceof Addition);
  }
View Full Code Here
TOP

Related Classes of net.sf.jsqlparser.statement.select.Select

  • com.beacon50.jdbc.aws.SimpleDBPreparedStatement
  • com.beacon50.jdbc.aws.SimpleDBStatement
  • net.sf.jsqlparser.parser.CCJSqlParser
  • net.sf.jsqlparser.test.select.SpeedTest
  • net.sf.jsqlparser.util.AddAliasesVisitorTest
  • net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
  • net.sf.jsqlparser.util.deparser.UpdateDeParser
  • net.sf.jsqlparser.util.SelectUtils
  • net.sf.jsqlparser.util.SelectUtilsTest
  • net.sf.jsqlparser.util.TablesNamesFinderTest
    • 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.