+
    ŒûjÕw  ã                   óè  € R t ^ RIt^ RIt^ RIt^ RIt^tRtRsR tR t	Rt
RtRtRtR	t ! R
 R]P                  4      tR:R ltR tR tR t ! R R4      tR:R ltR tR tR;R ltR:R ltR<R ltR<R ltR tR tR tR t R:R lt!R t"R<R lt#R  t$R! t%R<R" lt&R# t'R$ t(R% t)R=R& lt*R=R' lt+R>R( lt,R<R) lt-R?R* lt.R+ t/R, t0R- t1R. t2R:R/ lt3R@R0 lt4R:R1 lt5R2 t6R3 t7R4 t8RAt9R:R5 lt:R6 t;R7 t<R8 t=R9 t>R# )BzÒSQLite store of the addon library (docs/plan/milionar-library/030).

The only module that runs SQL. One connection per call (plugin and service
processes both use it), WAL journal, every write one transaction.
Nz
library.dbc                ó
   € V s R# )z*Tests point the store at a temporary file.N)Ú_override_path©Úpaths   &Úwcs/library2/store.pyÚset_pathr      s	   € ð ‚Nó    c                  ó”   € \         '       d   \         # ^ RIp \        P                  P	                  V P                  R4      \        4      # )é    Nz3special://profile/addon_data/plugin.video.milionar/)r   ÚxbmcvfsÚosr   ÚjoinÚtranslatePathÚDB_NAME)r   s    r   Údb_pathr      s2   € ßƒ~ÜÐÛÜ�7‰7�<‰<˜×-Ñ-Ð.cÓdÔfmÓnÐnr   a2  
CREATE TABLE titles(
  media_type TEXT NOT NULL CHECK(media_type IN ('movie','tv')),
  tmdb_id INTEGER NOT NULL,
  in_list INTEGER NOT NULL DEFAULT 0,
  list_added_at INTEGER,
  list_pos INTEGER,
  legacy_json TEXT,
  hidden_from_continue_at INTEGER,
  last_activity_at INTEGER,
  PRIMARY KEY(media_type, tmdb_id));
CREATE TABLE movie_state(
  tmdb_id INTEGER PRIMARY KEY,
  playcount INTEGER NOT NULL DEFAULT 0, last_played_at INTEGER,
  resume_pos REAL NOT NULL DEFAULT 0, resume_total REAL NOT NULL DEFAULT 0,
  last_ident TEXT, last_provider TEXT, last_file_name TEXT, mirrored_at INTEGER);
CREATE TABLE episode_state(
  show_id INTEGER NOT NULL, season INTEGER NOT NULL, episode INTEGER NOT NULL,
  playcount INTEGER NOT NULL DEFAULT 0, last_played_at INTEGER,
  resume_pos REAL NOT NULL DEFAULT 0, resume_total REAL NOT NULL DEFAULT 0,
  last_ident TEXT, last_provider TEXT, last_file_name TEXT, mirrored_at INTEGER,
  PRIMARY KEY(show_id, season, episode));
CREATE TABLE play_log(
  id INTEGER PRIMARY KEY, media_type TEXT, tmdb_id INTEGER, season INTEGER, episode INTEGER,
  started_at INTEGER, ended_at INTEGER, position REAL, total REAL, outcome TEXT);
CREATE TABLE meta(key TEXT PRIMARY KEY, json TEXT NOT NULL, fetched_at INTEGER NOT NULL, ttl INTEGER NOT NULL);
CREATE TABLE flags(key TEXT PRIMARY KEY, value TEXT);
zý
ALTER TABLE movie_state ADD COLUMN mirrored_playcount INTEGER;
ALTER TABLE movie_state ADD COLUMN mirrored_resume_pos REAL;
ALTER TABLE episode_state ADD COLUMN mirrored_playcount INTEGER;
ALTER TABLE episode_state ADD COLUMN mirrored_resume_pos REAL;
aÊ  
ALTER TABLE movie_state ADD COLUMN state_version INTEGER NOT NULL DEFAULT 0;
ALTER TABLE episode_state ADD COLUMN state_version INTEGER NOT NULL DEFAULT 0;
CREATE TABLE mirror_pending(
  media_type TEXT NOT NULL, tmdb_id INTEGER NOT NULL,
  season INTEGER NOT NULL, episode INTEGER NOT NULL,
  version INTEGER NOT NULL, attempts INTEGER NOT NULL DEFAULT 0,
  next_attempt REAL NOT NULL DEFAULT 0,
  PRIMARY KEY(media_type,tmdb_id,season,episode));
CREATE TABLE pending_marks(
  id INTEGER PRIMARY KEY, media_type TEXT NOT NULL, tmdb_id INTEGER NOT NULL,
  kind TEXT NOT NULL, season INTEGER, episode INTEGER, watched INTEGER NOT NULL,
  attempts INTEGER NOT NULL DEFAULT 0, next_attempt REAL NOT NULL DEFAULT 0);
zø
CREATE TABLE feedback(
  media_type TEXT NOT NULL CHECK(media_type IN ('movie','tv')),
  tmdb_id INTEGER NOT NULL,
  value TEXT NOT NULL CHECK(value IN ('like','dislike','hide','pick')),
  at INTEGER NOT NULL,
  PRIMARY KEY(media_type, tmdb_id));
a—  
CREATE TABLE sync_outbox(
  id INTEGER PRIMARY KEY, op_id TEXT NOT NULL UNIQUE, type TEXT NOT NULL, key TEXT NOT NULL, at INTEGER NOT NULL,
  payload TEXT NOT NULL DEFAULT '{}', attempts INTEGER NOT NULL DEFAULT 0, next_attempt REAL NOT NULL DEFAULT 0);
CREATE INDEX sync_outbox_key ON sync_outbox(key);
CREATE TABLE sync_state(key TEXT PRIMARY KEY, value TEXT);
ALTER TABLE play_log ADD COLUMN uuid TEXT;
c                   ó   € ] tR t^ftRtR# )Ú_Connection© N)Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__Ú__static_attributes__r   r   r   r   r   f   s   † Ûr   r   c                 óØ  € T ;'       g    \        4       p \        P                  P                  V 4      pV'       d   \        P                  ! VR R7       \
        P                  ! V RR\        R7      p\        4       Vn	        \        4       Vn
        RVn        \
        P                  Vn        VP                  R4       VP                  R4       VP                  R4       \        V4       V# )	T)Úexist_okç      @N)ÚtimeoutÚisolation_levelÚfactoryFzPRAGMA busy_timeout=5000zPRAGMA journal_mode=WALzPRAGMA foreign_keys=ON)r   r   r   ÚdirnameÚmakedirsÚsqlite3Úconnectr   ÚsetÚwidget_rowsÚwidget_titlesÚoutboxÚRowÚrow_factoryÚexecuteÚ_migrate)r   ÚfolderÚconns   &  r   r"   r"   j   s¢   € Ø×Ð”7“9€DÜ�W‰W�_‰_˜TÓ"€FßÜ
