package demos.getstatement;


import gudusoft.gsqlparser.*;

import java.io.File;

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

        if (args.length != 1){
            System.out.println("Usage: java getstatement 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.dbvmssql);
    sqlparser.sqlfilename  = args[0];

    int ret = sqlparser.getrawsqlstatements();
    if (ret == 0){
        for(int i=0;i<sqlparser.sqlstatements.size();i++){
            System.out.println(sqlparser.sqlstatements.get(i).sqlstatementtype.toString());
            System.out.println(sqlparser.sqlstatements.get(i).toString());
            System.out.println();
        }
    }else{
        System.out.println(sqlparser.getErrormessage());
    }

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