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
}