package demos.checksyntax;

/**
 * This demo illustrate how to use general sql parser to check syntax of SQL script.
 * You can download more demos from official site: http://www.sqlparser.com 
 */

import gudusoft.gsqlparser.*;

import java.io.File;


public class checksyntax {

     public static void main(String args[])
    {
        long t = System.currentTimeMillis();

        if (args.length != 1){
            System.out.println("Usage: java checksyntax sqlfile.sql");
            return;
        }
        File file=new File(args[0]);
        if (!file.exists()){
            System.out.println("File not exists:"+args[0]);
            return;
        }

        TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvoracle);
        sqlparser.sqlfilename  = args[0];

        int ret = sqlparser.parse();
        if (ret == 0){
            System.out.println("Check syntax ok!");
        }else{
            System.out.println(sqlparser.getErrormessage());
        }

        System.out.println("Time Escaped: "+ (System.currentTimeMillis() - t) );
    }
}