id\UdZddlZddlZddlZddlZddlZddlZddlZddlZddl m Z m Z ddl m Z m Z ddlmZddlmZddlmZddlZddlZddlmZdd lmZmZmZmZdd lmZmZm Z dd l!m"Z" ddl#Z#e#jHd Z%eee'jPjPd z Z)eejTddZ+eejTde,ee'jPjPdz Z-ejTddj]Z/ejTddj]jaZ1ddddZ2ejTddj]jaZ3ejTddj]Z4ejTddj]xsdZ5ejTddj]xsdZ6e7ejTddZ8ejTd d!j]jad"vZ9ejTd#dj]jud$Z;ejTd%dj]Z<ejTd&dj]Z=ejTd'dj]Z>ejTd(d)jd*Dchc]0}|j]r|j]ja2c}Z@ejTd+d,j]xsd,ZAejTd-d.j]jaxsd.ZBejTd/dj]jud$ZCe7ejTd0d1ZDe1d2vre1ZEn#ejTd3d4k(re;re=rd5ZEne/rd6ZEnd7ZEeEd6k(rd8nd9ZFe3se;reZHed?@ZIiZJeKe,eLeMe,ffeNdA<e;reje;dBndZPGdCdDeKZQdEZRdFe,dGe,fdHZSGdIdJZTdKZUddLeVdGeKe,e,ffdMZWddNe,dOeeKe,e,fdGeXeKfdPZYddQe7dNe,dGeeKfdRZZdQe7dSeKdGeeKfdTZ[dUeXe7dSeKdGeXeKfdVZ\dWZ]e]dGe,fdXZ^dYe,dGe,fdZZ_dGe,fd[Z`d\e,dGeVfd]Zad^edGeVfd_Zbd^edGe,fd`ZcdGe,fdaZdd\e,dGeKfdbZed\e,dGeKfdcZfd\e,dGeKfddZgd^edGeKfdeZhdfe,dGeVfdgZidGeKfdhZjdie,dGe,fdjZkdie,dGe,fdkZldie,dGe,fdlZmdie,dGe,fdmZndGe,fdnZodGe,fdoZpdGe,fdpZqdGe,fdqZrdre,dQe7dGe,fdsZsdte,dGeKfduZtdve,dGe,fdwZudGe,fdxZvdyeKdGeKfdzZwd{eKdGeKfd|Zxd{eKdGeKfd}Zyd{eKdGeLfd~ZzdeXeKdGeKfdZ{deXeKde,dGe,fdZ|dGe7fdZ}dd{eKdeVdGeKfdZ~ddeXeKdeVde7dGeKfdZdeXeKdGeKe,eXeKffdZddeXeKdeVde7dGeXeKfdZdeXeKde,de,dGeXeKfdZdee,dvee,dee,deeVdGeLe,eXff dZdeXeKdee,dvee,dee,deeVdGeXeKf dZde,dGe,fdZdee,dvee,dee,deeVdGeKe,e,ff dZdeXeKde,de,dGeXeKfdZdeXeKdte,dGeXeKfdZdeXeKdGeKfdZhdZdZeIjdd^efdZGdde"ZeIjddefdZeIjddZeIj%dd^efdZGdde"ZeIjdded^efdZeIj%ddZeIj%dedededededededdedddfdee,dvee,dee,deeVde,de,de7de7fdZeIj%ddQe7fdZeIj%dedededededededdedddfdee,dvee,dee,deeVde,de,de7de7fdZeIj%ddte,fdZGdde"ZeIj9ddte,defdZeIj%d«dÄZdQe7de,dGeKfdńZeIjdƫdQe7fdDŽZeIjdȫdQe7fdɄZGdʄde"ZeIj9d̫dQe7defd̈́ZeIj%dΫdτZeIj%dЫdфZeIj%dҫdve,de,fdԄZeIj%dիde,fdׄZGd؄de"ZeIjdګdefdۄZGd܄de"ZeIjdޫdefd߄ZGdde"ZeIjddefdZeIj%d$edZdZdZy#e&$rdZ%Y wxYwcc}w)zT Book Catalog - book-centered gallery with grouped photos and inline title editing. N)Counter defaultdict)datetimetimezone)Path)Optional)quote) load_dotenv)FastAPI HTTPExceptionQueryRequest) FileResponse HTMLResponse JSONResponse) BaseModelpsycopgzbooks.db IMAGES_PATHz0C:\Users\ignac\OneDrive\Pictures\selected_librosOPTIMIZED_IMAGES_PATHoptimized_images DATABASE_URLDATABASE_ADAPTERfrontrootside AUTH_MODE APP_PASSWORDAPP_SECRET_KEYzchange-me-in-productionSESSION_COOKIE_NAMEbibliothek_sessionSESSION_TTL_SECONDS2592000 COOKIE_SECUREfalse>1onyestrue SUPABASE_URL/SUPABASE_ANON_KEYSUPABASE_SERVICE_ROLE_KEYSUPABASE_AUTH_REDIRECT_URL OWNER_EMAILSzignaciolagosruiz@gmail.com, IMAGE_BUCKETzcatalog-imagesIMAGE_ACCESS_MODElocalREMOTE_IMAGE_BASE_URLSIGNED_URL_TTL_SECONDS604800>restsqlitepostgresVERCELr)r:r<r;ILIKELIKEsupabasepasswordnone)titlesubtitleauthor translator publisheryeareditionlanguageseriesvolume conditionspecial_features other_text raw_ocr_text>flaggedpendingverified correctedzBook Catalog Gallery)rCSIGNED_URL_CACHEz/auth/v1/.well-known/jwks.jsonc(eZdZfdZfdZxZS) HybridRowcXt|t||t||_yN)super__init__ziptuple_values)selfcolumnsvalues __class__s '/home/ubuntu/bibliothek-app/app/main.pyr[zHybridRow.__init__ks" Wf-.V} c`t|tr|j|St||SrY) isinstanceintr^rZ __getitem__)r_keyrbs rcrhzHybridRow.__getitem__os, c3 <<$ $w"3''rd)__name__ __module__ __qualname__r[rh __classcell__)rbs@rcrWrWjs%((rdrWcd|jDcgc]}|jc}fd}|Scc}w)Nct|SrY)rW)rar`s rcmake_rowz pg_row_factory..make_rowxs&))rd) descriptionname)cursorcolumnrpr`s @rcpg_row_factoryruus.)/););|(LZhiDIG 5DI$+KKDII !rdqueryrwcH|jdk(r|jddS|S)Nr<?z%s)rrz)r_rs rc_convert_queryzCompatConnection._convert_querys$ <<: %==d+ + rdc|jj}|j|j||xsd|S)N)rrsexecuter)r_rparamsrss rcrzCompatConnection.executes6!!#t**516+*G 3 Nrdselect extra_paramsc|ddd}|r|j|tjtdt |d}|j |j S)Nzid.asc1000)rorderlimit/rest/v1/book_imagesN@rrtimeout)updatehttpxgetr-rraise_for_statusjson)rrrresponses rcrest_fetch_rowsrsaF  l#yy .,- H   ==?rdimage_idctjtdt|d|ddd}|j |j }|r|dSdS)Nreq.r))ridr>@rr)rrr-rrr)rrrpayloads rcrest_fetch_rowrsdyy .,-z"  H mmoG 71:*d*rdractjtdtddd|i|d}|j |j }|r|dSdS) NrTrrrrrrrrr)rpatchr-rrr)rrarrs rcrest_update_rowrsb{{ .,-48H:&'  H mmoG 71:*d*rd image_idsc|sgSdjd|D}tjtdt ddd|di|d }|j |j S) Nr3c32K|]}t|ywrY)r).0rs rc z#rest_update_rows..s;X3x=;srTrrzin.()rr)joinrrr-rrr)rraidsrs rcrest_update_rowsrso  ((;; ;C{{ .,-48SEm$  H  ==?rdcLtdk7rytjtt}|j dj Dchc]}|d }}d|vr|j dd|vr|j dd|vr|j d d |vr|j d d |vr|j d d|vr|j dd|vr|j d|j d|j|jycc}w)Nr;zPRAGMA table_info(book_images)rrqz>ALTER TABLE book_images ADD COLUMN description TEXT DEFAULT "" review_statuszGALTER TABLE book_images ADD COLUMN review_status TEXT DEFAULT 'pending'review_updated_atzDALTER TABLE book_images ADD COLUMN review_updated_at TEXT DEFAULT "" image_urlz.s(STAR#d)//+Ss??)rflistrrrvalues rc clean_textrs; }% SSS u:   rdrctjtjd|jdtj j S)Nutf-8)hmacnewr"encodehashlibsha256 hexdigest)rs rcsession_signaturers6 88N))'2GNN74KW^^ \ f f hhrdctttjtz}d|}|dt|S)Nzshared::)rgtimer%r) expires_atrs rccreate_session_tokenr"s<TYY[!$77J |$GYa)'23 44rdtokenc |jdd\}}|jdd\}}t|}t |}t j ||sy|ttjk\S#t$rYywxYw)NrrF)rsplitsplitrg ValueErrorrrcompare_digestr)rr signature_expires_at_textrexpecteds rcis_valid_session_tokenr(s"\\#q1$]]32?) !)H   y( 3 TYY[) )) s5A99 BBrequestctdk7stsyt|jj t }t |xr t|S)NrAT)r r!rcookiesrr#boolr)rrs rcrequest_is_authenticatedr6s>Jl w**+>? @E ; 81%88rdct|jjd}|jj dr|ddj Sy)Nrzbearer r)rrrlowerryr)r auth_headers rcextract_bearer_tokenr=sJW__00ABK%%i012$$&& rdc$tr tdSdS)Nz/auth/v1r)r-rrdrcsupabase_issuerrDs(4l^8 $<"C  C C0C++C0folderc.ddddj|dS)Nz Front coverzTitle page / inside pageSpinerz Book photorrs rc photo_labelrs#*  c&,  rdct|tr|jS|yt|trg}|D]}t|tr|j}nUt t |dd}|s=t|t r-t |jdxs|jd}|s||j|dj|jSt |S)NrrWcontent ) rfrrrrr*dictrappendr)rpartschunkrWs rcextract_message_textr s'3}}'4  #E%%{{}!'%"<= 5$ 7%eii&7&O599Y;OPD T" #yy%%'' g rdrct|jd}t|jd}t|jd}t|jdxs|}|xs t|}|xst|xs|}|s(d|jddd|jd d}|s|}||d <||d<|S) Nrrrr/photos/ source_folderrr.source_filename display_url)rrrR)rrrrrr preview_urls rcattach_image_urlsrs488K01I488K01Idhh~67L#DHH-A$BCS|?1,?KT12DETK  /2!> ?qJ[]_A`@ab ! %D#D KrdrcJt|}t|jd}t||d<t |jd|d<t|jd|d<t t |jd|d|d<t||S)NrrrrrCrrs)rrrrr[rrrhr)rrrs rcserialize_review_imager2s 9D 1 2F%f-D3DHH_4MND *4884G+H ID ('9J)KTRVZXDd Krdc pt|}|dt|jdxsd|dt|jdt|jd|jdd|jdd|jd d|jd d|d |d |d d S)NrrCzImage #rErJrrrrrrrr) rrCrErJrrrrrrr)rrXr)rrs rcreview_queue_itemr=s !# &D4jDHHW-.HGDJ<2HTXXh/0txx 34/2688$5r:xx r2XXk2.M*o.!"56  rdchtjt|jdd|dfS)Nr rFOLDER_PRIORITYrrrs rcphoto_sort_keyrNs,    377?+C Da H#d) TTrdrowsc*t|tdS)Nrir)sortedr)rs rcpick_cover_imagerRs $N +A ..rdfieldc|Dcgc]}t|j|}}|Dcgc]}|s| }}|syt|jdddScc}wcc}w)Nrrr)rXrr most_common)rrrrars rcmost_common_valuerVsd48 9Sj( 9F 9!' 15e 1F 1  6? & &q )! ,Q // : 1s!AA"A"c~t|}tjd|}|rt|j dSy)Nz(1[6-9]\d{2}|20\d{2}|2100)ri')rrfsearchrggroup)rrWmatchs rcyear_sort_valuer^s6 e D II3T :E 5;;q>"" rd with_urlsc |d|d|d|jdd|jdd|jdd|jddt|dd }|r t|S|S) Nrrrrrrrr)rrrrrrrr)rrr)rrrs rc image_briefrfs|$i_-01WW["-WW["-3!gg&:B?"3#78 D'0 T "9T9rd sample_limitc 2t|t}t|}t|dj d}t |d}|xsd|d}t d|D}td|D} t|D chc]7} t| j dst| j d9c} d } id t||dd|d |d t |d d t |d dt |ddt |ddt|d|d| d| d| d| ddd| d| dzd| d| dzd| dt||d|d|D cgc]} t| |c} dtd|DScc} wcc} w) NrrrCz Untitled #rc3VK|]!}t|jdsd#ywrqrNrrrrs rcrz"summarize_group..zs Zz#''-BX7Y!Z))c3PK|]}t|jd ywrNr[rrs rcrz"summarize_group..{s fRU3CGGO4LMf$&rc.tj|dS)Nr)rrrs rcz!summarize_group..~s?..vq9rdrseditable_titlerErGrHrJ image_countdescribed_count review_countsrRrSrQrT)rRrSrQrTneeds_review_countdone_review_countfolders cover_image)r sample_images min_image_idc3&K|] }|d ywrNrrs rcrz"summarize_group..s>#CI>) rrrrhrrsumrrrrrzrmin) rrr ordered_rowscoverrir display_titlerrrrs rcsummarize_grouprts#$N3L \ *E&|A':':7'CD&|W=N"@ 5;-&@MZ|ZZOfYeffM9En#TWT[T[\kTlImCGGO, -n 9G  %&6d D   .  #L(;   &|[A   !,7   %lJ?  s<(  ?  $Y/%j1$Y/&{3    mI6y9QQ! " ]:6{9SS# $ 7% & {5I>' ( >>+  o0hs?FF$Fctt}|D]H}t|}tt |j d|d}||j |J|S)NrCr)rrrrrrhrr)rgroupedrrris rc group_rowsrs[$G"Cytxx/@A4:N D!" Nrdcrt|jDcgc]}t|||c}Scc}w)Nrr)rrar)rrrrs rc build_groupsrs/`jko`p`w`w`y zW\OEY\ R zz zs4groupssortrc|dk(}dtfd|dk(rfd}n$|dk(rfd}n|dk(rfd }n|d k(rfd }nd }t||| S)Ndescrwc<t|jxsdS)Nz~~~~)rXrrs rctext_keyzsort_groups..text_keys% &&(2F2rdrCc$|d|dfS)NrCrrrrs rcrzsort_groups..s(5>":E..s'(5?";XeGn=UW\]kWl!mrdrHc>t|d|d|dfS)NrHrCr)rrs rcrzsort_groups..s(/%-"@(5QX>BZ\abp\q!rrdrc,|d|d|dfS)NrrCrrrs rcrzsort_groups..s#% "6w8PRWXfRg!hrdc |dS)Nrr)rs rcrzsort_groups..s ~!6rdrireverserr)rrrrkey_funcrs @rc sort_groupsrs`voG333 wR  m r  h6 &h 88rdrrJ has_titlec g}g}|rI|jdtdtdtdtd d|d}|j||||g|r"|jd|j||r.|jdtd |jd|d|d ur|jd n|d ur|jd |rddj|znd}||fS)Nz(title z ? OR author z ? OR publisher z ? OR raw_ocr_text z ?)%zsource_folder = ?z language z ?Tz"title != 'Unknown' AND title != ''Fz!(title = 'Unknown' OR title = '')z WHERE z AND r)rSEARCH_OPERATORextendr)rrrJr conditionsrtermwheres rc build_filtersrs J F o&mO3DDTUdTeexzIyJJM N 6(!} tT4./ -. fIo%6b9: (1o&D>? e =>4>I Z0 0BE &=rdc g}t|j}|D]4}|rt|jd|k7r$|r9|jt|jdjvr_tt |jd}|dur|s|dur|r|rdj t|jdt|jdt|jdt|jd gj} || vr|j t|7|S) NrrJrCTFrdrErGrP)rrrrrXrrr) rrrrJrfilteredneedler title_knownhaystacks rcfilter_rows_pythonrs-H   % % 'F# j!9:fD  ( 377:;N0O0U0U0WW :cggg&678  [   +  xxswww/0swwx01sww{34sww~67 eg X%S "+#, Ordrct|}|jddjddjddjddS)Nrrr3rd(r)rrzrVs rcpostgrest_escape_likersE e D <<R ( (c 2 : :3 D L LSRU VVrdc |i}g}|r)t|}|jd|d|d|d|d |r|jd||r|jdt|d|d ur#|jd |jd n|d ur|jd |rddj|d|d<|S)Nzor(title.ilike.*z*,author.ilike.*z*,publisher.ilike.*z*,raw_ocr_text.ilike.*z*)zsource_folder.eq.zlanguage.ilike.**Tztitle.not.eq.Unknownz title.not.eq.Fzor(title.eq.Unknown,title.eq.)rr3rand)rrr)rrrJrrclausesrs rcrest_filter_paramsrs  FG &v.vh&6vh>QRXQYYopvowwy z *6(34)*?*I)J!LMD-.' e 78CHHW-.a0u Mrdc|dk(}dtfd|dk(rfd}n-|dk(rfd}n"|dk(rfd }n|d k(rd }n|d k(rfd }nd}t|||S)Nrrwc4t|jSrYrUrs rcrz$sort_images_python..text_key!s% &&((rdrCcV|jd|jddfS)NrCrrrrrs rcrz$sort_images_python..%s%)9 :CGGD!.'s:): ;XcgggFV=WY\Y`Y`aeghYijrdrHct|jd|jd|jddfS)NrHrCrr)rrrs rcrz$sort_images_python..)s: @(377SZK[B\^a^e^efjlm^nordrctjt|jdd|jddfS)Nrrrrrrs rcrz$sort_images_python..+s7 3 3Jsww?W4XZ[ \^a^e^efjlm^nordrcV|jd|jddfS)Nrrrrrs rcrz$sort_images_python..-s'1B)C DcggdTUFVWrdc&|jddS)Nrrrrs rcrz$sort_images_python../sswwtQ/rdrr)rrrrrrs @rcsort_images_pythonrsnvoG)3) wM  j o  o " "W/ $Hg 66rdct|}|ddk(r|Dcgc]}|d|dk(s|c}S|d}|Dcgc]"}t|jd|k(s!|$c}Scc}wcc}w)NrwrurrrirC)r~rhr)rrsdecodedrris rcrows_for_group_keyr 4sxy)Gv'!#Hs4yGJ4G'GHH12 YC?37773C#DHX#XC YYI ZsA#A#"A(A(ct|t}t|}|ddg}|D]'}t|}|j t |)||d<|d<t fdt|Dd|d<|S) Nrrrimagesprimary_image_idc3:K|]\}}|dk(s|ywrr)rindexru primary_ids rcrz%build_group_detail..Js R<5%d z8QRsrprimary_image_index)rrrrrrnext enumerate)rrsummaryr rrrs @rcbuild_group_detailr=s$N3Ll+G'-J F4Cy ,T234GH",G %)R9V#4R &G !" Nrd>/login/logout/healthz)z/_vercelz/faviconz /.well-knownrGcNK|jjdk(rtdvr||d{Stvst fdt Dr||d{Stdk(rnt |r||d{Sjds"jdsjdrtdd id Sttd Std k(rijds"jdsjdr&t|} t||j_||d{S||d{S7.77#t$r-}td|j i|j" cYd}~Sd}~wwxYw7U7Gw) Nr.>rBr@c3@K|]}j|ywrY)ry)rprefixr8s rcrz password_gate..Ys"Yv4??6#:"YsrAz/api/rrOr rr)rr@)rvr8r PUBLIC_PATHSanyPUBLIC_PREFIXESrryrr LOGIN_HTMLrr'r+r)r r r)r call_nextrr|r8s @rc password_gater Tsf ;;  D s{y$88w''' |s"Y"YYw'''J #G ,"7++ + ??7 #tz'BdooV_F`+D ESVW WJC88J ??7 #tz'BdooV_F`(1E Y%A%%H "w'''7# ##)(',! Y#Xszz$:XX Y' #s/F%E /F%"E###F%E&BF%&E( F% F! F%F#F%#F%&F%( F1"FFF%FF%#F%ceZdZUeed<y) LoginRequestrANrjrkrlr__annotations__rrdrcr"r"oMrdr"rreqc tdk7r tddtr |jtk7r tddt ddi}|j t tdttd d |S) NrAzPassword login is disabledrrzIncorrect passwordokTlaxr.)httponlymax_agesecuresamesiter8) r r r!rAr set_cookier#rr%r')r&rs rcloginr0sstJ4PQQ 44HIIT4L)H #  OrdrcNtddi}|jtd|S)Nr)Tr.r<)r delete_cookier#)rs rclogoutr3s)T4L)H .S9 Ordz /api/auth/mec tdk(rPt|}d|jdd|jddt|jddtdSdtddS)Nr@Tr rr) authenticatedr user_idis_owner auth_mode)r5r8r7)r r-rr0r,s rcauth_mer9sbJ$W-!XXgr*xxr*&txx'<="   " t LLrdceZdZUeed<y)InviteMemberRequestr Nr#rrdrcr;r; Jrdr;z/api/invite-memberc tdk7r tddtrts tddt |}t |j dj}t|s tdd t |jj}|rd |vr tdd i}tr t|d <tjtd |dttdd|d|ddd}|jdk(r tdd|jdk\r)t |jxsd}td|ddd|dS)Nr@rxzSupabase Auth is not enabledriz$Supabase service role key is missingr izOnly owners can invite members@zPlease enter a valid email redirect_toz/auth/v1/inviterrrmember)r! invited_by)r datarC)rrrriiz3That email is already invited or already has accesszFailed to send inviterAT)r)r )r r r0r-r-rrrr0r r1rrHrrW)r&rr)requester_email invite_emailrrr s rc invite_memberrEsRJ4RSS $L4Z[[  )D '!2399;O / *4TUUcii(..0L 3l24PQQ F! :}zz .(&'@&AB/. " - H$s"4ijjs"HMM*E.EF4CLAA ..rdrcdttdS)NT)r)db_moder8)rr rrdrchealthzrHs7 CCrdz /api/imagesrasc)ged)rJlepageper_pagec tdk(rtt||||}td|} t| ||} t | } |dz |z} | | | |zD cgc] } t | } } | | ||t d| |zdz |zdSt}t||||\}}|jd||jd} hd}||vr|nd }|d k(rd nd }|dz |z} d |d|d|d}|j|||| gzj} |jg} | D]%} | jt t| '| | ||t d| |zdz |zdScc} w)Nr:zid,title,subtitle,author,publisher,year,language,source_folder,source_filename,description,review_status,review_updated_at,image_url,thumb_url,storage_path,thumb_storage_path,raw_ocr_textrr)r totalrNrOpagesz SELECT COUNT(*) FROM book_imagesr>rrHrCrErrrrDESCASCa SELECT id, title, subtitle, author, publisher, year, language, source_folder, source_filename, description, review_status, review_updated_at, image_url, thumb_url, storage_path, thumb_storage_path FROM book_imagesz ORDER BY rdz LIMIT ? OFFSET ? )rrrrrzrmaxrrrfetchonerrrr)rrrJrrrrNrOrrrRoffsetrr rrr allowed_sortssort_col order_dirrs rc list_imagesr\s&)&&(IN  J% "$e4D (h&9=ffxFW9XY#(-YY UX-1h>?    8D!&&(IFME6 LL;E7CV L U U WXY ZEYM},t$H6/uIQh( "F 1YK(  E <<v6(:: ; D D FDJJL F9 ,T#Y789Q)A-(:;  CZsE$z/api/images/{image_id}c Htdk(rt|}|s tddt|}|d}t d}g}t t ||tD]2}|d|k(r |j|d|d |d |d |d d d4|dd|d<|St}|jd|fj}|s|jtddtt|}|d}|jdjDcgc] }t|}}|jg}t t ||tD]2}|d|k(r |j|d|d |d |d |d d d4|dd|d<|Scc}w)Nr:r(Image not foundrrszaid,title,author,source_folder,source_filename,image_url,thumb_url,storage_path,thumb_storage_pathrrrCrErrz same book)rrCrErfilenamereasonrelated&SELECT * FROM book_images WHERE id = ?zSELECT id, title, author, source_folder, source_filename, image_url, thumb_url, storage_path, thumb_storage_path FROM book_images)rrr rrrr rrrrrWrrr) rrrursall_rowsrb related_rowrrs rcget_image_detailrgs&X&C8IJ J&s++& "$GH!"4Xy"I~^ K4 H, NN%d+(1)(3)/: +,= >)   #3B<i 8D ,,?( M V V XC  4EFF "49 -Ek"I P (*   QH  JJLG09E>Z  t  ( !$'$W-%h/%o6'(9:%     s|E) L1sFz /api/booksrCc tdk(rt||||}td|} t| } t | j D cgc]} t | ddc} ||} t| } |dz |z}| |||zD cgc]} t | | dd d}} || ||td| |zdz |zd St}t||||\}}|jd |d |jDcgc] }t|} }|jt t| d ||} t| } |dz |z}| |||z| ||td| |zdz |zd Scc} wcc} wcc}w)Nr:zid,title,author,publisher,year,language,source_folder,source_filename,description,review_status,review_updated_at,image_url,thumb_url,storage_path,thumb_storage_pathrQFrrrrsT)booksrRrNrOrSa  SELECT id, title, author, publisher, year, language, source_folder, source_filename, description, review_status, review_updated_at, image_url, thumb_url, storage_path, thumb_storage_path FROM book_imagesz )r)rrrrrrarrzrVrrrrrrr)rrrJrrrrNrOrr grouped_maprrrRrXpagedrrrrfs rc list_booksrmRs&)&&(IN  t% !& cncucucwxZ_oeuSTUxz~AFGF (h&ouv|EHPPpQRfkU;-?!@D_`aRR UX-1h>?    8D!&&(IFME6#G$     (*   Q D  JJL d;T5 IF KEQh( "F 12Q)A-(:;  AyR sE+E0;E5z/api/books/{group_key}chtdk(r0t}t||}|s tddt |St }|j djDcgc] }t|}}|jt||}|s tddt |Scc}w)Nr:r(Book group not foundrzSELECT * FROM book_images) rrr r rrrrrr)rsr grouped_rowsrrfs rcget_book_grouprqs& )$ : C8NO O!,// 8D!\\*EFOOQ RDG RD RJJL%dI6L 4JKK l ++ Ss%B/ceZdZUeed<y)UpdateGroupTitleRequestrCNr#rrdrcrsrsr<rdrsz"/api/book-groups/{group_key}/titlec8t|j}|r|jdk(r tddtdk(rqt d}t ||}|s tdd|Dcgc]}|d  }}t|d |i|d d }d t||tt||d St}|jdjD cgc] } t| }} t ||}|s|jtdd|Dcgc] }||d f } }|j!d| |j#|j|d d }d t||tt||d Scc}wcc} wcc}w)NrTrxzPlease enter a real titlerr:zid,titler(rorrCrT)r)updatedrCrsz!SELECT id, title FROM book_imagesz-UPDATE book_images SET title = ? WHERE id = ?)rrCrr rrr rrzrrrhrrrrrrr) rsr& new_titlerrprrfocus_image_idrrfupdatess rcupdate_book_group_titlerys399%I  )Y64OPP&z*)$ : C8NO O*673SY7 7Wi$89%a.<()/)*DnU    8D!\\*MNWWY ZDG ZD Z%dI6L  4JKK1=># 3t9%>G>DgNKKMJJL!!_T*N|$%oi&@.Q  /8 [ ?s+ F F Fz/api/review/dashboardc tdk(rt}td|D}td|Dd}|Dcgc]"}t |j ddk(s!|$}}t ||d|d|d|d|d|dz|d|dzd |r t|nd|Dcgc] }t|c}d St}|jd jDcgc] }t|}}|jtd |D}td |Dd}|Dcgc]"}t |j ddk(s!|$}}t ||d|d|d|d|d|dz|d|dzd |r t|nd|Dcgc] }t|c}d Scc}wcc}wcc}wcc}wcc}w)Nr:c3PK|]}t|jd ywrrrs rcrz'get_review_dashboard..s[s01IJ[rc3\K|]$}t|jddk(s!|&ywrrRNrrs rcrz'get_review_dashboard..s(o0GP_H`0aen0no",,rrQrRrSrT)rRrRrSrQrTdone remaining)counts next_imagerQz%SELECT * FROM book_images ORDER BY idc3PK|]}t|jd ywrrrs rcrz'get_review_dashboard..sW3,SWW_-EFWrc3\K|]$}t|jddk(s!|&ywr}rrs rcrz'get_review_dashboard..s'_ 78P QU^ ^_r~)rrrrr[rrzrrrrrrr)rrnext_rowr flagged_rowsrrfs rcget_review_dashboardrs & [VZ[[ooquv'+n/FswwG_/`dm/mn nT!),":.!),#K0z*VK-@@#I. 1BB?G0:D:FG3)#.G   8D!\\*QR[[] ^DG ^D ^JJL WRVW WF__ H$(jC+B377?C[+\`i+iCjLjYi(z*i( ,:& )<< *VI->> ;C,X66BCs%c*C  5oH _kDs)"F9 F9(F>*G7"GG"G  review_statectdk(r@t|}|s tddt||t d}t |xs|St }|jd|fj}|s|jtddt }|jd|||f|j|jd|fj}|jt t|S)Nr:r(r^r)rrrczLUPDATE book_images SET review_status = ?, review_updated_at = ? WHERE id = ?) rrr rrbrrrrWrrr)rrrrur updated_ats rcupdate_review_staters&X&C8IJ J!(laqas,tu%gn55 8D ,,?( M V V XC  4EFF!#JLLV z8, KKMllCh[QZZ\GJJL !$w- 00rdz/api/review/{image_id}/verifyc dt|ddS)NTrSr)rurrs rcverify_review_imagers!4Xz!J KKrdz/api/review/{image_id}/flagc dt|ddS)NTrQrrrs rcflag_review_imagers!4Xy!I JJrdceZdZUdZeed<dZeed<dZeed<dZeed<dZ eed<dZ eed<dZ eed<dZ eed <dZ eed <dZeed <dZeed <dZeed <dZeed<dZeed<y)ReviewCorrectionRequestrrCrDrErFrGrHrIrJrKrLrMrNrOrPN)rjrkrlrCrr$rDrErFrGrHrIrJrKrLrMrNrOrPrrdrcrr sE3OHcFCJIsD#NGSHcFCFCIscJL#rdrz/api/review/{image_id}c ntdk(rqt|}|s tddtDcic]}|t t ||}}d|d<t |d<t||}dt|xs|d St}|jd |fj}|s|jtddtDcic]}|t t ||}}d jd tD}tDcgc]}|| }}|jdt |g|jd |d||j|jd |fj}|jdtt!|d Scc}wcc}wcc}w)Nr:r(r^rrTrrTrrcrc3&K|] }|d yw)z = ?Nr)rrs rcrz)save_review_correction..DsFuugTNFrzUPDATE book_images SET z7, review_status = ?, review_updated_at = ? WHERE id = ?)rrr REVIEW_FIELDSrr*rbrrrrrWrrrrr) rr&rrrrur assignmentsras rcsave_review_correctionr1s&X&C8IJ JGTUe5*WS%%899UU#. '7'9#$!(G4%;GNs%KLL 8D ,,?( M V V XC  4EFFCPQ%uje!455QGQ))F FFK8EFuGENFFF MM; 0 2H=>LL !+.ef KKMllCh[QZZ\GJJL!7W !F GG1VRFsF( F- F2z /api/statsctdk(rtd}t|}td|D}td|D}td|D}t d|D}t d|D}t d|D}|tt |||||d |d |d |d |d |d zd t |jD cgc] \}} || d c} }t |jdD cgc] \} } | | d c} } dSt} | jdjD cgc] } t| }} t|}td|D}td|D}td|D}t d|D}| jdj} | jdj}| j|tt |||||d |d |d |d |d |d zd | Dcgc] }|d|ddc}|Dcgc] }|d|ddc}dScc} }wcc} } wcc} wcc}wcc}w)Nr:zid,title,author,language,source_folder,source_filename,description,review_status,image_url,thumb_url,storage_path,thumb_storage_pathc3VK|]!}t|jdsd#ywrCrNrXrrs rcrzget_stats..Ws Ksj9I.JKrc3VK|]!}t|jdsd#ywrErNrrs rcrzget_stats..Xs Mz#''(:K/L!Mrc3VK|]!}t|jdsd#ywrrrs rcrzget_stats..Ys PcZ 8N-OPrc3PK|]}t|jd ywrrrs rcrzget_stats..Zs bVY 78P Qbrc3K|]9}t|jdst|jd;yw)rNrrs rcrzget_stats..[s3}Xbcfcjcjkzc{X| 377?+C D} AAc3K|]9}t|jdst|jd;yw)rJNrrs rcrzget_stats..\s3!ucU_`c`g`ghr`sUt*SWWZ-@"A!urrRrSrQrT)rRrSrQrTr)rcountc|d |dfS)Nrrr)rs rcrzget_stats..msZ^_`ZaYacghicjXkrdr)rJr)rR book_groups with_title with_authorwith_descriptionreviewr languageszoSELECT id, title, author, language, source_folder, source_filename, description, review_status FROM book_imagesc3VK|]!}t|jdsd#ywrrrs rcrzget_stats..ys G3*SWWW5E*FQGrc3VK|]!}t|jdsd#ywrrrs rcrzget_stats..zs IC:cggh6G+HaIrc3VK|]!}t|jdsd#ywrrrs rcrzget_stats..{s L#CGGM4J)KALrc3PK|]}t|jd ywrrrs rcrzget_stats..|s ^RU3CGGO4LM^rz]SELECT source_folder, COUNT(*) FROM book_images GROUP BY source_folder ORDER BY source_folderzSELECT language, COUNT(*) as cnt FROM book_images WHERE language != '' AND language != 'Unknown' GROUP BY language ORDER BY cnt DESCrr) rrrzrrrritemsrrrrr)rrRrr with_descr folder_countslanguage_countsrrrJrrfrrrs rc get_statsrRs& fgD KdKK MtMM PTPP b]abb }PT}} !!uT!uuz$/0$& )(3)*5(3*;7%j1M+4NN QWWdWjWjWlPmn}vu6E:n(.o.C.C.EKk'l#He&6  ( 8D } (*    Q D  IEG$GGJI4IIKLLLI^Y]^^Mllghj   Ohj JJL:d+, "%$Y/%j1$Y/&{3!*- k0JJ  DKKCs1vA7KGPQ3q6CF;Q 7o @LQsI( I. I49I9I>z/api/languagesc ntdk(rWtd}t|Dchc]7}t|j dst|j d9c}St }|j dj}|j|Dcgc]}|d c}Scc}wcc}w)Nr:rJzjSELECT DISTINCT language FROM book_images WHERE language != '' AND language != 'Unknown' ORDER BY languager) rrrrXrrrrr)rrrs rc get_languagesrs&z*$j3*UXU\U\]gUhJiz#''*"56jkk 8D <<t hj  JJL" #sCF ##k $sB-B- B2z/photos/{folder}/{filename}r_c|dk(r t|z }n t|z |z }|js tddtt |dS)Nrr(zImage file not foundr image/jpeg media_type) IMAGES_BASEexistsr rr)rr_r8s rc serve_photorsK X%V#h. ;;=4JKK D l ;;rdz/media/{asset_path:path} asset_pathctj}||z j}||k7r||jvr tdd|j r|j s tddt t|dS)NrxzInvalid asset pathrr(zOptimized asset not foundrr)OPTIMIZED_IMAGES_BASEresolveparentsr ris_filerr)rbaser8s rcserve_optimized_mediarss ( ( *D :  & & (D t|DLL04HII ;;= 4OPP D l ;;rdceZdZUeed<y)GenerateRequestrN)rjrkrlrgr$rrdrcrrr%rdrz/api/generate-descriptionc d}tdk(r$t|j}|sltddt }|j d|jfj }|s|jtddt|}g}dD]6\}}|j|d}|s|dk7s!|j|d |8d j|}|d xsddd } |d } ddddj| d} ddl m } | tjd} | j j#ddd| d|d| dgd}t%|j&dj(j*}|s t-d tdk(rt3|jd0|id0|iS|J|j d1||jf|j5|jd0|iS#t.$r}g}|d r |d dk7r|jd!|d d!|d"r|d"dk7r|jd#|d"|d$r|jd%|d$|d&r|jd'|d&d(|rd)| d*d+j|znd,| d(}|d-t1|dd.d/z }Yd}~3d}~wwxYw)2Nr:r(r^rrc) )rCTitle)rDSubtitle)rEAuthor)rG Publisher)rHYear)rIEdition)rJLanguage)rF Translator)rKSeries)rLVolume)rM Condition)rNzSpecial features)rOz Other detailsrUnknownz: rrPirztitle page or inner pagez front coverspine)rrrz book photorMistralMISTRAL_API_KEYapi_keymistral-small-latestr)ztYou are writing a brief, appealing description for an antiquarian/second-hand book listing. This photo shows the **a** of a book. Based on the OCR text and extracted metadata below, write: 1. A one-line description of what this photo shows (e.g. "Title page of a 1902 English edition published in Buenos Aires") 2. A 2-3 sentence selling description highlighting what makes this book interesting or collectible (age, rarity, publisher, condition, historical significance, etc.) Keep it professional but warm - like a knowledgeable bookseller. Write in English. EXTRACTED METADATA: z RAW OCR TEXT FROM PHOTO: r!rrxmodelmessages max_tokensz%Mistral returned an empty descriptionrC"rEby rGz published by rHrrz Photo of z. rdz Book photo (z [AI generation failed: rL]rqz3UPDATE book_images SET description = ? WHERE id = ?)rrrr rrrWrrrrrmistralai.clientrosgetenvchatcompleterchoicesmessagerrr&rrr)r&db_connrur info_partsrilabelr book_infoocr_text photo_type photo_descrclientrrqr|rs rcgenerate_descriptionrs7G&s||,C8IJ J(ooFXaac MMOC8IJ JS J3 U #r" Ui'   r%1 2#3& *%In%+Ud3H'J* c*l#  ,G,+;;''(#$"|$    $)( ,+8+;+;A+>+F+F+N+NO FG G&& }k&BC ; '' """MP[]`]i]iOjk  ; ''1 G >eGn 9 LL1U7^,A. / ?uX); LL3uX/0 1   LL={);(<= > = LL1U6]O1- . |2 &% 8 |1-  4SXds^4DAFF GsBG77 KB9J??Kc*eZdZUdZeed<dZeed<y)BatchGenerateRequestrstart_id rN)rjrkrlrrgr$rrrdrcrr'sHcE3Ordrz /api/generate-descriptions-batchctdk(retd}|Dcgc]?}t|jdr|jdd|jk\s>|A}}|d|j }nPt }|jd|j|j fj}|jg}|D][}t|tr|dn|d} tt||j|dd tj d ]tdk(rt%d tdD}n= ? ORDER BY id LIMIT ?rr))rstatusg?zerror: c3VK|]!}t|jdrd#ywrrrs rcrz.generate_descriptions_batch..Es$nc:VYV]V]^kVlKmnrzNSELECT COUNT(*) FROM book_images WHERE description IS NULL OR description = '') generatedresultsr)rrrrrrrrrrrfrrrrrsleepr&rrWrz)r&rrrrrr|rs rcgenerate_descriptions_batchr,s&/0#s:cggm6L+MRURYRYZ^`aRbfifrfrRrssKcii x|| x \\399 %  (*  GH *3 53t93q6 H (!C D NN(d; < JJsO H&n_]%Cnn xLL \ (*Q  W' RR;t" H NN(uoF G G Hs(FFF!>F GF;;GceZdZUeed<y) ChatRequestquestionNr#rrdrcrrRr%rdrz /api/chatctdk(rltdDcgc]I}t|jdr-t|jdj dk7r|K}}t |d}n9t }|jdj}|jg}|D]O}t|trx|jd}|jd}|jd }|jd } |jd } |jd } |jd } n |dd\}}}} } } } d|g} |r| jd|d|r|dk7r| jd|| r| jd| d| r| jd| d| r| dk7r| jd| | r| jd| |jdj| Rdj|} ddlm}|t!j"d}|j$j'dd d!t)|d"|d#d$|j*d#gd%&}t-|j.dj0j2}d'|xsd(iScc}w#t4$r}d'd)|d*icYd}~Sd}~wwxYw)+Nr:z.^sj9I.J.P.P.RrdrzSELECT id, title, author, publisher, year, language, series, source_folder FROM book_images WHERE title != 'Unknown' AND title != '' ORDER BY titlerrErGrHrJrKrr#rrrrr[rzlang:zseries:rdrrrrrsystemzYou are a helpful librarian/bookseller assistant. Answer questions about this book photo collection. Be specific - cite book titles, authors, and image IDs (#N) when relevant. CATALOG (z identified images): rr)iranswerz#AI chat returned an empty response.zAI chat unavailable: z'. Try searching in the gallery instead.)rrrrrrrrrrrfrrrrrrrrrrzrrrrrr&)r&rrjr catalog_linesbookbook_idrCrErGrHrJrKr catalog_textrrrrr|s rcchat_about_booksr Vs&''ef #'''*+ 3777;K0L0R0R0TXa0a   u"RSx  b (*  M. dD !hhtnGHHW%EXXh'F-I88F#Dxx +HXXh'FHLQq EGUFItXvWI  LL1UG1 & f ) LL3vh (  LL1YKq) *  LL1TF! % I- LL5 + ,  LL76(+ ,SXXe_-3.699]+L`,+;;''(%$  e*    CLL9 ( &h&6&6q&9&A&A&I&IJ&I$IJJ @ `1#6]^__`s%AJ-BJ22 K ;KK K )response_classctjtjdd}tjd|}t |S)Nz Bibliothek - Family Access
Private family link

