gzddlZddlZddlZddlmZddlmZddlmZddlmZddlmZddlmZGdd e Z y) N)common)database)helpers)logger) libraries)sessionczeZdZdZddZddZddZddZddZddZ dd Z dd Z dd Z dd Z dd ZddZddZy)GraphscyN)selfs /opt/Tautulli/plexpy/graphs.py__init__zGraphs.__init__!s Nctj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } | D cic]} | d|  } } tjj}t!dt#|Dcgc]}|tj$|z }}g}g}g}g}g}t'|D]}|j)d}|j+|| j-|i}|j-dd}|j-dd}|j-dd}|j-dd}|j+||j+||j+||j+|d|d}d|d}d|d}d|d} g}!t/j0dr|!j+|t/j0dr|!j+|t/j0dr|!j+|t/j0dr|!j+| ||!d}"|"S#t$r"} tjd | zYd} ~ yd} ~ wwxYwcc} wcc}w) N<session_history.reference_idsession_history.idplaysaSELECT sh.date_played, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN 1 ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN 1 ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN 1 ELSE 0 END) AS music_count, SUM(shm.live) AS live_count FROM (SELECT *, date(started, 'unixepoch', 'localtime') AS date_played FROM session_history WHERE session_history.stopped >=   GROUP BY date_played, zj) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id GROUP BY sh.date_played ORDER BY sh.startedaSELECT sh.date_played, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN sh.d ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN sh.d ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN sh.d ELSE 0 END) AS music_count, SUM(CASE WHEN shm.live = 1 THEN sh.d ELSE 0 END) AS live_count FROM (SELECT *, date(started, 'unixepoch', 'localtime') AS date_played, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >=  GROUP BY date_played, zTTautulli Graphs :: Unable to execute database query for get_total_plays_per_day: %s. date_playedrdays%Y-%m-%dtv_count movie_count music_count live_countTVnamedataMoviesMusicLive TVshowmovieartistlive categoriesseries)rMonitorDatabaser cast_to_int timestamp_make_user_condplexpyCONFIGGROUP_HISTORY_TABLESselect Exceptionrwarndatetimedatetodayrangeint timedeltasortedstrftimeappendgetrhas_library_type)#r time_rangey_axisuser_idgrouping monitor_dbr4 user_condgroup_byqueryresulteitemresult_by_date_playedbasex date_listr0series_1series_2series_3series_4 date_item date_string result_dateseries_1_valueseries_2_valueseries_3_valueseries_4_valueseries_1_outputseries_2_outputseries_3_outputseries_4_output series_outputoutputs# rget_total_plays_per_dayzGraphs.get_total_plays_per_day$s--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW*  2;Ix Q$**51!H2;Ix'Q*$**51 HN Ntm!4d!: N N}}""$@EaZ@YZ1TH..A66Z Z  * ,I#,,Z8K   k */33KDK(__Z;N(__]A>N(__]A>N(__\1=N OON + OON + OON + OON + , $(#+-#+#+-#*#+-#,#+-  % %f -   1  % %g .   1  % %h /   1  % %f -   1 *)+ m  KKnqrr s !O [s%AJ; K) K.; K&K!!K&c@tj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } | D cic]} | d|  } } t jjrgd}ngd}g}g}g}g}g}|D]}|j|| j|i}|jdd}|jdd}|jdd}|jdd}|j||j||j||j|d|d}d|d}d|d}d|d}g}t!j"dr|j|t!j"dr|j|t!j"dr|j|t!j"dr|j|||d}|S#t$r"} tjd | zYd} ~ yd} ~ wwxYwcc} w) NrrrrrraSELECT sh.daynumber, (CASE sh.daynumber WHEN 0 THEN 'Sunday' WHEN 1 THEN 'Monday' WHEN 2 THEN 'Tuesday' WHEN 3 THEN 'Wednesday' WHEN 4 THEN 'Thursday' WHEN 5 THEN 'Friday' ELSE 'Saturday' END) AS dayofweek, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN 1 ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN 1 ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN 1 ELSE 0 END) AS music_count, SUM(shm.live) AS live_count FROM (SELECT *, CAST(strftime('%w', date(started, 'unixepoch', 'localtime')) AS INTEGER) AS daynumber FROM session_history WHERE session_history.stopped >= rz GROUP BY daynumber, zg) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id GROUP BY dayofweek ORDER BY sh.daynumberaSELECT sh.daynumber, (CASE sh.daynumber WHEN 0 THEN 'Sunday' WHEN 1 THEN 'Monday' WHEN 2 THEN 'Tuesday' WHEN 3 THEN 'Wednesday' WHEN 4 THEN 'Thursday' WHEN 5 THEN 'Friday' ELSE 'Saturday' END) AS dayofweek, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN sh.d ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN sh.d ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN sh.d ELSE 0 END) AS music_count, SUM(CASE WHEN shm.live = 1 THEN sh.d ELSE 0 END) AS live_count FROM (SELECT *, CAST(strftime('%w', date(started, 'unixepoch', 'localtime')) AS INTEGER) AS daynumber, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= z GROUP BY daynumber, zZTautulli Graphs :: Unable to execute database query for get_total_plays_per_dayofweek: %s. dayofweek)MondayTuesday WednesdayThursdayFridaySaturdaySunday)rprjrkrlrmrnror rr!r"r#r$r%r(r)r*r+r,r-r.r/)rr2rr3r4r5r6r7r8r9r:rr;WEEK_START_MONDAYrDrErrF) rrGrHrIrJrKr4rLrMrNrOrPrQresult_by_dayofweek days_listr0rVrWrXrYday_item result_dayr]r^r_r`rarbrcrdrerfs rget_total_plays_per_dayofweekz$Graphs.get_total_plays_per_dayofweeks--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW:  *4=i)S,$**51/!h4=i7S:$**51 DJJ4tK0$6JJ == * *EI;I ! ,H   h ',002>J'^^J:N'^^M1=N'^^M1=N'^^L!= rz GROUP BY hourofday, zj) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id GROUP BY sh.hourofday ORDER BY sh.hourofdayaSELECT sh.hourofday, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN sh.d ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN sh.d ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN sh.d ELSE 0 END) AS music_count, SUM(CASE WHEN shm.live = 1 THEN sh.d ELSE 0 END) AS live_count FROM (SELECT *, strftime('%H', datetime(started, 'unixepoch', 'localtime')) AS hourofday, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= z GROUP BY hourofday, zZTautulli Graphs :: Unable to execute database query for get_total_plays_per_hourofday: %s. hourofday)000102030405060708091011121314151617181920212223r rr!r"r#r$r%r(r)r*r+r,r-r.r/)rr2rr3r4r5r6r7r8r9r:rr;rDrErrF) rrGrHrIrJrKr4rLrMrNrOrPrQresult_by_hourofday hours_listr0rVrWrXrY hour_item result_hourr]r^r_r`rarbrcrdrerfs rget_total_plays_per_hourofdayz$Graphs.get_total_plays_per_hourofdays--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW*  4=i S$**51!H4=i'S*$**51 DJJ4tK0$6JJ:  # ,I   i (-11)R@K(__Z;N(__]A>N(__]A>N(__\1=N OON + OON + OON + OON + ,$(#+-#+#+-#*#+-#,#+-  % %f -   1  % %g .   1  % %h /   1  % %f -   1 *)+ k  KKtwxx y KsAI I< I9I44I9c&tj}tj|xsd}t j tj j| jdj }|j|}|tjj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } | D cic]} | d|  } } t"j$j'}|}|g}t)t+|dz D]{}|j,|z dzdz s%t#j$|j.dz dd}n.t#j$|j.|j,dz d}|j1|}g}g}g}g}g}t3|D]}|j5d}|j1|j5d| j |i}|j dd}|j dd}|j dd}|j dd}|j1||j1||j1||j1|d|d}d|d}d|d}d|d} g}!t7j8dr|!j1|t7j8dr|!j1|t7j8dr|!j1|t7j8dr|!j1| ||!d }"|"S#t$r"} tj d | zYd} ~ yd} ~ wwxYwcc} w)!N )monthsmonthrrraSELECT sh.datestring, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN 1 ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN 1 ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN 1 ELSE 0 END) AS music_count, SUM(shm.live) AS live_count FROM (SELECT *, strftime('%Y-%m', datetime(started, 'unixepoch', 'localtime')) AS datestring FROM session_history WHERE session_history.stopped >= rz GROUP BY datestring, zl) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id GROUP BY sh.datestring ORDER BY sh.datestringaSELECT sh.datestring, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN sh.d ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN sh.d ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN sh.d ELSE 0 END) AS music_count, SUM(CASE WHEN shm.live = 1 THEN sh.d ELSE 0 END) AS live_count FROM (SELECT *, strftime('%Y-%m', datetime(started, 'unixepoch', 'localtime')) AS datestring, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= z GROUP BY datestring, zVTautulli Graphs :: Unable to execute database query for get_total_plays_per_month: %s. datestringz%Y-%mz%b %Yr rr!r"r#r$r%r(r)r*r+r,r-r.r/)rr2rr3arrowrEr4shiftfloorr5r6r7r8r9r:rr;r<r=r>r?r@ryearrDrBrCrrF)#rrGrHrIrJrKr4rLrMrNrOrPrQresult_by_datestringdt_todaydt month_rangenr0rVrWrXrYr[r\r]r^r_r`rarbrcrdrerfs# rget_total_plays_per_monthz Graphs.get_total_plays_per_month{sh--/ ((4: IIg//1288 8LRRSZ[eeg ((1  }}99H5=1CW*  5>y( T$**51!H5>y('T*$**51 FLLT\ 2D 8LL==&&( d s:q() #A^^A%+Q.]]27719b!4]]277BHHQJ:   r "  # % ,B++g.K   bkk'2 3.22;CK(__Z;N(__]A>N(__]A>N(__\1=N OON + OON + OON + OON + , $(#+-#+#+-#*#+-#,#+-  % %f -   1  % %g .   1  % %h /   1  % %f -   1 *)+ {  KKpstt u  Ms7AM ; N N )NN cvtj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } g} g} g}g}g}| D]}| jtjj!|d|d| j|d|j|d|j|d|j|dd| d}d|d}d|d}d|d}g}t#j$dr|j|t#j$dr|j|t#j$dr|j|t#j$dr|j|| |d}|S#t$r"} tjd| zYd} ~ yd} ~ wwxYw)NrrrrrraSELECT sh.platform, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN 1 ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN 1 ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN 1 ELSE 0 END) AS music_count, SUM(shm.live) AS live_count, COUNT(sh.id) AS total_count FROM (SELECT * FROM session_history WHERE session_history.stopped >= r GROUP BY z) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id GROUP BY sh.platform ORDER BY total_count DESC, sh.platform ASC LIMIT 10azSELECT sh.platform, SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN sh.d ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN sh.d ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN sh.d ELSE 0 END) AS music_count, SUM(CASE WHEN shm.live = 1 THEN sh.d ELSE 0 END) AS live_count, SUM(sh.d) AS total_duration FROM (SELECT *, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= GROUP BY zy) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id GROUP BY sh.platform ORDER BY total_duration DESC LIMIT 10z`Tautulli Graphs :: Unable to execute database query for get_total_plays_by_top_10_platforms: %s.platformr r!r"r#r$r%r(r)r*r+r,r-r.r/)rr2rr3r4r5r6r7r8r9r:rr;rDrPLATFORM_NAME_OVERRIDESrErrF)rrGrHrIrJrKr4rLrMrNrOrPr0rVrWrXrYrQrarbrcrdrerfs r#get_total_plays_by_top_10_platformsz*Graphs.get_total_plays_by_top_10_platformssR--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW,  '0H F$**51!!L'0H)F,$**51   0D   f<<@@jAQSWXbScd e OOD, - OOD/ 0 OOD/ 0 OOD. /  0$(#+-#+#+-#*#+-#,#+-  % %f -   1  % %g .   1  % %h /   1  % %f -   1 *)+ O  KKz}~~  sAH H8H33H8ctj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } g} g} g}g}g}tj}| D]}|r(| jt!|d|k(r|dndn| j|d| j|d|j|d|j|d|j|dd| d}d|d}d|d}d|d}g}t#j$dr|j|t#j$dr|j|t#j$dr|j|t#j$dr|j|| |d }|S#t$r"} tjd| zYd} ~ yd} ~ wwxYw)!Nrrrrrra/SELECT u.user_id, u.username, (CASE WHEN u.friendly_name IS NULL OR TRIM(u.friendly_name) = '' THEN u.username ELSE u.friendly_name END) AS friendly_name,SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN 1 ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN 1 ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN 1 ELSE 0 END) AS music_count, SUM(shm.live) AS live_count, COUNT(sh.id) AS total_count FROM (SELECT * FROM session_history WHERE session_history.stopped >= rrz) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id JOIN users AS u ON u.user_id = sh.user_id GROUP BY sh.user_id ORDER BY total_count DESC LIMIT 10aSELECT u.user_id, u.username, (CASE WHEN u.friendly_name IS NULL OR TRIM(u.friendly_name) = '' THEN u.username ELSE u.friendly_name END) AS friendly_name,SUM(CASE WHEN sh.media_type = 'episode' AND shm.live = 0 THEN sh.d ELSE 0 END) AS tv_count, SUM(CASE WHEN sh.media_type = 'movie' AND shm.live = 0 THEN sh.d ELSE 0 END) AS movie_count, SUM(CASE WHEN sh.media_type = 'track' AND shm.live = 0 THEN sh.d ELSE 0 END) AS music_count, SUM(CASE WHEN shm.live = 1 THEN sh.d ELSE 0 END) AS live_count, SUM(sh.d) AS total_duration FROM (SELECT *, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= rz) AS sh JOIN session_history_metadata AS shm ON shm.id = sh.id JOIN users AS u ON u.user_id = sh.user_id GROUP BY sh.user_id ORDER BY total_duration DESC LIMIT 10z\Tautulli Graphs :: Unable to execute database query for get_total_plays_by_top_10_users: %s.rIusername Plex User friendly_namer r!r"r#r$r%r(r)r*r+r,r-r.r/)rr2rr3r4r5r6r7r8r9r:rr;rget_session_user_idrDstrrrF)rrGrHrIrJrKr4rLrMrNrOrPr0rVrWrXrYsession_user_idrQrarbrcrdrerfs rget_total_plays_by_top_10_usersz&Graphs.get_total_plays_by_top_10_usersOso--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW2  "'0H!F$$**51'!X'0H/F2$**51  !557 0D!!c$y/6Jo6]$z"2cno!!$"78 OOD, - OOD/ 0 OOD/ 0 OOD. / 0$(#+-#+#+-#*#+-#,#+-  % %f -   1  % %g .   1  % %h /   1  % %f -   1 *)+ Y  KKvyzz { sAH** I3IIcdtj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } | D cic]} | d|  } } tjj}t!dt#|Dcgc]}|tj$|z }}g}g}g}g}t'|D]}|j)d}|j+|| j-|i}|j-dd}|j-dd}|j-dd}|j+||j+||j+|d|d}d|d}d|d}||||gd}|S#t$r"} tjd | zYd} ~ yd} ~ wwxYwcc} wcc}w)NrrrrrraSELECT sh.date_played, SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN 1 ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN 1 ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN 1 ELSE 0 END) AS tc_count FROM (SELECT *, date(started, 'unixepoch', 'localtime') AS date_played FROM session_history WHERE session_history.stopped >= rrzn) AS sh JOIN session_history_media_info AS shmi ON shmi.id = sh.id GROUP BY sh.date_played ORDER BY sh.startedaASELECT sh.date_played, SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN sh.d ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN sh.d ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN sh.d ELSE 0 END) AS tc_count FROM (SELECT *, date(started, 'unixepoch', 'localtime') AS date_played, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= r\Tautulli Graphs :: Unable to execute database query for get_total_plays_per_stream_type: %s.rrrrdp_countds_counttc_count Direct Playr% Direct Stream Transcoder/)rr2rr3r4r5r6r7r8r9r:rr;r<r=r>r?r@rArBrCrDrE)rrGrHrIrJrKr4rLrMrNrOrPrQrRrSrTrUr0rVrWrXrZr[r\r]r^r_rarbrcrfs rget_total_plays_per_stream_typez&Graphs.get_total_plays_per_stream_typesW--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW$  2;Ix Q$**51!<2;IxQ $**51 HN Ntm!4d!: N N}}""$@EaZ@YZ1TH..A66Z Z  * ,I#,,Z8K   k */33KDK(__Z;N(__Z;N(__Z;N OON + OON + OON + ,$1#+-#2#+-#.#+-!+,oOQ O  KKvyzz { !O [s%AG: H( H-: H%H  H%cptj}tj|xsd}tj|dzdzdzz }|j |d}d}d|d|d}|j |}tj|d } tj|d } tjj} td t|D cgc]} | tj | z }} g}g}g}g}g}t#|D]}|j%d}|j'||| j)|dfg}|| j)|dfg}|| j)|dfg}|| j)|g}|j'||j'||j'||j'|d|d}d|d}d|d}d|d}|||||gd}|S#t$r"} tjd | zYd} ~ yd} ~ wwxYwcc} w)NrrrWHEREcg}|D]H}|jt|ddzdd|jt|ddzddJt|d }d }d }d }|D]$}|d dk(r ||d z }||k\r|}|}||d z }&|S) NstartedBr)timecountstoppedAc |dS)Nrr )ks rzcGraphs.get_total_concurrent_streams_per_stream_type..calc_most_concurrent..s & r)keyrr)rDrrB)rOtimesrQr final_count last_countds rcalc_most_concurrentzQGraphs.get_total_concurrent_streams_per_stream_type..calc_most_concurrentsE P c$y/&:S&@1MN c$y/&:S&@2NO P5&9:EEKJ (W:?QwZ'E *%* &+ QwZ'E ( rzSELECT sh.date_played, sh.started, sh.stopped, shmi.transcode_decision FROM (SELECT *, date(started, 'unixepoch', 'localtime') AS date_played FROM session_history zc GROUP BY id) AS sh JOIN session_history_media_info AS shmi ON sh.id = shmi.id WHERE sh.stopped >= z ORDER BY sh.startedr)rtranscode_decisionrrrrz direct playcopy transcoderr%rrzMax. Concurrent Streamsr/)rr2rr3r4r5r9r:rr; group_by_keysr<r=r>r?r@rArBrCrDrE)rrGrIrKr4rLrrNrOrPresult_by_date_and_decisionresult_by_daterSrTrUr0rVrWrXrYrZr[r]r^r_r`rarbrcrdrfs r,get_total_concurrent_streams_per_stream_typez3Graphs.get_total_concurrent_streams_per_stream_typesj--/ ((4: %%'*r/B*>*CC ((':  , .7 CE &&u-F '.&;&;FDi&j# ..v}E}}""$@EaZ@YZ1TH..A66Z Z  * ,I#,,Z8K   k *1+//m0LbQN2+//f0ErJN2+//k0JBON2"";3N OON + OON + OON + OON +) ,,$1#+-#2#+-#.#+-#<#+-!+,oP_`b g  KKvyzz { [s#H H3 H0H++H0ctj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } g} g} g}g}| D]R}| j|d| j|d|j|d|j|dTd| d}d|d}d|d}| |||gd}|S#t$r"} tjd | zYd} ~ yd} ~ wwxYw)NrrrrrraSELECT shmi.video_full_resolution AS resolution, SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN 1 ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN 1 ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN 1 ELSE 0 END) AS tc_count, COUNT(sh.id) AS total_count FROM (SELECT * FROM session_history WHERE session_history.stopped >= < AND session_history.media_type IN ('movie', 'episode') ry) AS sh JOIN session_history_media_info AS shmi ON shmi.id = sh.id GROUP BY resolution ORDER BY total_count DESC LIMIT 10a:SELECT shmi.video_full_resolution AS resolution,SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN sh.d ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN sh.d ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN sh.d ELSE 0 END) AS tc_count, SUM(sh.d) AS total_duration FROM (SELECT *, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= |) AS sh JOIN session_history_media_info AS shmi ON shmi.id = sh.id GROUP BY resolution ORDER BY total_duration DESC LIMIT 10zaTautulli Graphs :: Unable to execute database query for get_total_plays_by_source_resolution: %s. resolutionrrrrr%rrr/rr2rr3r4r5r6r7r8r9r:rr;rDrrGrHrIrJrKr4rLrMrNrOrPr0rVrWrXrQrarbrcrfs r$get_total_plays_by_source_resolutionz+Graphs.get_total_plays_by_source_resolutionps--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW(  '0H F$**51!!D'0H!F$$**51   .D   d<0 1 OOD, - OOD, - OOD, -  .$1#+-#2#+-#.#+-!+,oOQ 3  KK{~ A AD:: E%E  E%ctj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } g} g} g}g}| D]R}| j|d| j|d|j|d|j|dTd| d}d|d}d|d}| |||gd}|S#t$r"} tjd | zYd} ~ yd} ~ wwxYw)NrrrrrraSELECT (CASE WHEN shmi.stream_video_full_resolution IS NULL THEN (CASE WHEN shmi.video_decision = 'transcode' THEN (CASE WHEN shmi.transcode_height <= 360 THEN 'SD' WHEN shmi.transcode_height <= 480 THEN '480' WHEN shmi.transcode_height <= 576 THEN '576' WHEN shmi.transcode_height <= 720 THEN '720' WHEN shmi.transcode_height <= 1080 THEN '1080' WHEN shmi.transcode_height <= 1440 THEN 'QHD' WHEN shmi.transcode_height <= 2160 THEN '4k' ELSE 'unknown' END) ELSE shmi.video_full_resolution END) ELSE shmi.stream_video_full_resolution END) AS resolution, SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN 1 ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN 1 ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN 1 ELSE 0 END) AS tc_count, COUNT(sh.id) AS total_count FROM (SELECT * FROM session_history WHERE session_history.stopped >= rrraoSELECT (CASE WHEN shmi.stream_video_full_resolution IS NULL THEN (CASE WHEN shmi.video_decision = 'transcode' THEN (CASE WHEN shmi.transcode_height <= 360 THEN 'SD' WHEN shmi.transcode_height <= 480 THEN '480' WHEN shmi.transcode_height <= 576 THEN '576' WHEN shmi.transcode_height <= 720 THEN '720' WHEN shmi.transcode_height <= 1080 THEN '1080' WHEN shmi.transcode_height <= 1440 THEN 'QHD' WHEN shmi.transcode_height <= 2160 THEN '4k' ELSE 'unknown' END) ELSE shmi.video_full_resolution END) ELSE shmi.stream_video_full_resolution END) AS resolution, SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN sh.d ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN sh.d ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN sh.d ELSE 0 END) AS tc_count, SUM(sh.d) AS total_duration FROM (SELECT *, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= rzaTautulli Graphs :: Unable to execute database query for get_total_plays_by_stream_resolution: %s.rrrrrr%rrr/rrs r$get_total_plays_by_stream_resolutionz+Graphs.get_total_plays_by_stream_resolutions--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CWB  6'0H5F8$**51;!x'0H;F>$**51   .D   d<0 1 OOD, - OOD, - OOD, -  .$1#+-#2#+-#.#+-!+,oOQ 3  KK{~ A rctj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } g} g} g}g}| D]s}| jtjj!|d|d| j|d|j|d|j|dud| d}d|d}d|d}| |||gd}|S#t$r"} tjd | zYd} ~ yd} ~ wwxYw)NrrrrrravSELECT sh.platform, SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN 1 ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN 1 ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN 1 ELSE 0 END) AS tc_count, COUNT(sh.id) AS total_count FROM (SELECT * FROM session_history WHERE session_history.stopped >= rrzz) AS sh JOIN session_history_media_info AS shmi ON shmi.id = sh.id GROUP BY sh.platform ORDER BY total_count DESC LIMIT 10aSELECT sh.platform, SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN sh.d ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN sh.d ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN sh.d ELSE 0 END) AS tc_count, SUM(sh.d) AS total_duration FROM (SELECT *, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= z}) AS sh JOIN session_history_media_info AS shmi ON shmi.id = sh.id GROUP BY sh.platform ORDER BY total_duration DESC LIMIT 10z`Tautulli Graphs :: Unable to execute database query for get_stream_type_by_top_10_platforms: %s.rrrrrr%rrr/)rr2rr3r4r5r6r7r8r9r:rr;rDrrrErs r#get_stream_type_by_top_10_platformsz*Graphs.get_stream_type_by_top_10_platforms&s--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW&  '0H F$**51!@'0HF"$**51   .D   f<<@@jAQSWXbScd e OOD, - OOD, - OOD, -  .$1#+-#2#+-#.#+-!+,oOQ 5  KKz}~~  sAE F$FFcLtj}tj|xsd}tj|dzdzdzz }|j |}|t jj}|rdnd} |dk(rd|d|d |d } |j| } nd |d|d |d } |j| } g} g} g}g}tj}| D]|}|r(| jt!|d|k(r|dndn| j|d| j|d|j|d|j|d~d| d}d|d}d|d}| |||gd}|S#t$r"} tjd | zYd} ~ yd} ~ wwxYw)NrrrrrraSELECT u.user_id, u.username, (CASE WHEN u.friendly_name IS NULL OR TRIM(u.friendly_name) = '' THEN u.username ELSE u.friendly_name END) AS friendly_name,SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN 1 ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN 1 ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN 1 ELSE 0 END) AS tc_count, COUNT(sh.id) AS total_count FROM (SELECT * FROM session_history WHERE session_history.stopped >= rrz) AS sh JOIN session_history_media_info AS shmi ON shmi.id = sh.id JOIN users AS u ON u.user_id = sh.user_id GROUP BY u.user_id ORDER BY total_count DESC LIMIT 10aSELECT u.user_id, u.username, (CASE WHEN u.friendly_name IS NULL OR TRIM(u.friendly_name) = '' THEN u.username ELSE u.friendly_name END) AS friendly_name,SUM(CASE WHEN shmi.transcode_decision = 'direct play' THEN sh.d ELSE 0 END) AS dp_count, SUM(CASE WHEN shmi.transcode_decision = 'copy' THEN sh.d ELSE 0 END) AS ds_count, SUM(CASE WHEN shmi.transcode_decision = 'transcode' THEN sh.d ELSE 0 END) AS tc_count, SUM(sh.d) AS total_duration FROM (SELECT *, SUM(CASE WHEN stopped > 0 THEN (stopped - started) - (CASE WHEN paused_counter IS NULL THEN 0 ELSE paused_counter END) ELSE 0 END) AS d FROM session_history WHERE session_history.stopped >= z) AS sh JOIN session_history_media_info AS shmi ON shmi.id = sh.id JOIN users AS u ON u.user_id = sh.user_id GROUP BY u.user_id ORDER BY total_duration DESC LIMIT 10z\Tautulli Graphs :: Unable to execute database query for get_stream_type_by_top_10_users: %s.rIrrrrrrrr%rrr/)rr2rr3r4r5r6r7r8r9r:rr;rrrDr)rrGrHrIrJrKr4rLrMrNrOrPr0rVrWrXrrQrarbrcrfs rget_stream_type_by_top_10_usersz&Graphs.get_stream_type_by_top_10_usersss--/ ((4: %%'*r/B*>*CC ((1  }}99H5=1CW,  '0HF"$**51%!L'0H%F($**51  !557 .D!!c$y/6Jo6]$z"2cno!!$"78 OOD, - OOD, - OOD, - .$1#+-#2#+-#.#+-!+,oOQ ?  KKvyzz { sAE88 F#FF#c.d}tjr>|r<|ttjk7r|dtjzz}|S|r>tj|}t d|Dr|ddj |zz}|S)zG Expects user_id to be a comma-separated list of ints. z session_history.user_id = %s c3<K|]}|jywr )isdigit).0ids r z)Graphs._make_user_cond..s3B2::<3sz! session_history.user_id IN (%s) ,)rrrr split_stripalljoin)rrI cond_prefixrLuser_idss rr5zGraphs._make_user_conds  & & (WCHcHcHeDf9f#&FIdIdIf&ffI  **73H3(33'*MPSPXPXYaPb*bb r)30rNN)rrNN)rN)AND)__name__ __module__ __qualname__rrgrvrrrrrrrrrrr5r rrr r s` kZ||jXrh^@iVVp\|L\fPKZVp rr ) r<rr6rrrrrrobjectr r rrrs0$ xVxr