`iiSSKrSSKJrJrJrJrJrJr SSKJ r SSK J r J r J r SrSrSSKJr "SS\5rg! SSKJr N=f) N)dialogaddonVSlogVSPathisMatrixVSProfil)cInputParameterHandler) QuotePlusUnquotecUtilcDbDB)dbapi2c\rSrSrSrSrS SjrSrSrS!Sjr S r S r S r S r S rSrSrSrSrSrSrS"SjrSrSrSrSrS SjrSrSrSrSrSrSr g)#r c[5nUS:XaSnOSU-S-n[U5RS5n[R "U5Ul[RUR lUR R5Ul URRS5 URR5cUR5 U$![a [U5nNf=f! [SU-5 g=f)Nz Master userzBspecial://home/userdata/addon_data/plugin.video.vstream/vstream.dbz!special://home/userdata/profiles/z+/addon_data/plugin.video.vstream/vstream.dbzutf-8zv SELECT name, sql FROM sqlite_master WHERE type='table' ORDER BY name;zError: Unable to access to %s)rrdecodeAttributeErrorsqliteconnectdbRow row_factorycursordbcurexecutefetchone_create_tablesr)selfnamerREALDBs @/home/kodi/.kodi/addons/plugin.video.vstream/resources/lib/db.py __enter__ cDb.__enter__sz = UB4t;>kkB BZ&&w/F nnV,DG"(**DGG )DJ JJ   " #zz""$,##%K BZF   1F: ; sCB C4C10C14Dc|URR5 URR5 g! g=f)z!Cleanup db when object destroyed N)rcloser)rexc_type exc_value tracebacks r"__exit__ cDb.__exit__3s.  JJ    GGMMO  s47;cUS:wa8URRSU-5 URR5 SnURRU5 SnURRU5 SnURRU5 SnURRU5 SnURRU5 SnURRU5 [ S 5 g) NzDROP TABLE IF EXISTS zCREATE TABLE IF NOT EXISTS history (addon_id integer PRIMARY KEY AUTOINCREMENT, title TEXT, disp TEXT, icone TEXT, UNIQUE(title));zCREATE TABLE IF NOT EXISTS resume (addon_id integer PRIMARY KEY AUTOINCREMENT, title TEXT, hoster TEXT, point TEXT, total TEXT, UNIQUE(title, hoster));zCREATE TABLE IF NOT EXISTS watched (addon_id integer PRIMARY KEY AUTOINCREMENT, tmdb_id TEXT, title_id TEXT, title TEXT, siteurl TEXT, site TEXT, fav TEXT, cat TEXT, season integer, UNIQUE(title_id));zCREATE TABLE IF NOT EXISTS favorite (addon_id integer PRIMARY KEY AUTOINCREMENT, title TEXT, siteurl TEXT, site TEXT, fav TEXT, cat TEXT, icon TEXT, fanart TEXT, UNIQUE(title, site));zCREATE TABLE IF NOT EXISTS viewing (addon_id integer PRIMARY KEY AUTOINCREMENT, tmdb_id TEXT, title_id TEXT, title TEXT, siteurl TEXT, site TEXT, fav TEXT, cat TEXT, season integer, UNIQUE (title_id));zCREATE TABLE IF NOT EXISTS download (addon_id integer PRIMARY KEY AUTOINCREMENT, title TEXT, url TEXT, path TEXT, cat TEXT, icon TEXT, size TEXT,totalsize TEXT, status TEXT, UNIQUE(title, path));zTable initialized)rrrcommitr)r dropTable sql_creates r"rcDb._create_tables;s ? JJ  6B C GGNN   :&  :&   :&   :&   :&   :& !"c[5(do[U[5(aURS5nSSKnUR SU5RSS5nURS5nUR5$UR5R5nUR5$![a Nf=f! UR5$=f)Nutf8rNFKDasciiignorez string-escape) r isinstancestrrr unicodedata normalizeencodestrip)rdatar:s r"str_conv cDb.str_convszz$$$;;v.D ((6==gxPD {{?3zz|;;='')Dzz|&  zz|sB-B=- B:9B:=Cc UR[US55nUSnSnUS;agSnURRXRX445 URR 5 [ S5 g![anS[U5;aTSU<S U<S U<S U<S 3 nURRU5 URR 5 [ S 5 O[ SU<SU<35 SnAgSnAff=f)Ntitledispzicon.png)12359z9INSERT INTO history (title, disp, icone) VALUES (?, ?, ?)zSQL INSERT history SuccessfullyUNIQUE constraint failedzUPDATE history set title = 'z ', disp = 'z ', icone= 'z' WHERE title = ''zSQL UPDATE history SuccessfullyzSQL ERROR INSERT, title = z, ) r?r rrrr.r Exceptionr9)rmetarBrCiconexes r"insert_historycDb.insert_historys gd7m45F| 0 0  LB JJ  r4#6 7 GGNN  3 4 )SV3glnrtxzA ""2& 78E1EF  sAA22 C<#a&-HO_bcd_eLe#a&(JJ&&'PQGGNN$56"c!f,JJ&&'TUGGNN$56!SV+JJ&&'VWGGNN$56 ""2 WTW^d'ef  =ABB+ Cs8.D7 AE7 EEE K'EKKKcUSnU(dgURSS5nSU;aUSOSnSU-nURRU5 URR5nUH(nUSnU(dM[ U5[ U5:Hs $ U(aS$S$![ anS [ U5;dS [ U5;dS [ U5;a{UR5 URRU5 URR5nU(aSOSsSnA$![ an[S U-5 SnAOSnAff=fSnAgSnAff=f) NrlFrmr-rVrDz+SELECT * FROM watched WHERE title_id = '%s'Trtrurv SQL ERROR %s) r{rrrTintrKr9convertWatchedr) rrLrBrVrWrXr> matchedcatrOs r" get_watchedcDb.get_watched#s:^$ c2&"d]d5kBUJ   JJ  z *,,.J#!%[ :z?c#h66# &4 05 0 3q6)->#a&-HO_bcd_eLe##%7JJ&&z2!%!4!4!6J#-458 7.:5667 sTAB!;B! B!B!! E+=E)?D.(E. E8E E EEEc SnU(aUSU-- nUS- nURRU5 URR5nU$![anS[ U5;dS[ U5;dS[ U5;adUR 5 URRU5 URR5nUsSnA$![a nSnAOSnAff=f[ SU-5 SnAgSnAff=f)NzSELECT tmdb_id, * FROM watched where cat = '%s'z order by addon_id DESCrtrurvSQL ERROR : %s)rrrTrKr9rrrUs r"get_catWatchedcDb.get_catWatchedDs5  -3 3J//  1 JJ  z *,,.J  13q6)->#a&-HO_bcd_eLe##%JJ&&z2!%!4!4!6J%%  "Z/ 0 0 1s;6A D=C=6C D C'C="C''C==DcUSnU(dgSU;aUSOSnU(aSU-nOSU-nURRU5 URR5 g![an[ SU-5 SnAgSnAff=f)Nrlror-z(DELETE FROM watched WHERE tmdb_id = '%s'z)DELETE FROM watched WHERE title_id = '%s'r_rrrrr.rKr)rrLrBrorWrOs r" del_watchedcDb.del_watched_s^$ #+t#3h CfLJDuLJ / JJ  z * GGNN  / .:- . . /s5A$$ B.BBcURRS5 URRS5 URRS5 URRS5 URRS5 URRS5 URRS5 g![a nSnANSnAff=f![a nSnANSnAff=f![a nSnANSnAff=f![a nSnANSnAff=f![a nSnANSnAff=f![a nSnANSnAff=f![a nSnAgSnAff=f)Nz3ALTER TABLE watched RENAME COLUMN title TO title_idz"ALTER TABLE watched add title TEXTz$ALTER TABLE watched add tmdb_id TEXTz$ALTER TABLE watched add siteurl TEXTz!ALTER TABLE watched add site TEXTz ALTER TABLE watched add fav TEXTz&ALTER TABLE watched add season integer)rrrK)rrOs r"rcDb.convertWatchedss?  JJ  T U  JJ  C D  JJ  E F  JJ  E F  JJ  B C  JJ  A B  JJ  G H 7                     s{CCC4D 2D"D9*E CC C1,C14 DD DD" D61D69 E E  E$E$cURUS5RSS5n[US5nUSnUSnSU-nURR U5 S nURR XbX4U45 URR5 g![ an[ SU-5 SnANYSnAff=f![ anS [U5;dS [U5;dS [U5;aYURS 5 [ S5 URR XbX4U45 URR5 SnAg[ SU-5 SnAgSnAff=f)Nrlrmr-rppointtotal%DELETE FROM resume WHERE title = '%s'rszDINSERT INTO resume (title, hoster, point, total) VALUES (?, ?, ?, ?)rtrurvresumeTable recreated : resumeSQL ERROR INSERT : %s) r?r{r rrrKrrr.r9r)rrLrBrprrrNrOs r" insert_resumecDb.insert_resumesA d>23;;CDf&W W  4u <  JJ  r " 3WB JJ  r4#> ? GGNN   .2% &   33q6)->#a&-HO_bcd_eLe##H-01 ""2tE'BC  -122 3s7B:B? B<$B77B<? E' BE"E""E'cURUS5nSU-nURRU5 URR5nU(dg[ US5[ US54$![ aWnS[ U5;dS[ U5;a!URS5 [S 5 SnAg[S U-5 SnAgSnAff=f) Nrlz2SELECT point, total FROM resume WHERE title = '%s'r_rrtrurrr) r?rrrfloatrKr9rr)rrLrBrWrXrOs r" get_resumecDb.get_resumes d>23JEQ  , JJ  z *,,.J#A'z!})== = ,3q6)->#a&-H##H-011&*++  ,s#:C=CCcUSnU(dgS[U5-nURRU5 URR 5 g![ an[ SU-5 SnAgSnAff=f)Nrlr_rrr rrrr.rKr)rrL sTitleWatchedrhrOs r" del_resumecDb.del_resumesi^, #a&-HO_bcd_eLe##I.12 ""2utTZ|]abg]hjm'vw -12  sA C FBE<<FcSnURRU5 URR5nU$![an[ SU-5 SnAgSnAff=f)Nz;SELECT * FROM viewing group by title order by addon_id DESCrrSrs r" get_viewingcDb.get_viewingUsWR   JJ  z *,,.J   "Z/ 0 s6; AAAc2SU;aUSOSnU(dSnSU;a USUS-- nOSU-nSU;a USUS-- nSnURRU5 URR5 URRnU(dYU(aRUSS:Xa/S U;a)USR S S 5US'UR U5$SU;aUS UR U5$g ![an[S U<S U<35 SnAU$SnAff=f)NrlzDELETE FROM viewingrVrz)DELETE FROM viewing WHERE title_id = '%s'z and cat = '%s'rr_S0_STz SQL ERROR z , error = ) rrrr.rr{rrKr)rrLrrhrrOs r"rcDb.del_viewingas*0>$0F^,D .J}1DK?? CmSJ}/$u+==  @ JJ  z * GGNN WW**Fm;#%%=*@+/+?+G+Gt+TD(++D11D=U ++D11 @  A> ? ?  @sBC.C.. D8DDc LURUS5n[US5n[US5nUSnSnURRXbX5USUSSS45 URR 5 [ S 5 g![an[ S 5 SnAgSnAff=f) NrBurlrMpathzkINSERT INTO download (title, url, path, cat, icon, size, totalsize, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?)rVr-rz SQL INSERT download SuccessfullyzSQL ERROR INSERT into download)r?r rrrr.rrK)rrLrBrrsPathrNrOs r"insert_downloadcDb.insert_downloads d7m,U $$v,'V  z  JJ  r3tE{E2rST#U V GGNN  4 5  2 3  sA B B# BB#cUS:XaSnO[US5nSU-nURRU5 URR5nU$![an[ SU-5 SnAgSnAff=f)Nr-zSELECT * FROM downloadrz8SELECT * FROM download WHERE url = '%s' AND status = '0'r)r rrrTrKr)rrLrWrrXrOs r" get_downloadcDb.get_downloadsv 2:1JDK(CSVYYJ  JJ  z *,,.J   .:- . s6A A7A22A7cSnURRU5 URR5 g![an[ SU-5 SnAgSnAff=f)Nz'DELETE FROM download WHERE status = '2'r_rrrrWrOs r"clean_downloadcDb.clean_downloadsO>  JJ  z * GGNN  .:- . 5: AAAc[US5nSU-nURRU5 URR 5 g![ an[ SU-5 SnAgSnAff=f)NrzBUPDATE download SET status = '0' WHERE status = '2' AND url = '%s'r_rr)rrLrrWrOs r"reset_downloadcDb.reset_downloadscU $Y\__  JJ  z * GGNN  .:- . s5A A-A((A-cB[US5S:a[US5nSU-nO[US5S:a USnSU-nOgURRU5 URR 5 g![ an[SU-5 SnAgSnAff=f)Nrrz%DELETE FROM download WHERE url = '%s'rz&DELETE FROM download WHERE path = '%s'r_r)lenr rrrr.rKr)rrLrrWrrOs r" del_downloadcDb.del_downloads tE{ a DK(C@3FJ f  "