§
   —­Ò€¥‹€ã                   ó–   — d Z ddlZddlmZ dZdZi Zd„ Zd„ Zd„ Z	d	„ Z
d
„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ ZeeeeedœZdd„Zd„ Zd„ Zd„ ZdS )u�  Pulled account changes â†’ the local copy (docs/plan/milionar-account/020 Â§4).

SQLite entities of one page (watch, library, title, feedback, play_log) are written in ONE store transaction together
with the new cursor; documents (channels, histories, favourites), settings and the onboarding go through wcs.account.docs
and wcs.account.settings_sync afterwards (idempotent). A key with a queued local op is skipped (T6): the push of that op
is answered by the server and the next pull brings the resolved row. Rows only change when values differ, so only the
cards of really changed titles redraw (store.dirty + conn.widget_titles, as for a local change).é    N)Ústate)ÚwatchÚlibraryÚtitleÚfeedbackÚplay_log)ÚprogressÚwatchedÚ	unwatchedÚclear_resumec                 óÈ  — t          ¦   «         }|                      d¦  «        D �]<}|d         |d         }}|t          v r|                     d|f¦  «         Œ4|dk    r|                     d|f¦  «         ŒR|dv r|                     d|f¦  «         Œn|d	k    r|                     d
|f¦  «         ŒŒ|                     d¦  «        r|                     d|f¦  «         Œ¹|dk    r|                     d¦  «         ŒÕ|                     d¦  «        r|                     d|f¦  «         �Œ|                     d¦  «        r|                     d|f¦  «         �Œ1|                     d¦  «        r|                     d|f¦  «         �Œ_|dk    r|                     d|f¦  «         �Œ~|                     d¦  «        r|                     d|f¦  «         �Œ¬|                     d¦  «        r2|                     d|                     d¦  «        d         f¦  «         �Œó|                     d¦  «        r|                     d|f¦  «         �Œ!|dk    r|                     d¦  «         �Œ>|S )z9{(entity, key)} that still have a local op in the outbox.z!SELECT type, key FROM sync_outboxÚtypeÚkeyr   Ú	mark_manyúwatch*)Úlist_setÚ	list_mover   Úhide_continuer   r   Úreset_watch©r   Ú*Úsearch_ÚsearchÚrecent_ÚrecentÚ
ai_recent_Ú	ai_recentÚfavorite_setÚfavoriteÚchannel_progressÚchannel_Úchannelú:r   Úsetting_ÚsettingÚonboarding_set)Ú
onboardingÚuser)ÚsetÚexecuteÚ	WATCH_OPSÚaddÚ
startswithÚsplit)ÚconnÚkeysÚrowÚopr   s        ú_/Users/chudy/Library/Application Support/Kodi/addons/plugin.video.milionar/wcs/account/apply.pyÚpending_keysr4      sƒ  € å‰5Œ5€DØ�|Š|Ð?Ñ@Ô@ð -ñ -ˆØ�f”+˜s 5œzˆCˆØ•ˆ?ˆ?Ø�HŠH�g˜s�^Ñ$Ô$Ð$Ð$Ø�;ÒÐØ�HŠH�h �_Ñ%Ô%Ð%Ð%ØÐ,Ð,Ð,Ø�HŠH�i Ð%Ñ&Ô&Ð&Ð&Ø�?Ò"Ð"Ø�HŠH�g˜s�^Ñ$Ô$Ð$Ð$Ø�]Š]˜:Ñ&Ô&ð 	-Ø�HŠH�j #Ð&Ñ'Ô'Ð'Ð'Ø�=Ò Ð Ø�HŠH�_Ñ%Ô%Ð%Ð%Ø�]Š]˜9Ñ%Ô%ð 	-Ø�HŠH�h �_Ñ%Ô%Ð%Ñ%Ø�]Š]˜9Ñ%Ô%ð 	-Ø�HŠH�h �_Ñ%Ô%Ð%Ñ%Ø�]Š]˜<Ñ(Ô(ð 	-Ø�HŠH�k 3Ð'Ñ(Ô(Ð(Ñ(Ø�>Ò!Ð!Ø�HŠH�j #Ð&Ñ'Ô'Ð'Ñ'Ø�]Š]Ð-Ñ.Ô.ð 	-Ø�HŠHÐ(¨#Ð.Ñ/Ô/Ð/Ñ/Ø�]Š]˜:Ñ&Ô&ð 	-Ø�HŠH�i §¢¨3¡¤°Ô!2Ð3Ñ4Ô4Ð4Ñ4Ø�]Š]˜:Ñ&Ô&ð 	-Ø�HŠH�i Ð%Ñ&Ô&Ð&Ñ&ØÐ#Ò#Ð#Ø�HŠHÐ+Ñ,Ô,Ð,ùØ€Kó    c                 óš   — | |f|v rdS | dk    r<d                      |                     d¦  «        d d…         ¦  «        }d|f|v sd|v rdS dS )NTr   r#   é   r   r   F)Újoinr.   )Úentityr   Úpendingr   s       r3   Ú_pendingr;   7   si   € Ø�€}˜ÐÐØˆtØ�ÒÐØ—’˜Ÿš 3™œ¨¨¨Ô+Ñ,Ô,ˆØ�eÐ Ð'Ð'¨?¸gÐ+EÐ+EØ�4Øˆ5r5   c                 ót   — t          | ||¦  «        rdS t                               | |f¦  «        }|d uo||k     S )NT)r;   ÚackedÚget)r9   r   Úrevr:   Úseens        r3   Ú_skippedrA   A   sD   € Ý�˜˜WÑ%Ô%ð ØˆtÝ�9Š9�f˜c�]Ñ#Ô#€DØ�tÐÐ*  d¢
Ð*r5   c                 ó  — |                       d¦  «                             ¦   «         }	 |r1t          d„ t          j        |d         ¦  «        D ¦   «         ¦  «        nt          ¦   «         S # t
          $ r t          ¦   «         cY S w xY w)zmKeys whose server row was skipped while a local op on them was queued: fetched again once the op is answered.z0SELECT value FROM sync_state WHERE key='skipped'c              3   ó4   K  — | ]}t          |¦  «        V — Œd S )N)Útuple)Ú.0Úks     r3   ú	<genexpr>zskipped_keys.<locals>.<genexpr>L   s(   è è € Ð8Ð8 •5˜‘8”8Ð8Ð8Ð8Ð8Ð8Ð8r5   r   )r*   Úfetchoner)   ÚjsonÚloadsÚ
