| Server IP : 3.147.158.171 / Your IP : 216.73.216.216 Web Server : Apache/2.4.67 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-2-178.us-east-2.compute.internal 6.1.172-216.329.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Wed May 20 06:31:34 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.21 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /tsai/repo/api/app/services/ |
Upload File : |
import sqlite3
from pathlib import Path
from typing import List, Optional
from ..appTypes import IndexedSite
DB_PATH = Path(__file__).resolve().parent.parent.parent / 'data' / 'site_index.db'
class SiteIndexService:
def get_all(self) -> List[IndexedSite]:
if not DB_PATH.exists():
return []
conn = sqlite3.connect(str(DB_PATH))
conn.row_factory = sqlite3.Row
rows = conn.execute('SELECT * FROM site_index ORDER BY name').fetchall()
conn.close()
return [IndexedSite(**dict(row)) for row in rows]
def get_by_slug(self, slug: str) -> Optional[IndexedSite]:
if not DB_PATH.exists():
return None
conn = sqlite3.connect(str(DB_PATH))
conn.row_factory = sqlite3.Row
row = conn.execute('SELECT * FROM site_index WHERE slug = ?', (slug,)).fetchone()
conn.close()
if row:
return IndexedSite(**dict(row))
return None