xpackage main
import (
"database/sql"
"fmt"
"log"
_ "github.com/mattn/go-sqlite3"
)
func logFatal(err error) {
if err != nil {
log.Fatal(err)
}
}
type entry struct {
datum string
tonnen string
}
func main() {
db, err := sql.Open("sqlite3", "test.db")
logFatal(err)
sqlStatement := "SELECT * FROM blau"
results, err := db.Query(sqlStatement)
logFatal(err)
result := entry{}
for results.Next() {
// var datum, tonnen string
err := results.Scan(&result.datum, &result.tonnen)
logFatal(err)
fmt.Printf("Am %v wurden %v Tonnen geleert\n", result.datum, result.tonnen)
}
}