§
   Nã3.ÓÄò‚ã                   óª   — d Z ddlZddlZddlZddlZddlZddlmZmZm	Z	 dZ
d„ Zd„ Zd„ Zd„ Zdd	„Zd
„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zdd„Zdd„Zd„ ZdS )a›  Merge this Kodi's own data into the account right after a sign-in (WEB docs/plan/account-sync S28, T37).

The sign-in backup (DATA/account/local_backup/) holds the device's data as it was before the sign-in. `summary()`
counts what can be merged; `ops()` turns it into ordinary account ops with the data's own times, so the server merges
them by the sync's rules (newer position wins, a watched is never lost, lists are a union, a later removal in the
account stays). Op ids are deterministic: the same data merged again is answered `duplicate`. Channel uuids are
remapped per account, so one Kodi's channels can go into two accounts. Nothing here changes the backup.é    N)ÚdocsÚhooksÚstateéd   c                  ó,   — t          j        dd¦  «        S )NÚaccountÚlocal_backup)r   Ú_path© ó    ú_/Users/chudy/Library/Application Support/Kodi/addons/plugin.video.milionar/wcs/account/merge.pyÚ
backup_dirr      s   € ÝŒ:�i Ñ0Ô0Ð0r   c                 óB   — t           j                             | d¦  «        S )NÚfiles)ÚosÚpathÚjoin©Úroots    r   Ú_filesr      s   € ÝŒ7�<Š<˜˜gÑ&Ô&Ð&r   c                 óÂ  — t           j                             | d¦  «        }t           j                             |¦  «        sg S t	          j        |d¬¦  «        }t          j        |_        	 d„ |                     |¦  «        D ¦   «         | 	                    ¦   «          S # t          j
        $ r g cY | 	                    ¦   «          S w xY w# | 	                    ¦   «          w xY w)Nzlibrary_user.dbg      @)Útimeoutc                 ó,   — g | ]}t          |¦  «        ‘ŒS r   )Údict©Ú.0Úrs     r   ú
<listcomp>z_rows.<locals>.<listcomp>#   s   € Ð3Ð3Ð3˜A•�Q‘”Ð3Ð3Ð3r   )r   r   r   ÚisfileÚsqlite3ÚconnectÚRowÚrow_factoryÚexecuteÚcloseÚError)r   Úsqlr   Úconns       r   Ú_rowsr)      sÎ   € ÝŒ7�<Š<˜Ð/Ñ0Ô0€DÝŒ7�>Š>˜$ÑÔð Øˆ	ÝŒ?˜4¨Ð-Ñ-Ô-€DÝ”{€DÔðØ3Ð3 §¢¨cÑ!2Ô!2Ð3Ñ3Ô3ð 	�
Š
‰Œˆˆøõ Œ=ð ð ð Øˆ	ˆ	à�
Š
‰Œˆˆðøøøøð 	�
Š
‰Œˆˆøøøs$   Á*B ÂCÂ.C ÃCÃC ÃCc                 óD   — t          j        t          | ¦  «        ¦  «        S ©N)r   Ú_channel_localr   r   s    r   Ú	_channelsr-   *   s   € ÝÔ�v d™|œ|Ñ,Ô,Ð,r   c           
      ó  — | pt          ¦   «         } t          | d¦  «        }d„ |D ¦   «         }t          | d¦  «        }t          | ¦  «        }|                     dd¦  «        |                     dd¦  «        t	          |r|d         d         ndpd¦  «        t	          |r|d         d         ndpd¦  «        t          d	„ |                     ¦   «         D ¦   «         ¦  «        t          d
