46 lines
993 B
Go
46 lines
993 B
Go
package model
|
|
|
|
import (
|
|
"database/sql"
|
|
"fmt"
|
|
)
|
|
|
|
// Fuel repräsentiert einen Kraftstofftyp.
|
|
type Fuel struct {
|
|
ID int `json:"id"`
|
|
Name string `json:"name"`
|
|
Unit string `json:"unit"`
|
|
}
|
|
|
|
// GetFuels liest alle Kraftstofftypen aus der Datenbank.
|
|
func GetFuels(db *sql.DB) ([]Fuel, error) {
|
|
rows, err := db.Query("SELECT id, name, unit FROM fuels ORDER BY id")
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
defer rows.Close()
|
|
|
|
var fuels []Fuel
|
|
for rows.Next() {
|
|
var f Fuel
|
|
if err := rows.Scan(&f.ID, &f.Name, &f.Unit); err != nil {
|
|
return nil, err
|
|
}
|
|
fuels = append(fuels, f)
|
|
}
|
|
return fuels, rows.Err()
|
|
}
|
|
|
|
// GetFuelByID liest einen einzelnen Kraftstofftyp nach ID.
|
|
func GetFuelByID(db *sql.DB, id int) (*Fuel, error) {
|
|
var f Fuel
|
|
err := db.QueryRow("SELECT id, name, unit FROM fuels WHERE id = ?", id).Scan(&f.ID, &f.Name, &f.Unit)
|
|
if err == sql.ErrNoRows {
|
|
return nil, fmt.Errorf("fuel with id %d not found", id)
|
|
}
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
return &f, nil
|
|
}
|