database

type Database interface {
	// Query executes a SELECT query and scans results into dest
	// dest should be a pointer to a slice of structs with `db` tags
	Query(ctx context.Context, dest interface{}, query string, args ...interface{}) error

	// QueryOne executes a SELECT query and scans a single result into dest
	// dest should be a pointer to a struct with `db` tags
	// Returns an error if no rows are found or multiple rows are returned
	QueryOne(ctx context.Context, dest interface{}, query string, args ...interface{}) error

	// Exec executes an INSERT, UPDATE, or DELETE query
	// Returns the result (typically last insert ID or rows affected)
	Exec(ctx context.Context, query string, args ...interface{}) (interface{}, error)
}