{"id":44543,"date":"2023-02-11T23:31:25","date_gmt":"2023-04-01T06:46:19","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/"},"modified":"2024-04-29T14:12:47","modified_gmt":"2024-04-29T06:12:47","slug":"%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/","title":{"rendered":"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b"},"content":{"rendered":"<h2>\u8bf7\u53c2\u8003<\/h2>\n<p>\u5c1d\u8bd5\u4f7f\u7528Golang\u7684revel\u6846\u67b6\u521b\u5efa\u4e00\u4e2a\u7c7b\u4f3c\u8bba\u575b\u7684\u4e1c\u897f\u3002<\/p>\n<h3>\u68c0\u67e5Go\u548cMySQL\u7684\u7248\u672c<\/h3>\n<pre class=\"post-pre\"><code>$ go version\r\ngo version go1.7.1 darwin\/amd64\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>mysql <span class=\"nt\">--version<\/span>\r\nmysql  Ver 14.14 Distrib 5.7.15, <span class=\"k\">for <\/span>osx10.11 <span class=\"o\">(<\/span>x86_64<span class=\"o\">)<\/span> using  EditLine wrapper\r\n\r\n<\/code><\/pre>\n<h3>\u8bbe\u5b9a\u73af\u5883\u53d8\u91cf<\/h3>\n<p>\u8bf7\u5c06\u4ee5\u4e0b\u5185\u5bb9\u6dfb\u52a0\u5230.bash_profile\u6587\u4ef6\u4e2d\u3002<\/p>\n<pre class=\"post-pre\"><code>#golang\r\nexport GOROOT=\/usr\/local\/opt\/go\/libexec\r\nexport GOPATH=$HOME\/.go\r\nexport PATH=$PATH:$GOROOT\/bin:$GOPATH\/bin\r\n<\/code><\/pre>\n<h3>\u5b89\u88c5 Revel\u3002<\/h3>\n<pre class=\"post-pre\"><code>$ go get github.com\/revel\/revel\r\n$ go get github.com\/revel\/cmd\/revel\r\n<\/code><\/pre>\n<h3>\u786e\u8ba4\u5df2\u5b89\u88c5\u7684revel<\/h3>\n<pre class=\"post-pre\"><code>$ revel version\r\n~\r\n~ revel! http:\/\/revel.github.io\r\n~\r\nVersion(s):\r\n   Revel v0.13.1 (2016-06-06)\r\n   go1.7.1 darwin\/amd64\r\n<\/code><\/pre>\n<h3>\u4f7f\u7528\u5168\u65b0\u7684\u5e94\u7528\u7a0b\u5f0f\u540d\u79f0(revel new app_name)\u521b\u5efa\u9879\u76ee\u3002<\/h3>\n<p>\u501f\u7528\u4e86shiro16\u5148\u751f\u7684golang-bbs\u4ee3\u7801<\/p>\n<pre class=\"post-pre\"><code>$ revel new github.com\/shiro16\/golang-bbs\r\n~\r\n~ revel! http:\/\/revel.github.io\r\n~\r\nYour application is ready:\r\n   \/Users\/xxxxxx\/.go\/src\/github.com\/shiro16\/golang-bbs\r\n\r\nYou can run it with:\r\n   revel run github.com\/shiro16\/golang-bbs\r\n<\/code><\/pre>\n<h3>\u4f7f\u7528revel run\u547d\u4ee4\u542f\u52a8Web\u670d\u52a1\u5668\u3002<\/h3>\n<pre class=\"post-pre\"><code>$ revel run github.com\/shiro16\/golang-bbs\r\n~\r\n~ revel! http:\/\/revel.github.io\r\n~\r\nINFO  2016\/10\/07 14:28:23 revel.go:365: Loaded module testrunner\r\nINFO  2016\/10\/07 14:28:23 revel.go:365: Loaded module static\r\nINFO  2016\/10\/07 14:28:23 revel.go:230: Initialized Revel v0.13.1 (2016-06-06) for &gt;= go1.4\r\nINFO  2016\/10\/07 14:28:23 run.go:57: Running golang-bbs (github.com\/shiro16\/golang-bbs) in dev mode\r\nINFO  2016\/10\/07 14:28:23 harness.go:170: Listening on :9000\r\nINFO  2016\/10\/07 14:28:30 build.go:179: Cleaning dir tmp\r\nINFO  2016\/10\/07 14:28:30 build.go:179: Cleaning dir routes\r\nINFO  2016\/10\/07 14:28:30 build.go:179: Cleaning dir tmp\r\nINFO  2016\/10\/07 14:28:30 build.go:179: Cleaning dir routes\r\nINFO  2016\/10\/07 14:28:31 revel.go:365: Loaded module static\r\nINFO  2016\/10\/07 14:28:31 revel.go:365: Loaded module testrunner\r\nINFO  2016\/10\/07 14:28:31 revel.go:230: Initialized Revel v0.13.1 (2016-06-06) for &gt;= go1.4\r\nINFO  2016\/10\/07 14:28:31 main.go:30: Running revel server\r\nGo to \/@tests to run the tests.\r\n<\/code><\/pre>\n<p>\u4f7f\u7528Ctrl+C\u505c\u6b62\u670d\u52a1\u5668\u3002<\/p>\n<h2>\u521b\u5efaAPI<\/h2>\n<h3>\u7f16\u8f91routes\u6587\u4ef6<\/h3>\n<pre class=\"post-pre\"><code><span class=\"p\">GET     \/                                       App.Index\r\n<\/span><span class=\"gi\">+ GET     \/api\/v1\/comments                        ApiV1Comments.Index\r\n+ GET     \/api\/v1\/comments\/:id                    ApiV1Comments.Show\r\n+ POST    \/api\/v1\/comments                        ApiV1Comments.Create\r\n+ DELETE  \/api\/v1\/comments\/:id                    ApiV1Comments.Delete\r\n<\/span><\/code><\/pre>\n<h3>\u521b\u5efa\u63a7\u5236\u5668<\/h3>\n<h4>\u521b\u5efa\u4e00\u4e2a\u901a\u7528\u63a7\u5236\u5668<\/h4>\n<pre class=\"post-pre\"><code><span class=\"c\">\/\/ app\/controllers\/api\/v1\/v1.go<\/span>\r\n<span class=\"k\">package<\/span> <span class=\"n\">controllers<\/span>\r\n\r\n<span class=\"k\">import<\/span> <span class=\"p\">(<\/span>\r\n        <span class=\"s\">\"github.com\/revel\/revel\"<\/span>\r\n        <span class=\"s\">\"github.com\/shiro16\/golang-bbs\/app\/utils\"<\/span>\r\n        <span class=\"s\">\"net\/http\"<\/span>\r\n<span class=\"p\">)<\/span>\r\n\r\n<span class=\"c\">\/\/ \u57cb\u3081\u8fbc\u307f\u306b\u3088\u3063\u3066 revel.Controller \u3092\u30e9\u30c3\u30d7\u3057\u305f ApiV1Controller \u3092\u5b9a\u7fa9\u3059\u308b<\/span>\r\n<span class=\"k\">type<\/span> <span class=\"n\">ApiV1Controller<\/span> <span class=\"k\">struct<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"o\">*<\/span><span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Controller<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c\">\/\/ \u30a8\u30e9\u30fc\u306e\u969b\u306b\u8fd4\u3059 Json \u7528\u306e\u69cb\u9020\u4f53<\/span>\r\n<span class=\"k\">type<\/span> <span class=\"n\">ErrorResponse<\/span> <span class=\"k\">struct<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">Code<\/span>    <span class=\"kt\">int<\/span>    <span class=\"s\">`json:\"code\"`<\/span>\r\n        <span class=\"n\">Message<\/span> <span class=\"kt\">string<\/span> <span class=\"s\">`json:\"message\"`<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c\">\/\/ \u6b63\u5e38\u306a\u969b\u306b\u8fd4\u3059 Json \u7528\u306e\u69cb\u9020\u4f53(\u4eca\u56de\u306f1\u7a2e\u985e\u3067\u7d71\u4e00\u3059\u308b)<\/span>\r\n<span class=\"k\">type<\/span> <span class=\"n\">Response<\/span> <span class=\"k\">struct<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">Results<\/span> <span class=\"k\">interface<\/span><span class=\"p\">{}<\/span> <span class=\"s\">`json:\"results\"`<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c\">\/\/ \u5f15\u6570\u3068\u3057\u3066\u6e21\u3055\u308c\u3066 interface \u306b\u30ea\u30af\u30a8\u30b9\u30c8\u306e Json \u306e\u5024\u3092\u683c\u7d0d\u3059\u308b<\/span>\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"o\">*<\/span><span class=\"n\">ApiV1Controller<\/span><span class=\"p\">)<\/span> <span class=\"n\">BindParams<\/span><span class=\"p\">(<\/span><span class=\"n\">s<\/span> <span class=\"k\">interface<\/span><span class=\"p\">{})<\/span> <span class=\"kt\">error<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">utils<\/span><span class=\"o\">.<\/span><span class=\"n\">JsonDecode<\/span><span class=\"p\">(<\/span><span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">Request<\/span><span class=\"o\">.<\/span><span class=\"n\">Body<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c\">\/\/ Bad Request Error \u3092\u8fd4\u3059\u3084\u3064<\/span>\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"o\">*<\/span><span class=\"n\">ApiV1Controller<\/span><span class=\"p\">)<\/span> <span class=\"n\">HandleBadRequestError<\/span><span class=\"p\">(<\/span><span class=\"n\">s<\/span> <span class=\"kt\">string<\/span><span class=\"p\">)<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Result<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">Response<\/span><span class=\"o\">.<\/span><span class=\"n\">Status<\/span> <span class=\"o\">=<\/span> <span class=\"n\">http<\/span><span class=\"o\">.<\/span><span class=\"n\">StatusBadRequest<\/span>\r\n        <span class=\"n\">r<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">ErrorResponse<\/span><span class=\"p\">{<\/span><span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">Response<\/span><span class=\"o\">.<\/span><span class=\"n\">Status<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">}<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">RenderJson<\/span><span class=\"p\">(<\/span><span class=\"n\">r<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c\">\/\/ Not Found Error \u3092\u8fd4\u3059\u3084\u3064<\/span>\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"o\">*<\/span><span class=\"n\">ApiV1Controller<\/span><span class=\"p\">)<\/span> <span class=\"n\">HandleNotFoundError<\/span><span class=\"p\">(<\/span><span class=\"n\">s<\/span> <span class=\"kt\">string<\/span><span class=\"p\">)<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Result<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">Response<\/span><span class=\"o\">.<\/span><span class=\"n\">Status<\/span> <span class=\"o\">=<\/span> <span class=\"n\">http<\/span><span class=\"o\">.<\/span><span class=\"n\">StatusNotFound<\/span>\r\n        <span class=\"n\">r<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">ErrorResponse<\/span><span class=\"p\">{<\/span><span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">Response<\/span><span class=\"o\">.<\/span><span class=\"n\">Status<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">}<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">RenderJson<\/span><span class=\"p\">(<\/span><span class=\"n\">r<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"c\">\/\/ Internal Server Error \u3092\u8fd4\u3059\u3084\u3064<\/span>\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"o\">*<\/span><span class=\"n\">ApiV1Controller<\/span><span class=\"p\">)<\/span> <span class=\"n\">HandleInternalServerError<\/span><span class=\"p\">(<\/span><span class=\"n\">s<\/span> <span class=\"kt\">string<\/span><span class=\"p\">)<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Result<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">Response<\/span><span class=\"o\">.<\/span><span class=\"n\">Status<\/span> <span class=\"o\">=<\/span> <span class=\"n\">http<\/span><span class=\"o\">.<\/span><span class=\"n\">StatusInternalServerError<\/span>\r\n        <span class=\"n\">r<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">ErrorResponse<\/span><span class=\"p\">{<\/span><span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">Response<\/span><span class=\"o\">.<\/span><span class=\"n\">Status<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">}<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">RenderJson<\/span><span class=\"p\">(<\/span><span class=\"n\">r<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h4>\u521b\u5efa\u8bc4\u8bba\u63a7\u5236\u5668<\/h4>\n<pre class=\"post-pre\"><code><span class=\"c\">\/\/ app\/controllers\/api\/v1\/comments.go<\/span>\r\n<span class=\"k\">package<\/span> <span class=\"n\">controllers<\/span>\r\n\r\n<span class=\"k\">import<\/span> <span class=\"p\">(<\/span>\r\n        <span class=\"s\">\"github.com\/revel\/revel\"<\/span>\r\n        <span class=\"s\">\"github.com\/shiro16\/golang-bbs\/app\/controllers\"<\/span>\r\n<span class=\"p\">)<\/span>\r\n\r\n<span class=\"k\">type<\/span> <span class=\"n\">ApiV1Comments<\/span> <span class=\"k\">struct<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">ApiV1Controller<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"n\">ApiV1Comments<\/span><span class=\"p\">)<\/span> <span class=\"n\">Index<\/span><span class=\"p\">()<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Result<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">r<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">Response<\/span><span class=\"p\">{<\/span><span class=\"s\">\"index\"<\/span><span class=\"p\">}<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">RenderJson<\/span><span class=\"p\">(<\/span><span class=\"n\">r<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"n\">ApiV1Comments<\/span><span class=\"p\">)<\/span> <span class=\"n\">Show<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span> <span class=\"kt\">int<\/span><span class=\"p\">)<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Result<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">r<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">Response<\/span><span class=\"p\">{<\/span><span class=\"s\">\"show\"<\/span><span class=\"p\">}<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">RenderJson<\/span><span class=\"p\">(<\/span><span class=\"n\">r<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"n\">ApiV1Comments<\/span><span class=\"p\">)<\/span> <span class=\"n\">Create<\/span><span class=\"p\">()<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Result<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">r<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">Response<\/span><span class=\"p\">{<\/span><span class=\"s\">\"create\"<\/span><span class=\"p\">}<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">RenderJson<\/span><span class=\"p\">(<\/span><span class=\"n\">r<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">func<\/span> <span class=\"p\">(<\/span><span class=\"n\">c<\/span> <span class=\"n\">ApiV1Comments<\/span><span class=\"p\">)<\/span> <span class=\"n\">Delete<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span> <span class=\"kt\">int<\/span><span class=\"p\">)<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Result<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">r<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">Response<\/span><span class=\"p\">{<\/span><span class=\"s\">\"delete\"<\/span><span class=\"p\">}<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">c<\/span><span class=\"o\">.<\/span><span class=\"n\">RenderJson<\/span><span class=\"p\">(<\/span><span class=\"n\">r<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h2>API\u7684\u64cd\u4f5c\u9a8c\u8bc1<\/h2>\n<p>\u542f\u52a8\u670d\u52a1\u5668\uff1a<br \/>\n$ \u4f7f\u7528 revel run \u547d\u4ee4\u542f\u52a8github.com\/shiro16\/golang-bbs\u3002<\/p>\n<p>\u8bf7\u4e0d\u8981\u6253\u5f00\u7ec8\u7aef\u5e76\u5c1d\u8bd5\u4f7f\u7528curl\u547d\u4ee4\u3002<\/p>\n<p>\u8bf7\u7528\u4e2d\u6587\u5c06\u4ee5\u4e0b\u5185\u5bb9\u91cd\u8ff0\uff0c\u53ea\u9700\u8981\u4e00\u79cd\u9009\u9879\uff1a$ curl http:\/\/localhost:9000\/api\/v1\/comments\u3002<\/p>\n<pre class=\"post-pre\"><code>{\r\n  \"results\": \"index\"\r\n}\r\n<\/code><\/pre>\n<p>\u8bf7\u4f7f\u7528\u4ee5\u4e0b\u7684\u65b9\u5f0f\u5728\u672c\u5730\u8bbf\u95ee\u6b64\u94fe\u63a5\uff1a$ curl http:\/\/localhost:9000\/api\/v1\/comments\/1<\/p>\n<pre class=\"post-pre\"><code>{\r\n  \"results\": \"show\"\r\n}\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u662f\u5bf9\u8be5\u547d\u4ee4\u7684\u4e2d\u6587\u672c\u5730\u5316\u7684\u91cd\u8ff0\uff1a<\/p>\n<p>$ curl -X POST http:\/\/localhost:9000\/api\/v1\/comments<\/p>\n<p>\u8bf7\u6ce8\u610f\u4ec5\u63d0\u4f9b\u4e00\u4e2a\u9009\u9879\u3002<\/p>\n<pre class=\"post-pre\"><code>{\r\n  \"results\": \"create\"\r\n}\r\n<\/code><\/pre>\n<p>$ curl -X DELETE http:\/\/localhost:9000\/api\/v1\/comments\/1<br \/>\n\u8bf7\u4ee5\u672c\u57309000\u7aef\u53e3\u53d1\u9001\u4e00\u4e2aDELETE\u8bf7\u6c42\u5230http:\/\/localhost:9000\/api\/v1\/comments\/1\u3002<\/p>\n<pre class=\"post-pre\"><code>{\r\n  \"results\": \"delete\"\r\n}\r\n<\/code><\/pre>\n<p>\u5728\u542f\u52a8\u670d\u52a1\u5668\u7684\u7ec8\u7aef\u4e0a\u663e\u793a\u4e86\u63a7\u5236\u53f0\u65e5\u5fd7\u3002<\/p>\n<pre class=\"post-pre\"><code>2016\/10\/07 15:31:00.070 ::1 200 4.097022ms GET \/api\/v1\/comments\r\n2016\/10\/07 15:31:26.809 ::1 200  146.966\u00b5s GET \/api\/v1\/comments\/1\r\n2016\/10\/07 15:31:39.625 ::1 200  108.271\u00b5s POST \/api\/v1\/comments\r\n2016\/10\/07 15:31:50.521 ::1 200  105.353\u00b5s DELETE \/api\/v1\/comments\/1\r\n<\/code><\/pre>\n<h2>\u6570\u636e\u5e93\u7ba1\u7406<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u4f7f\u7528\u3059\u308bORM: github.com\/jinzhu\/gorm<\/ul>\n<\/li>\n<\/ul>\n<p>\u4f7f\u7528\u3059\u308bvalidation: github.com\/go-validator\/validator<\/p>\n<h2>\u521b\u5efa\u6570\u636e\u5e93<\/h2>\n<ul class=\"post-ul\">mysql\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3001create database\u3092\u5b9f\u884c<\/ul>\n<p>$ \u4f7f\u7528\u8005 root \u767b\u5165 mysql<\/p>\n<p>mysql&gt; \u521b\u5efa\u6570\u636e\u5e93 golang_bbs_development;<\/p>\n<p>mysql&gt; \u9000\u51fa<\/p>\n<h3>\u6dfb\u52a0DB\u7684\u8fde\u63a5\u4fe1\u606f<\/h3>\n<p>\u5728\u7ec8\u7aef\u8f93\u5165\uff1a$ vi conf\/app.conf<\/p>\n<p>\u5728[dev]\u90e8\u5206\u6dfb\u52a0\u4e00\u884c<\/p>\n<pre class=\"post-pre\"><code><span class=\"gi\">+ db.info = \"root@\/golang_bbs_development?charset=utf8&amp;parseTime=True\r\n<\/span><\/code><\/pre>\n<h3>\u6211\u5011\u9700\u8981\u5efa\u7acb\u4e00\u500b\u6a21\u578b\u3002<\/h3>\n<p>\u5b89\u88c5\u8981\u4f7f\u7528\u7684ORM\uff08gorm\uff09\u548c\u9a8c\u8bc1\u5668\uff08validator\uff09\u3002<\/p>\n<pre class=\"post-pre\"><code>$ go get github.com\/jinzhu\/gorm\r\n$ go get gopkg.in\/validator.v2\r\n<\/code><\/pre>\n<h4>\u521b\u5efa\u8bc4\u8bba\u6a21\u578b<\/h4>\n<pre class=\"post-pre\"><code><span class=\"c\">\/\/ app\/models\/comment.go<\/span>\r\n<span class=\"k\">package<\/span> <span class=\"n\">models<\/span>\r\n\r\n<span class=\"k\">import<\/span> <span class=\"p\">(<\/span>\r\n        <span class=\"s\">\"time\"<\/span>\r\n<span class=\"p\">)<\/span>\r\n\r\n<span class=\"k\">type<\/span> <span class=\"n\">Comment<\/span> <span class=\"k\">struct<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">ID<\/span>        <span class=\"kt\">uint64<\/span>     <span class=\"s\">`gorm:\"primary_key\" json:\"id\"`<\/span>\r\n        <span class=\"n\">Nickname<\/span>  <span class=\"kt\">string<\/span>     <span class=\"s\">`sql:\"size:64\" json:\"nickname\" validate:\"max=64\"`<\/span>\r\n        <span class=\"n\">Body<\/span>      <span class=\"kt\">string<\/span>     <span class=\"s\">`sql:\"size:255\" json:\"body\" validate:\"min=1,max=255\"`<\/span>\r\n        <span class=\"n\">CreatedAt<\/span> <span class=\"n\">time<\/span><span class=\"o\">.<\/span><span class=\"n\">Time<\/span>  <span class=\"s\">`json:\"created_at\"`<\/span>\r\n        <span class=\"n\">UpdatedAt<\/span> <span class=\"n\">time<\/span><span class=\"o\">.<\/span><span class=\"n\">Time<\/span>  <span class=\"s\">`json:\"updated_at\"`<\/span>\r\n        <span class=\"n\">DeletedAt<\/span> <span class=\"o\">*<\/span><span class=\"n\">time<\/span><span class=\"o\">.<\/span><span class=\"n\">Time<\/span> <span class=\"s\">`json:\"deleted_at\"`<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h4>\u521b\u5efagorm\u63a7\u5236\u5668<\/h4>\n<pre class=\"post-pre\"><code>\/\/ app\/controllers\/gorm.go\r\npackage controllers\r\n\r\nimport (\r\n        _ \"github.com\/go-sql-driver\/mysql\"\r\n        \"github.com\/jinzhu\/gorm\"\r\n        \"github.com\/revel\/revel\"\r\n        \"github.com\/shiro16\/golang-bbs\/app\/models\"\r\n        \"log\"\r\n)\r\n\r\nvar DB *gorm.DB\r\n\r\nfunc InitDB() {\r\n        db, err := gorm.Open(\"mysql\", dbInfoString())\r\n        if err != nil {\r\n                log.Panicf(\"Failed to connect to database: %v\\n\", err)\r\n        }\r\n\r\n        db.DB()\r\n        db.AutoMigrate(&amp;models.Comment{}) # \u3053\u3053\u3067 table \u306e\u4f5c\u6210\u3092\u884c\u3063\u3066\u3044\u308b\r\n        DB = db\r\n}\r\n\r\nfunc dbInfoString() string {\r\n        s, b := revel.Config.String(\"db.info\")\r\n        if !b {\r\n                log.Panicf(\"database info not found\")\r\n        }\r\n\r\n        return s\r\n}\r\n<\/code><\/pre>\n<h4>\u5728\u4ee3\u7801\u4e2d\u6dfb\u52a0\u8c03\u7528\u4e0a\u8ff0\u63a7\u5236\u5668\u7684\u5904\u7406\u903b\u8f91\u3002<\/h4>\n<p>\u8bf7\u7528\u4e2d\u6587\u91cd\u65b0\u8868\u8fbe\u5982\u4e0b\u5185\u5bb9\uff1a $ vi app\/init.go<br \/>\n\u8bf7\u7f16\u8f91 app\/init.go \u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gd\">- import \"github.com\/revel\/revel\"\r\n<\/span><span class=\"gi\">+ import(\r\n+         \"github.com\/revel\/revel\"\r\n+         \"github.com\/shiro16\/golang-bbs\/app\/controllers\"\r\n+ )\r\n<\/span>\r\nfunc init() {\r\n<span class=\"err\">....<\/span>\r\n+ revel.OnAppStart(controllers.InitDB) \/\/ 28\u884c\u76ee\u304f\u3089\u3044\u306b\r\n<span class=\"err\">}<\/span>\r\n<\/code><\/pre>\n<h3>\u5728\u63a7\u5236\u5668\u4e2d\u4f7f\u7528\u6a21\u578b<\/h3>\n<h4>\u7f16\u8f91\u8bc4\u8bba\u63a7\u5236\u5668<\/h4>\n<pre class=\"post-pre\"><code><span class=\"p\">package controllers\r\n<\/span>\r\nimport (\r\n    \"github.com\/revel\/revel\"\r\n<span class=\"gi\">+   \"github.com\/shiro16\/golang-bbs\/app\/controllers\"\r\n+   \"github.com\/shiro16\/golang-bbs\/app\/models\"\r\n+   \"gopkg.in\/validator.v2\"\r\n<\/span><span class=\"err\">)<\/span>\r\n\r\n<span class=\"p\">type ApiV1Comments struct {\r\n<\/span>    ApiV1Controller\r\n<span class=\"err\">}<\/span>\r\n\r\n<span class=\"p\">func (c ApiV1Comments) Index() revel.Result {\r\n<\/span><span class=\"gi\">+   comments := []models.Comment{}\r\n<\/span>\r\n+   if err := controllers.DB.Order(\"id desc\").Find(&amp;comments).Error; err != nil {\r\n<span class=\"gi\">+       return c.HandleInternalServerError(\"Record Find Failure\")\r\n+   }\r\n<\/span>\r\n+   r := Response{comments}\r\n<span class=\"gd\">-   r := Response{\"index\"}\r\n<\/span>    return c.RenderJson(r)\r\n<span class=\"err\">}<\/span>\r\n\r\n<span class=\"p\">func (c ApiV1Comments) Show(id int) revel.Result {\r\n<\/span><span class=\"gi\">+   comment := &amp;models.Comment{}\r\n<\/span>\r\n+   if err := controllers.DB.First(&amp;comment, id).Error; err != nil {\r\n<span class=\"gi\">+       return c.HandleNotFoundError(err.Error())\r\n+   }\r\n<\/span>\r\n+   r := Response{comment}\r\n<span class=\"gd\">-   r := Response{\"show\"}\r\n<\/span>    return c.RenderJson(r)\r\n<span class=\"err\">}<\/span>\r\n\r\n<span class=\"p\">func (c ApiV1Comments) Create() revel.Result {\r\n<\/span><span class=\"gi\">+   comment := &amp;models.Comment{}\r\n<\/span>\r\n+   if err := c.BindParams(comment); err != nil {\r\n<span class=\"gi\">+       return c.HandleBadRequestError(err.Error())\r\n+   }\r\n<\/span>\r\n+   if err := validator.Validate(comment); err != nil {\r\n<span class=\"gi\">+       return c.HandleBadRequestError(err.Error())\r\n+   }\r\n<\/span>\r\n+   if err := controllers.DB.Create(comment).Error; err != nil {\r\n<span class=\"gi\">+       return c.HandleInternalServerError(\"Record Create Failure\")\r\n+   }\r\n<\/span>\r\n+   r := Response{comment}\r\n<span class=\"gd\">-   r := Response{\"create\"}\r\n<\/span>    return c.RenderJson(r)\r\n<span class=\"err\">}<\/span>\r\n\r\n<span class=\"p\">func (c ApiV1Comments) Delete(id int) revel.Result {\r\n<\/span><span class=\"gi\">+   comment := models.Comment{}\r\n<\/span>\r\n+   if err := controllers.DB.First(&amp;comment, id).Error; err != nil {\r\n<span class=\"gi\">+       return c.HandleNotFoundError(err.Error())\r\n+   }\r\n<\/span>\r\n+   if err := controllers.DB.Delete(&amp;comment).Error; err != nil {\r\n<span class=\"gi\">+       return c.HandleInternalServerError(\"Record Delete Failure\")\r\n+   }\r\n<\/span>\r\n+   r := Response{\"success\"}\r\n<span class=\"gd\">-   r := Response{\"delete\"}\r\n<\/span>    return c.RenderJson(r)\r\n<span class=\"err\">}<\/span>\r\n<\/code><\/pre>\n<h3>\u521b\u5efaapp\/controllers\/comments.go\u3002<\/h3>\n<pre class=\"post-pre\"><code>package controllers\r\n\r\nimport (\r\n    \"github.com\/revel\/revel\"\r\n    \"github.com\/shiro16\/golang-bbs\/app\/models\"\r\n    \"net\/http\"\r\n)\r\n\r\ntype Comments struct {\r\n    *revel.Controller\r\n}\r\n\r\nfunc (c Comments) Index() revel.Result {\r\n    comments := []models.Comment{}\r\n\r\n    if err := DB.Order(\"id desc\").Find(&amp;comments).Error; err != nil {\r\n        c.Response.Status = http.StatusNotFound\r\n        \/\/ TODO: error rendering\r\n    }\r\n\r\n    c.RenderArgs[\"comments\"] = comments\r\n    return c.Render()\r\n}\r\n<\/code><\/pre>\n<h2>\u68c0\u67e5API\u7684\u8fd0\u4f5c<\/h2>\n<p>\u542f\u52a8\u670d\u52a1\u5668<br \/>\n$ revel run github.com\/shiro16\/golang-bbs<\/p>\n<p>\u5728\u547d\u4ee4\u884c\u4e2d\u6253\u5f00\u7ec8\u7aef\u5e76\u5c1d\u8bd5\u4f7f\u7528curl\u547d\u4ee4\u2192\u51fa\u73b0\u9519\u8bef\uff01<\/p>\n<p>\u7528\u4e2d\u6587\u5bf9\u4ee5\u4e0b\u5185\u5bb9\u8fdb\u884c\u6539\u8ff0\uff1a<br \/>\n$ curl -H &#8220;Content-type: application\/json&#8221; -X POST -d &#8216;{&#8220;nickname&#8221;:&#8221;shiro16&#8243;, &#8220;body&#8221;:&#8221;test comment&#8221;}&#8217; http:\/\/localhost:9000\/api\/v1\/comments<\/p>\n<p>curl\u547d\u4ee4:-H\u8868\u793a\u8bbe\u7f6e\u8bf7\u6c42\u5934\u90e8\uff0c&#8221;Content-type: application\/json&#8221;\u8868\u793a\u8bf7\u6c42\u5934\u90e8\u7684\u5185\u5bb9\u7c7b\u578b\u4e3aJSON\uff1b-X POST\u8868\u793a\u4f7f\u7528POST\u65b9\u6cd5\u53d1\u9001\u8bf7\u6c42\uff1b-d\u540e\u9762\u7684\u5185\u5bb9\u662f\u8bf7\u6c42\u4f53\uff0c\u5373\u8981\u53d1\u9001\u7684JSON\u6570\u636e\uff1bhttp:\/\/localhost:9000\/api\/v1\/comments\u662f\u8981\u53d1\u9001\u8bf7\u6c42\u7684URL\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">Go<\/span> <span class=\"n\">Compilation<\/span> <span class=\"n\">Error<\/span>\r\n<span class=\"n\">The<\/span> <span class=\"n\">Go<\/span> <span class=\"n\">code<\/span> <span class=\"n\">src<\/span><span class=\"o\">\/<\/span><span class=\"n\">github<\/span><span class=\"o\">.<\/span><span class=\"n\">com<\/span><span class=\"o\">\/<\/span><span class=\"n\">shiro16<\/span><span class=\"o\">\/<\/span><span class=\"n\">golang<\/span><span class=\"o\">-<\/span><span class=\"n\">bbs<\/span><span class=\"o\">\/<\/span><span class=\"n\">app<\/span><span class=\"o\">\/<\/span><span class=\"n\">controllers<\/span><span class=\"o\">\/<\/span><span class=\"n\">gorm<\/span><span class=\"o\">.<\/span><span class=\"k\">go<\/span> <span class=\"n\">does<\/span> <span class=\"n\">not<\/span> <span class=\"n\">compile<\/span><span class=\"o\">:<\/span> <span class=\"n\">cannot<\/span> <span class=\"n\">use<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">db<\/span> <span class=\"p\">(<\/span><span class=\"k\">type<\/span> <span class=\"o\">**<\/span><span class=\"n\">gorm<\/span><span class=\"o\">.<\/span><span class=\"n\">DB<\/span><span class=\"p\">)<\/span> <span class=\"n\">as<\/span> <span class=\"k\">type<\/span> <span class=\"o\">*<\/span><span class=\"n\">gorm<\/span><span class=\"o\">.<\/span><span class=\"n\">DB<\/span> <span class=\"n\">in<\/span> <span class=\"n\">assignment<\/span>\r\n\r\n<span class=\"n\">In<\/span> <span class=\"n\">src<\/span><span class=\"o\">\/<\/span><span class=\"n\">github<\/span><span class=\"o\">.<\/span><span class=\"n\">com<\/span><span class=\"o\">\/<\/span><span class=\"n\">shiro16<\/span><span class=\"o\">\/<\/span><span class=\"n\">golang<\/span><span class=\"o\">-<\/span><span class=\"n\">bbs<\/span><span class=\"o\">\/<\/span><span class=\"n\">app<\/span><span class=\"o\">\/<\/span><span class=\"n\">controllers<\/span><span class=\"o\">\/<\/span><span class=\"n\">gorm<\/span><span class=\"o\">.<\/span><span class=\"k\">go<\/span> <span class=\"p\">(<\/span><span class=\"n\">around<\/span> <span class=\"n\">line<\/span> <span class=\"m\">22<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"m\">17<\/span><span class=\"o\">:<\/span>\r\n                <span class=\"n\">log<\/span><span class=\"o\">.<\/span><span class=\"n\">Panicf<\/span><span class=\"p\">(<\/span><span class=\"s\">\"Failed to connect to database: %v<\/span><span class=\"se\">\\n<\/span><span class=\"s\">\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">err<\/span><span class=\"p\">)<\/span>\r\n<span class=\"m\">18<\/span><span class=\"o\">:<\/span>\r\n        <span class=\"p\">}<\/span>\r\n<span class=\"m\">19<\/span><span class=\"o\">:<\/span>\r\n<span class=\"m\">20<\/span><span class=\"o\">:<\/span>\r\n        <span class=\"n\">db<\/span><span class=\"o\">.<\/span><span class=\"n\">DB<\/span><span class=\"p\">()<\/span>\r\n<span class=\"m\">21<\/span><span class=\"o\">:<\/span>\r\n        <span class=\"n\">db<\/span><span class=\"o\">.<\/span><span class=\"n\">AutoMigrate<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">models<\/span><span class=\"o\">.<\/span><span class=\"n\">Comment<\/span><span class=\"p\">{})<\/span> \r\n<span class=\"m\">22<\/span><span class=\"o\">:<\/span>\r\n        <span class=\"n\">DB<\/span> <span class=\"o\">=<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">db<\/span>\r\n<span class=\"m\">23<\/span><span class=\"o\">:<\/span>\r\n<span class=\"p\">}<\/span>\r\n<span class=\"m\">24<\/span><span class=\"o\">:<\/span>\r\n<span class=\"m\">25<\/span><span class=\"o\">:<\/span>\r\n<span class=\"k\">func<\/span> <span class=\"n\">dbInfoString<\/span><span class=\"p\">()<\/span> <span class=\"kt\">string<\/span> <span class=\"p\">{<\/span>\r\n<span class=\"m\">26<\/span><span class=\"o\">:<\/span>\r\n        <span class=\"n\">s<\/span><span class=\"p\">,<\/span> <span class=\"n\">b<\/span> <span class=\"o\">:=<\/span> <span class=\"n\">revel<\/span><span class=\"o\">.<\/span><span class=\"n\">Config<\/span><span class=\"o\">.<\/span><span class=\"n\">String<\/span><span class=\"p\">(<\/span><span class=\"s\">\"db.info\"<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<h2>\u5bf9API\u8fdb\u884c\u529f\u80fd\u9a8c\u8bc1<\/h2>\n<h3>\u542f\u52a8\u670d\u52a1\u5668<\/h3>\n<p>\u8bf7\u8fd0\u884c `revel run github.com\/shiro16\/golang-bbs`\u3002<\/p>\n<h3>\u6253\u5f00\u4e00\u4e2a\u7ec8\u7aef\u5e76\u5c1d\u8bd5\u4f7f\u7528curl\u547d\u4ee4\u3002<\/h3>\n<pre class=\"post-pre\"><code>$ curl -H \"Content-type: application\/json\" -X POST -d '{\"nickname\":\"shiro16\", \"body\":\"test comment\"}' http:\/\/localhost:9000\/api\/v1\/comments\r\n{\r\n  \"results\": {\r\n    \"id\": 1,\r\n    \"nickname\": \"shiro16\",\r\n    \"body\": \"test comment\",\r\n    \"created_at\": \"2016-10-11T17:23:40.257591728+09:00\",\r\n    \"updated_at\": \"2016-10-11T17:23:40.257591728+09:00\",\r\n    \"deleted_at\": null\r\n  }\r\n}\r\n<\/code><\/pre>\n<h3>\u786e\u8ba4\u9a8c\u8bc1\u529f\u80fd\u662f\u5426\u6b63\u5e38\u8fd0\u4f5c\u3002<\/h3>\n<pre class=\"post-pre\"><code>$ curl -H \"Content-type: application\/json\" -X POST -d '{\"nickname\":\"shiro16\", \"body\":\"\"}' http:\/\/localhost:9000\/api\/v1\/comments\r\n{\r\n  \"code\": 400,\r\n  \"message\": \"Body: less than min\"\r\n}\r\n<\/code><\/pre>\n<h3>\u8bf7\u67e5\u770b\u8bc4\u8bba\u5217\u8868\u3002<\/h3>\n<pre class=\"post-pre\"><code>$ curl http:\/\/localhost:9000\/api\/v1\/comments\r\n{\r\n  \"results\": [\r\n    {\r\n      \"id\": 1,\r\n      \"nickname\": \"shiro16\",\r\n      \"body\": \"test comment\",\r\n      \"created_at\": \"2016-10-11T08:23:40Z\",\r\n      \"updated_at\": \"2016-10-11T08:23:40Z\",\r\n      \"deleted_at\": null\r\n    }\r\n  ]\r\n}\r\n<\/code><\/pre>\n<h3>\u8bf7\u53c2\u8003\u8bc4\u8bba\u7684\u5177\u4f53\u5185\u5bb9\u3002<\/h3>\n<pre class=\"post-pre\"><code>$ curl http:\/\/localhost:9000\/api\/v1\/comments\/1\r\n{\r\n  \"results\": {\r\n    \"id\": 1,\r\n    \"nickname\": \"shiro16\",\r\n    \"body\": \"test comment\",\r\n    \"created_at\": \"2016-10-11T08:23:40Z\",\r\n    \"updated_at\": \"2016-10-11T08:23:40Z\",\r\n    \"deleted_at\": null\r\n  }\r\n}\r\n<\/code><\/pre>\n<h3>\u5f15\u7528\u4e0d\u5b58\u5728\u7684\u8bc4\u8bba<\/h3>\n<pre class=\"post-pre\"><code>$ curl http:\/\/localhost:9000\/api\/v1\/comments\/2 \r\n{\r\n  \"code\": 404,\r\n  \"message\": \"record not found\"\r\n}\r\n<\/code><\/pre>\n<h3>\u5220\u9664\u8bc4\u8bba\u529f\u80fd\u7684\u6d4b\u8bd5.<\/h3>\n<pre class=\"post-pre\"><code>$ curl -X DELETE http:\/\/localhost:9000\/api\/v1\/comments\/1\r\n{\r\n  \"results\": \"success\"\r\n}\r\n<\/code><\/pre>\n<h2>\u603b\u7ed3<\/h2>\n<p>\u6211\u5df2\u7ecf\u6210\u529f\u5c06\u6d88\u606f\u5b58\u50a8\u5230\u4e86MySQL\uff0c\u5e76\u5c06\u5176\u8f93\u51fa\u4e3aJSON\u3002\u4e0b\u4e00\u6b65\uff0c\u6211\u5e0c\u671b\u80fd\u591f\u5bf9\u8f93\u51fa\u7ed3\u679c\u8fdb\u884c\u88c5\u9970\uff0c\u4ee5\u53ca\u5728\u767b\u5f55\u548c\u53d1\u5e03\u65b9\u9762\u589e\u5f3a\u529f\u80fd\u3002\u8fd8\u6709\u4eba\u8bf4&#8221;\u9a8c\u8bc1\u6700\u597d\u662f\u5728\u6a21\u578b\u4e2d\u6267\u884c&#8221;\uff0c\u6211\u5e0c\u671b\u80fd\u591f\u5728\u7814\u7a76\u8fd9\u65b9\u9762\u4fe1\u606f\u7684\u540c\u65f6\u8fdb\u884c\u62a5\u544a\u3002<\/p>\n<p>revel\u306esample\u306f\u3053\u3061\u3089\u306b\u3042\u308b\u306e\u3067\u662f\u975e\u53c2\u8003\u306b\u306a\u3055\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8bf7\u53c2\u8003 \u5c1d\u8bd5\u4f7f\u7528Golang\u7684revel\u6846\u67b6\u521b\u5efa\u4e00\u4e2a\u7c7b\u4f3c\u8bba\u575b\u7684\u4e1c\u897f\u3002 \u68c0\u67e5Go\u548cMySQL\u7684\u7248\u672c $ go v [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-44543","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u7528golang\u521b\u5efa\u7b80\u6613\u8bba\u575b\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b\" \/>\n<meta property=\"og:description\" content=\"\u8bf7\u53c2\u8003 \u5c1d\u8bd5\u4f7f\u7528Golang\u7684revel\u6846\u67b6\u521b\u5efa\u4e00\u4e2a\u7c7b\u4f3c\u8bba\u575b\u7684\u4e1c\u897f\u3002 \u68c0\u67e5Go\u548cMySQL\u7684\u7248\u672c $ go v [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u7528golang\u521b\u5efa\u7b80\u6613\u8bba\u575b\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-01T06:46:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T06:12:47+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u5b87\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u5b87\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/\",\"name\":\"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-01T06:46:19+00:00\",\"dateModified\":\"2024-04-29T06:12:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\",\"name\":\"\u6e05, \u5b87\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u5b87\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u7528golang\u521b\u5efa\u7b80\u6613\u8bba\u575b\/","og_locale":"zh_CN","og_type":"article","og_title":"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b","og_description":"\u8bf7\u53c2\u8003 \u5c1d\u8bd5\u4f7f\u7528Golang\u7684revel\u6846\u67b6\u521b\u5efa\u4e00\u4e2a\u7c7b\u4f3c\u8bba\u575b\u7684\u4e1c\u897f\u3002 \u68c0\u67e5Go\u548cMySQL\u7684\u7248\u672c $ go v [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u7528golang\u521b\u5efa\u7b80\u6613\u8bba\u575b\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-01T06:46:19+00:00","article_modified_time":"2024-04-29T06:12:47+00:00","author":"\u6e05, \u5b87","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u5b87","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/","name":"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-01T06:46:19+00:00","dateModified":"2024-04-29T06:12:47+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u7528Golang\u521b\u5efa\u7b80\u6613\u8bba\u575b"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e","name":"\u6e05, \u5b87","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","caption":"\u6e05, \u5b87"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e7%94%a8golang%e5%88%9b%e5%bb%ba%e7%ae%80%e6%98%93%e8%ae%ba%e5%9d%9b\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=44543"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44543\/revisions"}],"predecessor-version":[{"id":85750,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44543\/revisions\/85750"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=44543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=44543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=44543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}