{"id":1392,"date":"2020-05-27T00:00:00","date_gmt":"2020-05-26T15:00:00","guid":{"rendered":"https:\/\/www.ishikawasekkei.com\/?p=1392"},"modified":"2020-05-26T23:57:04","modified_gmt":"2020-05-26T14:57:04","slug":"python-tkinter-gui-programing-how-to-get-table-information","status":"publish","type":"post","link":"https:\/\/www.ishikawasekkei.com\/index.php\/2020\/05\/27\/python-tkinter-gui-programing-how-to-get-table-information\/","title":{"rendered":"Python tkinter GUI\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0 \u30c6\u30fc\u30d6\u30eb\u60c5\u5831\u53d6\u5f97"},"content":{"rendered":"\n

\u3000\u4eca\u65e5\u3082\u898b\u306b\u6765\u3066\u304f\u3060\u3055\u3063\u3066\u3001\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002\u77f3\u5ddd\u3055\u3093\u3067\u3059\u3002<\/p>\n\n\n\n

\u3000\u4eca\u65e5\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30e9\u30af\u30eb\u3078\u63a5\u7d9a\u3001\u305d\u306e\u30b9\u30ad\u30fc\u30de\u306e\u30c6\u30fc\u30d6\u30eb\u60c5\u5831\u3092\u53d6\u5f97\u3057\u3066Treeview\u3078\u8868\u793a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u307e\u3057\u305f\u3002\u3044\u3084\uff5e\u3001\u3051\u3063\u3053\u3046\u6642\u9593\u304c\u304b\u304b\u308a\u307e\u3057\u305f\u306d\u3047\u3002Treeview\u3092\u601d\u3063\u305f\u3088\u3046\u306b\u64cd\u4f5c\u3059\u308b\u306e\u304c\u96e3\u3057\u304b\u3063\u305f\u306a\u3041\u3002<\/p>\n\n\n\n

\u3000Oracle\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f18c Express Edition\u3001Python\u306fAnaconda3\u3067\u3059\u3002<\/p>\n\n\n\n

\u51fa\u6765\u4e0a\u304c\u308a\u30a4\u30e1\u30fc\u30b8<\/h2>\n\n\n\n

\u3000\u4eca\u56de\u306e\u30bd\u30fc\u30b9\u3092\u5b9f\u884c\u3057\u3066\u3001\u300cload table\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u3053\u3093\u306a\u611f\u3058\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u306a\u308a\u307e\u3059\u3002\u5de6\u5074\u306e\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u3092\u9078\u629e\u3059\u308b\u3068\u53f3\u5074\u306b\u9805\u76ee\u306e\u4e00\u89a7\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\"\"
\u3067\u304d\u3042\u304c\u308a\u30a4\u30e1\u30fc\u30b8<\/figcaption><\/figure>\n\n\n\n

\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h2>\n\n\n\n
import cx_Oracle as db\nimport tkinter as tk\nimport tkinter.ttk as ttk\n\nLOGIN_USER = \"\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u3053\u3053\u306b\u5165\u529b\"\nLOGIN_PASSWORD = \"\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u3053\u3053\u306b\u5165\u529b\"\nLOGIN_HOST = \"localhost:1521\/xepdb1\"\n\nclass Application(tk.Tk):\n    def __init__(self):\n        super().__init__()\n        self.title(\"Table viewer sample for ORACLE XE 18c\")\n\n        self.conn = db.connect(LOGIN_USER, LOGIN_PASSWORD, LOGIN_HOST)\n        self.cur = self.conn.cursor()\n        \n        self.style = ttk.Style(self)\n        self.style.configure(\"Treeview\", rowheight=30)\n        \n        columns = (\"#1\", \"#2\")\n        self.table_list = ttk.Treeview(self, show=\"headings\", columns=columns, selectmode=\"browse\")\n        self.table_list.heading(\"#1\", text=\"TABLE_NAME\")\n        self.table_list.column(\"#1\", width=125)\n        self.table_list.heading(\"#2\", text=\"COMMENTS\")\n        self.table_list.column(\"#2\", width=300)\n        self.table_list.grid(row=0, column=0, rowspan=2, sticky=tk.NSEW)\n        self.scroll_bar = ttk.Scrollbar(self, command=self.table_list.yview)\n        self.table_list.configure(yscroll=self.scroll_bar.set)\n        self.scroll_bar.grid(row=0, column=1, rowspan=2, sticky=tk.NS)\n        self.table_list.bind(\"<<TreeviewSelect>>\", self.show_table)\n        \n        columns = (\"#1\",\"#2\",\"#3\")\n        self.table_info = ttk.Treeview(self, show=\"headings\", columns=columns)\n        self.table_info.heading(\"#1\", text=\"COLUMN_NAME\")\n        self.table_info.heading(\"#2\", text=\"COMMENTS\")\n        self.table_info.heading(\"#3\", text=\"DATA_TYPE\")\n        self.table_info.grid(row=0, column=2, sticky=tk.NSEW)\n        \n        self.load_button = ttk.Button(self, text=\"load table\", command=self.load_table)\n        self.load_button.grid(row=1, column=2)\n        \n        self.grid_rowconfigure(0, weight=1)\n\n    def load_table(self):\n        self.table_list.delete(*self.table_list.get_children())\n        self.table_info.delete(*self.table_info.get_children())\n        sql = (\"SELECT TABLE_NAME, COMMENTS\"\n               \"  FROM USER_TAB_COMMENTS\"\n               \" WHERE TABLE_TYPE = 'TABLE'\")\n        results = self.cur.execute(sql)\n        for row in results:\n            self.table_list.insert(\"\", tk.END, values=row)\n        self.table_list.selection_set(self.table_list.get_children()[0])\n    \n    def show_table(self, event):\n        sel = self.table_list.selection()\n        table_name = self.table_list.item(sel[0])[\"values\"][0]\n        sql = (\"SELECT T1.COLUMN_NAME, T1.COMMENTS,\"\n               \"  CASE WHEN T2.DATA_TYPE IN ('TIMESTAMP(6)','DATE') THEN T2.DATA_TYPE\"\n               \"       WHEN T2.DATA_TYPE IN ('CHAR','VARCHAR2') THEN T2.DATA_TYPE ||'('||T2.DATA_LENGTH||')'\"\n               \"       WHEN T2.DATA_TYPE = 'NUMBER' THEN T2.DATA_TYPE || \"\n               \"         CASE WHEN T2.DATA_PRECISION IS NULL AND T2.DATA_SCALE IS NULL THEN ''\"\n               \"              WHEN T2.DATA_PRECISION IS NOT NULL AND NVL(T2.DATA_SCALE,0) = 0 THEN '('||T2.DATA_PRECISION||')'\"\n               \"              WHEN T2.DATA_PRECISION IS NOT NULL AND T2.DATA_SCALE IS NOT NULL THEN '('||T2.DATA_PRECISION||'.'||T2.DATA_SCALE||')'\"\n               \"              WHEN T2.DATA_PRECISION IS NULL THEN '(.'||T2.DATA_SCALE||')'\"\n               \"              END\"\n               \"       END\"\n               \"  FROM USER_COL_COMMENTS T1, USER_TAB_COLUMNS T2\"\n               \" WHERE T1.TABLE_NAME = T2.TABLE_NAME\"\n               \"   AND T1.COLUMN_NAME = T2.COLUMN_NAME\"\n               \"   AND T1.TABLE_NAME = :table_name\")\n        results = self.cur.execute(sql, table_name=table_name)\n        self.table_info.delete(*self.table_info.get_children())\n        for row in results:\n            self.table_info.insert(\"\", tk.END, values=row)\n        \nif __name__ == \"__main__\":\n    application = Application()\n    application.mainloop()\n<\/pre>\n\n\n\n
\u89e3\u8aac<\/h2>\n\n\n\n
\u3000Oracle\u3078\u306e\u63a5\u7d9a\u306b\u306f\u304a\u306a\u3058\u307f\u306ecx_Oracle\u3092\u5229\u7528\u3057\u307e\u3057\u305f\u3002cx_Oracle\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3061\u3089<\/a>\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n
\u3000\uff15\uff5e7\u884c\u76ee\u306e\u63a5\u7d9a\u60c5\u5831\u306f\u3054\u81ea\u5206\u306e\u74b0\u5883\u306b\u3042\u308f\u305b\u3066\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002Oracle18c Express Edition\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u307c\u304f\u306e\u74b0\u5883\u3067\u306f\u3001\u3053\u306eLOGIN_HOST\u3067\u63a5\u7d9a\u3067\u304d\u307e\u3057\u305f\u3002\u3082\u3057\u304b\u3057\u305f\u3089localhost\u3092\u30ed\u30fc\u30ab\u30ebPC\u306eIP\u30a2\u30c9\u30ec\u30b9\u306b\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u304b\u3082\u77e5\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n
\u300014\u300115\u884c\u76ee\u306e\u521d\u671f\u5316\u51e6\u7406\u3067\u3001Oracle\u3078\u306e\u63a5\u7d9a\u3068\u30ab\u30fc\u30bd\u30eb\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u300221\u884c\u76ee\u3067Treeview\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002show\u30aa\u30d7\u30b7\u30e7\u30f3\u306f”tree”\u3068”heading”\u304c\u6307\u5b9a\u3067\u304d\u307e\u3059\u304c\u3001\u7d44\u307f\u5408\u308f\u305b\u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5909\u308f\u3063\u3066\u304d\u307e\u3059\u3002<\/p>\n\n\n\n