ollieglass

def weeks(self):
    final_date = Transaction.objects.all().order_by('-transaction_date')[0].transaction_date
    
    start_date = Transaction.objects.all().order_by('transaction_date')[0].transaction_date
    end_date = start_date + datetime.timedelta(weeks=1)

    while end_date <= final_date:
        yield start_date, end_date

        start_date += datetime.timedelta(weeks=1)

ollieglass

def transaction(request):
    transaction_id = request.REQUEST.get('transactionId')
    category_id = request.REQUEST.get('categoryId')

    t = Transaction.objects.get(pk=transaction_id)
    m = t.merchant
    c = Category.objects.get(pk=category_id)

    m.category = c
    m.save()

ollieglass

    var setCategory = function(transactionId, categoryId) {
        $.ajax({
            type: "GET",
            url: "/transaction/",
            data: { 
                transactionId: transactionId,
                categoryId: categoryId
            }
        }).done(function( msg ) {
            console.log(msg);

ollieglass

{% loop through transactions... %}
    <td>
        {% if not transaction.merchant.category %}
            
            <select data-value="{{ transaction.id }}">
                <option value="-1">Not set</option>
                {% for category in categories %}
                    <option value="{{ category.id }}">{{ category.name }}</option>
                {% endfor %}
            </select>

ollieglass

for filename in os.listdir(path):
    
    reader = csv.reader(open(path + filename), dialect=csv.excel)
    headers = reader.next()

    for row in reader:

        m, created = Merchant.objects.get_or_create(name=row[3])

        # lose the £ symbol and minus sign, cast to float

ollieglass

class Category(models.Model):
    name = models.CharField(max_length=255)


class Merchant(models.Model):
    name = models.CharField(max_length=255)
    category = models.ForeignKey(Category, blank=True, null=True, db_index=True)


class Transaction(models.Model):

ollieglass

/* Write a program that prints the numbers from 1 to 100. 
   But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”.
   For numbers which are multiples of both three and five print “FizzBuzz”. 

    Pythonic Java - https://gist.github.com/1725650                 
*/

public class FizzBuzz                                   {

    public static void main(String[] args)              {

ollieglass

import MySQLdb

db = MySQLdb.connect(host="localhost", port=3306, user="user", passwd="passwd", db="db")

cursor = db.cursor()
cursor.execute("SELECT id, referrer_id FROM users")

print "graph referrers {"
for row in cursor.fetchall():
    print "%s -- %s" % (row[0], row[1])

ollieglass

import requests
import urlparse
from oauth_hook import OAuthHook

# consumer key + secret
CONSUMER_KEY = ''
CONSUMER_SECRET = ''

# get access token, create client
client = requests.session(

ollieglass

graph condiments {
    ketchup -- mayonnaise -- tartar -- lemon
    ketchup -- bbq
}