Package net.sf.jsqlparser.test.truncate

Source Code of net.sf.jsqlparser.test.truncate.TruncateTest

package net.sf.jsqlparser.test.truncate;

import java.io.StringReader;

import junit.framework.TestCase;
import net.sf.jsqlparser.parser.CCJSqlParserManager;
import net.sf.jsqlparser.statement.truncate.Truncate;

public class TruncateTest extends TestCase {

  private CCJSqlParserManager parserManager = new CCJSqlParserManager();

  public TruncateTest(String arg0) {
    super(arg0);
  }

  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().getFullyQualifiedName());
    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());
  }
}
TOP

Related Classes of net.sf.jsqlparser.test.truncate.TruncateTest

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.