// ----------------------------------------------------------------
//
//	maria_delete.go
//
//					Feb/27/2023
//
// ----------------------------------------------------------------
package main

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

// ----------------------------------------------------------------
func main() {
	fmt.Fprintln (os.Stderr,"*** 開始 ***")
	key_in := os.Args[1]

	fmt.Printf ("key_in = %s\n" , key_in)

	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)
	}

	db.Exec ("delete from cities WHERE id = ?", key_in)



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

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