Function parseOptions

cmd/mssqldef/mssqldef.go:22–146

Return parsed options and schema filename TODO: Support `sqldef schema.sql -opt val...`

(args []string)

// Return parsed options and schema filename
// TODO: Support `sqldef schema.sql -opt val...`
func parseOptions(args []string) (database.Config, *sqldef.Options) {
	// MSSQL default: legacy_ignore_quotes is true (legacy mode)
	defaultConfig := database.GeneratorConfig{LegacyIgnoreQuotes: true}
	configs := []database.GeneratorConfig{defaultConfig}

	var opts struct {
		User       string   `short:"U" long:"user" description:"MSSQL user name" value-name:"USERNAME" default:"sa"`
		Password   string   `short:"P" long:"password" description:"MSSQL user password, overridden by $MSSQL_PWD" value-name:"PASSWORD"`
		Host       string   `short:"h" long:"host" description:"Host to connect to the MSSQL server" value-name:"HOSTNAME" default:"127.0.0.1"`
		Port       uint     `short:"p" long:"port" description:"Port used for the connection" value-name:"PORT" default:"1433"`
		Trusted    bool     `short:"E" long:"trusted-connection" description:"Use Windows authentication"`
		Instance   string   `long:"instance" description:"Instance name" value-name:"INSTANCE"`
		TrustCert  bool     `long:"trust-server-cert" description:"Trust server certificate"`
		Prompt     bool     `long:"password-prompt" description:"Force MSSQL user password prompt"`
		File       []string `long:"file" description:"Read desired SQL from the file, rather than stdin" value-name:"FILENAME" default:"-"`
		DryRun     bool     `long:"dry-run" description:"Don't run DDLs but just show them"`
		Check      bool     `long:"check" description:"Like --dry-run, but exit with code 2 when DDL would be applied (useful as a CI gate to detect schema drift)"`
		Apply      bool     `long:"apply" description:"Apply DDLs to the database (default, but will require this flag in future versions)"`
		Export     bool     `long:"export" description:"Just dump the current schema to stdout"`
		EnableDrop bool     `long:"enable-drop" description:"Enable destructive changes such as DROP for TABLE, SCHEMA, ROLE, USER, FUNCTION, PROCEDURE, TRIGGER, VIEW, INDEX, SEQUENCE, TYPE"`

		// Custom handlers for config flags to preserve order
		Config       func(string) `long:"config" description:"YAML configuration file (can be specified multiple times)" value-name:"PATH"`
		ConfigInline func(string) `long:"config-inline" description:"YAML configuration as inline string (can be specified multiple times)" value-name:"YAML"`

		Help    bool `long:"help" description:"Show this help"`
		Version bool `long:"version" description:"Show version information"`
	}

	opts.Config = func(path string) {
		configs = append(configs, database.ParseGeneratorConfig(path, defaultConfig))
	}
	opts.ConfigInline = func(yaml string) {
		configs = append(configs, database.ParseGeneratorConfigString(yaml, defaultConfig))
	}

	parser := flags.NewParser(&opts, flags.None)
	parser.Usage = `[OPTION]... DATABASE --export
  mssqldef [OPTION]... DATABASE --apply < desired.sql
  mssqldef [OPTION]... DATABASE --dry-run < desired.sql
  mssqldef [OPTION]... current.sql < desired.sql`
	args, err := parser.ParseArgs(args)
	if err != nil {
		log.Fatal(err)
	}

	if opts.Help {
		parser.WriteHelp(os.Stdout)
		fmt.Printf("\nFor more information, see: https://github.com/sqldef/sqldef/blob/v%s/cmd-mssqldef.md\n", sqldef.GetVersion())
		os.Exit(0)
	}

	if opts.Version {
		fmt.Println(sqldef.GetFullVersion())
		os.Exit(0)
	}

	desiredFiles := sqldef.ParseFiles(opts.File)