Method GetById

models/DocumentModel.go:186–210

根据文档id获取一篇文档的全部信息 @param id 文档id @return params 文档信息 @return rows 记录数 @return err 错误

(id interface{})

//@return               rows            记录数
//@return               err             错误
func (this *Document) GetById(id interface{}) (doc fullDocument, err error) {
	var sql string
	tables := []string{GetTableDocumentInfo() + " info", GetTableDocument() + " doc", GetTableDocumentStore() + " ds", GetTableUser() + " u"}
	fields := map[string][]string{
		"ds":   helper.DeleteSlice(GetFields(NewDocumentStore()), "Id"),
		"info": GetFields(NewDocumentInfo()),
		"u":    {"Username", "Id Uid"},
		"doc":  GetFields(NewDocument()),
	}
	on := []map[string]string{
		{"ds.Id": "info.DsId"},
		{"doc.Id": "info.Id"},
		{"u.Id": "info.Uid"},
	}
	helper.Logger.Debug("查询字段：%+v", fields)

	sql, err = LeftJoinSqlBuild(tables, on, fields, 1, 1, nil, nil, "info.Id=?")
	if err != nil {
		helper.Logger.Error(err.Error())
		err = errors.New("内部错误：数据查询失败")
		return
	}
	err = orm.NewOrm().Raw(sql, id).QueryRow(&doc)
	return
}

func (this *Document) GetDocument(id int, fields ...string) (doc Document) {
	orm.NewOrm().QueryTable(this).Filter("Id", id).One(&doc, fields...)