Код IT
← Каталог

pyTelegramBot — боты в Telegram — SQLite

Фрагмент из «pyTelegramBot — боты в Telegram»: SQLite.

python pythonencyclopedia3434 embed URL статья в энциклопедии
Python main.py 
import sqlite3

conn = sqlite3.connect("bot.db")
conn.execute(
    "CREATE TABLE IF NOT EXISTS users (tg_id INTEGER PRIMARY KEY, name TEXT, score INTEGER DEFAULT 0)"
)

def upsert_user(tg_id: int, name: str) -> None:
    conn.execute(
        "INSERT INTO users (tg_id, name) VALUES (?, ?) "
        "ON CONFLICT(tg_id) DO UPDATE SET name = excluded.name",
        (tg_id, name),
    )
    conn.commit()
import sqlite3

conn = sqlite3.connect("bot.db")
conn.execute(
    "CREATE TABLE IF NOT EXISTS users (tg_id INTEGER PRIMARY KEY, name TEXT, score INTEGER DEFAULT 0)"
)

def upsert_user(tg_id: int, name: str) -> None:
    conn.execute(
        "INSERT INTO users (tg_id, name) VALUES (?, ?) "
        "ON CONFLICT(tg_id) DO UPDATE SET name = excluded.name",
        (tg_id, name),
    )
    conn.commit()