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

Example 16 with Column

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

the class MySqlCreateTableTest6 method test_0.

public void test_0() throws Exception {
    String sql = //
    "CREATE TABLE Persons\n" + //
    "(\n" + //
    "Id_P int NOT NULL,\n" + //
    "LastName varchar(255) NOT NULL,\n" + //
    "FirstName varchar(255),\n" + //
    "Address varchar(255),\n" + //
    "City varchar(255),\n" + //
    "UNIQUE (Id_P)\n" + ")";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    MySqlCreateTableStatement stmt = (MySqlCreateTableStatement) statementList.get(0);
    //        print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    stmt.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(5, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("Persons")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("Persons", "Id_P")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("Persons", "LastName")));
}

Example 17 with Column

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

the class MySqlCreateTableTest5 method test_0.

public void test_0() throws Exception {
    String sql = //
    "CREATE TABLE `test` (" + //
    "  `id` bigint(20) NOT NULL AUTO_INCREMENT," + //
    "  `dspcode` char(200) DEFAULT NULL," + //
    "  PRIMARY KEY (`id`)," + //
    "  KEY `index_name` (`dspcode`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    MySqlCreateTableStatement stmt = (MySqlCreateTableStatement) statementList.get(0);
    //        print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    stmt.accept(visitor);
    Assert.assertEquals("utf8", stmt.getTableOptions().get("CHARSET").toString());
    //        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("test")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("test", "id")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("test", "dspcode")));
}

Example 18 with Column

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

the class MySqlCreateTableTest1 method test_0.

public void test_0() throws Exception {
    String sql = //
    "CREATE TABLE lookup" + //
    "  (id INT, INDEX USING BTREE (id))" + "  ENGINE = MEMORY;";
    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("lookup")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("lookup", "id")));
}

Example 19 with Column

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

the class MySqlCreateTableTest11 method test_0.

public void test_0() throws Exception {
    String sql = //
    "CREATE TABLE `tmall_campaign` (" + //
    "`id` int(11) NOT NULL AUTO_INCREMENT," + //
    "`campaign_name` varchar(200) NOT NULL COMMENT '活动名称'," + //
    "`create_date` datetime DEFAULT NULL COMMENT '活动创建时间'," + //
    "`delete_flag` int(11) DEFAULT '0' COMMENT '活动删除标识'," + //
    "PRIMARY KEY (`id`)" + ") ENGINE=InnoDB DEFAULT CHARSET=gbk;";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    SQLCreateTableStatement stmt = (SQLCreateTableStatement) statementList.get(0);
    //        print(statementList);
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    stmt.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(4, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("tmall_campaign")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tmall_campaign", "id")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tmall_campaign", "campaign_name")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tmall_campaign", "create_date")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("tmall_campaign", "delete_flag")));
}

Example 20 with Column

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

the class MySqlCreateTableTest14 method test_0.

public void test_0() throws Exception {
    String sql = //
    " CREATE TABLE `OptionList` ( " + //
    "`ID` int(11) NOT NULL AUTO_INCREMENT, " + //
    "`OptionID` int(11) DEFAULT NULL COMMENT '选项ID', " + //
    "`QuizID` int(11) DEFAULT NULL COMMENT '竞猜题目ID', " + //
    "`OptionName` varchar(500) DEFAULT NULL COMMENT '选项名称', " + //
    "`OptionCount` int(11) DEFAULT NULL COMMENT '选择的人数', " + //
    "PRIMARY KEY (`ID`), KEY `quizId` (`QuizID`) USING BTREE, " + //
    "KEY `optionId` (`OptionID`) USING BTREE" + ") ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT=''";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    SQLStatement stmt = statementList.get(0);
    Assert.assertEquals("CREATE TABLE `OptionList` (" + "\n\t`ID` int(11) NOT NULL AUTO_INCREMENT, " + "\n\t`OptionID` int(11) DEFAULT NULL COMMENT '选项ID', " + "\n\t`QuizID` int(11) DEFAULT NULL COMMENT '竞猜题目ID', " + "\n\t`OptionName` varchar(500) DEFAULT NULL COMMENT '选项名称', " + "\n\t`OptionCount` int(11) DEFAULT NULL COMMENT '选择的人数', " + "\n\tPRIMARY KEY (`ID`), " + "\n\tKEY `quizId` USING BTREE (`QuizID`), " + "\n\tKEY `optionId` USING BTREE (`OptionID`)" + //
    "\n) ENGINE = InnoDB CHARSET = gbk COMMENT = ''", SQLUtils.toMySqlString(stmt));
    Assert.assertEquals("create table `OptionList` (" + "\n\t`ID` int(11) not null auto_increment, " + "\n\t`OptionID` int(11) default null comment '选项ID', " + "\n\t`QuizID` int(11) default null comment '竞猜题目ID', " + "\n\t`OptionName` varchar(500) default null comment '选项名称', " + "\n\t`OptionCount` int(11) default null comment '选择的人数', " + "\n\tprimary key (`ID`), " + "\n\tkey `quizId` using BTREE (`QuizID`), " + "\n\tkey `optionId` using BTREE (`OptionID`)" + //
    "\n) engine = InnoDB charset = gbk comment = ''", SQLUtils.toMySqlString(stmt, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
    Assert.assertEquals(1, statementList.size());
    MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
    stmt.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(5, visitor.getColumns().size());
    Assert.assertEquals(0, visitor.getConditions().size());
    Assert.assertTrue(visitor.getTables().containsKey(new TableStat.Name("OptionList")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("OptionList", "ID")));
    Assert.assertTrue(visitor.getColumns().contains(new Column("OptionList", "OptionCount")));
}