blob: 0419f26c1bc7663df2481e46f912816be8d2ae10 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
#!/usr/bin/env python3
from __future__ import annotations
import sqlite3
from pathlib import Path
DB_PATH = Path("storage/cmdhelp.db")
def main() -> None:
conn = sqlite3.connect(DB_PATH)
try:
card_count = conn.execute("SELECT COUNT(*) FROM cards").fetchone()[0]
emb_count = conn.execute("SELECT COUNT(*) FROM card_embeddings").fetchone()[0]
print(f"cards: {card_count}")
print(f"embeddings: {emb_count}")
print()
rows = conn.execute("""
SELECT id, command, safety
FROM cards
ORDER BY id
LIMIT 10
""").fetchall()
for row in rows:
print(row)
finally:
conn.close()
if __name__ == "__main__":
main()
|
