database

package

v0.0.0-...-9b07614 Latest Latest Go to latest Published: Nov 7, 2023 License: MulanPSL-2.0 Imports: 5 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

func CreateDB(dname, dsname string) (*sql.DB, error)

CreateDB opens sql service according to dname and dsname.

func InsertAKCertRow(akcert []byte, did int64) error

InsertAKCertRow inserts ak cert row in table `akey_cert`.

func SetAllAKCertUnavailable(did int64) error

SetAllAKCertUnavailable sets available=false in table `akey_cert` according to device id.

type AKCertRow struct {
	Id        int64
	Device_id int64
	Cre_time  time.Time
	Exp_time  time.Time
	Akey_cert string
	Available bool
}

AKCertRow stores one record of ak cert key information in database table `akey_cert`.

type DKeyRow struct {
	Id          int64
	Device_cert string
	Registered  bool
	Trusted     bool
	Reg_time    time.Time
	Client_info string
}

DKeyRow stores one record of device key information in database table `device_key`.

func InsertDKeyRow(dkcert []byte) (DKeyRow, error)

InsertDKeyRow inserts device key row in table `device_key`.