ValueError)r/   r1   s     r3   Úskipped_keysrL   H   s†   € à
�,Š,ÐIÑ
JÔ
J×
SÒ
SÑ
UÔ
U€CðØ<?ÐJ�sÐ8Ð8¥T¤Z°°A´Ñ%7Ô%7Ð8Ñ8Ô8Ñ8Ô8Ð8ÅSÁUÄUÐJøÝð ð ð Ý‰uŒuˆˆˆðøøøs   ©A A* Á*BÂBc                 ór   — |                       dt          j        t          |¦  «        ¦  «        f¦  «         d S )NzBINSERT OR REPLACE INTO sync_state(key, value) VALUES('skipped', ?))r*   rI   ÚdumpsÚsorted)r/   r0   s     r3   Úsave_skippedrP   Q   s6   € Ø‡L‚LÐUÕX\ÔXbÕciÐjnÑcoÔcoÑXpÔXpÐWrÑsÔsÐsÐsÐsr5   c                 ór   ‡— t          | ¦  «        Št          ˆfd„t          | ¦  «        D ¦   «         ¦  «        S )z-Skipped keys that have no queued op any more.c              3   óV   •K  — | ]#}t          |d          |d         ‰¦  «        °|V — Œ$dS )r   é   N)r;   )rE   rF   r:   s     €r3   rG   zdue_refresh.<locals>.<genexpr>X   s<   øè è € ÐUÐU˜µxÀÀ!ÄÀaÈÄdÈGÑ7TÔ7TÐU�!ÐUÐUÐUÐUÐUÐUr5   )r4   rO   rL   )r/   r:   s    @r3   Údue_refreshrT   U   s;   ø€ å˜4Ñ Ô €GÝÐUÐUÐUÐU�\¨$Ñ/Ô/ÐUÑUÔUÑUÔUÐUr5   c           	      óâ  — |                      d¦  «        }|d         }t          |d         ¦  «        }d x}}	|dk    r8t          |d         ¦  «        t          |d         ¦  «        }	}|dk     s|	dk     rdS |                     ||||	¦  «        \  }
}}}}|r1|                      d                     |
|¦  «        |¦  «        j        }�nk|                     | ||||	¦  «         t          |                     d	¦  «        pd¦  «        |                     d
¦  «        t          |                     d¦  «        pd¦  «        t          |                     d¦  «        pd¦  «        |                     d¦  «        |                     d¦  «        |                     d¦  «        f}|                      d                     |
|¦  «        ||z   |d d…         z   ¦  «        j        }|rX|                     d
¦  «        rC| 	                    | ||¦  «         |                      dt          |d
         ¦  «        ||f¦  «         |r/| 
                    | ||||	¦  «         |                     | |¦  «         t          |¦  «        S )Nr#   r   rS   Útvr7   é   FzdUPDATE {} SET playcount=0, resume_pos=0, resume_total=0 WHERE {} AND (playcount!=0 OR resume_pos!=0)Ú	playcountÚlast_played_atÚ
