问Sqlite3删除和重新索引项

EN

conn = sqlite3.connect("AccStorage.db")
c = conn.cursor()
c.execute("""CREATE TABLE  if not exists acc_storage (
acc_id INTEGER PRIMARY KEY AUTOINCREMENT,
acc_platform text, 
username text, 
user_mail text, 
user_password text, 
acc_creation_date text, 
acc_recovery_codes text, 
acc_phone_number text, 
acc_recovery_mail text
)""")

c.execute("""INSERT INTO acc_storage (acc_platform, 
username, 
user_mail, 
user_password, 
acc_creation_date, 
acc_recovery_codes, 
acc_phone_number, 
acc_recovery_mail) VALUES ('Reddit', 'Fare', 'Tasarruflu@xyz.com', 'abcdefg', '5.5.5', 'xxxxaaaa', '9305010', 'recovery@gmail.com')""")
conn.commit()
conn.close()

        def DeleteFromDatabase(self):
        Value_No = 65536
        Value_Yes = 16384
        isconfirm = self.ask_for_delete()
        if isconfirm == Value_Yes:
            account_id = int(self.exm_acc_ui.aditaccLabel.text().split(": ")[-1])
            conn6 = sqlite3.connect("AccStorage.db")
            c6 = conn6.cursor()
            c6.execute(f"""DELETE FROM acc_storage WHERE acc_id = {account_id-1}""")
            conn6.commit()
            conn6.close()
            self.editaccWindow.close()
            self.examineAccWindow.close()
            self.acc_info_read()
        elif isconfirm == Value_No:
            pass