{"id":183878,"date":"2020-10-27T06:17:29","date_gmt":"2020-10-26T22:17:29","guid":{"rendered":"http:\/\/4563.org\/?p=183878"},"modified":"2020-10-27T06:17:29","modified_gmt":"2020-10-26T22:17:29","slug":"%e4%bc%b8%e6%89%8b%e6%b1%82%e4%b8%80%e4%b8%aa-gorm-%e7%9a%84%e6%9f%a5%e8%af%a2%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=183878","title":{"rendered":"\u4f38\u624b\u6c42\u4e00\u4e2a gorm \u7684\u67e5\u8be2\u65b9\u6cd5"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  \u4f38\u624b\u6c42\u4e00\u4e2a gorm \u7684\u67e5\u8be2\u65b9\u6cd5               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : zxCoder <\/span>  <span><i><\/i> 2<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u770b\u4e86\u4e00\u4e0a\u5348\u6587\u6863\u8fd8\u6ca1\u5199\u51fa\u6765<\/p>\n<p>post tag post_tag_relation \u4e09\u4e2a\u8868\uff0cpost \u548c tag \u662f\u591a\u5bf9\u591a\u5173\u7cfb<\/p>\n<p>\u73b0\u5728\u8981\u4ece\u5173\u7cfb\u8868\u4e2d\u67e5\u627e\u67d0\u4e2a tagId \u5bf9\u5e94\u7684\u6240\u6709 postId\uff0c\u518d\u67e5\u8fd9\u4e9b postId \u5bf9\u5e94\u7684 post \u4fe1\u606f\uff0c\u5c31\u5305\u62ec\u628a\u6bcf\u4e2a post \u5bf9\u5e94\u7684\u6240\u6709 tag \u4e5f\u67e5\u51fa\u6765\uff0c\u6709\u4ec0\u4e48\u65b9\u4fbf\u7684\u65b9\u6cd5\u5417<\/p>\n<p>\u56e0\u4e3a\u67e5\u8be2\u6761\u4ef6\u4e0d\u786e\u5b9a\uff0c\u6240\u4ee5\u76ee\u524d\u662f\u8fd9\u6837\u5199\u7684<\/p>\n<pre><code>tagId,ok:=para[\"tagId\"]  if ok{   tagId=int(tagId.(float64))   var postIds []int64   var rels []models.PostTagRelation   err := db.Table(\"post_tag_relation\").Where(\"tag_id=?\", tagId).Where(\"del=?\",0).Select(\"postId\").Find(&amp;rels).Error   if err != nil {    log.Println(\"query error: \", err)    c.JSON(200, failResp)    return   }   for _, rel := range rels {    postIds = append(postIds, rel.PostId)   }   db2=db2.Where(\"id in (?)\",postIds)  } <\/code><\/pre>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>0<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>\u4f38\u624b\u6c42\u4e00\u4e2a gorm \u7684\u67e5\u8be2\u65b9\u6cd5 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/183878"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=183878"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/183878\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=183878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=183878"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=183878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}