resume_posÚresume_totalÚ
last_identÚlast_providerÚlast_file_namea0  UPDATE {} SET playcount=?, last_played_at=?, resume_pos=?, resume_total=?, last_ident=COALESCE(?, last_ident), last_provider=COALESCE(?, last_provider), last_file_name=COALESCE(?, last_file_name) WHERE {} AND (playcount IS NOT ? OR last_played_at IS NOT ? OR resume_pos IS NOT ? OR resume_total IS NOT ?)é   ziUPDATE titles SET last_activity_at=MAX(COALESCE(last_activity_at, 0), ?) WHERE media_type=? AND tmdb_id=?)r.   ÚintÚ_state_keysr*   ÚformatÚrowcountÚ_ensure_stater>   ÚfloatÚ_ensure_titleÚ_changedÚ_media_dirtyÚbool)r/   Ústorer   r1   ÚdeletedÚpartsÚmediaÚtmdb_idÚseasonÚepisodeÚtableÚwhereÚargsÚcolsÚvalsÚchangedÚvaluess                    r3   Ú_watchrx   [   sŸ  € Ø�IŠI�c‰NŒN€EØ�!ŒH€EÝ�%˜”(‰mŒm€GØÐ€FˆWØ�‚}€}Ý˜e Aœh™-œ-­¨U°1¬X©¬�ˆØ�AŠ:ˆ:˜ 1š˜Ø�5Ø%*×%6Ò%6°u¸gÀvÈwÑ%WÔ%WÑ"€Eˆ5�$˜˜dØð GØ—,’,ð  AßAGÂÈÈuÑAUÔAUÐW[ñ]ô ]Ü]eð 	‰ð 	×Ò˜D %¨°&¸'ÑBÔBÐBÝ�c—g’g˜kÑ*Ô*Ð/¨aÑ0Ô0°#·'²'Ð:JÑ2KÔ2KÍUÐSV×SZÒSZÐ[gÑShÔShÐSmÐlmÑMnÔMnÝ˜Ÿš Ñ/Ô/Ð4°1Ñ5Ô5°s·w²w¸|Ñ7LÔ7LÈcÏgÊgÐVeÑNfÔNfÐhk×hoÒhoð  qAñ  iBô  iBðCˆà—,’,ðnçntÒntÐuzð  }Bñ  oCô  oCØ�T‰M˜F 2 A 2œJÑ&ñ	(ô (ô )1ð	 	ð
 ð 	G�s—w’wÐ/Ñ0Ô0ð 	GØ×Ò  e¨WÑ5Ô5Ð5Ø�LŠLð  EÝ˜cÐ"2Ô3Ñ4Ô4°e¸WÐEñGô Gð Gàð (Ø�Š�t˜U G¨V°WÑ=Ô=Ð=Ø×Ò˜4 Ñ'Ô'Ð'Ý�‰=Œ=Ðr5   c                 óØ  — |                      d¦  «        d         t          |                      d¦  «        d         ¦  «        }}|                     | ||¦  «         |r|                      d||f¦  «        j        }nÉ|                     d¦  «        }|€k|                      d||f¦  «                             ¦   «         }	|	r|	d         r|	d         n.|                      d|f¦  «                             ¦   «         d         }|                      d	||                     d
