VSCode常用指令:

Ctrl-k-t 換色系

目標1: 單字app

1- create.py

ver1.

import sqlite3

con = sqlite3.connect("memory.db")
cur = con.cursor()

# 新建資料表
cur.execute("CREATE TABLE memory(id, word, meaning, example)")
con.commit()
con.close()

2-insert-many

ver1:

import sqlite3

con = sqlite3.connect("memory.db")
cur = con.cursor()

data = [
    (1,"money", "錢", "make a lot of money"),
    (2,"dog", "狗", "I like dogs."),
    (3,"apple", "蘋果", "I eat apples."),
]
cur.executemany("INSERT INTO memory VALUES(?, ?, ?, ?)", data)
con.commit() # Remember to commit the transaction after executing INSERT.
con.close()

3-select a particular word

import sqlite3

con = sqlite3.connect("memory.db")
cur = con.cursor()

ret = cur.execute("SELECT * FROM memory WHERE word='money'")
#ret = cur.execute("SELECT title, year FROM movie WHERE year=1971")

#print(ret.fetchall())
ret = ret.fetchone()
if ret is None:
    print("is None")
else:
    print(ret)
print(str(ret))
con.close()