Function parseOptions

cmd/psqldef/psqldef.go:23–160

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) {
	// PostgreSQL-specific default: legacy_ignore_quotes is true for backward compatibility
	defaultConfig := database.GeneratorConfig{LegacyIgnoreQuotes: true}
	configs := []database.GeneratorConfig{defaultConfig}

	var opts struct {
		User                  string   `short:"U" long:"user" description:"PostgreSQL user name" value-name:"USERNAME" default:"postgres"`
		Password              string   `short:"W" long:"password" description:"PostgreSQL user password, overridden by $PGPASSWORD" value-name:"PASSWORD"`
		Host                  string   `short:"h" long:"host" description:"Host or socket directory to connect to the PostgreSQL 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:"5432"`
		Prompt                bool     `long:"password-prompt" description:"Force PostgreSQL user password prompt"`
		File                  []string `short:"f" 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"`
		SkipView              bool     `long:"skip-view" description:"Skip managing views/materialized views"`
		SkipExtension         bool     `long:"skip-extension" description:"Skip managing extensions"`
		SkipPartition         bool     `long:"skip-partition" description:"Skip managing partitioned tables"`
		DisableDdlTransaction bool     `long:"disable-ddl-transaction" description:"Execute DDL statements outside a transaction block"`
		BeforeApply           string   `long:"before-apply" description:"Execute the given string before applying the regular DDLs" value-name:"SQL"`

		// 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]... DBNAME --export
  psqldef [OPTION]... DBNAME --apply < desired.sql
  psqldef [OPTION]... DBNAME --dry-run < desired.sql
  psqldef [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-psqldef.md\n", sqldef.GetVersion())
		os.Exit(0)
	}

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