buff1.0/buff/sendMail-api/test.py

import sqlite3
# Step 5: Save to SQLite database
conn = sqlite3.connect('settings.db')
cursor = conn.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS sms_codes (edit_content TEXT, send_content_short TEXT)''')
# 判断sms_codes表中的数据量是否大于3
cursor.execute('''SELECT COUNT(*) FROM sms_codes''')
#获取执行结果
count = cursor.fetchone()[0]
print(count)
conn.close()