�Š�F TÕ*Ü�?Š?˜4¨¸dÌKÔX€DÜ“u€DÔÜ›€DÔØ€D„KÜ—{‘{€DÔØ‡L�LÐ+Ô,Ø‡L�LÐ*Ô+Ø‡L�LÐ)Ô*ÜˆT„NØ€Kr   c                 ó  € V P                  R 4      P                  4       ^ ,          pV\        8¼  d   R# V P                  R4        V P                  R 4      P                  4       ^ ,          pV^8  dT   \        P	                  4       P                  R4       F,  pVP	                  4       '       g   K  V P                  V4       K.  	  V^8  dT   \        P	                  4       P                  R4       F,  pVP	                  4       '       g   K  V P                  V4       K.  	  V^8  dT   \        P	                  4       P                  R4       F,  pVP	                  4       '       g   K  V P                  V4       K.  	  V^8  dT   \        P	                  4       P                  R4       F,  pVP	                  4       '       g   K  V P                  V4       K.  	  V^8  dT   \        P	                  4       P                  R4       F,  pVP	                  4       '       g   K  V P                  V4       K.  	  V P                  RP                  \        4      4       V P                  R4       R#   \         d    T P                  R4       h i ; i)zPRAGMA user_versionNúBEGIN IMMEDIATEÚ;zPRAGMA user_version={}ÚCOMMITÚROLLBACK)r)   ÚfetchoneÚSCHEMA_VERSIONÚ	SCHEMA_V1ÚstripÚsplitÚ	SCHEMA_V2Ú	SCHEMA_V3Ú	SCHEMA_V4Ú	SCHEMA_V5ÚformatÚ	Exception)r,   ÚversionÚ	statements   &  r   r*   r*   {   sÑ  € Ø�l‰lÐ0Ó1×:Ñ:Ó<¸QÕ?€GØ”.Ô ÙØ‡L�LÐ"Ô#ðØ—,‘,Ð4Ó5×>Ñ>Ó@ÀÕCˆØ�QŒ;Ü&Ÿ_™_Ó.×4Ñ4°SÖ9�	Ø—?‘?×$Ô$Ø—L‘L Ö+ñ :ð �QŒ;Ü&Ÿ_™_Ó.×4Ñ4°SÖ9�	Ø—?‘?×$Ô$Ø—L‘L Ö+ñ :ð �QŒ;Ü&Ÿ_™_Ó.×4Ñ4°SÖ9�	Ø—?‘?×$Ô$Ø—L‘L Ö+ñ :ð �QŒ;Ü&Ÿ_™_Ó.×4Ñ4°SÖ9�	Ø—?‘?×$Ô$Ø—L‘L Ö+ñ :ð �QŒ;Ü&Ÿ_™_Ó.×4Ñ4°SÖ9�	Ø—?‘?×$Ô$Ø—L‘L Ö+ñ :ð 	�‰Ð-×4Ñ4´^ÓDÔEØ�‰�XÖøÜô Ø�‰�ZÔ Øðús0   ÁA&I% Â1AI% ÄAI% Å%AI% Æ?AI% ÈA
I% É%Jc                ó0  € V P                  R4       Uu. uF  q^ ,          NK  	  ppV UUu/ uFR  pY0P                  RP                  V4      4       Uu/ uF$  q^,          V^,          V^,          V^,          3bK&  	  upbKT  	  upp# u upi u upi u uppi )z8{table: {column: (notnull, default, pk)}} of a database.zNSELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'zPRAGMA table_info("{}"))r)   r;   )r,   ÚrowÚtablesÚtables   &   r   Ú_columnsrC   �   s˜   € à $§¡Ð-}Ô ~ÓÑ ~˜�!�fˆfÑ ~€FÐáô!Ù�ð ÇÁÐMf×MmÑMmÐnsÓMtÔ@uÓvÑ@u¸˜•F˜S �V S¨¥V¨S°­VÐ4Ò4Ñ@uÑvÒvÙò!ð !ùò @ùÚvùó !s   ”B¬'BÁ*BÁ=BÂBc           	     ó�  a€ \         P                  P                  V 4      '       g   R# \        P                  ! RRR7      p \        V4       \        V4      pVP                  4        ^ RIH	p  \        P                  ! RP                  V! \         P                  P                  V 4      4      4      RRR7      p \        V4      pVP                  4        TP                  4        F–  w  poTP                  T4      pTe   \        S4      \        T4      8:  g    R	# \         ;QJ d-    T3R
 lTP                  4        4       F  '       g   K   RM"	  R	M! T3R
 lTP                  4        4       4      '       g   K•   R	# 	  R#   TP                  4        i ; i  TP                  4        i ; i  \        P                   d     R	# i ; i)aP  True when this version can work with the library at `path`: every table and column it knows is there, and a column
it does not know takes a row without it. A beta may only add (docs/plan/skin-milionar/340-beta-channel.md, B5):
the update checks the stable version's own readable() before going back, release.py before publishing a beta.Tz:memory:N)r   )Úquotezfile:{}?mode=ror   )Úurir   Fc              3   ó„   <"  € T F5  w  pw  r#pVS9  ;'       d    T;'       d    VR J ;'       d    V'       * x € K7  	  R # 5i©Nr   )Ú.0ÚnameÚnotnullÚdefaultÚpkÚcolumnss   &    €r   Ú	<genexpr>Úreadable.<locals>.<genexpr>½   sI   øé € ð BÙ3@Ñ/�4Ñ/˜'¨Bð ˜7Ñ"×MÐM w×MÐM°7¸d°?×MÐMÈ2ÄvÔMÛ3@ùs   ƒA š	A ¤A °A )r   r   Úexistsr!   r"   r*   rC   ÚcloseÚurllib.parserE   r;   ÚabspathÚErrorÚitemsÚgetr#   Úany)	r   ÚownÚexpectedrE   r,   ÚactualrB   ÚfoundrN   s	   &       @r   Úreadabler]   ¤   sM  ø€ ô �7‰7�>‰>˜$×ÒÙÜ
�/Š/˜*°dÔ
;€CðÜ�ŒÜ˜C“=ˆà�	‰	ŒÝ"ðÜ�ŠÐ0×7Ñ7¹¼b¿g¹g¿o¹oÈdÓ>SÓ8TÓUÐ[_ÐilÔmˆð	Ü˜d“^ˆFà�J‰JŒLð #Ÿ.™.Ö*‰ˆˆwØ—
‘
˜5Ó!ˆØŠ=¤ G£´°E³
Ô :Úß‹3ô BØ38·;±;´=óB�3�3Š3ô BØ38·;±;´=óB÷ Bô Bâñ +ñ øð# 	�	‰	�ûð �J‰J�LûÜ�=‰=ô Úðús7   ÁF Á/AF, Â;F ÃF, ÆFÆF)Æ)F, Æ,GÇGc                   ó:   a € ] tR t^Ãt o RtRR ltR tR tRtV t	R# )Ú_Txz3with store.tx() as conn: one IMMEDIATE transaction.Nc                ó&   € \        V4      V n        R # rH   )r"   r,   )Úselfr   s   &&r   Ú__init__Ú_Tx.__init__Æ   s   € Ü˜D“MˆŽ	r   c                óP   € V P                   P                  R 4       V P                   # )r.   )r,   r)   )ra   s   &r   Ú	__enter__Ú_Tx.__enter__É   s   € Ø�	‰	×ÑÐ+Ô,Ø�y‰yÐr   c                óô  € V'       g    \        V P                  P                  4      M	\        4       pV'       g&   \        V P                  P                  \
        R 7      M. p V'       gM   V FF  pRV,           pV P                  P                  RV34       V P                  P                  RV34       KH  	  V P                  P                  V'       d   RMR4       V P                  P                  4        V'       d    ^ RIH	p V! RWER7       V P                  P                  '       d   V'       g   ^ R	IHp	 V	P                  4        R
#   T P                  P                  4        i ; i  \         d     Lhi ; i))Úkeyzwidget.rev.z2INSERT OR IGNORE INTO flags(key,value) VALUES(?,0)z;UPDATE flags SET value=CAST(value AS INTEGER)+1 WHERE key=?r1   r0   )ÚnotifyÚskin_rows_changed)Útitles©ÚhooksF)r#   r,   r$   Úsortedr%   Ústrr)   rR   Úwcs.skin.refreshri   r<   r&   Úwcs.accountrm   Ú	committed)
ra   Úexc_typeÚexcÚtbÚchangedrk   r@   rh   ri   rm   s
   &&&&      r   Ú__exit__Ú_Tx.__exit__Í   s	  € ß4<”#�d—i‘i×+Ñ+Ô,Ä#Ã%ˆßAI”˜Ÿ	™	×/Ñ/´SÕ9Èrˆð	ßÛ"�CØ'¨#Õ-�CØ—I‘I×%Ñ%Ð&ZÐ]`Ð\bÔcØ—I‘I×%Ñ%Ð&cÐfiÐekÖlñ #ð �I‰I×Ñ¯H™j¸(ÔCà�I‰I�O‰OÔßðÝ3ÙÐ*¨GÕCð �9‰9××Ð§HÝ)Ø�O‰OÔÙøð �I‰I�O‰OÕûô
 ô Ùðús+   Á"E
 Á*A(E
 ÃE
 Ã>E) Å
E&Å)E7Å6E7)r,   rH   )
r   r   r   r   Ú__doc__rb   re   rw   r   Ú__classdictcell__)Ú__classdict__s   @r   r_   r_   Ã   s   ø‡ € Ù=ô"ò÷ð r   r_   c                 ó   € \        V 4      # rH   )r_   r   s   &r   Útxr}   å   s   € Üˆt‹9Ðr   c                  ó>   € \        \        P                  ! 4       4      # rH   )ÚintÚtimer   r   r   Ú_nowr�   é   s   € ÜŒt�yŠy‹{ÓÐr   c                ó<   € V P                   P                  V4       R# )zPCollect rows once per transaction; revisions commit with the corresponding data.N)r$   Úupdate)r,   Úrowss   &&r   Údirtyr…   í   s   € à×Ñ×Ñ˜DÖ!r   c                 ó4   € ^ RI Hp \        W! W4      4       R# )r
   )Ú
media_rowsN)rp   r‡   r…   )r,   Ú
media_typeÚ
membershipr‡   s   &&& r   Ú_media_dirtyrŠ   ò   s   € Ý+Ü	ˆ$�
˜:Ó2Ö3r   c                óž   € ^ RI Hp VP                  4       '       g   VP                  4       '       g   R# ^ RI Hp VP                  WW#4       R# )ue   Queue an account op in this transaction (signed-in devices only, docs/plan/milionar-account/020 Â§2).)ÚstateNrl   )rq   rŒ   Úis_applyingÚ	signed_inrm   Úrecord)r,   Úop_typerh   ÚpayloadrŒ   rm   s   &&&&  r   Ú_recordr’   ÷   s4   € å!Ø×Ñ×Ò %§/¡/×"3Ò"3ÙÝ!Ø	‡L�L� Ö-r   c                 óÀ   € V R 8X  d   RP                  \        V4      4      # RP                  \        V4      Vf   RM
\        V4      Vf   R4      # \        V4      4      # )Úmoviezmovie:{}ztv:{}:{}:{}éÿÿÿÿ)r;   r   ©rˆ   Útmdb_idÚseasonÚepisodes   &&&&r   Ú
_watch_keyrš      sX   € Ø�WÔØ× Ñ ¤ W£Ó.Ð.Ø×Ñ¤ G£°F²N©bÌÈFËÐ[bÒ[jÐUWÓ}Ð}ÔpsÐt{Óp|Ó}Ð}r   c                ó¶   € V P                   P                  V\        V4      W434       \        WW44      w  rVrxp	V P	                  RP                  WV4      V4       R# )zdA watch state changed: its version goes up and the cards of this title redraw at once (row journal).z4UPDATE {} SET state_version=state_version+1 WHERE {}N)r%   Úaddr   Ú_state_keysr)   r;   )
r,   rˆ   r—   r˜   r™   rB   ÚwhereÚargsÚ_colsÚ_valss
   &&&&&     r   Ú_changedr¢     sO   € à×Ñ×Ñ˜J¬¨G«°fÐFÔGÜ'2°:ÈÓ'XÑ$€E�$˜uØ‡L�LÐG×NÑNÈuÓ\Ð^bÖcr   c                 ó@   € V P                  R V\        V4      34       R# )z>INSERT OR IGNORE INTO titles(media_type, tmdb_id) VALUES(?, ?)N)r)   r   )r,   rˆ   r—   s   &&&r   Ú_ensure_titler¤     s   € Ø‡L�LÐQÐT^Ô`cÐdkÓ`lÐSmÖnr   c                ó–  € \        4       p VP                  RV 34      P                  4       pVP                  4        . pV F\  p VR,          '       d   \        P
                  ! VR,          4      M/ pVP                  RVR,          4       VP                  V4       K^  	  V#   TP                  4        i ; i  \         d    / p LTi ; i)zELegacy dicts of My movies ('movie') / My series ('tv') in list order.zrSELECT legacy_json, tmdb_id FROM titles WHERE media_type=? AND in_list=1 ORDER BY list_pos, list_added_at, tmdb_idÚlegacy_jsonÚidr—   )	r"   r)   ÚfetchallrR   ÚjsonÚloadsÚ
ValueErrorÚ
setdefaultÚappend)rˆ   r,   r„   Úresultr@   Úentrys   &     r   Úget_listr°     s½   € ä‹9€DðØ�|‰|ð HØJTÈóXßX`ÑX`ÓXbð 	ð 	�
‰
ŒØ€FÛˆð	Ø69¸-×6HÔ6H”D—J’J˜s =Õ1Ô2ÈbˆEð 	×Ñ˜˜s 9�~Ô.Ø�‰�eÖñ ð €Møð 	�
‰
�ûô
 ô 	ØŠEð	ús   Œ!B# Á.B8Â#B5Â8CÃCc           	     ó  € \        4       p VP                  RV 34      P                  4       pVP                  4        V Uu/ uF  q3R,          RVR,          RVR,          /bK   	  up#   TP                  4        i ; iu upi )z`{tmdb_id: {'added', 'activity'}} (epoch seconds or None) of the titles in My movies / My series.z\SELECT tmdb_id, list_added_at, last_activity_at FROM titles WHERE media_type=? AND in_list=1r—   ÚaddedÚlist_added_atÚactivityÚlast_activity_at©r"   r)   r¨   rR   )rˆ   r,   r„   Úrs   &   r   Ú
list_timesr¸   &  s{   € ä‹9€DðØ�|‰|ÐzØ'˜Mó+ß+3©8«:ð 	ð 	�
‰
ŒÙdhÓiÑdhÐ_`ˆi�L˜7 A oÕ$6¸
ÀAÐFXÕDYÐZÒZÑdhÑiÐiøð 	�
‰
�üÚis   Œ!A( Á$A=Á(A:c                ó|  € \        4       p\        4       ;_uu_ 4       pVP                  RV 34       Uu/ uF  qDR,          VR,          bK  	  pp. p^ p\        V4       Fr  w  r‰\	        V	R,          4      p
VP                  V
4       \        W0V
4       \        P                  ! V	RR7      pWsP                  RW‹W W¨V34      P                  ,          pKt  	  V'       d\   RP                  R	\        V4      ,          4      pWsP                  R
P                  V4      V .V,           4      P                  ,          pM#WsP                  RV 34      P                  ,          pV'       d»   \        W0R4       \        V4       F^  w  rŠW¥9  d&   \        VRRP                  W
4      RRRVRV/4       K0  WZ,          V8w  g   K?  \        VRRP                  W
4      RV/4       K`  	  \        V4      \        V4      ,
           F"  p
\        VRRP                  W
4      RR/4       K$  	  RRR4       R# u upi   + '       g   i     R# ; i)zLMake `entries` (legacy dicts with 'id') the whole list, keeping their order.zESELECT tmdb_id, list_pos FROM titles WHERE media_type=? AND in_list=1r—   Úlist_posr§   F©Úensure_asciiz¿UPDATE titles SET in_list=1, list_pos=?, legacy_json=?, list_added_at=COALESCE(list_added_at, ?) WHERE media_type=? AND tmdb_id=? AND (in_list!=1 OR list_pos IS NOT ? OR legacy_json IS NOT ?)Ú,Ú?zcUPDATE titles SET in_list=0, list_pos=NULL WHERE media_type=? AND in_list=1 AND tmdb_id NOT IN ({})zKUPDATE titles SET in_list=0, list_pos=NULL WHERE media_type=? AND in_list=1TÚlist_setú{}:{}Úin_listÚposÚadded_atÚ	list_moveN)r�   r}   r)   Ú	enumerater   r­   r¤   r©   ÚdumpsÚrowcountr   Úlenr;   rŠ   r’   r#   )rˆ   ÚentriesÚnowr,   r·   ÚbeforeÚkeeprv   rÂ   r¯   r—   ÚencodedÚmarkss   &&           r   Úreplace_listrÏ   1  s#  € ä
‹&€CÜ	�Œ�Ø7;·|±|ØSÐV`ÐUbô8dó eñ 8d°!�I•,  *¥Ò-ñ 8dˆð eàˆØˆÜ# GÖ,‰JˆCÜ˜% �+Ó&ˆGØ�K‰K˜Ô Ü˜$¨GÔ4Ü—j’j °UÔ;ˆGØ—|‘|ð %Yð ¨¸ÀwÐOóQ÷ RZÑQYõZŠGñ -÷ Ø—H‘H˜S¤3 t£9�_Ó-ˆEØ—|‘|ð %3ß39±6¸%³=À:À,ÐQUÕBUóWßW_ÑW_õ`‰Gð —|‘|Ð$qÐt~ð  tAó  B÷  Kñ  Kõ  KˆGßÜ˜¨4Ô0Ü )¨$¦‘�ØÔ(Ü˜D *¨g¯n©n¸ZÓ.QÐT]Ð_cÐejÐloÐq{ð  ~Að  TBö  CØ•_¨Ö+Ü˜D +¨w¯~©~¸jÓ/RÐUZÐ\_ÐT`Öañ	 !0ô
 ˜v›;¬¨T«×2Ð2�Ü˜˜j¨'¯.©.¸Ó*MÐPYÐ[`ÐOaÖbñ 3÷7 
‰ùòe÷ 
�ˆús2   �H*³H%ÁBH*ÃBH*Å!AH*Æ7A$H*È%H*È*H;	c                ó~  € \        4       p\        4       ;_uu_ 4       p\        WPV4       V'       ds   VP                  RV 34      P	                  4       ^ ,          pTP                  RYdV'       d   \
        P                  ! VRR7      MRV \        V4      34      P                  pM)RpVP                  RV \        V4      34      P                  pV'       dM   \        WPR4       \        TRR	P                  V \        V4      4      R
\        V4      RTRV'       d   TMR/4       RRR4       R#   + '       g   i     R# ; i)zUAdd / remove one title. Added titles go to the end of the list (like the old append).zSSELECT COALESCE(MAX(list_pos), -1) + 1 FROM titles WHERE media_type=? AND in_list=1z�UPDATE titles SET in_list=1, list_pos=?, list_added_at=?, legacy_json=COALESCE(?, legacy_json) WHERE media_type=? AND tmdb_id=? AND in_list=0Fr»   NzZUPDATE titles SET in_list=0, list_pos=NULL WHERE media_type=? AND tmdb_id=? AND in_list!=0Tr¿   rÀ   rÁ   rÂ   rÃ   )r�   r}   r¤   r)   r2   r©   rÆ   r   rÇ   rŠ   r’   r;   Úbool)rˆ   r—   rÁ   ÚlegacyrÊ   r,   Úendrv   s   &&&&    r   Úset_in_listrÔ   S  s	  € ä
‹&€CÜ	�Œ�Ü�d¨Ô0ßØ—,‘,ÐtØ *˜}ó.ß.6©h«j¸õ<ˆCà—l‘lð $JàÏf¤D§J¢J¨vÀEÕ$JÐZ^Ð`jÔloÐpwÓlxÐyó{÷ |Dñ  |Dñ ð ˆCØ—l‘lÐ#Ø$¤c¨'£lÐ3ó5ß5=±Xð çÜ˜¨4Ô0Ü�D˜* g§n¡n°ZÄÀWÃÓ&NØ¤ W£¨u°c¸:ÏgÁsÐ[_Ð`ôb÷ 
��Šús   �B7D+ÃAD+Ä+D<	c                 óð   € \        4       p VP                  R V \        V4      34      P                  4       pVP	                  4        \        T;'       d
    VR,          4      #   TP	                  4        i ; i)z;SELECT in_list FROM titles WHERE media_type=? AND tmdb_id=?rÁ   )r"   r)   r   r2   rR   rÑ   ©rˆ   r—   r,   r@   s   &&  r   Ú
is_in_listr×   h  sd   € Ü‹9€DðØ�l‰lÐXØ&¬¨G«Ð5ó7ß7?±x³zð 	ð 	�
‰
ŒÜ�×&Ð&˜˜I�Ó'Ð'øð 	�
‰
�ús   Œ+A# Á#A5c           	      óÌ   € V R 8X  d   RR\        V4      3R\        V4      33# RR\        V4      \        V4      \        V4      3R\        V4      \        V4      \        V4      33# )r”   Úmovie_statez	tmdb_id=?Úepisode_statez$show_id=? AND season=? AND episode=?)r—   )Úshow_idr˜   r™   )r   r–   s   &&&&r   r�   r�   t  sl   € Ø�WÔØ˜k¬C°«L¨?¸LÌ3ÈwË<È/ÐYÐYØÐCÄcÈ'ÃlÔTWÐX^ÓT_ÔadÐelÓamÐEnØ,¬s°7«|¼SÀ»[Ì#ÈgË,Ð.WðYð Yr   c                 óÈ   € \        WW44      w  rVrxp	V P                  R P                  VRP                  V4      RP                  R\	        V4      ,          4      4      V	4       R# )z'INSERT OR IGNORE INTO {}({}) VALUES({})r½   r¾   N)r�   r)   r;   r   rÈ   )
r,   rˆ   r—   r˜   r™   rB   Ú_whereÚ_argsÚcolsÚvalss
   &&&&&     r   Ú_ensure_staterá   {  sV   € Ü'2°:ÈÓ'XÑ$€E�5 Ø‡L�LÐ:×AÑAÀ%ÈÏÉÐRVËÐY\×YaÑYaÐbeÔhkÐlpÓhqÕbqÓYrÓsÐuyÖzr   c                 ón   € \        WV4       V P                  R W1\        V4      34       \        W4       R# )zcUPDATE titles SET last_activity_at=?, hidden_from_continue_at=NULL WHERE media_type=? AND tmdb_id=?N)r¤   r)   r   rŠ   )r,   rˆ   r—   Úwhens   &&&&r   Ú_touchrä   €  s/   € Ü�$ GÔ,Ø‡L�LÐvØ¤C¨£LÐ1ô3ä�Ö"r   c                 ó
  € \        WW#4      w  rErgp\        4       p	 V	P                  R P                  WE4      V4      P	                  4       p
V	P                  4        V
'       d   \        V
4      # R#   T	P                  4        i ; i)zSELECT * FROM {} WHERE {}N)r�   r"   r)   r;   r2   rR   Údict)rˆ   r—   r˜   r™   rB   rž   rŸ   r    r¡   r,   r@   s   &&&&       r   Ú	get_staterç   ‡  sm   € Ü'2°:ÈÓ'XÑ$€E�$˜uÜ‹9€DðØ�l‰lÐ6×=Ñ=¸eÓKÈTÓR×[Ñ[Ó]ˆà�
‰
ŒßŒ4�‹9Ð% Ð%øð 	�
‰
�ús   œ/A0 Á0Bc                 óî   € \        4       p  V P                  R4      P                  4       pV P                  4        V Uu/ uF  q"R,          \	        V4      bK  	  up#   T P                  4        i ; iu upi )z7{tmdb_id: movie_state row} of every movie with a state.zSELECT * FROM movie_stater—   ©r"   r)   r¨   rR   ræ   ©r,   r„   r·   s      r   Úget_movie_statesrë   ‘  s^   € ä‹9€DðØ�|‰|Ð7Ó8×AÑAÓCˆà�
‰
ŒÙ+/Ó0©4 aˆi�Lœ$˜q›'Ò!©4Ñ0Ð0øð 	�
‰
�üÚ0s   ŒA ¿A2ÁA/c                 ó$  € \        4       p  V P                  R4      P                  4       pV P                  4        / pV F8  p\	        V4      VP                  VR,          / 4      VR,          VR,          3&   K:  	  V#   T P                  4        i ; i)zM{show_id: {(season, episode): episode_state row}} for every show with states.zSELECT * FROM episode_staterÛ   r˜   r™   )r"   r)   r¨   rR   ræ   r¬   )r,   r„   r®   r·   s       r   Úget_all_episode_statesrí   ›  s}   € ä‹9€DðØ�|‰|Ð9Ó:×CÑCÓEˆà�
‰
ŒØ€FÛˆÜKOÐPQË7ˆ×Ñ˜!˜I�,¨Ó+¨Q¨x­[¸!¸I½,Ð,GÓHñ à€Møð	 	�
‰
�ús   ŒA= Á=Bc                 óö   € \        4       p VP                  R \        V 4      34      P                  4       pVP	                  4        V Uu. uF  p\        V4      NK  	  up#   TP	                  4        i ; iu upi )zDSELECT * FROM episode_state WHERE show_id=? ORDER BY season, episode)r"   r)   r   r¨   rR   ræ   )rÛ   r,   r„   r·   s   &   r   Úget_episode_statesrï   ¨  se   € Ü‹9€DðØ�|‰|ÐbÜ  ›\˜Oó-ß-5©X«Zð 	ð 	�
‰
ŒÙ!Ó"™T˜ŒD�ŽG™TÑ"Ð"øð 	�
‰
�üÚ"s   Œ*A! Á
A6Á!A3c                ód  € T;'       g    \        4       p\        WWE4      w  r‰r«pT;'       g    / p\        4       ;_uu_ 4       p\        WÐWV4       VP	                  RP                  W‰4      \        V4      \        V4      WvP                  R4      VP                  R4      VP                  R4      3V
,           \        V4      \        V4      VP                  R4      VP                  R4      VP                  R4      3,           4      P                  pV'       d{   \        WÐW4       \        WÐWV4       \        VR\        WWE4      R\        V4      R\        V4      RVP                  R4      RVP                  R4      RVP                  R4      /4       RRR4       R#   + '       g   i     R# ; i)	zcIn-progress position; also records the source file used (`source` = dict ident/provider/file_name).ax  UPDATE {} SET resume_pos=?, resume_total=?, last_played_at=?, last_ident=COALESCE(?, last_ident), last_provider=COALESCE(?, last_provider), last_file_name=COALESCE(?, last_file_name) WHERE {} AND (resume_pos!=? OR resume_total!=? OR COALESCE(?,last_ident) IS NOT last_ident OR COALESCE(?,last_provider) IS NOT last_provider OR COALESCE(?,last_file_name) IS NOT last_file_name)ÚidentÚproviderÚ	file_nameÚprogressrÂ   ÚtotalN)r�   r�   r}   rá   r)   r;   ÚfloatrW   rÇ   rä   r¢   r’   rš   )rˆ   r—   Úpositionrõ   r˜   r™   Úsourcerã   rB   rž   rŸ   r    r¡   r,   rv   s   &&&&&&&&       r   Úsave_resumerù   ²  s‚  € à�>ˆ>”4“6€DÜ'2°:ÈÓ'XÑ$€E�$˜uØ�\ˆ\�r€FÜ	�Œ�Ü�d¨¸ÔAØ—,‘,ð  ~÷ Eñ  Eð  FKó  SÜ˜H“o¤u¨U£|°T¿:¹:ÀgÓ;NÐPV×PZÑPZÐ[eÓPfØ—j‘j Ó-ð/Ø15õ6Ü9>¸x»Ì%ÐPUË,ÐX^×XbÑXbÐcjÓXkØ8>¿
¹
À:Ó8NÐPV×PZÑPZÐ[fÓPgð9iõió	j÷ ksÑjrð 	÷ Ü�4 WÔ3Ü�T w¸Ô@Ü�D˜*¤j°ÀfÓ&VØœE (›O¨W´e¸E³lÀGÈVÏZÉZÐX_ÓM`Ø §¡¨JÓ!7¸ÀfÇjÁjÐQ\ÓF]ð_ô`÷ 
��Šús   ÁEFÆF/	c                óV  € T;'       g    \        4       p\        WW#4      w  rgr‰p
T;'       g    / p\        4       ;_uu_ 4       p\        W°WV4       VP	                  RP                  Wg4      WEP                  R4      VP                  R4      VP                  R4      3V,           4       \        W°W4       \        W°WV4       \        VR\        WW#4      RVP                  R4      RVP                  R4      RVP                  R4      /4       RRR4       R#   + '       g   i     R# ; i)z'Watched: playcount + 1, resume cleared.zÖUPDATE {} SET playcount=playcount+1, resume_pos=0, resume_total=0, last_played_at=?, last_ident=COALESCE(?, last_ident), last_provider=COALESCE(?, last_provider), last_file_name=COALESCE(?, last_file_name) WHERE {}rñ   rò   ró   ÚwatchedN)r�   r�   r}   rá   r)   r;   rW   rä   r¢   r’   rš   )rˆ   r—   r˜   r™   rã   rø   rB   rž   rŸ   r    r¡   r,   s   &&&&&&      r   Úmark_watchedrü   È  sö   € à�>ˆ>”4“6€DÜ'2°:ÈÓ'XÑ$€E�$˜uØ�\ˆ\�r€FÜ	�Œ�Ü�d¨¸ÔAØ�‰ð KçKQÉ6ÐRWÓK_ØŸJ™J wÓ/°·±¸JÓ1GÈÏÉÐT_ÓI`ÐaÐdhÕhô	jô 	ˆt Ô/Ü� 7°GÔ<Ü��i¤¨JÀÓ!QØ˜&Ÿ*™* WÓ-¨z¸6¿:¹:ÀjÓ;QÐS^Ð`f×`jÑ`jÐkvÓ`wÐxô	z÷ 
��Šús   ÁC
DÄD(	c                óh  € T;'       g    \        4       p\        WW#4      w  rVrxp	\        4       ;_uu_ 4       p
\        W WV4       V
P	                  RP                  WV4      V4       \        W W4       \        W WV4       \        V
R\        WW#4      4       RRR4       R#   + '       g   i     R# ; i)z*Unwatched: playcount 0 and resume cleared.z@UPDATE {} SET playcount=0, resume_pos=0, resume_total=0 WHERE {}Ú	unwatchedN)
r�   r�   r}   rá   r)   r;   rä   r¢   r’   rš   )rˆ   r—   r˜   r™   rã   rB   rž   rŸ   r    r¡   r,   s   &&&&&      r   Úmark_unwatchedrÿ   Ù  sˆ   € à�>ˆ>”4“6€DÜ'2°:ÈÓ'XÑ$€E�$˜uÜ	�Œ�Ü�d¨¸ÔAØ�‰ÐW×^Ñ^Ð_dÓlÐnrÔsÜˆt Ô/Ü� 7°GÔ<Ü��k¤:¨jÀ6Ó#SÔT÷ 
��Šús   ·AB Â B1	c                 óH  € \        WW#4      w  rErgp\        4       ;_uu_ 4       p	V	P                  R P                  WE4      V4      P                  p
V
'       d0   \        W�4       \        W�WV4       \        V	R\        WW#4      4       RRR4       R#   + '       g   i     R# ; i)zZUPDATE {} SET resume_pos=0, resume_total=0 WHERE {} AND (resume_pos!=0 OR resume_total!=0)Úclear_resumeN)	r�   r}   r)   r;   rÇ   rŠ   r¢   r’   rš   )rˆ   r—   r˜   r™   rB   rž   rŸ   r    r¡   r,   rv   s   &&&&       r   r  r  å  s   € Ü'2°:ÈÓ'XÑ$€E�$˜uÜ	�Œ�Ø—,‘,ð  HßHNÉÈuÓH\Ð^bódßdlÑdlð 	çÜ˜Ô*Ü�T w¸Ô@Ü�D˜.¬*°ZÈ&Ó*ZÔ[÷ 
��Šús   £A#BÂB!	c                ón  € T;'       g    \        4       p^ p. p\        4       ;_uu_ 4       pVe3   VP                  RV34      P                  4       '       g    RRR4       ^ # V R8X  d   RMRp	V R8X  d7   VP                  R\	        V4      34       U
u/ uF  p
R\        V
4      bK  	  up
MDVP                  R\	        V4      34       U
u/ uF  qªR,          V
R	,          3\        V
4      bK   	  up
p\        V4       EF1  w  rÍVP                  WÍ34      ;'       g    / p\	        VP                  R
4      ;'       g    ^ 4      ^ 8„  pV'       d	   V'       g;   V'       g5   V'       g-   \        VP                  R4      ;'       g    ^ 4      '       g   K•  \        W€WV4       \        WWÍ4      w  pppppV'       d,   VP                  RP                  V	V4      V3V,           4       M"VP                  RP                  V	V4      V4       \        W€WV4       VP                  WÍ.4       V^,          pEK4  	  V'       dA   \        W€W4       \        VRRP                  V \	        V4      4      RVR\!        V4      /4       Ve   VP                  RV34       RRR4       V# u up
i u up
i   + '       g   i     T# ; i)zZManual mark: one transaction, no network/RPC, and no second playcount for a repeated mark.Nz&SELECT 1 FROM pending_marks WHERE id=?r”   rÙ   rÚ   z)SELECT * FROM movie_state WHERE tmdb_id=?z+SELECT * FROM episode_state WHERE show_id=?r˜   r™   Ú	playcountÚ
resume_poszOUPDATE {} SET playcount=1,resume_pos=0,resume_total=0,last_played_at=? WHERE {}z>UPDATE {} SET playcount=0,resume_pos=0,resume_total=0 WHERE {}Ú	mark_manyrÀ   Útargetsrû   z$DELETE FROM pending_marks WHERE id=?©NN)r�   r}   r)   r2   r   ræ   r#   rW   rö   rá   r�   r;   r¢   r­   rä   r’   rÑ   )rˆ   r—   r  rû   rã   Ú
pending_idrv   Úmarkedr,   rB   r·   Úexistingr˜   r™   rŒ   ÚplayedÚ_tablerž   rŸ   r    r¡   s   &&&&&&               r   r  r  ð  sŽ  € à�>ˆ>”4“6€DØ€GØ€FÜ	�Œ�ØÒ!¨$¯,©,Ð7_ÐblÐanÓ*o×*xÑ*x×*zÒ*zØ÷ 
‰ð ",¨wÔ!6‘¸Oˆà! WÔ,ð 59·L±LÐAlÔorÐszÓo{Ðn}Ô4~ÓÑ4~¨q�\¤4¨£7Ò*Ñ4~ÒàCGÇ<Á<ØEÌÈGËÀôDXó Yñ DX¸a˜•k 1 Y¥<Ð0´$°q³'Ò9ñ DXñ Yð 	ô  # 7Ÿ|‰OˆFØ—L‘L &Ð!2Ó3×9Ð9°rˆEÜ˜Ÿ™ ;Ó/×4Ð4°1Ó5¸Ñ9ˆFßŸF¯G¿FÌ5ÐQV×QZÑQZÐ[gÓQh×QmÐQmÐlm×KnÒKnÙÜ˜$¨G¸WÔEÜ0;¸JÐQWÓ0aÑ-ˆF�E˜4 ¨ßØ—‘Ðn×uÑuÐv{ð  ~Có  Dð  GKð  FMð  PTõ  FTõ  Uà—‘Ð]×dÑdÐejÐlqÓrÐtxÔyÜ�T w¸Ô@Ø�M‰M˜6Ð+Ô,Ø�q�L‹Gñ  ,÷ Ü�4 WÔ3Ü�D˜+ w§~¡~°jÄ#ÀgÃ,Ó'OÐR[Ð]cÐenÔptÐu|Óp}ÐQ~ÔØÒ!Ø�L‰LÐ?À*ÀÔO÷5 
ð6 €Nùò/ @ùòY÷ 
Žð6 €Núsh   «+J#ÁJ#Á"0J#ÂJÂ'!J#Ã$JÃ,AJ#Ä9J#ÅJ#ÅJ#ÅJ#Å#J#Æ J#ÆB*J#È8AJ#Ê
J#Ê#J4	c	                 óÀ   € \        4       ;_uu_ 4       p	V	P                  R V \        V4      W#WEWgV3	4       \        V	R04       RRR4       R#   + '       g   i     R# ; i)z|INSERT INTO play_log(media_type,tmdb_id,season,episode,started_at,ended_at,position,total,outcome) VALUES(?,?,?,?,?,?,?,?,?)Úrecent_playedN)r}   r)   r   r…   )
rˆ   r—   r˜   r™   Ú
started_atÚended_atr÷   rõ   Úoutcomer,   s
   &&&&&&&&& r   Úlog_playr    sN   € Ü	�Œ�Ø�‰ð 1à ¤# g£,°ÀÐW_ÐhoÐpô	rô 	ˆd�_Ð%Ô&÷	 
��Šús   “/AÁA	c                ó  € \        4       ;_uu_ 4       p^ RIpVP                  RV \        V4      W#WFP	                  4       P
                  34      p\        VR04       VP                  uuRRR4       #   + '       g   i     R# ; i)znOpen a play_log row (ended_at NULL); returns its id. An open row after a crash is closed by close_open_logs().Nz[INSERT INTO play_log(media_type,tmdb_id,season,episode,started_at,uuid) VALUES(?,?,?,?,?,?)r  )r}   Úuuidr)   r   Úuuid4Úhexr…   Ú	lastrowid)rˆ   r—   r˜   r™   r  r,   r  Úcurs   &&&&&   r   Ú	log_startr    s_   € ä	�Œ�ÛØ�l‰lÐxØ&¬¨G«°fÀz×S]ÑS]ÓS_×ScÑScÐdófˆäˆd�_Ð%Ô&Ø�}‰}÷ 
��‹ús   “AA2Á2B	c                 óŒ   € \        4       ;_uu_ 4       pVP                  R WV 34       RRR4       R#   + '       g   i     R# ; i)z2UPDATE play_log SET position=?, total=? WHERE id=?N)r}   r)   )Úrow_idr÷   rõ   r,   s   &&& r   Ú
log_updater  %  s,   € Ü	�Œ�Ø�‰ÐIÈHÐ]cÐKdÔe÷ 
��Šús	   “2²A	c                 óÊ  € \        4       ;_uu_ 4       pVP                  R WW4V 34       VP                  RV 34      P                  4       pV'       dv   VR,          '       dg   \        VRVR,          RVR,          RVR,          RVR,          R	VR	,          R
VR
,          RVR,          RVR,          RVR,          RVR,          /	4       RRR4       R#   + '       g   i     R# ; i)zIUPDATE play_log SET ended_at=?, position=?, total=?, outcome=? WHERE id=?z!SELECT * FROM play_log WHERE id=?r  Úplay_log_addÚmediarˆ   r§   r—   r˜   r™   r  r  r÷   rõ   r  N)r}   r)   r2   r’   )r  r  r÷   rõ   r  r,   r@   s   &&&&&  r   Ú
log_finishr   *  sÆ   € Ü	�Œ�Ø�‰Ð`Ø¨%¸&ÐAô	Cà�l‰lÐ>ÀÀ	ÓJ×SÑSÓUˆß�3�v—;”;Ü�D˜.¨#¨f­+Ø˜˜\Õ*¨D°#°iµ.À(ÈCÐPXÍMÐ[dÐfiÐjsÕftØ˜c ,Õ/°¸SÀ½_ÈjÐZ]Ð^hÕZiØ˜˜W� y°#°iµ.ð8Bô C÷ 
��Šús   “ACÁ!A&CÃC"	c                óÆ   € \        4       ;_uu_ 4       pTP                  RT ;'       g    \        4       34      pVP                  uuRRR4       #   + '       g   i     R# ; i)zfService start: rows left open by a crash / power loss get outcome 'crash' (their last position stays).zFUPDATE play_log SET ended_at=?, outcome='crash' WHERE ended_at IS NULLN)r}   r)   r�   rÇ   )rã   r,   r  s   &  r   Úclose_open_logsr"  6  s=   € ä	�Œ�Ø�l‰lÐcØ ŸN˜N¤D£FÐ,ó.ˆà�|‰|÷ 
��‹ús   “1AÁA 	c                 óä   € \        4       p VP                  R V 34      P                  4       pVP                  4        V Uu. uF  p\	        V4      NK  	  up#   TP                  4        i ; iu upi )z/SELECT * FROM play_log ORDER BY id DESC LIMIT ?ré   )Úlimitr,   r„   r·   s   &   r   Úrecent_logsr%  >  s\   € Ü‹9€DðØ�|‰|ÐMÐPUÈxÓX×aÑaÓcˆà�
‰
ŒÙ!Ó"™T˜ŒD�ŽG™TÑ"Ð"øð 	�
‰
�üÚ"s   Œ!A ÁA-ÁA*c                 óÀ  € \        4       ;_uu_ 4       p\        W@V4       TP                  R P                  V'       d   RMR4      V'       d   T;'       g    \	        4       MRV \        V4      34      P                  pV'       d>   \        W@4       \        VRRP                  V \        V4      4      R\        V4      /4       RRR4       R#   + '       g   i     R# ; i)zrUPDATE titles SET hidden_from_continue_at=? WHERE media_type=? AND tmdb_id=? AND hidden_from_continue_at IS {}NULLÚ zNOT NÚhide_continuerÀ   Úhidden)
r}   r¤   r)   r;   r�   r   rÇ   rŠ   r’   rÑ   )rˆ   r—   r)  rã   r,   rv   s   &&&&  r   Úset_hidden_from_continuer*  G  s¡   € Ü	�Œ�Ü�d¨Ô0Ø—,‘,ð  GßGMÁv×TZÉbÐ`fÓGgß*0�t—~�~œt›vø°d¸JÌÈGËÐUóWçW_ÑW_ð 	÷ Ü˜Ô*Ü�D˜/¨7¯>©>¸*ÄcÈ'ÃlÓ+SÐV^Ô`dÐekÓ`lÐUmÔn÷ 
��Šús   “9CÁCÁA,CÃC	c            	     óP  € \        4       p  V P                  R4       Uu. uF  pRV^ ,          RR3NK  	  ppY P                  R4       Uu. uF  pRV^ ,          V^,          V^,          3NK   	  up,          pV P                  4        V# u upi u upi   T P                  4        i ; i)zX[('movie', id, None, None), ('tv', show, season, episode)] for every stored watch state.zSELECT tmdb_id FROM movie_stater”   Nz2SELECT show_id, season, episode FROM episode_stateÚtv)r"   r)   rR   )r,   r·   Úkeyss      r   Úall_state_keysr.  R  s•   € ä‹9€DðØ59·\±\ÐBcÔ5dÓeÑ5d°�˜!˜A�$  dÓ+Ñ5dˆÐeØ·<±<Ð@tÔ3uÓvÑ3u¨a�$˜˜!�˜a �d A a¥DÓ)Ñ3uÑvÕvˆà�
‰
ŒØ€Kùò	 fùÚvøà�
‰
�ús'   ŒB ŸB	µB Á
$BÁ.	B Â	
B ÂB%c            
     óü  € \        4       ;_uu_ 4       p RV P                  R4      P                  4       ^ ,          RV P                  R4      P                  4       ^ ,          RV P                  R4      P                  4       ^ ,          /pR F#  pV P                  RP                  V4      4       K%  	  V P                  R4       ^ R	IHp \        W4       \        V R