¦  «        p|                     ¦   «         |||f¦  «        j        }|r|                     | |d¦  «         t          |¦  «        S )Nr#   r   rS   zZUPDATE titles SET in_list=0, list_pos=NULL WHERE media_type=? AND tmdb_id=? AND in_list!=0Úlist_poszESELECT in_list, list_pos FROM titles WHERE media_type=? AND tmdb_id=?Úin_listzSSELECT 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=COALESCE(list_added_at, ?) WHERE media_type=? AND tmdb_id=? AND (in_list!=1 OR list_pos IS NOT ?)Úlist_added_atT)
r.   r`   rf   r*   rc   r>   rH   Ú_nowrh   ri   )
r/   rj   r   r1   rk   rm   rn   rv   ÚposÚcurrents
             r3   Ú_libraryr€   {   s�  € Ø—Y’Y˜s‘^”^ AÔ&­¨C¯IªI°c©N¬N¸1Ô,=Ñ(>Ô(>ˆ7€EØ	×Ò˜˜e WÑ-Ô-Ð-Øð nØ—,’,Ð{Ø % wÐ/ñ1ô 1Ü19ð 	ˆð �gŠg�jÑ!Ô!ˆØˆ;Ø—l’lÐ#jÐmrÐt{Ðl|Ñ}Ô}÷  Gò  Gñ  Iô  IˆGØ)0ð °W¸YÔ5Gð �'˜*Ô%Ð%ÈTÏ\Ê\ØeÐhmÐgoñNqô NqßqyÒqyÑq{Ôq{Ð|}ôNˆCà—,’,ð  hà # S§W¢W¨_Ñ%=Ô%=Ð%MÀÇÂÁÄÈuÐV]Ð_bÐcñeô eäemð 	ð ð .Ø×Ò˜4 ¨Ñ-Ô-Ð-Ý�‰=Œ=Ðr5   c                 ót  — |                      d¦  «        d         t          |                      d¦  «        d         ¦  «        }}|                     | ||¦  «         |rd n|                     d¦  «        }|                      d||||f¦  «        j        }|r|                     | |¦  «         t          |¦  «        S )Nr#   r   rS   Úhidden_from_continue_atzqUPDATE titles SET hidden_from_continue_at=? WHERE media_type=? AND tmdb_id=? AND hidden_from_continue_at IS NOT ?)r.   r`   rf   r>   r*   rc   rh   ri   )	r/   rj   r   r1   rk   rm   rn   Úhiddenrv   s	            r3   Ú_titler„   �   s½   € Ø—Y’Y˜s‘^”^ AÔ&­¨C¯IªI°c©N¬N¸1Ô,=Ñ(>Ô(>ˆ7€EØ	×Ò˜˜e WÑ-Ô-Ð-ØÐDˆTˆT #§'¢'Ð*CÑ"DÔ"D€FØ�lŠlð BØDJÈEÐSZÐ\bÐCcñeô eÜemð àð (Ø×Ò˜4 Ñ'Ô'Ð'Ý�‰=Œ=Ðr5   c                 ó  — |                      d¦  «        d         t          |                      d¦  «        d         ¦  «        }}|s|                     d¦  «        |j        vr*t	          |                      d||f¦  «        j        ¦  «        S t          |                     d¦  «        pddz  ¦  «        p|                     ¦   «         }t	          |                      d|||d         ||||d         f¦  «        j        ¦  «        S )	Nr#   r   rS   Úvaluez5DELETE FROM feedback WHERE media_type=? AND tmdb_id=?Úatiè  z¥INSERT OR REPLACE INTO feedback(media_type, tmdb_id, value, at) SELECT ?,?,?,? WHERE NOT EXISTS (SELECT 1 FROM feedback WHERE media_type=? AND tmdb_id=? AND value=?))r.   r`   r>   ÚFEEDBACK_VALUESri   r*   rc   r}   )r/   rj   r   r1   rk   rm   rn   r‡   s           r3   Ú	_feedbackr‰   š   sõ   € Ø—Y’Y˜s‘^”^ AÔ&­¨C¯IªI°c©N¬N¸1Ô,=Ñ(>Ô(>ˆ7€EØð v�#—'’'˜'Ñ"Ô"¨%Ô*?Ð?Ð?Ý�D—L’LÐ!XÐ[`ÐbiÐZjÑkÔkÔtÑuÔuÐuÝ	ˆc�gŠg�d‰mŒmÐ ˜q DÑ(Ñ	)Ô	)Ð	9¨U¯ZªZ©\¬\€BÝ�—’ð eà# W¨c°'¬l¸BÀÀwÐPSÐT[ÔP\Ð]ñ_ô _ä_gñiô ið ir5   c                 ó¬  — |rD|                       d|f¦  «        j        }|r|                     | dh¦  «         t          |¦  «        S |                       d|f¦  «                             ¦   «         rdS |                       d|                     d¦  «        |                     d¦  «        |                     d¦  «        |                     d	¦  «        |                     d
¦  «        |                     d¦  «        |                     d¦  «        |                     d¦  «        |                     d¦  «        |f
¦  «         |                     | dh¦  «         dS )Nz!DELETE FROM play_log WHERE uuid=?Úrecent_playedz#SELECT 1 FROM play_log WHERE uuid=?FzƒINSERT INTO play_log(media_type,tmdb_id,season,episode,started_at,ended_at,position,total,outcome,uuid) VALUES(?,?,?,?,?,?,?,?,?,?)Ú
media_typern   ro   rp   Ú
started_atÚended_atÚpositionÚtotalÚoutcomeT)r*   rc   Údirtyri   rH   r>   )r/   rj   r   r1   rk   rv   s         r3   Ú	_play_logr“   ¤   sf  € Øð Ø—,’,ÐBÀSÀFÑKÔKÔTˆØð 	1Ø�KŠK˜˜Ð/Ñ0Ô0Ð0Ý�G‰}Œ}ÐØ‡|‚|Ð9¸C¸6ÑBÔB×KÒKÑMÔMð ØˆuØ‡L‚Lð /Ø14·²¸Ñ1FÔ1FÈÏÊÐPYÑHZÔHZÐ\_×\cÒ\cÐdlÑ\mÔ\mÐor×ovÒovð  xAñ  pBô  pBØ03·²¸Ñ0EÔ0EÀsÇwÂwÈzÑGZÔGZÐ\_×\cÒ\cÐdnÑ\oÔ\oÐqt×qxÒqxð  zAñ  rBô  rBØ03·²¸	Ñ0BÔ0BÀCð1IñJô Jð Jð 
‡K‚K��Ð'Ñ(Ô(Ð(Øˆ4r5   Fc                 óº  — ddl }ddlm} d}g }|                      ¦   «         }i }t          j        ¦   «         5  |                     ¦   «         5 }	|                      ¦   «         |z
  |d<   |rºt                               ¦   «          t          |	t          ¦   «         ¦  «         |	 
                    d¦  «         |	 
                    d¦  «         |	 
                    d¦  «         |	 
                    d¦  «         |	 
                    d	¦  «         dd
