db

type Query[R any] struct {
	// The query, sql statements, or the stored procedure to query/execute.
	Query string
	// If the query will be called multiple times setting this to true
	// will generate a reusable prepared statement that will be used for
	// subsequent runs.
	Prepared bool
	// The input variables
	In map[string]any
	// The output variables
	Out map[string]any
	// Creates a row to be populated. This may be necessary for complex
	// types with pointers, slices, maps, etc.
	Create func() R
	// Where to place the rows received. The presense of this field
	// indicates that rows should be requested and parsed.
	Results QueryResult[R]
	// Where to place a single result row. The presense of this field
	// indicates that a row should be requested and parsed.
	Result *R
	// How many rows were affected on the last query run.
	RowsAffected int64
	// The ID of the last inserted record on the last query run.
	LastID int64
	// contains filtered or unexported fields
}

type QueryResult[R any] interface {
	Add(result R) bool
}

type QuerySlice[R any] struct {
	Slice *[]R
	Max   int
}

type Runnable interface {
	Run(ctx context.Context, conn *sql.Conn) error
}