{"id":57,"date":"2025-09-29T11:27:34","date_gmt":"2025-09-29T02:27:34","guid":{"rendered":"https:\/\/devserver.kr\/blog\/?p=57"},"modified":"2025-09-29T11:54:38","modified_gmt":"2025-09-29T02:54:38","slug":"python-sqlite-%ec%82%ac%ec%9a%a9%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/devserver.kr\/blog\/python\/python-sqlite-%ec%82%ac%ec%9a%a9%eb%b0%a9%eb%b2%95\/","title":{"rendered":"Python\uc5d0\uc11c sqlite \uc0ac\uc6a9\ubc29\ubc95"},"content":{"rendered":"\n<div class=\"wp-block-jetpack-markdown\"><p>sqlite3\uc740 \uae30\ubcf8 \ud3ec\ud568\ub418\uc5b4 \uc788\ub2e4.<\/p>\n<p>import sqlite3<\/p>\n<p>\uba54\ubaa8\ub9ac\uc5d0 DB \uc0dd\uc131 &#8211; \uc77c\ud68c\uc131\ncon = sqlite3.connect(\u2018:memory:\u2019)<\/p>\n<p>\ud30c\uc77c DB\ncon = sqlite3.connect(\u2018.\/test.db\u2019)<\/p>\n<p>cur = con.cursor()\ncur.execute(\u201cCREATE TABLE PhoneBook(Name text, PhoneNum text);\u201d)<\/p>\n<p>\ub370\uc774\ud130 \uc0bd\uc785\ncur = con.cursor()\ncur.execute(\u201cINSERT INTO PhoneBook Values(\u2018Derick\u2019, \u2018010-1234-5678\u2019);\u201d)<\/p>\n<p>or<\/p>\n<p>name = \u2018SangJung\u2019\nphoneNumber = \u2018010-5670-2343\u2019\ncur = con.cursor()\ncur.execute(\u2018INSERT INTO PhoneBook VALUES(?, ?);\u2019, (name, phoneNumber))<\/p>\n<p>or<\/p>\n<p>name = \u2018SangJung\u2019\nphoneNumber = \u2018010-5670-2343\u2019\ncur = con.cursor()\ncur.execute(\u2018INSERT INTO PhoneBook VALUES(:name, :phoneNumber);\u2019, {\u201cname\u201d:name, \u201cphoneNumber\u201d:phoneNumber})<\/p>\n<p>or<\/p>\n<p>dataList = ((\u2018Tom\u2019, \u2018010-543-5432\u2019), (\u2018DSP\u2019, \u2018010-123-1234\u2019))\ncur = con.cursor()\ncur.executemany(\u201cINSERT INTO PhoneBook VALUES(?, ?);\u201d, dataList)<\/p>\n<h3>\ub370\uc774\ud130 \uc870\ud68c<\/h3>\n<h4>\uc21c\ud68c \uc870\ud68c<\/h4>\n<p>cur.execute(\u2018SELECT * FROM PhoneBook\u2019)\nfor row in cur:\nprint(row)<\/p>\n<p>(\u2018Derick\u2019, \u2018010-1234-5678\u2019)\n(\u2018SangJung\u2019, \u2018010-5670-2343\u2019)\n(\u2018Tom\u2019, \u2018010-543-5432\u2019)\n(\u2018DSP\u2019, \u2018010-123-1234\u2019)<\/p>\n<h4>\ub2e8\uac74 \uc870\ud68c<\/h4>\n<p>cur.execute(\u2018SELECT * FROM PhoneBook\u2019)\ncur.fetchone()\n(\u2018Derick\u2019, \u2018010-1234-5678\u2019)<\/p>\n<h4>\ub2e4\uac74 \uc870\ud68c<\/h4>\n<p>cur.fetchmany(2)\n[(\u2018SangJung\u2019, \u2018010-5670-2343\u2019), (\u2018SangJung\u2019, \u2018010-5670-2343\u2019)]<\/p>\n<h4>\ubaa8\ub450 \uc870\ud68c<\/h4>\n<p>cur.fetchall()\n[(\u2018Tom\u2019, \u2018010-543-5432\u2019), (\u2018DSP\u2019, \u2018010-123-1234\u2019)]<\/p>\n<p>con.commit()<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-57","post","type-post","status-publish","format-standard","hentry","category-python"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/posts\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":2,"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":71,"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/posts\/57\/revisions\/71"}],"wp:attachment":[{"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/media?parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/categories?post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devserver.kr\/blog\/wp-json\/wp\/v2\/tags?post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}