lm}
 |                     |	|
¦  «         |rt          ¦   «         nt          |	¦  «        }|rt          ¦   «         nt          |	¦  «        }t          |¦  «        }| D �]!}|                     d¦  «        t#          |                     d¦  «        ¦  «        }}t%          |||¦  «        r|                     ||f¦  «         Œct)          ||t+          |                     d¦  «        pd¦  «        |¦  «        rŒ˜|                     ||f¦  «         |t.          vr|                     |¦  «         ŒÎt/          |         |	|||                     d¦  «        pi t3          |                     d¦  «        ¦  «        ¦  «        r|dz  }�Œ#||k    rt          |	|¦  «         |st5          |	j        ¦  «        dk    r|	j                             ¦   «          |                      ¦   «         |z
  |d<   ddd¦  «         n# 1 swxY w Y   ddd¦  «         n# 1 swxY w Y   |                      ¦   «         |z
  }|s|r ddlm} ||                     ||¬¦  «        z  }|�]|                     ¦   «         5 }	|	 
                    dt#          t+          |¦  «        ¦  «        f¦  «         ddd¦  «         n# 1 swxY w Y   |                      ¦   «         |z
  dk    rddlm} |                      d !                    t5          | ¦  «        ||                     dd¦  «        |                     dd¦  «        |                      ¦   «         |z
  |z
  ¦  «        ¦  «         |S )uÝ   Apply one page of changes, then store `cursor` (None: keep it). Returns the number of changed rows.
    `replace`: a bootstrap (sign-in or resync) â€” every SQL entity's rows are first emptied (the account replaces them).r   N©rj   ÚlockzDELETE FROM movie_statezDELETE FROM episode_statezDELETE FROM play_logzDELETE FROM feedbackz_UPDATE titles SET in_list=0, list_pos=NULL, hidden_from_continue_at=NULL, last_activity_at=NULL)ÚALL_ROWSr9   r   r?   r1   rk   rS   é(   Úrows)Údocs)ÚreplacezAINSERT OR REPLACE INTO sync_state(key, value) VALUES('cursor', ?)g      ð?)ÚclientzVpage of {} changes: library.db {:.1f} s (lock {:.1f}, rows {:.1f}), documents {:.1f} s)"ÚtimeÚwcs.library2rj   r   ÚapplyingÚtxr=   ÚclearrP   r)   r*   Úwcs.skin.refreshr—   r’   r4   rL   r>   Ústrr;   r,   rA   r`   ÚdiscardÚAPPLYÚappendri   ÚlenÚwidget_titlesÚwcs.accountrš   Úapplyrœ   Ú_logrb   )ÚchangesÚcursorr›   r�   rj   rv   rš   ÚstartedÚmarksr/   r—   r:   ÚskippedÚbeforeÚchanger9   r   Úsql_sÚ	documentsrœ   s                       r3   Ú
