GeneralTest.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package net.sf.jsqlparser.test;

import org.junit.Test;
import net.sf.jsqlparser.statement.insert.Insert;
import net.sf.jsqlparser.statement.delete.Delete;
import net.sf.jsqlparser.statement.Statement;
import java.io.StringReader;
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.parser.CCJSqlParserManager;
import net.sf.jsqlparser.statement.select.Select;
import net.sf.jsqlparser.util.deparser.ExpressionDeParser;
import net.sf.jsqlparser.util.deparser.StatementDeParser;
import org.junit.Before;
import static org.junit.Assert.*;

/**
 *
 * @author mg
 */
public class GeneralTest {

    protected CCJSqlParserManager parserManager;

    @Before
    public void setup() {
        parserManager = new CCJSqlParserManager();
    }

    @Test
    public void dummyTest()
    {
    }

    public void checkParseAndDeparse(String statementText) throws JSQLParserException {
        Statement statement = parserManager.parse(new StringReader(statementText));
        assertNotNull(statement);
        StringBuilder buffer = new StringBuilder();
        StatementDeParser deparser = new StatementDeParser(buffer);
        if (statement instanceof Select) {
            deparser.visit((Select) statement);
        } else if (statement instanceof Delete) {
            deparser.visit((Delete) statement);
        } else if (statement instanceof Insert) {
            deparser.visit((Insert) statement);
        } else {
            throw new JSQLParserException("Unknown type of parsed statement");
        }
        assertEquals(buffer.toString().toLowerCase().replaceAll(ExpressionDeParser.LINE_SEPARATOR, ""), statementText.toLowerCase().replaceAll(ExpressionDeParser.LINE_SEPARATOR, ""));
    }

}