)

}

}()

connection,cleanup,err:=dbtestutil.OpenContainerized(t, dbtestutil.DBContainerOptions{})

iferr!=nil {

panic(err)

connection:=os.Getenv("DB_DUMP_CONNECTION_URL")

ifconnection=="" {

varcleanupfunc()

connection,cleanup,err=dbtestutil.OpenContainerized(t, dbtestutil.DBContainerOptions{})

iferr!=nil {

err=xerrors.Errorf("open containerized database failed: %w",err)

panic(err)

}

defercleanup()

}

defercleanup()

db,err:=sql.Open("postgres",connection)

iferr!=nil {

err=xerrors.Errorf("open database failed: %w",err)

panic(err)

}

deferdb.Close()

err=migrations.Up(db)

iferr!=nil {

err=xerrors.Errorf("run migrations failed: %w",err)

panic(err)

}

dumpBytes,err:=dbtestutil.PGDumpSchemaOnly(connection)

iferr!=nil {

err=xerrors.Errorf("dump schema failed: %w",err)

panic(err)

}

}

err=os.WriteFile(filepath.Join(mainPath,"..","..","..","dump.sql"),append(preamble,dumpBytes...),0o600)

iferr!=nil {

err=xerrors.Errorf("write dump failed: %w",err)

panic(err)

}

}

- on macOS, run`brew install libpq zstd`

- on Linux, install[`zstd`](https://github.com/horta/zstd.install)

- PostgreSQL 13 (optional if Docker is available)

-*Note*: If you are using Docker, you can skip this step

- on macOS, run`brew install postgresql@13` and`brew services start postgresql@13`

- To enable schema generation with non-containerized PostgreSQL, set the following environment variable:

- on macOS, run`brew install pkg-config`