o Ni @sdZddlmZmZmZddlmZddlmZddl Z ddl m Z ddl m Z edd d Zejed gd d gd gd e ejdZGdddeZGdddeZGdddeZGdddeZddZejdededddeddddddfd ed!ed"e ed#e efd$d%Zejd&edd:d"e efd'd(Zejd)edd*efd+d,Zejd-eedd.d/Zejd0edd1d2Z e!d3krddl"Z"e#se$d4ee$d5e%de$d6ee"j&ed7d8d9dSdS);z FastAPI server for Italian vocabulary database. Provides paginated access to 100k+ vocabulary entries. Run with: uvicorn server:app --reload --port 5000 )FastAPIQuery HTTPException)CORSMiddleware) BaseModelN)Path)OptionalzItalian Vocabulary APIz1.0.0)titleversion*T) allow_originsallow_credentials allow_methods allow_headersz italian.dbc@s6eZdZUeed<eed<eed<eed<eed<dS) VocabItemiditalianenglishcategorynotesN)__name__ __module__ __qualname__int__annotations__strrr/var/www/html/it/server.pyrs  rc@s:eZdZUeeed<eed<eed<eed<eed<dS)PaginatedResponseitemspageper_pagetotal total_pagesN)rrrlistrrrrrrrr$s  rc@seZdZUeed<eed<dS) CategoryCountnamecountN)rrrrrrrrrrr%+s  r%c@s&eZdZUeed<eeefed<dS) StatsResponse total_entries categoriesN)rrrrrdictrrrrrr(/s r(cCstt}tj|_|S)zGet database connection.)sqlite3connectDB_PATHRow row_factory)connrrrget_db3s r2z /api/vocab)response_model)ge2)r5ler r!rsearchcCs|d|}|r |nd}t}|}d}d}d} d} |rJd|d} |r9|d |d | d | |||fn3|d |d | d | ||fn"|r]|d |d | d |||fn|d|d | d ||f|} dd| D} |rd|d} |r|d|d| |fn!|d|d| fn|r|d||fn|d||d}|| |||||d|dS)a  Get paginated vocabulary entries. - **page**: Page number (default: 1) - **per_page**: Items per page (default: 50, max: 200) - **category**: Filter by category (optional) - **search**: Search term (optional, searches italian and english) r4Nz1v.italian GLOB '[a-z]*' AND length(v.italian) > 1-italian GLOB '[a-z]*' AND length(italian) > 1z)ORDER BY (v.id * 2654435761) % 2147483647z'ORDER BY (id * 2654435761) % 2147483647"z"*z SELECT v.id, v.italian, v.english, v.category, v.notes FROM vocabulary v JOIN vocabulary_fts fts ON v.id = fts.rowid WHERE vocabulary_fts MATCH ? AND v.category = ? AND z z. LIMIT ? OFFSET ? z SELECT v.id, v.italian, v.english, v.category, v.notes FROM vocabulary v JOIN vocabulary_fts fts ON v.id = fts.rowid WHERE vocabulary_fts MATCH ? AND z SELECT id, italian, english, category, notes FROM vocabulary WHERE category = ? AND zt SELECT id, italian, english, category, notes FROM vocabulary WHERE cSsg|]}t|qSr)r+.0rowrrr ~szget_vocab..z SELECT COUNT(*) FROM vocabulary v JOIN vocabulary_fts fts ON v.id = fts.rowid WHERE vocabulary_fts MATCH ? AND v.category = ? AND z z SELECT COUNT(*) FROM vocabulary v JOIN vocabulary_fts fts ON v.id = fts.rowid WHERE vocabulary_fts MATCH ? AND z7SELECT COUNT(*) FROM vocabulary WHERE category = ? AND z&SELECT COUNT(*) FROM vocabulary WHERE r)rr r!r"r#)stripr2cursorexecutefetchallfetchoneclose)r r!rr9offsetr1cur base_filterbase_filter_no_alias order_clauseorder_clause_no_alias search_termrowsrr"rrr get_vocab9s       rNz/api/vocab/randomcCsht}|}d}|r|d|d|fn |d|d|}||r.t|Stddd)z?Get a random vocabulary entry, optionally filtered by category.r:zy SELECT id, italian, english, category, notes FROM vocabulary WHERE category = ? AND z; ORDER BY RANDOM() LIMIT 1 zh SELECT id, italian, english, category, notes FROM vocabulary WHERE zNo entries found status_codedetailr2rArBrDrEr+r)rr1rGrHr>rrr get_randoms"  rTz/api/vocab/{id}rcCsDt}|}|d|f|}||rt|Stddd)z&Get a specific vocabulary entry by ID.zISELECT id, italian, english, category, notes FROM vocabulary WHERE id = ?rOz Not foundrPrS)rr1rGr>rrrget_vocab_by_ids rUz/api/categoriescCs6t}|}|d|}|dd|DS)z#Get list of categories with counts.~ SELECT category, COUNT(*) as count FROM vocabulary GROUP BY category ORDER BY count DESC cSsg|] }|d|ddqS)rr')r&r'rr<rrrr?sz"get_categories..)r2rArBrCrE)r1rGrMrrrget_categoriess  rWz /api/statscCsRt}|}|d|d}|ddd|D}|||dS)zGet database statistics.zSELECT COUNT(*) FROM vocabularyrrVcSsi|] }|d|dqS)rr'rr<rrr szget_stats..)r)r*)r2rArBrDrCrE)r1rGr"r*rrr get_statss   rY__main__zDatabase not found at zRun: python build_vocab_db.pyzStarting server with database: z0.0.0.0i)hostport)N)'__doc__fastapirrrfastapi.middleware.corsrpydanticrr,pathlibrtypingrappadd_middleware__file__parentr.rrr%r(r2getrrrNrTrUr$rWrYruvicornexistsprintexitrunrrrrsh         f