{"id":1023,"date":"2022-01-09T22:48:21","date_gmt":"2022-01-09T13:48:21","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=1023"},"modified":"2022-01-23T08:05:15","modified_gmt":"2022-01-22T23:05:15","slug":"golang-sql-query%e3%81%8c%e8%bf%94%e3%81%99%e5%80%a4%e3%81%ae%e5%9e%8b%e3%81%ae%e5%a4%89%e6%95%b0%e5%ae%a3%e8%a8%80","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=1023","title":{"rendered":"<small>Golang sql.Query\u304c\u8fd4\u3059\u5024\u306e\u578b\u306e\u5909\u6570\u5ba3\u8a00<\/small>"},"content":{"rendered":"<p>\uff11\uff0e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 <a href=\"https:\/\/pkg.go.dev\/database\/sql\">https:\/\/pkg.go.dev\/database\/sql<\/a><br \/>\n\u30b5\u30f3\u30d7\u30eb\u306b\u3001sql.Query\u304c\u8fd4\u3059\u5024\u306e\u578b\u306e\u5909\u6570\u5ba3\u8a00\u306e\u4f8b\u304c\u306a\u3044<\/p>\n<pre>\r\nfunc (*DB) Query\r\nfunc (db *DB) Query(query string, args ...interface{}) (*Rows, error)\r\n<\/pre>\n<p>\uff12\uff0esql.Query\u304c\u8fd4\u3059\u578b\u306e\u5909\u6570\u5ba3\u8a00<\/p>\n<pre>\r\nvar rows *sql.Rows;\r\n<\/pre>\n<p>\uff13\uff0ecode<\/p>\n<pre>\r\nimport \"database\/sql\"\r\n\r\n\u30fb\u30fb\u30fb\r\n\r\nvar rows *sql.Rows;\r\n\r\nif user_name == \"admin\" {\r\n  rows, err = db.Query(s.String());\r\n} else {\r\n  rows, err = db.Query(s.String(), user_domain);\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff0e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 https:\/\/pkg.go.dev\/database\/sql \u30b5\u30f3\u30d7\u30eb\u306b\u3001sql.Query\u304c\u8fd4\u3059\u5024\u306e\u578b\u306e\u5909\u6570\u5ba3\u8a00\u306e\u4f8b\u304c\u306a\u3044 func (*DB) Query func (db *DB) Query(&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1023"}],"collection":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1023"}],"version-history":[{"count":15,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1023\/revisions"}],"predecessor-version":[{"id":1032,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1023\/revisions\/1032"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}