从所有以特定字符串结尾的表中获取数据

import sqlite3

def get_data_from_tables_ending_with(db_path, suffix):
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 获取所有以特定后缀结尾的表名
    cursor.execute(f"SELECT name FROM sqlite_master WHERE type='table' AND name LIKE '%{suffix}';")
    tables = cursor.fetchall()
    
    all_data = []
    for table in tables:
        table_name = table[0]
        cursor.execute(f"SELECT * FROM {table_name};")
        data = cursor.fetchall()
        all_data.extend(data)
    
    conn.close()
    return all_data

# 使用示例
db_path = 'example.db'
suffix = '_log'
data = get_data_from_tables_ending_with(db_path, suffix)
for row in data:
    print(row)

import sqlite3

def get_data_from_tables_ending_with(db_path, suffix):
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 使用参数化查询来避免SQL注入
    cursor.execute("SELECT name FROM sqlite_master WHERE type='table' AND name LIKE ?;", (f'%{suffix}',))
    tables = cursor.fetchall()
    
    all_data = []
    for table in tables:
        table_name = table[0]
        cursor.execute(f"SELECT * FROM {table_name};")
        data = cursor.fetchall()
        all_data.extend(data)
    
    conn.close()
    return all_data

# 使用示例
db_path = 'example.db'
suffix = '_log'
data = get_data_from_tables_ending_with(db_path, suffix)
for row in data:
    print(row)