mes 数据库 python sqlite

import sqlite3
from sqlite3 import Error

def create_connection():
    conn = None;
    try:
        conn = sqlite3.connect(':memory:') # 创建一个内存数据库。对于文件数据库，您可以使用文件路径。
        print(f'successful connection with sqlite version {sqlite3.version}')
    except Error as e:
        print(e)
    finally:
        if conn:
            conn.close()

create_connection()

def create_table(conn):
    try:
        sql = '''CREATE TABLE employees (
                    id integer PRIMARY KEY,
                    name text NOT NULL,
                    salary real
                );'''
        cur = conn.cursor()
        cur.execute(sql)
    except Error as e:
        print(e)

conn = sqlite3.connect(':memory:') # 创建一个内存数据库。对于文件数据库，您可以使用文件路径。
create_table(conn)

def insert_employee(conn, employee):
    sql = '''INSERT INTO employees(name,salary)
             VALUES(?,?)'''
    cur = conn.cursor()
    cur.execute(sql, employee)

def select_all_employees(conn):
    cur = conn.cursor()
    cur.execute("SELECT * FROM employees")

    rows = cur.fetchall()

    for row in rows:
        print(row)

conn = sqlite3.connect(':memory:') # 创建一个内存数据库。对于文件数据库，您可以使用文件路径。
create_table(conn)
insert_employee(conn, ('Tom', 60000))
insert_employee(conn, ('Jerry', 70000))
select_all_employees(conn)

def close_connection(conn):
    conn.close()

# 在完成所有操作后关闭数据库连接
close_connection(conn)

conn = sqlite3.connect('/path/to/your/database.db')

def get_all_tables(conn):
    cur = conn.cursor()
    cur.execute("SELECT name FROM sqlite_master WHERE type='table';")
    tables = cur.fetchall()
    for table in tables:
        print(table)

get_all_tables(conn)