34 lines
758 B
Go
34 lines
758 B
Go
package model
|
|
|
|
import (
|
|
"backend/Type"
|
|
"backend/util"
|
|
"fmt"
|
|
)
|
|
|
|
type Node struct {
|
|
Type.Node
|
|
}
|
|
|
|
func (n *Node) AddNode() error {
|
|
Db := util.MPool.GetGameDB()
|
|
defer Db.Close()
|
|
|
|
_, err := Db.NamedExec("INSERT INTO node (name, host, internalHost, hardware, area, operator, status, createTime, updateTime, user, password) VALUES (:name, :host, :internalHost, :hardware, :area, :operator, :status, :createTime, :updateTime, :user, :password)", n)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|
|
|
|
func (n *Node) NodeList() ([]*Type.Node, error) {
|
|
Db := util.MPool.GetGameDB()
|
|
var app []*Type.Node
|
|
err := Db.Select(&app, "SELECT * FROM node")
|
|
defer Db.Close()
|
|
if err != nil {
|
|
return nil, fmt.Errorf("failed to scan rows: %v", err)
|
|
}
|
|
return app, nil
|
|
}
|