package main
import ("fmt""html/template""myfare/uidSerial""net/http""gorm.io/driver/sqlite""gorm.io/gorm""strconv""time")
type Ninjya struct{
Uid string `gorm:"primaryKey"`
Name string
Time int
Stat int}
var products []Ninjya
var ninjyaSlice []string
// implements TableName of the Tabler interface
func (Ninjya)TableName() string {
t := time.Now()
tableName :="tbl"+ strconv.Itoa(t.Year())+ strconv.Itoa(t.YearDay())return tableName
}// to get active ninjya slice
func ninjya(){
db, err := gorm.Open(sqlite.Open("./myfare.db"),&gorm.Config{})if err != nil {panic("failed to connect database")}// Migrate the schema
db.AutoMigrate(&Ninjya{})// if you use Automigrate and change struct, it won't be reflected automatically
db.Debug().Order("Time desc").Where("Stat = ?",1).Find(&products)// SELECT * FROM where Stat = tbl*****;
ninjyaSlice = nil
for i, p := range products {
ninjyaSlice =append(ninjyaSlice, p.Name)
fmt.Println(i, p)}}
func handler(w http.ResponseWriter, r *http.Request){
t :=template.Must(template.ParseFiles("layout.html","pageData.html"))// to update ninjya statusninjya()
tm := time.Now().Format(time.RFC1123)
err := t.Execute(w, map[string]interface{}{"Time": tm,"Slice": ninjyaSlice,})if err != nil {
fmt.Fprintln(w, err)}}
func wevServer(){
mux := http.NewServeMux()// to include static resoureces
mux.Handle("/resources/", http.StripPrefix("/resources/", http.FileServer(http.Dir("resources/"))))
mux.HandleFunc("/", handler)
server := http.Server{
Addr:":8080",
Handler: mux,}
err := server.ListenAndServe()if err != nil {if err != http.ErrServerClosed {panic(err)}}}
func main(){// to call card reader function()
go uidSerial.SerialMain()// http server startwevServer()}
t := template.Must(template.ParseFiles("layout.html", "pageData.html"))
$ lsusb
Bus 001 Device 005: ID 0403:6001 Future Technology Devices International, Ltd FT232 Serial (UART) IC
Bus 001 Device 003: ID 0424:ec00 Microchip Technology, Inc. (formerly SMSC) SMSC9512/9514 Fast Ethernet Adapter
Bus 001 Device 002: ID 0424:9514 Microchip Technology, Inc. (formerly SMSC) SMC9514 Hub
Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub
package main
import ("fmt""gorm.io/driver/sqlite""gorm.io/gorm""time""strconv")
type Product struct{
Uid string `gorm:"primaryKey"`
Name string
Time int
Stat int}
var products []Product
//// implements TableName of the Tabler interface //
func (Product)TableName() string {
t := time.Now()
tableName :="tbl"+ strconv.Itoa(t.Year())+ strconv.Itoa(t.YearDay())return tableName
}
func main(){
db, err := gorm.Open(sqlite.Open("~~~path to the db~~~ /myfare.db"),&gorm.Config{})if err != nil {panic("failed to connect database")}// Migrate the schema
db.AutoMigrate(&Product{})// if you use Automigrate and change struct, it won't be reflected automatically
db.Debug().Find(&products)// SELECT * FROM tbl*****;for i, p := range products{//db.Model(&p).Update("Qty", 20)
fmt.Println(i, p)}}
db.Createがレコードの新規作成、db.Modelがレコードの更新、使ってませんがdb.Deleteがレコード削除です。条件付けはwhere句を使うのでSQLと類似しているように思います。またdb.Firstはレコードを一個だけ(SELECT * FROM products ORDER BY id LIMIT 1;と等価)引っ張ってくるしde.Findはselect*from相当です。
