package config

import "flag"

const (
	confSQLConnectionName = "database-connection-name"
	confSQLDBName         = "database-name"
	confSQLDBUsername     = "database-username"
	confSQLDBPassword     = "database-password"
	confSQLDBHost         = "database-host"
	confSQLDBPort         = "database-port"
	confSQLDBSchema       = "database-schema"
)

type SQLConfig struct {
	ConnectionName string
	DatabaseName   string
	User           string
	Password       string
	Host           string
	Port           string
	Schema         string
}

func (rc *SQLConfig) BindFlags(flags *flag.FlagSet) {
	flags.StringVar(
		&rc.ConnectionName,
		confSQLConnectionName,
		rc.ConnectionName,
		"sql connection name",
	)

	flags.StringVar(
		&rc.DatabaseName,
		confSQLDBName,
		rc.DatabaseName,
		"sql db name",
	)

	flags.StringVar(
		&rc.User,
		confSQLDBUsername,
		rc.User,
		"Database username",
	)

	flags.StringVar(
		&rc.Password,
		confSQLDBPassword,
		rc.Password,
		"Database Password",
	)

	flags.StringVar(
		&rc.Host,
		confSQLDBHost,
		rc.Host,
		"Database Host",
	)

	flags.StringVar(
		&rc.Port,
		confSQLDBPort,
		rc.Port,
		"Database Port",
	)

	flags.StringVar(
		&rc.Schema,
		confSQLDBSchema,
		rc.Schema,
		"Optionally specify a search path for DB connection",
	)
}