{"id":130,"date":"2022-03-15T10:50:33","date_gmt":"2022-03-15T01:50:33","guid":{"rendered":"https:\/\/www.kd2.jp\/memo3\/?p=130"},"modified":"2022-03-15T11:20:42","modified_gmt":"2022-03-15T02:20:42","slug":"psycopg2%e3%81%a7hello-world","status":"publish","type":"post","link":"https:\/\/www.kd2.jp\/memo3\/?p=130","title":{"rendered":"psycopg2\u3067Hello World"},"content":{"rendered":"<p>python 3.8.10<\/p>\n<div class=\"wp-block-codemirror-blocks code-block \">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;python&quot;,&quot;mime&quot;:&quot;text\/x-python&quot;,&quot;theme&quot;:&quot;eclipse&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:true,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;&quot;}\">import psycopg2\r\n\r\nconn = psycopg2.connect(\"dbname=dbname host=localhost user=user password=password\")\r\ncur = conn.cursor()\r\ncur.execute(\"select * from test1\")\r\nprint(cur.fetchone())\r\ncur.close()\r\nconn.close()<\/pre>\n<\/div>\n<p>\u5b9f\u884c\u7d50\u679c\u3002\u30bf\u30d7\u30eb\u3067\u8fd4\u3055\u308c\u308b\u3002<\/p>\n<div class=\"wp-block-codemirror-blocks code-block \">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;null&quot;,&quot;mime&quot;:&quot;text\/plain&quot;,&quot;theme&quot;:&quot;eclipse&quot;,&quot;lineNumbers&quot;:false,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:false,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;&quot;}\">('Hello World',)<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>python 3.8.10 import psycopg2 conn = psycopg2.connect(&#8220;dbname=dbname host=localhost user=user password=passwor&hellip; <a class=\"more-link\" href=\"https:\/\/www.kd2.jp\/memo3\/?p=130\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">psycopg2\u3067Hello World<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=\/wp\/v2\/posts\/130"}],"collection":[{"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=130"}],"version-history":[{"count":6,"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":136,"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=\/wp\/v2\/posts\/130\/revisions\/136"}],"wp:attachment":[{"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kd2.jp\/memo3\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}