storage

type Database interface {
	Ping(context.Context, time.Duration) error
	Query(ctx context.Context, query string, args ...any) (pgx.Rows, error)
	QueryRow(ctx context.Context, query string, args ...any) pgx.Row
	Exec(ctx context.Context, query string, args ...any) (pgconn.CommandTag, error)
	BeginTx(ctx context.Context) (Transaction, error)
	Close() error
}

type Transaction interface {
	Query(ctx context.Context, query string, args ...any) (pgx.Rows, error)
	Execute(ctx context.Context, query string, args ...any) (pgconn.CommandTag, error)
	Commit(ctx context.Context) error
	Rollback(ctx context.Context) error
}