Examples with Column com.alibaba.druid.stat.TableStat.Column used on opensource projects

Example 91 with Column

use of com.alibaba.druid.stat.TableStat.Column in project druid by alibaba.

the class MySqlCreateTableTest18 method test_0.

public void test_0() throws Exception {
    String sql = //
    "CREATE TABLE IF NOT EXISTS `t_awards` (" + //
    "  `id` int(11) NOT NULL AUTO_INCREMENT," + //
    "  `seller_id` int(11) NOT NULL," + //
    "  `shop_id` int(11) DEFAULT NULL," + //
    "  `mode` int(4) NOT NULL," + //
    "  `draw_rate_1` int(11) NOT NULL," + //
    "  `draw_rate_2` int(11) NOT NULL," + //
    "  `amount` int(11) NOT NULL," + //
    "  `position_code` int(11) NOT NULL," + //
    "  `f_denomination` int(11) DEFAULT NULL," + //
    "  `f_description` text," + //
    "  `f_url` text," + //
    "  `f_type` int(4) DEFAULT NULL," + //
    "  PRIMARY KEY (`id`)," + //
    "  UNIQUE KEY `id` (`id`)" + //
    ") ENGINE=InnoDB  DEFAULT CHARSET=gbk" + ";";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    SQLStatement statemen = statementList.get(0);
    //		print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    statemen.accept(visitor);
    //		System.out.println("Tables : " + visitor.getTables());
    //		System.out.println("fields : " + visitor.getColumns());
    //		System.out.println("coditions : " + visitor.getConditions());
    //		System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(12, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("t_awards")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("t_awards", "f_type")));
}

Example 92 with Column

use of com.alibaba.druid.stat.TableStat.Column in project druid by alibaba.

the class MySqlCreateTableTest2 method test_0.

public void test_0() throws Exception {
    String sql = "CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10)));";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    SQLStatement statemen = statementList.get(0);
    //        print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    statemen.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //        System.out.println("fields : " + visitor.getColumns());
    //        System.out.println("coditions : " + visitor.getConditions());
    //        System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(1, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("test")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("test", "blob_col")));
}

Example 93 with Column

use of com.alibaba.druid.stat.TableStat.Column in project druid by alibaba.

the class MySqlCreateTableTest3 method test_0.

public void test_0() throws Exception {
    String sql = "CREATE TABLE tk (col1 INT, col2 CHAR(5), col3 DATE)    PARTITION BY KEY(col3)    PARTITIONS 4;";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    SQLStatement statemen = statementList.get(0);
    //        print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    statemen.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //        System.out.println("fields : " + visitor.getColumns());
    //        System.out.println("coditions : " + visitor.getConditions());
    //        System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(3, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("tk")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tk", "col1")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tk", "col2")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tk", "col3")));
}

Example 94 with Column

use of com.alibaba.druid.stat.TableStat.Column in project druid by alibaba.

the class MySqlSelectTest_0 method test_0.

public void test_0() throws Exception {
    String sql = "SELECT CONCAT(last_name,', ',first_name) AS full_name FROM mytable ORDER BY full_name;";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    SQLStatement statemen = statementList.get(0);
    //        print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    statemen.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //        System.out.println("fields : " + visitor.getColumns());
    //        System.out.println("coditions : " + visitor.getConditions());
    //        System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(2, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("mytable")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("mytable", "last_name")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("mytable", "first_name")));
}

Example 95 with Column

use of com.alibaba.druid.stat.TableStat.Column in project druid by alibaba.

the class MySqlSelectTest_2 method test_0.

public void test_0() throws Exception {
    String sql = "SELECT college, region, seed FROM tournament ORDER BY 2, 3;";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    SQLStatement statemen = statementList.get(0);
    //        print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    statemen.accept(visitor);
    //        System.out.println("Tables : " + visitor.getTables());
    //        System.out.println("fields : " + visitor.getColumns());
    //        System.out.println("coditions : " + visitor.getConditions());
    //        System.out.println("orderBy : " + visitor.getOrderByColumns());
    Assert.assertEquals(1, visitor.getTables().size());
    Assert.assertEquals(3, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("tournament")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tournament", "college")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tournament", "region")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tournament", "seed")));
}