python - 插入sqlite python不会更改表

Question

我正在为 SQLite 数据集创建简单的类，当我插入新行时，表不会改变。

数据库.py

import sqlite3

class DB:
    def __init__(self, **kwargs):
        self.db = sqlite3.connect('passwods.db')
        self.c = self.db.cursor()
        self.c.execute('CREATE TABLE IF NOT EXISTS passwords (name, value)')

    def insert(self, alias, cipher):
        column = (alias, cipher)
        self.c.execute('INSERT INTO passwords (name, value) VALUES (?,?)',  column)
        self.db.commit()

    def get(self, alias):
        pk = (alias,)
        self.c.execute('SELECT * FROM passwords WHERE name=?', pk) 

    def getAll(self):
        self.c.execute('SELECT * FROM passwords')

交互式外壳

>>> from DB import DB
>>> db = DB()
>>> db.insert('firstName', 'firstValue')
>>> print(db.getAll())
None
>>>

Answer 1

您的方法 getAll 没有返回语句。如果你添加它，你可以看到表格实际上发生了变化:

def getAll(self):
    self.c.execute("SELECT * FROM passwords")
    return self.c.fetchall()