質問するログイン新規登録

回答編集履歴

3

処理修正

2020/02/13 11:17

投稿

shiracamus
shiracamus

スコア5406

answer CHANGED
@@ -17,12 +17,12 @@
17
17
 
18
18
  import main as gui
19
19
 
20
+ dbpath = "dex.sqlite3"
21
+ conn = sql.connect(dbpath)
22
+ cur = conn.cursor()
20
23
 
24
+
21
25
  def get_info():
22
- dbpath = "dex.sqlite3"
23
- conn = sql.connect(dbpath)
24
- cur = conn.cursor()
25
-
26
26
  name = gui.aname.get()
27
27
  cur.execute("SELECT A FROM dex WHERE name = '%s'" % name)
28
28
  A = cur.fetchone()

2

バグ修正

2020/02/13 11:17

投稿

shiracamus
shiracamus

スコア5406

answer CHANGED
@@ -23,7 +23,7 @@
23
23
  conn = sql.connect(dbpath)
24
24
  cur = conn.cursor()
25
25
 
26
- name = main.aname.get()
26
+ name = gui.aname.get()
27
27
  cur.execute("SELECT A FROM dex WHERE name = '%s'" % name)
28
28
  A = cur.fetchone()
29
29
  cur.execute("SELECT C FROM dex WHERE name = '%s'" % name)

1

printするだけの関数追記

2020/02/13 11:13

投稿

shiracamus
shiracamus

スコア5406

answer CHANGED
@@ -6,4 +6,42 @@
6
6
 
7
7
  AttackDatabase(様々な引数).get_info
8
8
 
9
- こうすればインスタンスメソッドで、selfが使えるようになります。
9
+ こうすればインスタンスメソッドで、selfが使えるようになります。
10
+
11
+ printするだけの関数にしてみました。
12
+
13
+ ```py
14
+ import tkinter as tk
15
+ import sqlite3 as sql
16
+ import tkinter.ttk as ttk
17
+
18
+ import main as gui
19
+
20
+
21
+ def get_info():
22
+ dbpath = "dex.sqlite3"
23
+ conn = sql.connect(dbpath)
24
+ cur = conn.cursor()
25
+
26
+ name = main.aname.get()
27
+ cur.execute("SELECT A FROM dex WHERE name = '%s'" % name)
28
+ A = cur.fetchone()
29
+ cur.execute("SELECT C FROM dex WHERE name = '%s'" % name)
30
+ C = cur.fetchone()
31
+ cur.execute("SELECT S FROM dex WHERE name = '%s'" % name)
32
+ S = cur.fetchone()
33
+
34
+ print(name)
35
+ print(A)
36
+ print(C)
37
+ print(S)
38
+
39
+
40
+ def main():
41
+ button = tk.Button(gui.win, text='print', command=get_info)
42
+ button.pack()
43
+ gui.win.mainloop()
44
+
45
+ if __name__ == "__main__":
46
+ main()
47
+ ```