Exemplo n.º 1
0
def generate_listenerhours(user):
    role_host = Role.get_role('host')
    total_listener_hours = 0

    for usershow in UserShow.query.filter(UserShow.user == user,
                                          UserShow.role == role_host,
                                          UserShow.status == UserShow.STATUS.STREAMED).yield_per(50):

        for listener in Listener.query.filter(Listener.connect <= usershow.show.end,
                                              usershow.show.begin <= Listener.disconnect).all():
            s = listener.connect
            if s < usershow.show.begin:
                s = usershow.show.begin
            e = listener.disconnect
            if e > usershow.show.end:
                e = usershow.show.end
            listener_time = e - s
            if listener_time.total_seconds() >= 0:
                total_listener_hours += listener_time.total_seconds()/3600
            else:
                print 'something went wrong: negative listenertime isn\'t possible'

    if total_listener_hours > 0 or True:
        us = UserStatistic.get_userstatistic(user, 'listenerhours')
        us.statistic.set(now(), total_listener_hours)
        rfk.database.session.flush()
Exemplo n.º 2
0
def generate_listener_peak(user):
    role_host = Role.get_role('host')
    user_listener_max = 0

    shows = Show.query.join(UserShow).filter(UserShow.user == user,
                                             UserShow.role == role_host,
                                             UserShow.status == UserShow.STATUS.STREAMED,
                                             Show.end <= now()).yield_per(50)

    for show in shows:
        try:
            stats_total = Statistic.query.filter(Statistic.identifier == 'lst-total').one()
            stats = stats_total.get(start=show.begin, stop=show.end)
        except exc.NoResultFound:
            stats = None

        if stats and stats.count() > 0:
            for stat in stats:
                if stat.value > user_listener_max:
                    user_listener_max = stat.value

    if user_listener_max > 0:
        us = UserStatistic.get_userstatistic(user, 'listenerpeak')
        us.statistic.set(now(), user_listener_max)
        rfk.database.session.flush()
Exemplo n.º 3
0
def generate_listenerhours(user):
    role_host = Role.get_role('host')
    total_listener_hours = 0

    for usershow in UserShow.query.filter(
            UserShow.user == user, UserShow.role == role_host,
            UserShow.status == UserShow.STATUS.STREAMED).yield_per(50):

        for listener in Listener.query.filter(
                Listener.connect <= usershow.show.end,
                usershow.show.begin <= Listener.disconnect).all():
            s = listener.connect
            if s < usershow.show.begin:
                s = usershow.show.begin
            e = listener.disconnect
            if e > usershow.show.end:
                e = usershow.show.end
            listener_time = e - s
            if listener_time.total_seconds() >= 0:
                total_listener_hours += listener_time.total_seconds() / 3600
            else:
                print 'something went wrong: negative listenertime isn\'t possible'

    if total_listener_hours > 0 or True:
        us = UserStatistic.get_userstatistic(user, 'listenerhours')
        us.statistic.set(now(), total_listener_hours)
        rfk.database.session.flush()
Exemplo n.º 4
0
def generate_listener_peak(user):
    role_host = Role.get_role('host')
    user_listener_max = 0

    shows = Show.query.join(UserShow).filter(
        UserShow.user == user, UserShow.role == role_host,
        UserShow.status == UserShow.STATUS.STREAMED,
        Show.end <= now()).yield_per(50)

    for show in shows:
        try:
            stats_total = Statistic.query.filter(
                Statistic.identifier == 'lst-total').one()
            stats = stats_total.get(start=show.begin, stop=show.end)
        except exc.NoResultFound:
            stats = None

        if stats and stats.count() > 0:
            for stat in stats:
                if stat.value > user_listener_max:
                    user_listener_max = stat.value

    if user_listener_max > 0:
        us = UserStatistic.get_userstatistic(user, 'listenerpeak')
        us.statistic.set(now(), user_listener_max)
        rfk.database.session.flush()
Exemplo n.º 5
0
def generate_missed_show_ratio(user):
    role_host = Role.get_role('host')
    missed_shows = 0
    total_shows = 0

    for usershow in UserShow.query.join(Show).filter(
            UserShow.user == user, UserShow.role == role_host,
            Show.flags == Show.FLAGS.PLANNED, Show.end <= now()).yield_per(50):

        total_shows += 1
        if usershow.status != UserShow.STATUS.STREAMED:
            missed_shows += 1

    if total_shows > 0:
        missed_show_ratio = (float(missed_shows) / float(total_shows)) * 100

        us = UserStatistic.get_userstatistic(user, 'missedshowratio')
        us.statistic.set(now(), missed_show_ratio)
        rfk.database.session.flush()
Exemplo n.º 6
0
def generate_missed_show_ratio(user):
    role_host = Role.get_role('host')
    missed_shows = 0
    total_shows = 0

    for usershow in UserShow.query.join(Show).filter(UserShow.user == user,
                                                     UserShow.role == role_host,
                                                     Show.flags == Show.FLAGS.PLANNED,
                                                     Show.end <= now()).yield_per(50):

        total_shows += 1
        if usershow.status != UserShow.STATUS.STREAMED:
            missed_shows += 1

    if total_shows > 0:
        missed_show_ratio = (float(missed_shows)/float(total_shows))*100

        us = UserStatistic.get_userstatistic(user, 'missedshowratio')
        us.statistic.set(now(), missed_show_ratio)
        rfk.database.session.flush()