{"id":420,"date":"2022-06-08T09:00:19","date_gmt":"2022-06-08T00:00:19","guid":{"rendered":"https:\/\/is-ai.jp\/?p=420"},"modified":"2022-06-07T18:50:21","modified_gmt":"2022-06-07T09:50:21","slug":"tkinter%e3%81%a8flask%e3%81%a7todo%e3%83%aa%e3%82%b9%e3%83%88%e3%81%ae%e4%bd%9c%e6%88%90","status":"publish","type":"post","link":"https:\/\/is-ai.jp\/?p=420","title":{"rendered":"Tkinter\u3068flask\u3067ToDo\u30ea\u30b9\u30c8\u306e\u4f5c\u6210"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">\u306f\u3058\u3081\u306b<\/h4>\n\n\n\n<p>\u4eca\u56de\u3001tkinter\u3067todo\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u3066\u3001\u305d\u308c\u3092flask\u3067API\u5316\u3057\u3066\u30a6\u30a7\u30d6\u304b\u3089\u3082\u64cd\u4f5c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>Blockchain\u30b5\u30fc\u30d0\u3092flask\u3067\u5b9f\u88c5\u3057\u3066\u307f\u305f\u3068\u304d\u306b\u81ea\u5206\u3067\u3082\u30b5\u30fc\u30d0\u95a2\u4fc2\u306e\u5b9f\u88c5\u3092\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u3001\u4eca\u56de\u306e\u5b9f\u88c5\u306b\u81f3\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>Demo\u52d5\u753b\u4f5c\u3063\u305f\u306e\u3067\u3088\u3051\u308c\u3070\u898b\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>\u5de6\u5074\u304cTkinter\u3067\u4f5c\u3063\u305fUi\u3067\u3001\u53f3\u5074\u306fHTML, css, JavaScript\u3067\u69cb\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/is-ai.jp\/wp-content\/uploads\/2022\/06\/e119145c8b952cf11db0c11d498ab6a7.mov\"><\/video><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/h4>\n\n\n\n<p>\u307e\u305f\u3001todo\u30ea\u30b9\u30c8\u3092\u7ba1\u7406\u3059\u308b\u305f\u3081SQLite3\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>tasks\u3068\u3044\u3046\u540d\u524d\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u4e8b\u524d\u306b\u4f5c\u6210\u3057\u3066\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4ee5\u4e0b\u30b3\u30fc\u30c9<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>class DataBase():\n    def insert_database(self, id, task):\n        conn = sqlite3.connect(&#39;sqlite.db&#39;)\n        c = conn.cursor()\n        sql = &quot;INSERT INTO tasks (id, task) values(?, ?)&quot;\n        c.execute(sql, (id, task))\n        conn.commit()\n        print(&#39;saved!!&#39;)\n        conn.close()\n    \n    def delete_task(self, id):\n        conn = sqlite3.connect(&#39;sqlite.db&#39;)\n        c = conn.cursor()\n        sql = f&quot;DELETE FROM tasks WHERE id={id}&quot;\n        c.execute(sql)\n        conn.commit()\n        print(&#39;deleted!!&#39;)\n        conn.close()\n        \n    def get_task_item(self):\n        conn = sqlite3.connect(&#39;sqlite.db&#39;)\n        c = conn.cursor()\n        rows = []\n        c.execute(&quot;SELECT * FROM tasks&quot;)\n        for row in c:\n            rows.append(row)\n        conn.close()\n        return rows[::-1]\n    \n    def get_selected_task_item(self, id):\n        conn = sqlite3.connect(&#39;sqlite.db&#39;)\n        c = conn.cursor()\n        rows = []\n        sql = f&quot;SELECT * FROM tasks WHERE id={id}&quot;\n        c.execute(sql)\n        for row in c:\n            rows.append(row)\n        conn.close()\n        return rows[::-1]\n    \n    def get_item_id(self):\n        conn = sqlite3.connect(&#39;sqlite.db&#39;)\n        c = conn.cursor()\n        rows = []\n        sql = f&quot;SELECT id FROM tasks&quot;\n        c.execute(sql)\n        for row in c:\n            rows.append(row)\n        conn.close()\n        return rows[::-1]<\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>\u307e\u305ftkinter\u306e\u30b3\u30fc\u30c9\u306f\u3053\u3061\u3089\u3067\u3059\u3002<\/p>\n\n\n\n<p>5\u79d2\u306b\u4e00\u56de\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u51fa\u3057\u3066\u66f4\u65b0\u3059\u308b\u3088\u3046\u306a\u30b3\u30fc\u30c9\u69cb\u6210\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>class TodoList(Canvas):\n    def __init__(self, master):\n        super().__init__(master, bg=&quot;white&quot;)\n        self.item = []\n        self.title = Label(self, text=&quot;ToDo List&quot;, bg=&quot;white&quot;, font=(&quot;DSEG7 Classic&quot;, 35, &quot;bold&quot;))\n        self.title.grid(row=0, column=0, ipady=20, sticky=&quot;news&quot;)\n        self.update()\n        \n    def generate_items(self, tasks):\n        if len(self.item) != 0:\n            for item in self.item:\n                item.destroy()\n                self.item = []\n\n        for i, task in enumerate(tasks):\n            newlined_task = self.adjust_text(task[1])\n            self.task = Label(self, text=newlined_task, bg=&quot;white&quot;, font=(&quot;DSEG7 Classic&quot;, 22, &quot;bold&quot;), justify=tk.LEFT, anchor=tk.W)\n            self.task.grid(row=i+1, column=0, ipadx=5, sticky=&quot;news&quot;)\n            self.item.append(self.task)\n            \n    def adjust_text(self, text, length=16):\n        text = &#39;- &#39; + text\n        text_length = len(text)\n        newlined_text = &#39;&#39;\n        \n        for i in range(int(text_length\/length)+1):\n            newlined_text += text[i*length:(i+1)*length]\n            newlined_text += &#39;\\n&#39;\n        return newlined_text\n    \n    def get_todo_items(self):\n        url = &quot;http:\/\/127.0.0.1:5000\/&quot;\n        response = requests.get(url)\n        json_data = response.json()\n        self.generate_items(json_data)            \n            \n    def update(self):\n        self.get_todo_items()\n        self.master.after(5000, self.update)<\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u304a\u308f\u308a\u306b<\/h4>\n\n\n\n<p>Flask\u3092\u4f7f\u3063\u3066API\u5316\u3059\u308b\u3053\u3068\u3067\u3001tkinter\u3067todo\u30ea\u30b9\u30c8\u3092\u78ba\u8a8d\u3057\u306a\u304c\u3089web\u30b5\u30a4\u30c8\u5074\u3067\u64cd\u4f5c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u5fa9\u7fd2\u3082\u517c\u306d\u305f\u9762\u767d\u3044\u5b9f\u88c5\u304c\u3067\u304d\u305f\u304b\u306a\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u306f\u3058\u3081\u306b \u4eca\u56de\u3001tkinter\u3067todo\u30ea\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u3066\u3001\u305d\u308c\u3092flask\u3067API\u5316\u3057\u3066\u30a6\u30a7\u30d6\u304b\u3089\u3082\u64cd\u4f5c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002 Blockchain\u30b5\u30fc\u30d0\u3092flask\u3067\u5b9f\u88c5\u3057\u3066\u307f\u305f\u3068\u304d\u306b\u81ea\u5206\u3067\u3082\u30b5\u30fc\u30d0\u95a2\u4fc2\u306e\u5b9f\u88c5\u3092\u3057\u3066\u307f\u305f\u2026<\/p>\n","protected":false},"author":1,"featured_media":421,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[41,7,40],"_links":{"self":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts\/420"}],"collection":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=420"}],"version-history":[{"count":1,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts\/420\/revisions"}],"predecessor-version":[{"id":423,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts\/420\/revisions\/423"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/media\/421"}],"wp:attachment":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}