Ant Zucaro antzucaro

## tuning_server_top_scorers.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                antzucaro
                / tuning_server_top_scorers.md
            
            
              Created
              March 14, 2021 18:37
            
              
                Query Tuning - Top Scorers by Server ID
              
          
    Server "top scorers" query

The original query in Python, using the ORM:
top_scorers_q = DBSession.query(
    fg.row_number().over(
        order_by=expr.desc(func.sum(PlayerGameStat.score))).label("rank"),
    Player.player_id, Player.nick,
    func.sum(PlayerGameStat.score).label("total_score"))\


## gist:9344ee8492b8ef868b63d1991a61a9c7
/*

This yeields the following:

12 bytes written
<nil>
could not decode data

*/

## rtmp.go
package main

import (
	"encoding/xml"
	"fmt"
	"io"
	"io/ioutil"
	"net/http"
	"os"
)

## strip_xonotic_low.txt
user@host:% tree autobuild/
autobuild/
├── data
│   ├── xonotic-rsync-data-low.pk3
│   └── xonotic-rsync-maps-low.pk3
├── key_0.d0pk
└── xonotic-linux64-dedicated

1 directory, 4 files

## blogofile_convert.go
package main

import (
    "bufio"
    "fmt"
    "os"
    "path/filepath"
    "strings"
    "strconv"
    "time"

## steps.txt
Generate the data (timestamps represent the entirety of 2013):

     go run summarizr.go -user antzucaro -key MY_API_KEY -from 1357016400 -to 1388552340

This produces a file "tracks.csv" with the selected range of data (8173 songs in total for me). One can load these tracks to a database easily with the below steps.

Create the database:

     postgres=# create database tracks2013 encoding='utf-8';
     CREATE DATABASE

## elo.py
from pyramid.paster import bootstrap
from xonstat.elo import *
from xonstat.models import *

def process_elos(game, session, game_type_cd=None):
    if game_type_cd is None:
        game_type_cd = game.game_type_cd

    # we do not have the actual duration of the game, so use the
    # maximum alivetime of the players instead

## ffrec.sh
#!/bin/sh

# this bit came from youtube.com/watch?v=_XDa1ahl7fw
INFO=$(xwininfo)
WIN_GEO=$(echo $INFO | grep -oEe 'geometry [0-9]+x[0-9]+' | grep -oEe '[0-9]+x[0-9]+')
WIN_XY=$(echo $INFO | grep -oEe 'Corners:\s+\+[0-9]+\+[0-9]+' | grep -oEe '[0-9]+\+[0-9]+' | sed -e 's/\+/,/' )

AUDIO_INPUT="-f alsa -i hw:0,0 -ac 2"
VIDEO_INPUT="-f x11grab -r 30 -s $WIN_GEO -i :0.0+$WIN_XY"
#AUDIO_CODEC="-acodec pcm_s16le"

## img_util.py
import sys
from glob import glob
from os import stat, rename
from os.path import splitext
from PIL import Image
from PIL.ExifTags import TAGS
from pyexif import ExifEditor
from time import strptime, mktime

# does not work as of 9/22/2011 - exception on _getexif() below

## new_post.py
#!/usr/bin/python

import os
import re
import sys
from optparse import OptionParser
from datetime import datetime

def sluggify(text=None):
    text = re.sub(r'[?:\'!@#$%^&*()+=]', '', text)
	/*

	This yeields the following:

	12 bytes written
	<nil>
	could not decode data

	*/
	package main

	import (
	"encoding/xml"
	"fmt"
	"io"
	"io/ioutil"
	"net/http"
	"os"
	)
	user@host:% tree autobuild/
	autobuild/
	├── data
	│ ├── xonotic-rsync-data-low.pk3
	│ └── xonotic-rsync-maps-low.pk3
	├── key_0.d0pk
	└── xonotic-linux64-dedicated

	1 directory, 4 files
	package main

	import (
	"bufio"
	"fmt"
	"os"
	"path/filepath"
	"strings"
	"strconv"
	"time"
	Generate the data (timestamps represent the entirety of 2013):

	go run summarizr.go -user antzucaro -key MY_API_KEY -from 1357016400 -to 1388552340

	This produces a file "tracks.csv" with the selected range of data (8173 songs in total for me). One can load these tracks to a database easily with the below steps.

	Create the database:

	postgres=# create database tracks2013 encoding='utf-8';
	CREATE DATABASE
	from pyramid.paster import bootstrap
	from xonstat.elo import *
	from xonstat.models import *

	def process_elos(game, session, game_type_cd=None):
	if game_type_cd is None:
	game_type_cd = game.game_type_cd

	# we do not have the actual duration of the game, so use the
	# maximum alivetime of the players instead
	#!/bin/sh

	# this bit came from youtube.com/watch?v=_XDa1ahl7fw
	INFO=$(xwininfo)
	WIN_GEO=$(echo $INFO \| grep -oEe 'geometry [0-9]+x[0-9]+' \| grep -oEe '[0-9]+x[0-9]+')
	WIN_XY=$(echo $INFO \| grep -oEe 'Corners:\s+\+[0-9]+\+[0-9]+' \| grep -oEe '[0-9]+\+[0-9]+' \| sed -e 's/\+/,/' )

	AUDIO_INPUT="-f alsa -i hw:0,0 -ac 2"
	VIDEO_INPUT="-f x11grab -r 30 -s $WIN_GEO -i :0.0+$WIN_XY"
	#AUDIO_CODEC="-acodec pcm_s16le"
	import sys
	from glob import glob
	from os import stat, rename
	from os.path import splitext
	from PIL import Image
	from PIL.ExifTags import TAGS
	from pyexif import ExifEditor
	from time import strptime, mktime

	# does not work as of 9/22/2011 - exception on _getexif() below
	#!/usr/bin/python

	import os
	import re
	import sys
	from optparse import OptionParser
	from datetime import datetime

	def sluggify(text=None):
	text = re.sub(r'[?:\'!@#$%^&*()+=]', '', text)