python - 问题打印添加到数据库的记录数

Question

如何打印数据库中添加的记录总数？在我的情况下，它是国家 1 和国家 2 的记录。每个国家有 20 条记录，所以总共有 40 条记录，但我只看到我的代码 cursor.rowcount 添加了 20 条记录（数据库中正确输入了 40 条记录）

我试试这个，但不行，它只是告诉我两个国家之一的记录数，而不是你俩的总数（我想要国家 1 + 国家 2）：

records_added_Nations = 0
print ("Record inserted successfully", cursor.rowcount)
records_added_Nations = records_added_Nations + 1
cursor.close ()

添加记录的代码是这样的：

#NATION 1   
sqlite_insert_query_Nation1 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
count_Nation1 = cursor.executemany(sqlite_insert_query_Nation1, Values_Nation1)
con.commit()

#NATION 2   
sqlite_insert_query_Nation2 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
count_Nation2 = cursor.executemany(sqlite_insert_query_Nation2, Values_Nation2)
con.commit()

标签： pythonsqlpython-3.xdatabasesqlite

Answer 1

每次操作后分配cursor.rowcount，并合计。

#NATION 1   
sqlite_insert_query_Nation1 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
cursor.executemany(sqlite_insert_query_Nation1, Values_Nation1)
count_Nation1 = cursor.rowcount
con.commit()

#NATION 2   
sqlite_insert_query_Nation2 = 'INSERT INTO Nation (Name_Nation) VALUES (?);'
cursor.executemany(sqlite_insert_query_Nation2, Values_Nation2)
count_Nation2 = cursor.rowcount
con.commit()

print ("Records inserted successfully", count_Nation1 + count_Nation2)