„ |                     ¦   «         D ¦   «         ¦  «        dœS )zn{movies, series, in_progress, watched, mytv, mycinema}: what this Kodi would add; all zero = nothing to offer.zPSELECT media_type, COUNT(*) AS n FROM titles WHERE in_list=1 GROUP BY media_typec                 ó,   — i | ]}|d          |d         “ŒS )Ú
media_typeÚnr   r   s     r   ú
<dictcomp>zsummary.<locals>.<dictcomp>2   s"   € Ð4Ð4Ð4¨ˆQˆ|Œ_˜a œfÐ4Ð4Ð4r   z´SELECT SUM(resume_pos > 0) AS progress, SUM(playcount > 0) AS watched FROM (SELECT resume_pos, playcount FROM movie_state UNION ALL SELECT resume_pos, playcount FROM episode_state)Úmovier   ÚtvÚprogressÚwatchedc              3   ó2   K  — | ]}|d          dk    ¯dV — ŒdS )Útyper4   é   Nr   ©r   Úcs     r   ú	<genexpr>zsummary.<locals>.<genexpr>9   s0   è è € ÐJÐJ˜a¸¸&¼	ÀTÒ8IÐ8I˜Ð8IÐ8IÐ8IÐ8IÐJÐJr   c              3   ó2   K  — | ]}|d          dk    ¯dV — ŒdS )r8   Úcinemar9   Nr   r:   s     r   r<   zsummary.<locals>.<genexpr>:   s0   è è € ÐRÐR !¸A¸f¼IÈÒ<QÐ<Q˜AÐ<QÐ<QÐ<QÐ<QÐRÐRr   )ÚmoviesÚseriesÚin_progressr6   ÚmytvÚmycinema)r   r)   r-   ÚgetÚintÚsumÚvalues)r   ÚlistsÚcountÚstatesÚchannelss        r   ÚsummaryrL   .   s  € àÐ•:‘<”<€DÝ�$ÐjÑkÔk€EØ4Ð4¨eÐ4Ñ4Ô4€EÝ�4ð Dñ Eô E€Få˜‰Œ€HØ—i’i ¨Ñ+Ô+°u·y²yÀÀqÑ7IÔ7IÝ¸Ð F  q¤	¨*Ô 5Ð 5ÀQÐLÈ1ÑMÔMÝ°FÐA˜F 1œI iÔ0Ð0ÀÐGÀaÑHÔHÝÐJÐJ 8§?¢?Ñ#4Ô#4ÐJÑJÔJÑJÔJÝÐRÐR x§¢Ñ'8Ô'8ÐRÑRÔRÑRÔRð	Tð Tð Tr   c                 óD   — t          |                      ¦   «         ¦  «        S r+   )ÚanyrG   )Úcountss    r   Úhas_datarP   =   s   € Ýˆv�}Š}‰ŒÑÔÐr   c           
      ó$  — |pi }t          j        t          j        | ||t	          |¦  «        gdd¬¦  «                             d¦  «        ¦  «        }d|                     ¦   «         d d…         z   | |t          dt	          |¦  «        ¦  «        |dœS )	NTF)Ú	sort_keysÚensure_asciizutf-8zm-é   r   )Úop_idr8   ÚkeyÚatÚpayload)ÚhashlibÚsha1ÚjsonÚdumpsrE   ÚencodeÚ	hexdigestÚmax)ÚkindrV   rW   rX   Údigests        r   Ú_oprb   A   s�   € Øˆm˜€GÝŒ\�$œ* d¨C°½#¸b¹'¼'Ð%BÈdÐafÐgÑgÔg×nÒnÐovÑwÔwÑxÔx€FØ˜F×,Ò,Ñ.Ô.¨s°¨sÔ3Ñ3¸TÈ#ÕUXÐYZÕ\_Ð`bÑ\cÔ\cÑUdÔUdÐqxÐyÐyÐyr   c                 óT  — g }d„ t          | d¦  «        D ¦   «         }|d„ t          | d¦  «        D ¦   «         z  }|D �]j}|                     d¦  «        r*t          |                     d¦  «        pd¦  «        dz  |z   nd}|                     d¦  «        |                     d	¦  «        |                     d
¦  «        dœ}t          |                     d¦  «        pd¦  «        }t          |                     d¦  «        pd¦  «        dk    r8|                     t          d|d         |dk    r|r|dz
  n||¦  «        ¦  «         |dk    r]|                     t          d|d         |t          ||t          |                     d¦  «        pd¦  «        ¬¦  «        ¦  «        ¦  «         �Œl|S )Nc                 ód   — g | ]-}t          |d t          j        d |d         ¦  «        ¬¦  «        ‘Œ.S )r3   Útmdb_id©ÚmediarV   ©r   r   Ú	watch_keyr   s     r   r   z_watch_ops.<locals>.<listcomp>I   sJ   € ð  Bð  Bð  BÐST�D�˜'¥u¤°wÀÀ)ÄÑ'MÔ'MÐNÑNÔNð  Bð  Bð  Br   zSELECT * FROM movie_statec                 ó€   — g | ];}t          |d t          j        d |d         |d         |d         ¦  «        ¬¦  «        ‘Œ<S )r4   Úshow_idÚseasonÚepisoderf   rh   r   s     r   r   z_watch_ops.<locals>.<listcomp>J   s\   € ð Bð Bð BØõ �!˜4¥U¤_°T¸1¸Y¼<ÈÈ8ÌÐVWÐXaÔVbÑ%cÔ%cÐdÑdÔdð Bð Bð Br   zSELECT * FROM episode_stateÚlast_played_atr   éè  Ú
