View count_contributors.py
# To get the number of support forum contributors:
from datetime import date
from django.db.models import F, Count
from kitsune.questions.models import Answer
start_date =date(2013,1,1)
end_date = date(2014,1,1)
View git-url
#!/bin/sh
# Usage: `git url` or `git url <commitish>`
#
# * copies the commit's github url to your clipboard
# * prints out the log message
# * opens the bugzilla page if it found a bug number
#
# Set up the github url with `git config github.url <url>`.
# Only for the Mac.
View surveygizmo.py
#!/usr/bin/env python
import json
import optparse
import sys
from datetime import datetime
try:
import requests
except ImportError:
View get_contributors.py
# Requirements:
# pip install requests==1.1.0
import requests
repos = [
'bedrock',
'django-browserid',
'input.mozilla.org',
View 72h.sql
SELECT
(extract( year from created )) AS `year`,
(extract( day from created )) AS `day`,
(extract( month from created )) AS `month`,
COUNT(`questions_question`.`created`) AS `count`
FROM `questions_question`
INNER JOIN `auth_user`
ON (`questions_question`.`creator_id` = `auth_user`.`id`)
WHERE (`auth_user`.`is_active` = 1
AND `questions_question`.`created` >= '2011-01-01 00:00:00'
View fabfile.py
from fabric.api import local
def get_db_dump():
local('scp username@host.mozilla.org:/data/www/sumodump.sql.gz .')
local('gunzip sumodump.sql.gz')
def load_dump():
local('mysql -e "DROP DATABASE kitsune;"')
local('mysql -e "CREATE DATABASE kitsune;"')
local('mysql kitsune < sumodump.sql')
View bugzilla.mozilla.org.js
var settings = {
agile_backlog: true
};
var css = ".graph { width: 300px; height: 300px; float: left; } .graph canvas.overlay { background: none repeat scroll 0 0 rgba(0, 0, 0, 0) !important; }";
$('head').append($('<style>').text(css));
function agileBacklog() {
if(settings.agile_backlog) {
var $wb = $('td.bz_status_whiteboard_column');
View interpreter
In [1]: from testapp.models import ModelA
In [2]: a = ModelA.objects.all()[0]
In [3]: a.my_related_cs
Out[3]: <django.db.models.fields.related.RelatedManager object at 0x101e1ca10>
In [4]: a.my_related_bs
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
View ISO8601.js
// from http://delete.me.uk/2005/03/iso8601.html
Date.prototype.setISO8601 = function (string) {
var regexp = "([0-9]{4})(-([0-9]{2})(-([0-9]{2})" +
"(T([0-9]{2}):([0-9]{2})(:([0-9]{2})(\.([0-9]+))?)?" +
"(Z|(([-+])([0-9]{2}):([0-9]{2})))?)?)?)?";
var d = string.match(new RegExp(regexp));
var offset = 0;
var date = new Date(d[1], 0, 1);
View getOS.js
function getOS() {
var os = [
['Windows 3.11', /Win16/i],
['Windows 95', /(Windows 95)|(Win95)|(Windows_95)/i],
['Windows 98', /(Windows 98)|(Win98)/i],
['Windows 2000', /(Windows NT 5.0)|(Windows 2000)/i],
['Windows XP', /(Windows NT 5.1)|(Windows XP)/i],
['Windows Server 2003', /(Windows NT 5.2)/i],
['Windows Vista', /(Windows NT 6.0)/i],
['Windows 7', /(Windows NT 6.1)/i],