python判断sqlite数据库是否存在_如何判断一个值是否存在于sqlite3数据库中，python...

您只需在插入之前进行查询，然后执行^{}。如果fetchone返回了某些内容，那么您肯定知道数据库中已经有一个记录具有email或{}：def signup():

email = request.form['email']

username = request.form['user']

password = request.form['password']

# Create cursor object

cur = g.db.cursor()

# run a select query against the table to see if any record exists

# that has the email or username

cur.execute("""SELECT email

,username

FROM users

WHERE email=?

OR username=?""",

(email, username))

# Fetch one result from the query because it

# doesn't matter how many records are returned.

# If it returns just one result, then you know

# that a record already exists in the table.

# If no results are pulled from the query, then

# fetchone will return None.

result = cur.fetchone()

if result:

# Record already exists

# Do something that tells the user that email/user handle already exists

else:

cur.execute("INSERT INTO users VALUES (?, ?, ?)", (email, username, password))

g.db.commit()