{"id":297,"date":"2008-10-01T09:46:32","date_gmt":"2008-10-01T00:46:32","guid":{"rendered":"http:\/\/blog.bitmeister.jp\/?p=297"},"modified":"2008-10-01T09:46:32","modified_gmt":"2008-10-01T00:46:32","slug":"python-cgi%e3%81%a7sqlite%e3%82%92%e4%bd%bf%e3%81%86","status":"publish","type":"post","link":"https:\/\/blog.bitmeister.jp\/?p=297","title":{"rendered":"Python CGI\u3067sqlite\u3092\u4f7f\u3046"},"content":{"rendered":"<p><a href=\"?p=291\">\u6628\u65e5\u306e\u74b0\u5883<\/a>\u3092\u30d9\u30fc\u30b9\u306b\u3001sqlite\u3092\u4f7f\u3063\u305f\u30b5\u30a4\u30c8\u3092\u69cb\u7bc9\u3057\u3066\u307f\u307e\u3057\u305f\u3002<br \/>\nsqlite\u306fpython2.5\u306b\u306f\u542b\u307e\u308c\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001\u7279\u5225\u306a\u3053\u3068\u306f\u3057\u306a\u304f\u3066\u3082\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>\u7c21\u5358\u306a\u63b2\u793a\u677f\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<\/p>\n<p>\u52d5\u4f5c\u8aac\u660e\uff09<br \/>\nDB\u304c\u306a\u3044\u72b6\u614b\u3060\u3068DB\u3092\u4f5c\u308a\u307e\u3059\u3002<br \/>\n\u8868\u793a\u306e\u969b\u306f\u5165\u529b\u30d5\u30a9\u30fc\u30e0\u3068DB\u304b\u3089\u8aad\u307f\u8fbc\u3093\u3060\u30b3\u30e1\u30f3\u30c8\u3092\u8868\u793a\u3057\u307e\u3059\u3002<br \/>\n\u5165\u529b\u30d5\u30a9\u30fc\u30e0\u306b\u5165\u529b\u3059\u308b\u3068DB\u306b\u767b\u9332\u3055\u308c\u307e\u3059\u3002<br \/>\nDB\u306b\u306f\u3001\u540d\u524d\u3001\u30bf\u30a4\u30c8\u30eb\u3001\u30b3\u30e1\u30f3\u30c8\u3001\u9001\u4fe1\u65e5\u6642\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002<br \/>\n<!--more--><br \/>\n\u30bd\u30fc\u30b9\uff09<br \/>\npyboard.py<br \/>\n\u203bPython\u521d\u5fc3\u8005\u304c\u4f5c\u3063\u305f\u3082\u306e\u3067\u3059\u306e\u3067\u3001\u591a\u5c11\u306e\u304a\u898b\u82e6\u3057\u3044\u70b9\u306f\u3054\u5bb9\u8d66\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre>\r\n<textarea name=\"code\" class=\"python\">\r\n#!C:\\Python25\\python.exe\r\n# -*- coding: utf-8 -*-\r\n\r\nimport cgi\r\nimport cgitb\r\nimport sqlite3\r\n\r\ncgitb.enable()\r\n\r\nprint \"Content-type: text\/html; charset=utf-8\"\r\nprint \"Pragma: no-cache\"\r\nprint \"Cache-Control: no-cache\"\r\nprint\r\nprint '''\r\n&lt;!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\">\r\n&lt;html lang=\"ja\">\r\n&lt;head>\r\n&lt;META HTTP-EQUIV=\"Content-type\" CONTENT=\"text\/html; charset=UTF-8\">\r\n&lt;META HTTP-EQUIV=\"Pragma\" CONTENT=\"no-cache\">\r\n&lt;META HTTP-EQUIV=\"Cache-Control\" CONTENT=\"no-cache\">\r\n&lt;title>python\u63b2\u793a\u677f&lt;\/title>\r\n&lt;\/head>\r\n&lt;body>\r\n&lt;form method=\"POST\" action=\".\/pyboard.py\">\r\n&lt;table>\r\n&lt;tr>\r\n  &lt;td>&lt;b>\u306a\u307e\u3048&lt;\/b>&lt;\/td>\r\n  &lt;td>&lt;input type=\"text\" name=\"name\" size=\"10\" value=\"\">&lt;\/td>\r\n&lt;\/tr>\r\n&lt;tr>\r\n  &lt;td>&lt;b>\u30bf\u30a4\u30c8\u30eb&lt;\/b>&lt;\/td>\r\n  &lt;td>&lt;input type=\"text\" name=\"title\" size=\"20\" value=\"\">&lt;\/td>\r\n&lt;\/tr>\r\n&lt;tr>\r\n  &lt;td>&lt;b>\u30b3\u30e1\u30f3\u30c8&lt;\/b>&lt;\/td>\r\n  &lt;td>&lt;textarea cols=\"20\" rows=\"5\" name=\"comment\">&lt;\/textarea>&lt;\/td>\r\n&lt;\/tr>\r\n&lt;tr>\r\n  &lt;td colspan=\"2\">&lt;input type=\"submit\" value=\"\u9001\u4fe1\">&lt;input type=\"reset\" value=\"\u30ea\u30bb\u30c3\u30c8\">&lt;\/td>\r\n&lt;\/tr>\r\n&lt;\/table>\r\n&lt;\/form>\r\n'''\r\n\r\nmessage = '''\r\n&lt;dt>&lt;hr \/>\u30bf\u30a4\u30c8\u30eb\uff1a%(title)s \u306a\u307e\u3048\uff1a%(name)s \u9001\u4fe1\u65e5\u6642\uff1a%(regdate)s&lt;\/dt>&lt;br>&lt;br>\r\n&lt;dd>%(comment)s&lt;\/dd>&lt;br>\r\n'''\r\n\r\ncon = sqlite3.connect(\"board.db\")\r\ntry:\r\n  # DB\u4f5c\u6210\r\n  con.executescript(\"\"\"create table boardtbl(regdate timestamp,name varchar(10),title varchar(30),comment varchar(100));\"\"\")\r\nexcept:\r\n  print\r\nfinally:\r\n  # \u5165\u529b\u30c7\u30fc\u30bf\u304c\u3042\u308c\u3070\u3001DB\u767b\u9332\r\n  form = cgi.FieldStorage()\r\n  if form.has_key('name'):\r\n    # name\u304c\u6307\u5b9a\u3055\u308c\u3066\u3044\u305f\u3089\u30b3\u30e1\u30f3\u30c8\u767b\u9332\r\n    name = form.getfirst('name','')\r\n    title = form.getfirst('title','')\r\n    comment = form.getfirst('comment','')\r\n    cur = con.cursor()\r\n    try:\r\n      cur.execute(\"insert into boardtbl values(datetime('now','localtime'),?,?,?)\",(cgi.escape(name),cgi.escape(title),cgi.escape(comment)))\r\n      con.commit()\r\n    except:\r\n      con.rollback()\r\n    finally:\r\n      cur.close()\r\n\r\n  # \u63b2\u793a\u677f\u8868\u793a\r\n  con.row_factory = sqlite3.Row\r\n  cur = con.cursor()\r\n  try:\r\n    cur.execute(\"select * from boardtbl order by regdate desc\")\r\n    print \"&lt;dl>\"\r\n    for each in cur.fetchall():\r\n      print message%{'title':each['title'].encode('utf-8'),'name':each['name'].encode('utf-8'),'regdate':each['regdate'].encode('utf-8'),'comment':each['comment'].encode('utf-8')}\r\n    print \"&lt;\/dl>\"\r\n  finally:\r\n    cur.close()\r\n    con.close()\r\n  print \"&lt;\/body>&lt;\/html>\"\r\n<\/textarea><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6628\u65e5\u306e\u74b0\u5883\u3092\u30d9\u30fc\u30b9\u306b\u3001sqlite\u3092\u4f7f\u3063\u305f\u30b5\u30a4\u30c8\u3092\u69cb\u7bc9\u3057\u3066\u307f\u307e\u3057\u305f\u3002 sqlite\u306fpython2.5\u306b\u306f\u542b\u307e\u308c\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001\u7279\u5225\u306a\u3053\u3068\u306f\u3057\u306a\u304f\u3066\u3082\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002 \u7c21\u5358\u306a\u63b2\u793a\u677f\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002 \u52d5\u4f5c\u8aac\u660e\uff09 DB\u304c\u306a\u3044 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-297","post","type-post","status-publish","format-standard","hentry","category-tech"],"_links":{"self":[{"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=\/wp\/v2\/posts\/297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=297"}],"version-history":[{"count":4,"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=\/wp\/v2\/posts\/297\/revisions"}],"predecessor-version":[{"id":301,"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=\/wp\/v2\/posts\/297\/revisions\/301"}],"wp:attachment":[{"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bitmeister.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}