admin管理员组

文章数量:1635832

func Upload(request UploadRecordsRequest) (Record, error) {
	
	result := Record{}
	
	query := `SELECT Num_ID, Reg_ID, User_ID, Organization, Organization_ID , 
				  User_Name ,Terminal_ID ,Interface_Time ,Requester ,Interface_Result,
				  Error_Code ,Interface_Name ,Interface_Condition ,Collect_Type ,SendID 
				  FROM Interface_Log WHERE ID=?`
	err := app.db.Get(&result, query, id)
	if err != nil {
		err = fmt.Errorf("数据库读失败: %s", err.Error())
		return result, err
	}
	fmt.Println(result.NumID, id)
	return result, nil
}

type Record struct {
	NumID              int64  `json:"numid" `
	RegID              string `json:"regid" `
	UserID             string `json:"userid" `
	Organization       string `json:"organization" `
	OrganizationID     string `json:"organizationid" `
	UserName           string `json:"username" `
	TerminalID         string `json:"terminalid" `
	InterfaceTime      string `json:"interfacetime" `
	Requester          string `json:"requester" `
	InterfaceResult    string `json:"interfaceresult" `
	ErrorCode          string `json:"errorcode" `
	InterfaceName      string `json:"interfacename"`
	InterfaceCondition string `json:"interfacecondition" `
	CollectType        string `json:"collecttype" `
	SendID             string `json:"sendid" `
}

上面这么写会导致如题所示的错误。

正确的代码如下:使用如下的:struct tags

func Upload(request UploadRecordsRequest) (Record, error) {
	
	result := Record{}
	
	query := `SELECT Num_ID as numid, Reg_ID as regid , User_ID as userid, Organization as organization, Organization_ID as organizationid, 
				  User_Name as username,Terminal_ID as terminalid,Interface_Time as interfacetime,Requester as requester,Interface_Result as interfaceresult,
				  Error_Code as errorcode,Interface_Name as interfacename,Interface_Condition as interfacecondition,Collect_Type as collecttype,SendID as sendid
				  FROM Interface_Log WHERE ID=?`
	err := app.db.Get(&result, query, id)
	if err != nil {
		err = fmt.Errorf("数据库读失败: %s", err.Error())
		return result, err
	}
	fmt.Println(result.NumID, id)
	return result, nil
}

type Record struct {
	NumID              int64  `json:"numid" db:"numid"`
	RegID              string `json:"regid" db:"regid"`
	UserID             string `json:"userid" db:"userid"`
	Organization       string `json:"organization" db:"organization"`
	OrganizationID     string `json:"organizationid" db:"organizationid"`
	UserName           string `json:"username" db:"username"`
	TerminalID         string `json:"terminalid" db:"terminalid"`
	InterfaceTime      string `json:"interfacetime" db:"interfacetime"`
	Requester          string `json:"requester" db:"requester"`
	InterfaceResult    string `json:"interfaceresult" db:"interfaceresult"`
	ErrorCode          string `json:"errorcode" db:"errorcode"`
	InterfaceName      string `json:"interfacename" db:"interfacename"`
	InterfaceCondition string `json:"interfacecondition" db:"interfacecondition"`
	CollectType        string `json:"collecttype" db:"collecttype"`
	SendID             string `json:"sendid" db:"sendid"`
}

 

本文标签: missingquotErrordestination