apply_pagerµ   ·   s  € ð €K€K€KØ"Ð"Ð"Ð"Ð"Ð"Ø€GØ€DØ�iŠi‰kŒk€GØ€EÝ	ŒÑ	Ô	ð !2ð !2Ø�XŠX‰ZŒZð  	2˜4Ø ŸIšI™KœK¨'Ñ1ˆE�&‰MØð 	,Ý—’‘”�Ý˜T¥3¡5¤5Ñ)Ô)Ð)Ø—’Ð6Ñ7Ô7Ð7Ø—’Ð8Ñ9Ô9Ð9Ø—’Ð3Ñ4Ô4Ð4Ø—’Ð3Ñ4Ô4Ð4Ø—’Ð~ÑÔÐØ5Ð5Ð5Ð5Ð5Ð5Ø—’˜D (Ñ+Ô+Ð+Ø&Ð>•c‘e”e�e­L¸Ñ,>Ô,>ˆGØ&Ð>•c‘e”e�e­L¸Ñ,>Ô,>ˆGÝ˜‘\”\ˆFØ!ð !ñ !�Ø$Ÿjšj¨Ñ2Ô2µC¸¿
º
À5Ñ8IÔ8IÑ4JÔ4J˜�Ý˜F C¨Ñ1Ô1ð Ø—K’K ¨ Ñ.Ô.Ð.ØÝ˜F C­¨V¯ZªZ¸Ñ->Ô->Ð-CÀ!Ñ)DÔ)DÀgÑNÔNð ØØ—’ ¨ Ñ.Ô.Ð.Ø¥Ð&Ð&Ø—K’K Ñ'Ô'Ð'ØÝ˜”=  u¨c°6·:²:¸eÑ3DÔ3DÐ3JÈÍDÐQW×Q[ÒQ[Ð\eÑQfÔQfÑLgÔLgÑhÔhð !Ø˜q‘L�GùØ˜&Ò Ð Ý˜T 7Ñ+Ô+Ð+Øð +�#˜dÔ0Ñ1Ô1°BÒ6Ð6ØÔ"×(Ò(Ñ*Ô*Ð*Ø ŸIšI™KœK¨'Ñ1ˆE�&‰MðA 	2ð  	2ð  	2ñ  	2ô  	2ð  	2ð  	2ð  	2ð  	2ð  	2ð  	2øøøð  	2ð  	2ð  	2ð  	2ð!2ð !2ð !2ñ !2ô !2ð !2ð !2ð !2ð !2ð !2ð !2øøøð !2ð !2ð !2ð !2ðD �IŠI‰KŒK˜'Ñ!€EØð :ˆwð :Ø1Ð1Ð1Ð1Ð1Ð1Ø�9—?’? 4°�?Ñ9Ô9Ñ9ˆØÐà�XŠX‰ZŒZð 	s˜4Ø�LŠLÐ\Õ_bÕcfÐgmÑcnÔcnÑ_oÔ_oÐ^qÑrÔrÐrð	sð 	sð 	sñ 	sô 	sð 	sð 	sð 	sð 	sð 	sð 	søøøð 	sð 	sð 	sð 	sà‡y‚y�{„{�WÑ˜sÒ"Ð"Ø&Ð&Ð&Ð&Ð&Ð&Ø�ŠÐl×sÒsÝ�‰LŒL˜% §¢¨6°1Ñ!5Ô!5°u·y²yÀÈÑ7KÔ7KÈTÏYÊYÉ[Ì[Ð[bÑMbÐejÑMjñlô lñ 	mô 	mð 	mà€NsH   ¸LÁJ,LË9LÌL		Ì	LÌL		ÌLÌL Ì#L Í82N6Î6N:Î=N:c                  ó  — ddl m}  |                      ¦   «         }	 |                     d¦  «                             ¦   «         }|rt          |d         ¦  «        nd	 |                     ¦   «          S # |                     ¦   «          w xY w)Nr   r•   z/SELECT value FROM sync_state WHERE key='cursor')rž   rj   Úconnectr*   rH   r`   Úclose)rj   r/   r1   s      r3   r­   r­   ñ   s~   € Ø"Ð"Ð"Ð"Ð"Ð"Ø�=Š=‰?Œ?€DðØ�lŠlÐLÑMÔM×VÒVÑXÔXˆØ!Ð(�s�3�q”6‰{Œ{ˆ{ qÐ(à�
Š
‰Œˆˆøˆ�
Š
‰Œˆˆøøøs   œ?A1 Á1Bc           
      ó  — g }|                       d¦  «        pi                      ¦   «         D ]S\  }}|D ]K}|                     ||dk    r|                      d¦  «        n|                      d¦  «        dd|dœ¦  «         ŒLŒT|S )zaA bootstrap response as one list of changes (rows with their keys), for apply_page(replace=True).Úentitiesr"   r   Úuuidr   F)r9   r   r?   rk   r1   )r>   Úitemsr¦   )ÚsnapshotÚoutr9   r™   r1   s        r3   Úbootstrap_changesr¿   û   s«   € à
