// ----------------------------------------------------------------
//
//	maria_read.go
//
//					Feb/26/2023
//
// ----------------------------------------------------------------
package main

import (
	"fmt"
	"os"
	"gorm.io/gorm"
	"gorm.io/driver/mysql"
)

type City struct {
        Id           string
        Name         string
        Population   int
        Date_mod     string
}

// ----------------------------------------------------------------
func main() {
	fmt.Fprintln (os.Stderr,"*** 開始 ***")
	host := "localhost"
	user := "scott"
	password := "tiger123"
	data_base := "city"

dsn := user + ":" + password + "@tcp(" + host + ":3306)/" + data_base + "?charset=utf8mb4&parseTime=True&loc=Local"
	db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
	if err != nil {
		panic(err)
	}

	cities := []City{}

	db.Find(&cities)

	llx := len(cities)
	fmt.Println(llx)

	for it := 0; it < llx; it++{
		unit_aa := cities[it]
		fmt.Printf("%s\t",unit_aa.Id)
		fmt.Printf("%s\t",unit_aa.Name)
		fmt.Printf("%d\t",unit_aa.Population)
		fmt.Printf("%s\n",unit_aa.Date_mod)
	}

	fmt.Fprintln (os.Stderr,"*** 終了 ***")
}

// ----------------------------------------------------------------