Bibliothek

Enter the shared family password to browse the catalog, review OCR, and help clean up the collection.

u&  Bibliothek - Book Catalog
Private family library
Bibliothek
Sign in with your invited email and I will send you a private magic link. Only approved family members can access the catalog.
📚

Bibliothek

Book-centered catalog for desktop and phone
0/0 described
Batch descriptions still run per photo, but the gallery now groups matching titles into books.
Verification game

Swipe right if the OCR is right. Swipe left if it needs fixing.

Loading the review queue...
How many books are in Spanish? Which books are from before 1900? List books with multiple photos What authors appear most often? Which titles still need descriptions?
Ask me anything about the collection and I will answer from the catalog.
Loading...
Book photo
)F)rN)r)T)Try)__doc__rorrrrrfrr collectionsrrrrpathlibrtypingr urllib.parser rrdotenvr fastapir r r rfastapi.responsesrrrpydanticr importlib import_moduler ImportError__file__parentrrrrrrrrrrr r!r"r#rgr%r'rqr-r/r0r1rr2r4r5r7r8rrrrZapprUrr]floatr$ PyJWKClientrrWrur{r}rrrrrrrrrrrrrrrrrr$r'r-r0r7r=r?rLrRrXr[rbrhrrr~rrrrrrrrrrrrrrrrrrrr rrr middlewarer r"rHr0r3rr9r;rErHr\rgrmrqrsrryrrrrrrrrrrrrrrrr rrrr/s0rcr(s  ,' ::FF%i%%i0G x.   & & 39299],_`a YRYY'>DNDYDYD`D`cuDu@vwxryy,224 299/4::<BBDq!4 BIIk2 & , , . 4 4 6 ryy,224 +-FGMMOlSlbii 57KLRRTlXl)"))$99EF /7399;AACGaa ryy,224;;C@ BII126<<>%BII&A2FLLN&RYY'CRHNNP>+GHNNsS  {{} KKM ryy)9:@@BVFV BII17;AACIIKVw! "92>DDFMMcRYRYY'?JK55GRYYxCL5NGGG$ 2')    @  *+13$sE%*--.3R^ocoo.LMNdh (( B  c3h CXd38n5MY]^bYc$ +S +# + + +c +4 +HTN + S 4 DJ : isisi5c5 *# *$ *9g9$9'c==(cd.999"7t5#5$5D-S-S-`s`s`ss< S S 8c8 D#DcsccLLL&   S(DT&4D"UUU/4:/$/0DJ0s0s0c :T :d :d :#$t*##C#X\#LT$ZDd4j$9{tDz{d{{UYZ^U_{9T 9#9c9d4j9( SM SMsm~   39 B t* SM SMsm  ~   $Z DWWW  SM SMsm~   #s(^ 67T$Z7s7374:7,ZT$ZZCZDJZT$ZD&1 :$$$49(|&)  MW M M) +/*+/W+/ +/\DD !$K!$K#Dk %d d uaA"s+: SM: SM:sm:~ :  :  : :::z !":s:#:z!$K!$K#Dk %d guaA"s+7 SM7 SM7sm7~ 7  7  7 777t !",c,#,$i /0&s&1H&1&R !+"+\1#1S1T12 )*L#L+L '(KK)Ki" #$HSH/FH%H@AAH  $ $ &'<