last_identÚlast_providerÚlast_file_name)ÚidentÚproviderÚ	file_nameÚ
resume_posÚ	playcountr6   rV   r9   r5   Úresume_total)ÚposÚtotal)r)   rD   rE   ÚfloatÚappendrb   r   )r   ÚoffsetÚopsÚrowsÚrowrW   ÚsourceÚresumes           r   Ú
_watch_opsrƒ   G   sÛ  € Ø
€Cð Bð  BÕX]Ð^bÐdñ  YAô  YAð  Bñ  Bô  B€DØð Bð BÝ˜DÐ"?Ñ@Ô@ðBñ Bô Bñ B€Dàð }ñ }ˆØDGÇGÂGÐL\ÑD]ÔD]Ðd�S�—’Ð)Ñ*Ô*Ð/¨aÑ0Ô0°4Ñ7¸&Ñ@Ð@ÐcdˆØŸ7š7 <Ñ0Ô0¸c¿gºgÀoÑ>VÔ>VÐeh×elÒelÐm}Ñe~Ôe~ÐÐˆÝ�s—w’w˜|Ñ,Ô,Ð1°Ñ2Ô2ˆÝˆs�wŠw�{Ñ#Ô#Ð( qÑ)Ô)¨AÒ-Ð-Ø�JŠJ•s˜9 c¨%¤j¸FÀQºJ¸JÈ2¸J°"°q±&°&ÐSUÐW]Ñ^Ô^Ñ_Ô_Ð_Ø�AŠ:ˆ:Ø�JŠJ•s˜: s¨5¤z°2µt¸FÈÕV[Ð\_×\cÒ\cÐdrÑ\sÔ\sÐ\xÐwxÑVyÔVyÐ7zÑ7zÔ7zÑ{Ô{Ñ|Ô|Ð|ùØ€Jr   c                 ó<  — g }t          | d¦  «        D ]ˆ}t          |                     d¦  «        pd¦  «        }|                     t	          dd                     |d         t          |d         ¦  «        ¦  «        |r|dz  |z   ndd	d |pd d
œ¦  «        ¦  «         Œ‰|S )NzWSELECT media_type, tmdb_id, list_added_at FROM titles WHERE in_list=1 ORDER BY list_posÚlist_added_atr   Úlist_setú{}:{}r0   re   ro   T)Úin_listry   Úadded_at)r)   rE   rD   r|   rb   Úformat)r   r}   r~   r€   Úaddeds        r   Ú	_list_opsrŒ   W   sÊ   € Ø
€CÝ�TÐtÑuÔuð Sð SˆÝ�C—G’G˜OÑ,Ô,Ð1°Ñ2Ô2ˆØ�
Š
•3�z 7§>¢>°#°lÔ2CÅSÈÈYÌÑEXÔEXÑ#YÔ#YÐtyð  \AÐ[`ÐcgÑ[gÐjpÑ[pÐ[pð  @AØ#'°À%À-È4ÐPÐPñRô Rñ 	Sô 	Sð 	Sð 	Sà€Jr   c           
      óª  — d}t           j                             | ¦  «        rct          j        | ¦  «        D ]M}t	          |t           j                             t           j                             | |¦  «        ¦  «        ¦  «        }ŒNn>t           j                             | ¦  «        rt           j                             | ¦  «        }t          |dz  ¦  «        S )Ng        ro   )	r   r   ÚisdirÚlistdirr_   Úgetmtimer   r   rE   )r   ÚnewestÚnames      r   Ú	_mtime_msr“   `   s¬   € Ø€FÝ	„w‡}‚}�TÑÔð (Ý”J˜tÑ$Ô$ð 	Mð 	MˆDÝ˜¥¤×!1Ò!1µ"´'·,²,¸tÀTÑ2JÔ2JÑ!KÔ!KÑLÔLˆFˆFð	Må	Œ�Š˜Ñ	Ô	ð (Ý”×!Ò! $Ñ'Ô'ˆÝˆv˜‰}ÑÔÐr   c           	      óª   — t          t          j        t          j        d                     | pd                     ¦   «         |¦  «        ¦  «        ¦  «        S )Nzmilionar-account:{}:{}Ú )ÚstrÚuuidÚuuid5ÚNAMESPACE_URLrŠ   Úlower)ÚemailÚ
local_uuids     r   Ú_remapr�   j   sB   € Ý�tŒz�$Ô,Ð.F×.MÒ.MÈuÈ{ÐXZ×NaÒNaÑNcÔNcÐeoÑ.pÔ.pÑqÔqÑrÔrÐrr   c           	      ór  ‡— t          | ¦  «        Ši }t          | ¦  «                             ¦   «         D ]Q\  }}t          |t	          |                     d¦  «        pd¦  «        t          z   ¬¦  «        |t          ||¦  «        <   ŒRi }t          j	        ‰¦  «                             ¦   «         D ]W\  }}| 
                    dd¦  «        \  }}t          ||¦  «        |v r'||d                     t          ||¦  «        |¦  «        <   ŒXt          ˆfd„t          j                             ¦   «         D ¦   «         ¦  «        |z   }	t          j        di ||	¦  «        }
t          ˆfd	„t          j                             ¦   «         D ¦   «         ¦  «        |z   }|
t          j        d
i ||p|	¦  «        z  }
d„ |
D ¦   «         S )Nry   r   )ry   ú:r9   r‡   c              3   ór   •K  — | ]1}t          t          j                             ‰|¦  «        ¦  «        V — Œ2d S r+   ©r“   r   r   r   ©r   r’   r   s     €r   r<   z_channel_ops.<locals>.<genexpr>x   s;   øè è € ÐZÐZ°d�Y•r”w—|’| E¨4Ñ0Ô0Ñ1Ô1ÐZÐZÐZÐZÐZÐZr   Úchannelc              3   ór   •K  — | ]1}t          t          j                             ‰|¦  «        ¦  «        V — Œ2d S r+   r¡   r¢   s     €r   r<   z_channel_ops.<locals>.<genexpr>z   s;   øè è € ÐaÐa¸d•Y�rœwŸ|š|¨E°4Ñ8Ô8Ñ9Ô9ÐaÐaÐaÐaÐaÐar   Úchannel_progressc           	      ób   — g | ],}t          |d          |d         |d         |d         ¦  «        ‘Œ-S )r8   rV   rW   rX   )rb   )r   Úos     r   r   z _channel_ops.<locals>.<listcomp>|   s6   € ÐIÐIÐIÀ�C��&”	˜1˜Uœ8 Q t¤W¨a°	¬lÑ;Ô;ÐIÐIÐIr   )r   r-   Úitemsr   rE   rD   Ú	POS_AFTERr�   r   Ú_progress_localÚsplitrŠ   r_   ÚCHANNEL_FILESrG   Údiff_opsÚHISTORY_DIRS)r   r›   r}   rK   rV   Úvaluer5   r£   ÚrestrW   r~   Ú
history_atr   s               @r   Ú_channel_opsr²   n   s´  ø€ Ý�4‰LŒL€EØ€HÝ ‘o”o×+Ò+Ñ-Ô-ð _ð _‰
ˆˆUÝ'+¨Eµs¸5¿9º9ÀUÑ;KÔ;KÐ;PÈqÑ7QÔ7QÕT]Ñ7]Ð'^Ñ'^Ô'^ˆ•˜˜sÑ#Ô#Ñ$Ð$Ø€HÝÔ*¨5Ñ1Ô1×7Ò7Ñ9Ô9ð Kð K‰
ˆˆUØŸ	š	 # qÑ)Ô)‰ˆ�Ý�%˜Ñ!Ô! XÐ-Ð-ØEJˆH�W—^’^¥F¨5°'Ñ$:Ô$:¸DÑAÔAÑBøÝ	ÐZÐZÐZÐZ½dÔ>P×>WÒ>WÑ>YÔ>YÐZÑZÔZÑ	ZÔ	ZÐ]cÑ	c€BÝ
Œ-˜	 2 x°Ñ
4Ô
4€CÝÐaÐaÐaÐaÅdÔFW×F^ÒF^ÑF`ÔF`ÐaÑaÔaÑaÔaÐdjÑj€JØ�4Œ=Ð+¨R°¸:Ð;KÈÑLÔLÑL€CØIÐIÀSÐIÑIÔIÐIr   c                 óˆ   — | pt          ¦   «         } t          | |¦  «        t          | |¦  «        z   t          | ||¦  «        z   S )zcEvery op of the merge, in an order the server can apply (channels before their items and progress).)r   rŒ   rƒ   r²   )r   r›   r}   s      r   r~   r~      sB   € àÐ•:‘<”<€DÝ�T˜6Ñ"Ô"¥Z°°fÑ%=Ô%=Ñ=ÅÈTÐSXÐZ`Ñ@aÔ@aÑaÐar   c                 ó´  — ddl }ddlm} |                     t          j        ¦  «        }|                     ¦   «         5 }t          | |                     t          j	        ¦  «        t          j        |¦  «        ¦  «        }|                     d¦  «                             ¦   «         d         }|D ]O}|                     d|d         |d         |d         |d	         t          j        |d
         d¬¦  «        f¦  «         ŒP|                     d¦  «                             ¦   «         d         |z
  }ddd¦  «         n# 1 swxY w Y   t          j        ¦   «          |S )zXQueue the merge into the outbox of the signed-in account; returns the number of new ops.r   N©Ústorez SELECT COUNT(*) FROM sync_outboxzRINSERT OR IGNORE INTO sync_outbox(op_id, type, key, at, payload) VALUES(?,?,?,?,?)rU   r8   rV   rW   rX   F)rS   )Ú	xbmcaddonÚwcs.library2r¶   ÚAddonr   ÚADDON_IDÚtxr~   Ú
