db

package

v0.3.0 Latest Latest Go to latest Published: Aug 24, 2026 License: Apache-2.0 Imports: 10 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/swayyaam/OSCTF

Links

Open Source Insights

Documentation ¶

Overview ¶

Package db owns the pgx connection pool and the goose migration runner. It embeds the migrations (via the migrations subpackage) and exposes a small WithTx transaction helper. It may import config only.

Index ¶

func Connect(ctx context.Context, dsn string, log *slog.Logger) (*pgxpool.Pool, error)
func Migrate(ctx context.Context, dsn string) error
func WithTx(ctx context.Context, pool *pgxpool.Pool, fn func(pgx.Tx) error) error

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func Connect ¶

func Connect(ctx context.Context, dsn string, log *slog.Logger) (*pgxpool.Pool, error)

Connect opens a pgx pool and pings it. It retries the initial connection to tolerate compose start ordering (Postgres may not be ready the instant we boot).

func Migrate ¶

func Migrate(ctx context.Context, dsn string) error

Migrate runs all embedded goose migrations up. It opens a short-lived database/sql handle over the pgx stdlib driver because goose needs one.

func WithTx ¶

func WithTx(ctx context.Context, pool *pgxpool.Pool, fn func(pgx.Tx) error) error

WithTx runs fn inside a transaction, committing on nil error and rolling back otherwise. Services own their transaction boundaries through this helper.

Types ¶

This section is empty.

Source Files ¶

View all Source files

db.go

Directories ¶

Path	Synopsis
gen
migrations Package migrations embeds the goose SQL migrations so they ship inside the binary and run on boot without a migrations directory on disk.	Package migrations embeds the goose SQL migrations so they ship inside the binary and run on boot without a migrations directory on disk.

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL