python - 如何在 python 中创建一个包含 1 行的 sqlite3 数据库

Question

我想知道是否有办法在 python 中使用单行(记录)数据创建 sqlite3 数据库，并且当我再次执行代码时，它不会被创建两次。

到目前为止，我已经尝试过编码:

conn = sqlite3.connect('db_M.db')
c = conn.cursor()
no1 = "Null"
no2 = "Null"
no3 = "Null"
value = 1
try:
    c.execute("CREATE TABLE IF NOT EXISTS M_Memory(Name TEXT, Person TEXT, memory TEXT, value REAL)")
    if True:
        c.execute("INSERT INTO M_Memory(Name, Person, memory, value) VALUES (?, ?, ?, ?)",
                  (no1, no2, no3, value))
except:
    print(" foo ")
conn.commit()

Answer 1

我解决了我自己的问题..如果您有更好的代码请分享..谢谢大家

import sqlite3


conn = sqlite3.connect('db_M.db')
c = conn.cursor()

c.execute("CREATE TABLE IF NOT EXISTS M_Memory(Name TEXT, Person TEXT, memory TEXT, value REAL)")


text10 = input("what do you want to call the memory ?\n")

text11 = input("what or who the memory will be about?\n")

text12 = input("what do you want me to save in it ?\n")


def Get_The_Max_Function():
    Max_Value = []
    c.execute('SELECT MAX(value) FROM M_Memory')
    lolo = c.fetchone()
    if lolo[0] is None:
        lolo = 0
        Max_Value.insert(0, lolo)
    else:
        x = int((lolo[0]))
        Max_Value.insert(0, x)
    return Max_Value


def dynamic_data_entry(Max_Value):
    Name = text10
    Person = text11
    memory = text12
    value = Max_Value[0] + 1

    c.execute("INSERT INTO M_Memory(Name, Person, memory, value) VALUES (?, ?, ?, ?)",
              (Name, Person, memory, value))
    conn.commit()


dynamic_data_entry(Get_The_Max_Function())
c.close()
conn.close()