X-Git-Url: http://de.git.xonotic.org/?p=xonotic%2Fxonstat.git;a=blobdiff_plain;f=xonstat%2Fbatch%2Fbadges%2Fgen_badges.py;h=0aa3f6014f28ced6956835d349b909925e9e77e6;hp=6ff16396599a5db80bdfa201e27cf0c0ef21ab97;hb=1a02dc60b8aeb312c2fd8024362224cfbc3ddc7a;hpb=681f425ad3132d659497603e4c329035adba0e2f diff --git a/xonstat/batch/badges/gen_badges.py b/xonstat/batch/badges/gen_badges.py index 6ff1639..0aa3f60 100644 --- a/xonstat/batch/badges/gen_badges.py +++ b/xonstat/batch/badges/gen_badges.py @@ -1,496 +1,117 @@ #-*- coding: utf-8 -*- import sys -import re -import cairo as C +from datetime import datetime import sqlalchemy as sa import sqlalchemy.sql.functions as func -from datetime import datetime -from mako.template import Template -from os import system +from sqlalchemy import distinct from pyramid.paster import bootstrap from xonstat.models import * -from xonstat.views.player import player_info_data -from xonstat.util import qfont_decode, _all_colors -from colorsys import rgb_to_hls, hls_to_rgb - - -# similar to html_colors() from util.py -_contrast_threshold = 0.5 - -_dec_colors = [ (0.5,0.5,0.5), - (1.0,0.0,0.0), - (0.2,1.0,0.0), - (1.0,1.0,0.0), - (0.2,0.4,1.0), - (0.2,1.0,1.0), - (1.0,0.2,102), - (1.0,1.0,1.0), - (0.6,0.6,0.6), - (0.5,0.5,0.5) - ] - - -# maximal number of query results (for testing, set to 0 to get all) -NUM_PLAYERS = 50 - -# image dimensions (likely breaks layout if changed) -WIDTH = 560 -HEIGHT = 70 - -# output filename, parameter is player id -OUTPUT = "output/%d.png" - - -NICK_POS = (5,18) -NICK_MAXWIDTH = 330 - -GAMES_POS = (60,35) -GAMES_WIDTH = 110 -WINLOSS_POS = (508,6) -WINLOSS_WIDTH = 104 - -KILLDEATH_POS = (390,6) -KILLDEATH_WIDTH = 104 - -PLAYTIME_POS = (452,64) -PLAYTIME_WIDTH = 218 - - -# parameters to affect the output, could be changed via URL -params = { - 'bg': 1, # 0 - black, 1 - dark_wall, ... - 'overlay': 0, # 0 - none, 1 - default overlay, ... - 'font': 0, # 0 - xolonium, 1 - dejavu sans -} +from skin import Skin +from playerdata import PlayerData + + +# maximal number of query results (for testing, set to None to get all) +NUM_PLAYERS = None + +# we look for players who have activity within the past DELTA hours +DELTA = 6 + + +# classic skin WITHOUT NAME - writes PNGs into "output//###.png" +skin_classic = Skin( "", + bg = "broken_noise", + overlay = "overlay_classic", + ) + +# more fancy skin [** WIP **]- writes PNGs into "output/archer/###.png" +skin_archer = Skin( "archer", + bg = "background_archer-v1", + overlay = None, + ) + +# minimal skin - writes PNGs into "output/minimal/###.png" +skin_minimal = Skin( "minimal", + bg = None, + bgcolor = (0.04, 0.04, 0.04, 1.0), + overlay = "overlay_minimal", + width = 560, + height = 40, + nick_fontsize = 16, + nick_pos = (36,16), + num_gametypes = 3, + nick_maxwidth = 300, + gametype_pos = (70,30), + gametype_color = (0.0, 0.0, 0.0), + gametype_text = "%s:", + gametype_width = 100, + gametype_fontsize = 10, + gametype_align = -1, + gametype_upper = False, + elo_pos = (75,30), + elo_text = "Elo %.0f", + elo_color = (0.7, 0.7, 0.7), + elo_align = 1, + rank_pos = None, + nostats_pos = None, + #nostats_pos = (75,30), + #nostats_fontsize = 10, + #nostats_angle = 0, + #nostats_text = "no stats yet!", + #nostats_color = (0.7, 0.4, 0.4), + kdr_pos = (392,15), + kdr_fontsize = 10, + kdr_colortop = (0.6, 0.8, 0.6), + kdr_colormid = (0.6, 0.6, 0.6), + kdr_colorbot = (0.8, 0.6, 0.6), + kills_pos = None, + deaths_pos = None, + winp_pos = (508,15), + winp_fontsize = 10, + winp_colortop = (0.6, 0.8, 0.8), + winp_colormid = (0.6, 0.6, 0.6), + winp_colorbot = (0.8, 0.8, 0.6), + wins_pos = None, + loss_pos = None, + ptime_pos = (451,30), + ptime_color = (0.7, 0.7, 0.7), + ) # parse cmdline parameters (for testing) -for arg in sys.argv[1:]: - try: - k,v = arg.split("=") - if params.has_key(k.lower()): - params[k] = int(v) - except: - continue - - -def get_data(player): - """Return player data as dict. - - This function is similar to the function in player.py but more optimized - for this purpose. - """ - - # total games - # wins/losses - # kills/deaths - # duel/dm/tdm/ctf elo + rank - - player_id = player.player_id - - total_stats = {} - - games_played = DBSession.query( - Game.game_type_cd, func.count(), func.sum(PlayerGameStat.alivetime)).\ - filter(Game.game_id == PlayerGameStat.game_id).\ - filter(PlayerGameStat.player_id == player_id).\ - group_by(Game.game_type_cd).\ - order_by(func.count().desc()).\ - limit(3).all() # limit to 3 gametypes! - - total_stats['games'] = 0 - total_stats['games_breakdown'] = {} # this is a dictionary inside a dictionary .. dictception? - total_stats['games_alivetime'] = {} - total_stats['gametypes'] = [] - for (game_type_cd, games, alivetime) in games_played: - total_stats['games'] += games - total_stats['gametypes'].append(game_type_cd) - total_stats['games_breakdown'][game_type_cd] = games - total_stats['games_alivetime'][game_type_cd] = alivetime - - (total_stats['kills'], total_stats['deaths'], total_stats['alivetime'],) = DBSession.query( - func.sum(PlayerGameStat.kills), - func.sum(PlayerGameStat.deaths), - func.sum(PlayerGameStat.alivetime)).\ - filter(PlayerGameStat.player_id == player_id).\ - one() - - (total_stats['wins'],) = DBSession.query( - func.count("*")).\ - filter(Game.game_id == PlayerGameStat.game_id).\ - filter(PlayerGameStat.player_id == player_id).\ - filter(Game.winner == PlayerGameStat.team or PlayerGameStat.rank == 1).\ - one() - - ranks = DBSession.query("game_type_cd", "rank", "max_rank").\ - from_statement( - "select pr.game_type_cd, pr.rank, overall.max_rank " - "from player_ranks pr, " - "(select game_type_cd, max(rank) max_rank " - "from player_ranks " - "group by game_type_cd) overall " - "where pr.game_type_cd = overall.game_type_cd " - "and player_id = :player_id " - "order by rank").\ - params(player_id=player_id).all() - - ranks_dict = {} - for gtc,rank,max_rank in ranks: - ranks_dict[gtc] = (rank, max_rank) - - elos = DBSession.query(PlayerElo).\ - filter_by(player_id=player_id).\ - order_by(PlayerElo.elo.desc()).\ - all() - - elos_dict = {} - for elo in elos: - if elo.games > 32: - elos_dict[elo.game_type_cd] = elo.elo - - data = { - 'player':player, - 'total_stats':total_stats, - 'ranks':ranks_dict, - 'elos':elos_dict, - } - - #print data - return data - - -def render_image(data): - """Render an image from the given data fields.""" - - font = "Xolonium" - if params['font'] == 1: - font = "DejaVu Sans" - total_stats = data['total_stats'] - total_games = total_stats['games'] - elos = data["elos"] - ranks = data["ranks"] - - - ## create background - - surf = C.ImageSurface(C.FORMAT_RGB24, WIDTH, HEIGHT) - ctx = C.Context(surf) - ctx.set_antialias(C.ANTIALIAS_GRAY) - - # draw background (just plain fillcolor) - if params['bg'] == 0: - ctx.rectangle(0, 0, WIDTH, HEIGHT) - ctx.set_source_rgb(0.04, 0.04, 0.04) # bgcolor of Xonotic forum - ctx.fill() - - # draw background image (try to get correct tiling, too) - if params['bg'] > 0: - bg = None - if params['bg'] == 1: - bg = C.ImageSurface.create_from_png("img/dark_wall.png") - elif params['bg'] == 2: - bg = C.ImageSurface.create_from_png("img/asfalt.png") - elif params['bg'] == 3: - bg = C.ImageSurface.create_from_png("img/broken_noise.png") - elif params['bg'] == 4: - bg = C.ImageSurface.create_from_png("img/burried.png") - elif params['bg'] == 5: - bg = C.ImageSurface.create_from_png("img/dark_leather.png") - elif params['bg'] == 6: - bg = C.ImageSurface.create_from_png("img/txture.png") - elif params['bg'] == 7: - bg = C.ImageSurface.create_from_png("img/black_linen_v2.png") - elif params['bg'] == 8: - bg = C.ImageSurface.create_from_png("img/background_archer-v1.png") - - # tile image - if bg: - bg_w, bg_h = bg.get_width(), bg.get_height() - bg_xoff = 0 - while bg_xoff < WIDTH: - bg_yoff = 0 - while bg_yoff < HEIGHT: - ctx.set_source_surface(bg, bg_xoff, bg_yoff) - ctx.paint() - bg_yoff += bg_h - bg_xoff += bg_w - - # draw overlay graphic - if params['overlay'] > 0: - overlay = None - if params['overlay'] == 1: - overlay = C.ImageSurface.create_from_png("img/overlay.png") - if overlay: - ctx.set_source_surface(overlay, 0, 0) - ctx.mask_surface(overlay) - ctx.paint() - - - ## draw player's nickname with fancy colors - - # deocde nick, strip all weird-looking characters - qstr = qfont_decode(player.nick).replace('^^', '^').replace(u'\x00', '').replace(u' ', ' ') - chars = [] - for c in qstr: - if ord(c) < 128: - chars.append(c) - qstr = ''.join(chars) - stripped_nick = strip_colors(qstr) - - # fontsize is reduced if width gets too large - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(20) - xoff, yoff, tw, th = ctx.text_extents(stripped_nick)[:4] - if tw > NICK_MAXWIDTH: - ctx.set_font_size(18) - xoff, yoff, tw, th = ctx.text_extents(stripped_nick)[:4] - if tw > NICK_MAXWIDTH: - ctx.set_font_size(16) - xoff, yoff, tw, th = ctx.text_extents(stripped_nick)[:4] - if tw > NICK_MAXWIDTH: - ctx.set_font_size(14) - xoff, yoff, tw, th = ctx.text_extents(stripped_nick)[:4] - if tw > NICK_MAXWIDTH: - ctx.set_font_size(12) - - - # split up nick into colored segments and draw each of them - - # split nick into colored segments - xoffset = 0 - _all_colors = re.compile(r'(\^\d|\^x[\dA-Fa-f]{3})') - #print qstr, _all_colors.findall(qstr), _all_colors.split(qstr) - - parts = _all_colors.split(qstr) - while len(parts) > 0: - tag = None - txt = parts[0] - if _all_colors.match(txt): - tag = txt[1:] # strip leading '^' - if len(parts) < 2: - break - txt = parts[1] - del parts[1] - del parts[0] - - if not txt or len(txt) == 0: - # only colorcode and no real text, skip this - continue - - r,g,b = _dec_colors[7] - try: - if tag.startswith('x'): - r = int(tag[1] * 2, 16) / 255.0 - g = int(tag[2] * 2, 16) / 255.0 - b = int(tag[3] * 2, 16) / 255.0 - hue, light, satur = rgb_to_hls(r, g, b) - if light < _contrast_threshold: - light = _contrast_threshold - r, g, b = hls_to_rgb(hue, light, satur) - else: - r,g,b = _dec_colors[int(tag[0])] - except: - r,g,b = _dec_colors[7] - - ctx.set_source_rgb(r, g, b) - ctx.move_to(NICK_POS[0] + xoffset, NICK_POS[1]) - ctx.show_text(txt) - - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - tw += (len(txt)-len(txt.strip()))*3 # account for lost whitespaces - xoffset += tw + 2 - - - ## print elos and ranks - - # show up to three gametypes the player has participated in - xoffset = 0 - for gt in total_stats['gametypes'][:3]: - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_BOLD) - ctx.set_font_size(10) - ctx.set_source_rgb(1.0, 1.0, 1.0) - txt = "[ %s ]" % gt.upper() - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(GAMES_POS[0]+xoffset-xoff-tw/2, GAMES_POS[1]-yoff-4) - ctx.show_text(txt) - - old_aa = ctx.get_antialias() - ctx.set_antialias(C.ANTIALIAS_NONE) - ctx.set_source_rgb(0.8, 0.8, 0.8) - ctx.set_line_width(1) - ctx.move_to(GAMES_POS[0]+xoffset-GAMES_WIDTH/2+5, GAMES_POS[1]+8) - ctx.line_to(GAMES_POS[0]+xoffset+GAMES_WIDTH/2-5, GAMES_POS[1]+8) - ctx.stroke() - ctx.move_to(GAMES_POS[0]+xoffset-GAMES_WIDTH/2+5, GAMES_POS[1]+32) - ctx.line_to(GAMES_POS[0]+xoffset+GAMES_WIDTH/2-5, GAMES_POS[1]+32) - ctx.stroke() - ctx.set_antialias(old_aa) - - if not elos.has_key(gt) or not ranks.has_key(gt): - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_BOLD) - ctx.set_font_size(12) - ctx.set_source_rgb(0.8, 0.2, 0.2) - txt = "no stats yet!" - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(GAMES_POS[0]+xoffset-xoff-tw/2, GAMES_POS[1]+28-yoff-4) - ctx.save() - ctx.rotate(math.radians(-10)) - ctx.show_text(txt) - ctx.restore() +skins = [] +for arg in sys.argv[1:]: + if arg.startswith("-"): + arg = arg[1:] + if arg == "force": + DELTA = 2**24 # large enough to enforce update, and doesn't result in errors + elif arg == "test": + NUM_PLAYERS = 100 else: - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(10) - ctx.set_source_rgb(1.0, 1.0, 0.5) - txt = "Elo: %.0f" % round(elos[gt], 0) - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(GAMES_POS[0]+xoffset-xoff-tw/2, GAMES_POS[1]+15-yoff-4) - ctx.show_text(txt) - - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(8) - ctx.set_source_rgb(0.8, 0.8, 1.0) - txt = "Rank %d of %d" % ranks[gt] - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(GAMES_POS[0]+xoffset-xoff-tw/2, GAMES_POS[1]+25-yoff-3) - ctx.show_text(txt) - - xoffset += GAMES_WIDTH - - - # print win percentage - - if params['overlay'] == 0: - ctx.rectangle(WINLOSS_POS[0]-WINLOSS_WIDTH/2, WINLOSS_POS[1]-7, WINLOSS_WIDTH, 15) - ctx.set_source_rgba(0.8, 0.8, 0.8, 0.1) - ctx.fill(); - - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(10) - ctx.set_source_rgb(0.8, 0.8, 0.8) - txt = "Win Percentage" - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(WINLOSS_POS[0]-xoff-tw/2, WINLOSS_POS[1]-yoff-3) - ctx.show_text(txt) - - wins, losses = total_stats["wins"], total_games-total_stats["wins"] - txt = "???" - try: - ratio = float(wins)/total_games - txt = "%.2f%%" % round(ratio * 100, 2) - except: - ratio = 0 - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_BOLD) - ctx.set_font_size(12) - if ratio >= 0.90: - ctx.set_source_rgb(0.2, 1.0, 1.0) - elif ratio >= 0.75: - ctx.set_source_rgb(0.5, 1.0, 1.0) - elif ratio >= 0.5: - ctx.set_source_rgb(0.5, 1.0, 0.8) - elif ratio >= 0.25: - ctx.set_source_rgb(0.8, 1.0, 0.5) + print """Usage: gen_badges.py [options] [skin list] + Options: + -force Force updating all badges (delta = 2^24) + -test Limit number of players to 100 (for testing) + -help Show this help text + Skin list: + Space-separated list of skins to use when creating badges. + Available skins: classic, minimal, archer + If no skins are given, classic and minmal will be used by default. + NOTE: Output directories must exists before running the program! +""" + sys.exit(-1) else: - ctx.set_source_rgb(1.0, 1.0, 0.5) - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(WINLOSS_POS[0]-xoff-tw/2, WINLOSS_POS[1]+18-yoff-4) - ctx.show_text(txt) - - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(8) - ctx.set_source_rgb(0.6, 0.8, 0.8) - txt = "%d win" % wins - if wins != 1: - txt += "s" - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(WINLOSS_POS[0]-xoff-tw/2, WINLOSS_POS[1]+30-yoff-3) - ctx.show_text(txt) - ctx.set_source_rgb(0.8, 0.8, 0.6) - txt = "%d loss" % losses - if losses != 1: - txt += "es" - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(WINLOSS_POS[0]-xoff-tw/2, WINLOSS_POS[1]+40-yoff-3) - ctx.show_text(txt) - - - # print kill/death ratio - - if params['overlay'] == 0: - ctx.rectangle(KILLDEATH_POS[0]-KILLDEATH_WIDTH/2, KILLDEATH_POS[1]-7, KILLDEATH_WIDTH, 15) - ctx.set_source_rgba(0.8, 0.8, 0.8, 0.1) - ctx.fill() - - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(10) - ctx.set_source_rgb(0.8, 0.8, 0.8) - txt = "Kill Ratio" - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(KILLDEATH_POS[0]-xoff-tw/2, KILLDEATH_POS[1]-yoff-3) - ctx.show_text(txt) - - kills, deaths = total_stats['kills'] , total_stats['deaths'] - txt = "???" - try: - ratio = float(kills)/deaths - txt = "%.3f" % round(ratio, 3) - except: - ratio = 0 - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_BOLD) - ctx.set_font_size(12) - if ratio >= 3: - ctx.set_source_rgb(0.0, 1.0, 0.0) - elif ratio >= 2: - ctx.set_source_rgb(0.2, 1.0, 0.2) - elif ratio >= 1: - ctx.set_source_rgb(0.5, 1.0, 0.5) - elif ratio >= 0.5: - ctx.set_source_rgb(1.0, 0.5, 0.5) - else: - ctx.set_source_rgb(1.0, 0.2, 0.2) - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(KILLDEATH_POS[0]-xoff-tw/2, KILLDEATH_POS[1]+18-yoff-4) - ctx.show_text(txt) - - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(8) - ctx.set_source_rgb(0.6, 0.8, 0.6) - txt = "%d kill" % kills - if kills != 1: - txt += "s" - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(KILLDEATH_POS[0]-xoff-tw/2, KILLDEATH_POS[1]+30-yoff-3) - ctx.show_text(txt) - ctx.set_source_rgb(0.8, 0.6, 0.6) - txt = "%d death" % deaths - if deaths != 1: - txt += "s" - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(KILLDEATH_POS[0]-xoff-tw/2, KILLDEATH_POS[1]+40-yoff-3) - ctx.show_text(txt) - - - # print playing time - - if params['overlay'] == 0: - ctx.rectangle( PLAYTIME_POS[0]-PLAYTIME_WIDTH/2, PLAYTIME_POS[1]-7, PLAYTIME_WIDTH, 14) - ctx.set_source_rgba(0.8, 0.8, 0.8, 0.6) - ctx.fill(); - - ctx.select_font_face(font, C.FONT_SLANT_NORMAL, C.FONT_WEIGHT_NORMAL) - ctx.set_font_size(10) - ctx.set_source_rgb(0.1, 0.1, 0.1) - txt = "Playing time: %s" % str(total_stats['alivetime']) - xoff, yoff, tw, th = ctx.text_extents(txt)[:4] - ctx.move_to(PLAYTIME_POS[0]-xoff-tw/2, PLAYTIME_POS[1]-yoff-4) - ctx.show_text(txt) - - - # save to PNG - surf.write_to_png(OUTPUT % data['player'].player_id) + if arg == "classic": + skins.append(skin_classic) + elif arg == "minimal": + skins.append(skin_minimal) + elif arg == "archer": + skins.append(skin_archer) +if len(skins) == 0: + skins = [ skin_classic, skin_minimal ] # environment setup env = bootstrap('../../../development.ini') @@ -498,39 +119,64 @@ req = env['request'] req.matchdict = {'id':3} print "Requesting player data from db ..." +cutoff_dt = datetime.utcnow() - timedelta(hours=DELTA) start = datetime.now() -players = DBSession.query(Player).\ - filter(Player.player_id == PlayerElo.player_id).\ - filter(Player.nick != None).\ - filter(Player.player_id > 2).\ - filter(Player.active_ind == True).\ - limit(NUM_PLAYERS).all() -stop = datetime.now() -print "Query took %.2f seconds" % (stop-start).total_seconds() - -print "Creating badges for %d active players ..." % len(players) -start = datetime.now() -data_time, render_time = 0,0 -for player in players: - req.matchdict['id'] = player.player_id - - sstart = datetime.now() - #data = player_info_data(req) - data = get_data(player) - sstop = datetime.now() - data_time += (sstop-sstart).total_seconds() - - print "\r #%-5d" % player.player_id, - sys.stdout.flush() - - sstart = datetime.now() - render_image(data) - sstop = datetime.now() - render_time += (sstop-sstart).total_seconds() -print +players = [] +if NUM_PLAYERS: + players = DBSession.query(distinct(Player.player_id)).\ + filter(Player.player_id == PlayerElo.player_id).\ + filter(Player.player_id == PlayerGameStat.player_id).\ + filter(PlayerGameStat.create_dt > cutoff_dt).\ + filter(Player.nick != None).\ + filter(Player.player_id > 2).\ + filter(Player.active_ind == True).\ + limit(NUM_PLAYERS).all() +else: + players = DBSession.query(distinct(Player.player_id)).\ + filter(Player.player_id == PlayerElo.player_id).\ + filter(Player.player_id == PlayerGameStat.player_id).\ + filter(PlayerGameStat.create_dt > cutoff_dt).\ + filter(Player.nick != None).\ + filter(Player.player_id > 2).\ + filter(Player.active_ind == True).\ + all() -stop = datetime.now() -print "Creating the badges took %.2f seconds (%.2f s per player)" % ((stop-start).total_seconds(), (stop-start).total_seconds()/float(len(players))) -print " Total time for getting data: %.2f s" % data_time -print " Total time for renering images: %.2f s" % render_time +playerdata = PlayerData() + +if len(players) > 0: + stop = datetime.now() + td = stop-start + total_seconds = (td.microseconds + (td.seconds + td.days * 24 * 3600) * 10**6) / 10**6 + print "Query took %.2f seconds" % (total_seconds) + + print "Creating badges for %d players ..." % len(players) + start = datetime.now() + data_time, render_time = 0,0 + for player_id in players: + req.matchdict['id'] = player_id + + sstart = datetime.now() + playerdata.get_data(player_id) + sstop = datetime.now() + td = sstop-sstart + total_seconds = float(td.microseconds + (td.seconds + td.days * 24 * 3600) * 10**6) / 10**6 + data_time += total_seconds + + sstart = datetime.now() + for sk in skins: + sk.render_image(playerdata, "output/%s/%d.png" % (str(sk), player_id[0])) + sstop = datetime.now() + td = sstop-sstart + total_seconds = float(td.microseconds + (td.seconds + td.days * 24 * 3600) * 10**6) / 10**6 + render_time += total_seconds + + stop = datetime.now() + td = stop-start + total_seconds = float(td.microseconds + (td.seconds + td.days * 24 * 3600) * 10**6) / 10**6 + print "Creating the badges took %.1f seconds (%.3f s per player)" % (total_seconds, total_seconds/float(len(players))) + print "Total time for rendering images: %.3f s" % render_time + print "Total time for getting data: %.3f s" % data_time + +else: + print "No active players found!"