martinsmid

sed -r 's/[0-9]+ |//' -i $1
sed -e 's/at 0x[a-z0-9]\+/at XXX/g' -i $1
sed -e 's/line [0-9]\+/line YYY/g' -i $1

martinsmid

create view counts_per_year
as SELECT pilot, substring(filename, 14, 4) as year, count(detail) as pocet
FROM test.output 
where aircraft like 'ventus%'
group by pilot, year;

select B.pilot, 
	IFNULL(O1.pocet, 0) as `2014`, 
    IFNULL(O2.pocet, 0) as `2015`, 
    IFNULL(O2.pocet, 0) - IFNULL(O1.pocet, 0) as delta,

martinsmid

{notification: [
    {
        grouped: true,
        id: [1,2,3],
        read: true,
        type: ‘new_match’, 
        model_id: [456,345,342] //<client media ids>                    
    }
    {
        grouped: false,