getSettingÚEMAILr   Ú	offset_msr$   Úfetchoner[   r\   Ú	committed)	r   r·   r¶   Úaddonr(   ÚmergedÚbeforeÚopr‹   s	            r   ÚenqueuerÅ   …   s—  € àÐÐÐØ"Ð"Ð"Ð"Ð"Ð"Ø�OŠO�EœNÑ+Ô+€EØ	�Š‰Œð X�tÝ�T˜5×+Ò+­E¬KÑ8Ô8½%¼/È$Ñ:OÔ:OÑPÔPˆØ—’Ð@ÑAÔA×JÒJÑLÔLÈQÔOˆØð 	xð 	xˆBØ�LŠLÐmØ˜Wœ+ r¨&¤z°2°e´9¸bÀ¼hÍÌ
ÐSUÐV_ÔS`ÐotÐHuÑHuÔHuÐvñxô xð xð xà—’Ð?Ñ@Ô@×IÒIÑKÔKÈAÔNÐQWÑWˆðXð Xð Xñ Xô Xð Xð Xð Xð Xð Xð Xøøøð Xð Xð Xð Xõ 
„OÑÔÐØ€Ls   ¾C0D:Ä:D>ÅD>c                  óì   — ddl m}  |                      ¦   «         }	 |                     d¦  «                             ¦   «         d         |                     ¦   «          S # |                     ¦   «          w xY w)z&Merge ops still waiting in the outbox.r   rµ   z7SELECT COUNT(*) FROM sync_outbox WHERE op_id LIKE 'm-%')r¸   r¶   r!   r$   r¿   r%   )r¶   r(   s     r   ÚpendingrÇ   •   si   € à"Ð"Ð"Ð"Ð"Ð"Ø�=Š=‰?Œ?€DðØ�|Š|ÐUÑVÔV×_Ò_ÑaÔaÐbcÔdà�
Š
‰Œˆˆøˆ�
Š
‰Œˆˆøøøs   œ,A ÁA3r+   )NNr   )Ú__doc__rY   r[   r   r    r—   Úwcs.accountr   r   r   r©   r   r   r)   r-   rL   rP   rb   rƒ   rŒ   r“   r�   r²   r~   rÅ   rÇ   r   r   r   ú<module>rÊ      sn  ððkð kð €€€Ø €€€Ø 	€	€	€	Ø €€€Ø €€€à *Ð *Ð *Ð *Ð *Ð *Ð *Ð *Ð *Ð *à€	ð1ð 1ð 1ð'ð 'ð 'ðð ð ð-ð -ð -ðTð Tð Tð Tð ð  ð  ðzð zð zðð ð ð ð ð ðð ð ðsð sð sðJð Jð Jð"bð bð bð bðð ð ð ð ð ð ð ð r   