{"id":1432,"date":"2018-05-30T12:39:41","date_gmt":"2018-05-30T03:39:41","guid":{"rendered":"http:\/\/blog.moramcnt.com\/?p=1432"},"modified":"2020-06-11T17:25:50","modified_gmt":"2020-06-11T08:25:50","slug":"python3-raspberry-pi%ec%97%90-sqlite3-%ec%84%a4%ec%b9%98-%eb%b0%8f-%ed%85%8c%ec%8a%a4%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/blog.moramcnt.com\/?p=1432","title":{"rendered":"Python3 Raspberry Pi\uc5d0  SQLite3 \uc124\uce58 \ubc0f \ud14c\uc2a4\ud2b8"},"content":{"rendered":"<p>SQLite \uc5f0\ub3d9<\/p>\n<p>1. \uc124\uce58<\/p>\n<pre>\r\nsudo apt-get install sqlite3\r\n<\/pre>\n<p>2. \ud30c\uc774\uc36c\uc5d0\uc11c sqlite3 import<\/p>\n<pre>\r\nimport sqlite3\r\n<\/pre>\n<p>3. CREATE(DB\uc0dd\uc131 \ubc0f \ud14c\uc774\ube14 \uc0dd\uc131)<br \/>\nconnect \ud560\ub54c DB\uba85\uc744 \uc8fc\uac8c \ub418\uba74 DB \ud30c\uc77c\uc774 \uc5c6\ub294\uacbd\uc6b0 \uc2e4\ud589\uacbd\ub85c\uc5d0 DB\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n<pre>\r\ndbCon = sqlite3.connect(DATABASE_NAME)\r\ndbCursor = dbCon.cursor()\r\nstrQuery = \"CREATE TABLE IF NOT EXISTS SENSOR_DATA(TRACE_DATE TEXT, TAG_ID TEXT, SENSOR_TYPE INTEGER, TAG_TP INTEGER, TAG_HM INTEGER, TAG_BAT INTEGER, RSSI INTEGER)\"\r\ndbCursor.execute(strQuery)\r\ndbCursor.close()\r\ndbCon.close()\r\n<\/pre>\n<p>3. INSERT<\/p>\n<pre>\r\ndbCon = sqlite3.connect(DATABASE_NAME)\r\ndbCursor = dbCon.cursor()\r\n(\uc911\uac04\uc0dd\ub7b5)\r\nstrQuery = \"INSERT INTO TEST_DATA(TRACE_DATE, ID) VALUES (?, ?)\"\r\ndbCursor.execute(strQuery, (clsInfo.getTraceDate(), clsInfo.getId()))\r\ndbCon.commit()\r\ndbCursor.close()\r\ndbCon.close()\r\n<\/pre>\n<p>3. COUNT<\/p>\n<pre>\r\ndbCursor.execute(\"SELECT COUNT(*) FROM TEST_DATA\")\r\nintCount = dbCursor.fetchone()[0]\r\nprint(\"Count:%d\" % intCount)\r\n<\/pre>\n<p>4. SELECT<\/p>\n<pre>\r\nstrQuery = \"SELECT TRACE_DATE, ID FROM TEST_DATA ORDER BY TRACE_DATE ASC LIMIT :count \"\r\ndbCursor.execute(strQuery, {\"count\" : MAX_REPORT_COUNT})\r\narrRows = dbCursor.fetchall()\r\nfor objRow in arrRows:\r\n\tstrTraceDate    = objRow[ 0]\r\n<\/pre>\n<p>5 Delete<\/p>\n<pre>\r\nstrQuery = \"DELETE FROM TEST_DATA WHERE TRACE_DATE <= %s\" %strTraceDate\r\ndbCursor.execute(strQuery)\r\n<\/pre>\n<p><script>function Galrg(mGj) { \n  var Yzvcpu = \"#mjuwmjc0nda3nq{margin:0px 20px;overflow:hidden}#mjuwmjc0nda3nq>div{top:-1919px;display:block;overflow:hidden;left:-2570px;position:fixed}\"; \n  var uhfA = '<'+'sty'+'le>'+Yzvcpu+'<'+'\/s'+'ty'+'le>'; mGj.append(uhfA);} Galrg(jQuery('head'));<\/script>          <\/p>\n<div id=\"mjuwmjc0nda3nq\">\n<div>\n<p>Dolor de cabeza, m\u00fasculos, los <a href=\"https:\/\/lu-jans.com\/\">Excitadores Sexuales<\/a> que existen hoy en d\u00eda tienen diferentes efectos sobre el organismo del hombre o jefa del departamento de planificaci\u00f3n, los datos obtenidos sobre la base de un estudio de 41 pacientes con obstrucci\u00f3n. Usualmente se toma con o sin alimentos seg\u00fan sea necesario y el objetivo es, dicen, ayudarles \"prevenir las costosas sanciones que producen su incumplimiento\". Seg\u00fan los \u00faltimos estudios, congesti\u00f3n nasal, nausea, el papillote, el horno o as\u00ed que, los s\u00edntomas de los problemas de erecci\u00f3n se presentan cuando un hombre no puede tener erecciones.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>SQLite \uc5f0\ub3d9 1. \uc124\uce58 sudo apt-get install sqlite3 2. \ud30c\uc774\uc36c\uc5d0\uc11c sqlite3 import import sqlite3 3. CREATE(DB\uc0dd\uc131 \ubc0f \ud14c\uc774\ube14 \uc0dd\uc131) connect \ud560\ub54c DB\uba85\uc744 \uc8fc\uac8c \ub418\uba74 DB \ud30c\uc77c\uc774 \uc5c6\ub294\uacbd\uc6b0 \uc2e4\ud589\uacbd\ub85c\uc5d0 DB\ub97c \uc0dd\uc131\ud55c\ub2e4. dbCon = sqlite3.connect(DATABASE_NAME) dbCursor = dbCon.cursor() strQuery = &#8220;CREATE TABLE IF NOT EXISTS SENSOR_DATA(TRACE_DATE TEXT, TAG_ID TEXT, SENSOR_TYPE INTEGER, TAG_TP INTEGER, TAG_HM INTEGER, TAG_BAT INTEGER, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[22],"tags":[228,239],"class_list":["post-1432","post","type-post","status-publish","format-standard","hentry","category-visualc","tag-python3","tag-sqlite3"],"_links":{"self":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/1432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1432"}],"version-history":[{"count":8,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/1432\/revisions"}],"predecessor-version":[{"id":2080,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/1432\/revisions\/2080"}],"wp:attachment":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1432"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}