TruncateTest.java

package net.sf.jsqlparser.test.truncate;

import java.io.StringReader;

import static junit.framework.TestCase.*;
import net.sf.jsqlparser.parser.CCJSqlParserManager;
import net.sf.jsqlparser.statement.truncate.Truncate;
import org.junit.Test;

public class TruncateTest {

    private final CCJSqlParserManager parserManager = new CCJSqlParserManager();

    @Test
    public void testTruncate() throws Exception {
        String statement = "TRUncATE TABLE myschema.mytab";
        Truncate truncate = (Truncate) parserManager.parse(new StringReader(statement));
        assertEquals("myschema", truncate.getTable().getSchemaName());
        assertEquals("myschema.mytab", truncate.getTable().getWholeTableName());
        assertEquals(statement.toUpperCase(), truncate.toString().toUpperCase());

        statement = "TRUncATE   TABLE    mytab";
        String toStringStatement = "TRUncATE TABLE mytab";
        truncate = (Truncate) parserManager.parse(new StringReader(statement));
        assertEquals("mytab", truncate.getTable().getName());
        assertEquals(toStringStatement.toUpperCase(), truncate.toString().toUpperCase());
    }

    public void testComment() throws Exception {
        String statement =
                "/*welkjhkas*/ TRUNCATE /*3*/ TABLE myschema.mytab /*ksjdf*/";
        Truncate truncate = (Truncate) parserManager.parse(new StringReader(statement));
        assertEquals(statement, "" + truncate);
    }
}