test_db.py 577 B

1234567891011121314151617181920212223242526
  1. import sqlite3
  2. import os
  3. db_path = 'd:/workspace/AuraK/server/database.sqlite'
  4. if not os.path.exists(db_path):
  5. print("DB not found")
  6. exit(1)
  7. conn = sqlite3.connect(db_path)
  8. c = conn.cursor()
  9. print("--- knowledge_group ---")
  10. try:
  11. for row in c.execute('SELECT id, name, tenantId from knowledge_group'):
  12. print(row)
  13. except Exception as e:
  14. print(e)
  15. print("\n--- import_task ---")
  16. try:
  17. for row in c.execute('SELECT id, targetGroupId, targetGroupName, status from import_task'):
  18. print(row)
  19. except Exception as e:
  20. print(e)
  21. conn.close()