test_db.py

# PC上数据库的位置为：/mnt/f/微云同步目录/1913864316/dev/projects/api-mapper

from db import Db
from dotenv import load_dotenv
import os

# 加载.env文件
load_dotenv()

db = Db(os.getenv("DB_PATH"))

results = db.execute_query("""
SELECT an.api_name, ak.api_key
FROM api_keys ak
JOIN api_groups ag ON ak.api_group_id = ag.id
JOIN api_names an ON an.api_group_id = ag.id
WHERE an.api_name = 'glm-4-flash';
""")


for row in results:
    print(row)