R4       RRR4       V#   + '       g   i     X# ; i)zeDelete every watched / resume state and the play log; the lists stay. Returns the removed row counts.Úmoviesz SELECT COUNT(*) FROM movie_stateÚepisodesz"SELECT COUNT(*) FROM episode_stateÚplayszSELECT COUNT(*) FROM play_logzDELETE FROM {}zEUPDATE titles SET last_activity_at=NULL, hidden_from_continue_at=NULL)ÚALL_ROWSÚreset_watchÚuserN)rÙ   rÚ   Úplay_logÚpending_marks)r}   r)   r2   r;   rp   r3  r…   r’   )r,   ÚcountsrB   r3  s       r   Úreset_watch_stater9  ]  sÒ   € ä	�Œ�Ø˜DŸL™LÐ)KÓL×UÑUÓWÐXYÕZØ˜dŸl™lÐ+OÓP×YÑYÓ[Ð\]Õ^Ø˜4Ÿ<™<Ð(GÓH×QÑQÓSÐTUÕVðXˆó SˆEØ�L‰LÐ)×0Ñ0°Ó7Ö8ñ Sà�‰Ð\Ô]Ý-ÜˆdÔÜ��m VÔ,÷ 
ð €M÷ 
Žð €Mús   “CC*Ã*C;	c                 óâ   € \        4       p VP                  R V \        V4      34      P                  4       pVP	                  4        V'       d   \        V4      # R#   TP	                  4        i ; i)z5SELECT * FROM titles WHERE media_type=? AND tmdb_id=?N)r"   r)   r   r2   rR   ræ   rÖ   s   &&  r   Ú	get_titler;  l  s^   € Ü‹9€DðØ�l‰lÐRØ&¬¨G«Ð5ó7ß7?±x³zð 	ð 	�
‰
ŒßŒ4�‹9Ð% Ð%øð 	�
‰
�ús   Œ+A ÁA.c                ó$  € Ve&   V\         9  d   \        RP                  V4      4      h\        4       ;_uu_ 4       pVfU   VP	                  RV \        V4      34      P                  '       d'   \        VRRP                  V \        V4      4      4       M_TP	                  RT \        V4      T\        Ve   TM	\        4       4      34       \        VRRP                  V \        V4      4      RV/4       RRR4       R#   + '       g   i     R# ; i)	zflike / dislike / hide (not interested) / pick (first-run favourite); None clears the title's feedback.NzUnknown feedback {!r}z5DELETE FROM feedback WHERE media_type=? AND tmdb_id=?Úfeedback_clearrÀ   zOINSERT OR REPLACE INTO feedback(media_type, tmdb_id, value, at) VALUES(?,?,?,?)Úfeedback_setÚvalue)	ÚFEEDBACK_VALUESr«   r;   r}   r)   r   rÇ   r’   r�   )rˆ   r—   r?  rã   r,   s   &&&& r   Úset_feedbackrA  {  sÖ   € àÒ˜U¬/Ô9ÜÐ0×7Ñ7¸Ó>Ó?Ð?Ü	�Œ�ØŠ=Ø�|‰|ÐSÐV`ÔbeÐfmÓbnÐUoÓp×y×yÐyÜ˜Ð.°·±¸zÌ3ÈwË<Ó0XÔYøà�L‰LÐjØ$¤c¨'£l°E¼3ÀtÒGW¹tÔ]aÓ]cÓ;dÐeôgä�D˜.¨'¯.©.¸ÄSÈÃ\Ó*RÐU\Ð^cÐTdÔe÷ 
��Šús   ¼B8C>Ã>D	c                 ó<  € \        4       ;_uu_ 4       p V P                  R4      P                  4        F.  p\        V RRP	                  VR,          VR,          4      4       K0  	  V P                  R4      P
                  uuRRR4       #   + '       g   i     R# ; i)zfDelete the likes and the first-run picks, so Pro tebe offers the pick again; dislikes and hidden stay.zHSELECT media_type, tmdb_id FROM feedback WHERE value IN ('like', 'pick')r=  rÀ   rˆ   r—   z4DELETE FROM feedback WHERE value IN ('like', 'pick')N)r}   r)   r¨   r’   r;   rÇ   )r,   r@   s     r   Úreset_tasterC  ‰  sj   € ä	�Œ�Ø—<‘<Ð jÓk×tÑtÖvˆCÜ�DÐ*¨G¯N©N¸3¸|Õ;LÈcÐR[ÍnÓ,]Ö^ñ wà�|‰|ÐRÓS×\Ñ\÷ 
