Class SelectTest

src/test/java/com/sql/parse/statement/druid/SelectTest.java:20–606

@date 2019年4月29日上午11:20:58·· @desc Select语法单元测试类

 * @desc Select语法单元测试类
 */
public class SelectTest {
    private static final Logger logger = LogManager.getLogger(SelectTest.class);

    private String table1;
    private String table2;
    private String column1;
    private String column2;
    private String column3;
    private String simpleSql;
    private String simpleSql2;

    @Before
    public void before() {
        // TODO Auto-generated method stub
        table1 = "table1";
        table2 = "table2";
        column1 = "column1";
        column2 = "column2";
        column3 = "column3";
        simpleSql = "select " + column1 +" from " + table1;
        simpleSql2 = "select t." + column1 + " from " + table1 + " t";
    }

    @Test
    public void testParse() {
        try {
            Select select = Select.parse(simpleSql);
            Assert.assertEquals(
                    SqlFormatter.format(select.getSql()),
                    SqlFormatter.format("SELECT column1 FROM table1 LIMIT 500")
            );
            Assert.assertEquals(
                    SqlFormatter.format(select.getSql(false)),
                    SqlFormatter.format("SELECT column1 FROM table1")
            );
        } catch (Exception e) {
            Assert.fail(e.getMessage());
        }
    }

    /**
     * @desc 新增查询列
     */
    @Test
    public void testSelectWithAddColumns() {
        try {
            Select select = Select.parse(simpleSql);
            Assert.assertEquals(
                    SqlFormatter.format(select.getSql()),
                    SqlFormatter.format("SELECT column1 FROM table1 LIMIT 500")
            );
            Assert.assertEquals(
                    SqlFormatter.format(select.getSql(false)),
                    SqlFormatter.format("SELECT column1 FROM table1")
            );
            select.addColumn(column2).addColumn(column3);
            Assert.assertEquals(
                    SqlFormatter.format(select.getSql()),