pass SQL code through Go SQL parser

mysqllint.go

package main

import (
	"github.com/xwb1989/sqlparser"

	"flag"
	"fmt"
	"io"
	"io/ioutil"
	"os"
)

var flagFile = flag.String("file", "", "SQL script path to check")

func Usage() {
	fmt.Printf("Usage: %s -file <sql script path>\n", os.Args[0])
}

func main() {
	flag.Parse()

	if flagFile == nil || *flagFile == "" {
		Usage()
		os.Exit(1)
	}

	filePath := *flagFile

	sqlScriptBytes, err := ioutil.ReadFile(filePath)

	if err != nil {
		panic(err)
	}

	sqlScript := string(sqlScriptBytes)

	tokenizer := sqlparser.NewStringTokenizer(sqlScript)

	for {
		_, err := sqlparser.ParseNext(tokenizer)

		if err == io.EOF {
			break
		}

		if err != nil {
			fmt.Printf("%s: %v\n", filePath, err)
			os.Exit(1)
		}
	}
}