��‹ús   “A,B
Â
B	c                 ó  € \        4       p  V P                  R4      P                  4       pV P                  4        V Uu/ uF%  q"R,          VR,          3VR,          VR,          3bK'  	  up#   T P                  4        i ; iu upi )zB{(media_type, tmdb_id): (value, at)} of every title with feedback.z3SELECT media_type, tmdb_id, value, at FROM feedbackrˆ   r—   r?  Úatr¶   rê   s      r   Úget_feedbackrF  ‘  sp   € ä‹9€DðØ�|‰|ÐQÓR×[Ñ[Ó]ˆà�
‰
ŒÙLPÓQÉDÀqˆ|�_˜a 	�lÐ+¨a°­j¸!¸D½'Ð-BÒBÉDÑQÐQøð 	�
‰
�üÚQs   ŒA- ¿+BÁ-A?c                 óÊ   € \        4       p VP                  R V 34      P                  4       pVP                  4        V'       d
   VR,          # R#   TP                  4        i ; i)z#SELECT value FROM flags WHERE key=?r?  N)r"   r)   r2   rR   )rh   r,   r@   s   &  r   Úget_flagrH  �  sQ   € Ü‹9€DðØ�l‰lÐ@À3À&ÓI×RÑRÓTˆà�
‰
Œßˆ3ˆw�<Ð( DÐ(øð 	�
‰
�ús   Œ!A ÁA"c           	      óž   € \        4       ;_uu_ 4       pVP                  R V \        V4      34       RRR4       R#   + '       g   i     R# ; i)z5INSERT OR REPLACE INTO flags(key, value) VALUES(?, ?)N)r}   r)   ro   )rh   r?  r,   s   && r   Úset_flagrJ  ¦  s2   € Ü	�Œ�Ø�‰ÐLÈsÔTWÐX]ÓT^ÐN_Ô`÷ 
��Šús	   “;»A	rH   )Fr  )NNNN)NNN)TNN)é   )ÚlikeÚdislikeÚhideÚpick)?ry   r©   r   r!   r€   r3   r   r   r   r   r4   r7   r8   r9   r:   Ú
Connectionr   r"   r*   rC   r]   r_   r}   r�   r…   rŠ   r’   rš   r¢   r¤   r°   r¸   rÏ   rÔ   r×   r�   rá   rä   rç   rë   rí   rï   rù   rü   rÿ   r  r  r  r  r  r   r"  r%  r*  r.  r9  r;  r@  rA  rC  rF  rH  rJ  r   r   r   Ú<module>rQ     sk  ðñó
 Û 	Û Û à€Ø
€Ø€òòoð€	ð<€	ð€	ð€	ð€	ô	�'×$Ñ$ô 	ôò"òD!ò÷>ñ ôDòò"ô
4ô
.ô~ôdòoòò&jòcôDbò*(ôYò{ò
#ô&ò1ò
ò#ô`ô,zô"	Uô\ô òF'òòfò
	Côô#ôoòòò&ð 6€ôfò]òRò)ôar   