Function RemovePsqlMetaCommands

internal/migrations/migrations.go:46–57

RemovePsqlMetaCommands strips psql meta-command lines (e.g. `\restrict KEY`, `\unrestrict KEY`, `\connect foo`) from SQL input. These are emitted by pg_dump but are not valid SQL, so they must be removed before parsing.

(contents string)

// `\unrestrict KEY`, `\connect foo`) from SQL input. These are emitted by
// pg_dump but are not valid SQL, so they must be removed before parsing.
func RemovePsqlMetaCommands(contents string) string {
	s := bufio.NewScanner(strings.NewReader(contents))
	var lines []string
	for s.Scan() {
		line := s.Text()
		if psqlMetaCommand.MatchString(line) {
			continue
		}
		lines = append(lines, line)
	}
	return strings.Join(lines, "\n")
}

func IsDown(filename string) bool {
	// Remove golang-migrate rollback files.