blob: 616e90714b99a8d12fb20e856a8a7d061dcaa155 [file] [log] [blame]
// compile
// Copyright 2021 The Go Authors. All rights reserved.
// Use of this source code is governed by a BSD-style
// license that can be found in the LICENSE file.
package main
import (
// Collection generic interface which things can be added to.
type Collection[T any] interface {
// Slice generic slice implementation of a Collection
type Slice[T any] []*T
func (s *Slice[T]) Add(t *T) {
*s = append(*s, t)
type Scanner interface {
Scan(...interface{}) error
type Mapper[T any] func(s Scanner, t T) error
type Repository[T any] struct {
db *sql.DB
func (r *Repository[T]) scan(rows *sql.Rows, m Mapper[*T], c Collection[*T]) error {
for rows.Next() {
t := new(T)
if err := m(rows, t); err != nil {
return err
return rows.Err()
func (r *Repository[T]) query(query string, m Mapper[*T], c Collection[*T]) error {
rows, err := r.db.Query(query)
if err != nil {
return err
if err := r.scan(rows, m, c); err != nil {
return err
return rows.Close()
type Actor struct {
ActorID uint16
FirstName string
LastName string
type ActorRepository struct {
r Repository[Actor]
func (ActorRepository) scan(s Scanner, a *Actor) error {
return s.Scan(&a.ActorID, &a.FirstName, &a.LastName)
func (r *ActorRepository) SelectAll(c Collection[*Actor]) error {
return r.r.query("SELECT `actor_id`, `first_name`, `last_name` FROM `actor` LIMIT 10", r.scan, c)