Versions in this module Expand all Collapse all v1 v1.0.0 Jan 25, 2024 Changes in this version + type DBTX interface + ExecContext func(context.Context, string, ...interface{}) (sql.Result, error) + PrepareContext func(context.Context, string) (*sql.Stmt, error) + QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error) + QueryRowContext func(context.Context, string, ...interface{}) *sql.Row + type GetDeviceInfoByProductIdAndSerialNumberParams struct + ProductID uint64 + SerialNumber string + type IotAlert struct + Actions json.RawMessage + CreateBy sql.NullString + CreateTime time.Time + ID uint64 + Level uint32 + MessageType sql.NullString + Name string + ProductID uint64 + Remark sql.NullString + Status int8 + UpdateBy sql.NullString + UpdateTime time.Time + type IotAlertTrigger struct + AlertID uint64 + CronExpression string + ID uint64 + IsAdvance sql.NullInt32 + JobID sql.NullInt64 + Operator sql.NullString + ProductID sql.NullInt64 + Source uint32 + Status int8 + ThingsModelID sql.NullInt64 + ThingsModelValue sql.NullString + Type int8 + type IotDevice struct + ActiveTime sql.NullTime + CreateBy string + CreateTime time.Time + DelFlag sql.NullString + FirmwareVersion float64 + GwDevCode sql.NullString + ID uint64 + ImgUrl sql.NullString + Latitude sql.NullFloat64 + LocationWay int8 + Longitude sql.NullFloat64 + Name string + NetworkAddress sql.NullString + NetworkIp sql.NullString + ProductID uint64 + Remark sql.NullString + Rssi sql.NullInt32 + SerialNumber string + Status int8 + UpdateBy string + UpdateTime time.Time + UserID uint64 + type IotEventLog struct + CreateBy string + CreateTime sql.NullTime + DeviceID sql.NullInt64 + ID uint64 + IsMonitor uint32 + Mode int8 + Remark sql.NullString + ThingsModelID sql.NullInt64 + Type uint32 + Value string + type IotProduct struct + CategoryID uint64 + CreateBy sql.NullString + CreateTime time.Time + DelFlag sql.NullString + DeviceType sql.NullInt32 + ID uint64 + ImgUrl sql.NullString + MqttAccount sql.NullString + MqttPassword sql.NullString + MqttSecret sql.NullString + Name string + NetworkMethod sql.NullInt32 + Remark sql.NullString + Status int8 + ThingsModelsJson json.RawMessage + UpdateBy sql.NullString + UpdateTime time.Time + VertificateMethod int8 + type IotProductAuthorize struct + Code string + CreateBy string + CreateTime sql.NullTime + DelFlag string + DeviceID sql.NullInt64 + ID uint64 + Remark sql.NullString + SerialNumber sql.NullString + Status int8 + UpdateBy string + UpdateTime sql.NullTime + type IotThingsModel struct + BitOption sql.NullString + Code sql.NullString + CreateBy sql.NullString + CreateTime sql.NullTime + Datatype string + DelFlag sql.NullString + Formula sql.NullString + Identifier string + IsChart bool + IsHistory sql.NullBool + IsMonitor bool + IsParams sql.NullInt32 + IsReadonly sql.NullBool + ModelID int64 + ModelName string + ModelOrder sql.NullInt32 + ProductID int64 + ProductName string + Quantity sql.NullInt32 + RegAddr sql.NullInt32 + Remark sql.NullString + ReverseFormula sql.NullString + Specs json.RawMessage + TempSlaveID sql.NullInt64 + TenantID int64 + TenantName string + Type int8 + UpdateBy sql.NullString + UpdateTime sql.NullTime + ValueType sql.NullString + type Queries struct + func New(db DBTX) *Queries + func Prepare(ctx context.Context, db DBTX) (*Queries, error) + func (q *Queries) Close() error + func (q *Queries) GetDeviceInfoByProductIdAndSerialNumber(ctx context.Context, arg *GetDeviceInfoByProductIdAndSerialNumberParams) (*IotDevice, error) + func (q *Queries) WithTx(tx *sql.Tx) *Queries + type SysUser struct + Avatar sql.NullString + CreateBy sql.NullString + CreateTime sql.NullTime + DelFlag sql.NullString + DeptID sql.NullInt64 + Email sql.NullString + LoginDate sql.NullTime + LoginIp sql.NullString + NickName string + Password sql.NullString + Phonenumber sql.NullString + Remark sql.NullString + Sex sql.NullString + Status sql.NullString + UpdateBy sql.NullString + UpdateTime sql.NullTime + UserID int64 + UserName string + UserType sql.NullString
Go to main page