adapter

type Handle interface {
	ReadWriter
	BeginTx(ctx context.Context, options *sql.TxOptions) (Transaction, error)
	io.Closer

	DBHandle() *sql.DB
}

type QueryResult interface {
	RowScanner
	Next() bool
	Err() error
	io.Closer
}

type ReadWriter interface {
	Reader
	Writer
}

type Reader interface {
	QueryContext(ctx context.Context, statement string, args ...any) (QueryResult, error)
	QueryRowContext(ctx context.Context, statement string, args ...any) RowScanner
}

type RowScanner interface {
	Scan(...any) error
}

type Transaction interface {
	ReadWriter
	Transactional

	TxHandle() *sql.Tx
}

type Transactional interface {
	Commit() error
	Rollback() error
}

type Writer interface {
	ExecContext(ctx context.Context, statement string, args ...any) (sql.Result, error)
}