Function ParseURL

adapter/postgresql/connection.go:108–160

ParseURL parses the given DSN into a ConnectionURL struct. A typical PostgreSQL connection URL looks like: postgres://bob:secret@1.2.3.4:5432/mydb?sslmode=verify-full

(s string)

//
//	postgres://bob:secret@1.2.3.4:5432/mydb?sslmode=verify-full
func ParseURL(s string) (u *ConnectionURL, err error) {
	o := make(values)

	if strings.HasPrefix(s, "postgres://") || strings.HasPrefix(s, "postgresql://") {
		s, err = parseURL(s)
		if err != nil {
			return u, err
		}
	}

	if err := parseOpts(s, o); err != nil {
		return u, err
	}
	u = &ConnectionURL{}

	u.User = o.Get("user")
	u.Password = o.Get("password")

	h := o.Get("host")
	p := o.Get("port")

	if strings.HasPrefix(h, "/") {
		u.Socket = h
	} else {
		if p == "" {
			u.Host = h
		} else {
			u.Host = fmt.Sprintf("%s:%s", h, p)
		}
	}

	u.Database = o.Get("dbname")

	u.Options = make(map[string]string)

	for k := range o {
		switch k {
		case "user", "password", "host", "port", "dbname":
			// Skip
		default:
			u.Options[k] = o[k]
		}
	}

	if timezone, ok := u.Options["timezone"]; ok {
		u.timezone, err = time.LoadLocation(timezone)
		if err != nil {
			return nil, err
		}
	}

	return u, err
}

// parseOpts parses the options from name and adds them to the values.
//