データモデリングにおける Golang の主な機能

package orm

import (
    "database/sql"
    "fmt"
)

// Person represents a person in a database.
type Person struct {
    Name  string
    Email string
}

// CreatePerson creates a new person in the database.
func CreatePerson(db *sql.DB, p Person) error {
    stmt, err := db.Prepare("INSERT INTO people (name, email) VALUES (?, ?)")
    if err != nil {
        return err
    }
    defer stmt.Close()

    _, err = stmt.Exec(p.Name, p.Email)
    return err
}

// GetPerson retrieves a person from the database by their name.
func GetPerson(db *sql.DB, name string) (*Person, error) {
    row := db.QueryRow("SELECT name, email FROM people WHERE name = ?", name)
    var p Person
    if err := row.Scan(&p.Name, &p.Email); err != nil {
        return nil, err
    }
    return &p, nil
}

func main() {
    db, err := sql.Open("postgres", "host=localhost user=postgres password=mypassword dbname=database")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    p := Person{Name: "John Doe", Email: "johndoe@example.com"}
    if err := CreatePerson(db, p); err != nil {
        panic(err)
    }
    p, err = GetPerson(db, "John Doe")
    if err != nil {
        panic(err)
    }
    fmt.Printf("Got person: %+v\n", p)
}