€CØ!Ÿš jÑ1Ô1Ð7°R×>Ò>Ñ@Ô@ð 7ð 7‰ˆ�Øð 	7ð 	7ˆCØ�JŠJ &À6ÈYÒCVÐCV°·²¸±´°Ð\_×\cÒ\cÐdjÑ\kÔ\kÐtuØ#(°ð6ð 6ñ 7ô 7ð 7ð 7ð	7ð €Jr5   c                 ó0   — t          j        | dd¬¦  «        S )NFT)Úensure_asciiÚ	sort_keys)rI   rN   )r†   s    r3   rN   rN     s   € ÝŒ:�e¨%¸4Ð@Ñ@Ô@Ð@r5   )F)Ú__doc__rI   r©   r   ÚSQL_ENTITIESr+   r=   r4   r;   rA   rL   rP   rT   rx   r€   r„   r‰   r“   r¥   rµ   r­   r¿   rN   © r5   r3   ú<module>rÆ      sT  ððdð dð €€€à Ð Ð Ð Ð Ð àD€Ø@€	à
€ð!ð !ð !ðHð ð ð+ð +ð +ðð ð ðtð tð tðVð Vð Vðð ð ð@ð ð ð(ð ð ðið ið iðð ð ð   X¸ÈIÐclÐmÐm€ð7ð 7ð 7ð 7ðtð ð ðð ð ðAð Að Að Að Ar5   