Spaces:
Sleeping
Sleeping
| """ | |
| Run get/list operations and print results (no writes). | |
| Run from backend: python -m db.test_functions.query_data *** | |
| Requires DATABASE_URL in backend/.env. | |
| """ | |
| import db | |
| def run(): | |
| print("=== list_mangas (default: newest first) ===\n") | |
| mangas = db.list_mangas() | |
| for m in mangas: | |
| print(f" {m.manga_title}") | |
| print(f"\n Total: {len(mangas)} manga(s)\n") | |
| if not mangas: | |
| print("No data. Run: python -m db.test_functions.create_data") | |
| return | |
| first_manga = mangas[0] | |
| manga_title = first_manga.manga_title | |
| chapters = db.list_chapters(manga_title) | |
| if not chapters: | |
| print(f"No chapters for {manga_title}. Run create_data to add pages.") | |
| return | |
| chapter_number = chapters[0].chapter_number | |
| print(f"=== list_chapters({manga_title!r}) ===\n") | |
| for c in chapters[:5]: | |
| print(f" ch.{c.chapter_number} (id={c.id})") | |
| if len(chapters) > 5: | |
| print(f" ... and {len(chapters) - 5} more chapter(s)") | |
| print(f"\n Total: {len(chapters)} chapter(s)\n") | |
| print(f"=== get_chapter_panels({manga_title!r}, {chapter_number}) ===\n") | |
| panels = db.get_chapter_panels(manga_title, chapter_number) | |
| for i, s in enumerate(panels[:5]): # show first 5 | |
| print( | |
| f" [{i+1}] page {s.page_number} bubble {s.bubble_index}: " | |
| f"{s.original_text[:30]!r} → {s.translated_text[:30]!r} " | |
| f"(url={s.panel_url!r})" | |
| ) | |
| if len(panels) > 5: | |
| print(f" ... and {len(panels) - 5} more panel(s)") | |
| print(f"\n Total: {len(panels)} panel(s) in chapter\n") | |
| if panels and panels[0].panel_url: | |
| url = panels[0].panel_url | |
| print(f"=== get_panel_by_panel_url({url!r}) ===\n") | |
| p = db.get_panel_by_panel_url(url) | |
| if p: | |
| print( | |
| f" found: {p.manga_title} ch.{p.chapter_number} " | |
| f"page={p.page_number} bubble={p.bubble_index} url={p.panel_url!r}" | |
| ) | |
| else: | |
| print(" not found") | |
| print() | |
| print(f"=== get_panels (manga_title={manga_title!r}, chapter_number={chapter_number}, page_number=1) ===\n") | |
| page_panels = db.get_panels( | |
| manga_title=manga_title, | |
| chapter_number=chapter_number, | |
| page_number=1, | |
| ) | |
| for s in page_panels: | |
| print(f" bubble {s.bubble_index}: {s.translated_text!r}") | |
| print(f"\n Total: {len(page_panels)} panel(s) on page 1\n") | |
| print("=== get_panels (no filters: all panels) ===\n") | |
| all_panels = db.get_panels() | |
| for s in all_panels: | |
| print( | |
| f" {s.manga_title} ch.{s.chapter_number} | {s.page_number} | " | |
| f"{s.bubble_index}: {s.translated_text!r} (url={s.panel_url!r})" | |
| ) | |
| print(f"\n Total: {len(all_panels)} panel(s)\n") | |
| if __name__ == "__main__": | |
| run() | |