simonw

{
  page(url:"http://www.eventbrite.com/") {
    title: text(selector:"title")
    cards: query(selector:"div.poster-card") {
      name: text(selector:"[itemprop=name]")
      url: attr(selector:"meta[itemprop=url]", name:"content")
      image_src: attr(selector:".js-poster-image", name:"src")
    }
  }
}

simonw

How to use Amazon AWS Elasticsearch

The good news: you can get it running on the free tier (with a tiny instance).

The bad news: it's stuck on Elasticsearch 1.5.2 and dynamic scripting (Groovy) is disabled.

http://docs.aws.amazon.com/elasticsearch-service/latest/developerguide/aes-limits.html

Authentication: the safest option is to create a brand new IAM user (using the tool at https://console.aws.amazon.com/iam/home?region=us-east-1 ) with its own access key and secret key. Then when you create the Elasticsearch instance you can paste in the following IAM string:

simonw

class ParameterizedTestsMeta(type):
    def __new__(cls, name, bases, attrs):
        skip_these_names = []
        i = 1
        for name, fn in attrs.items():
            if name.startswith('test_') and callable(fn) and getattr(fn, '_parameterized_params', None):
                skip_these_names.append(name)
                for params in fn._parameterized_params:
                    attrs['%s_%d' % (name, i)] = cls.make_parameterized_test(fn, params)
                    i += 1

simonw

git archive --format=tar.gz -o /tmp/my-repo.tar.gz --prefix=my-repo/ master

More detailed version: https://til.simonwillison.net/git/git-archive

simonw

brew install mysql-connector-c
pip install mysql-python

From http://stackoverflow.com/questions/16182294/installing-mysql-python-on-mac-os-x

simonw

jQuery.ajaxSetup({
    dataFilter: function(string) {
        return string.replace(/^for \(;;\);/, '')
    }
});

simonw

admin.site.register(MyModel,
    lookup_allowed=lambda *args, **kwargs: True,
)

simonw

from django.db import connection
c = connection.cursor()
c.execute('SHOW STATUS like "Ssl_cipher"')
c.fetchall()
# Output of ((u'Ssl_cipher', u''),) means no SSL
# Output of ((u'Ssl_cipher', u'AES256-SHA'),) means using SSL

simonw

from django.db.models import F, Func, Value
from myapp.models import MyModel

# Annotation
MyModel.objects.filter(description__icontains='\r\n').annotate(
    fixed_description=Func(
        F('description'),
        Value('\r\n'), Value('\n'),
        function='replace',
    )

simonw

<table border=1>
<tr>
  <th>&nbsp;</th>
<th colspan="21">July 2015</th><th colspan="31">August 2015</th><th colspan="30">September 2015</th><th colspan="31">October 2015</th><th colspan="30">November 2015</th><th colspan="31">December 2015</th><th colspan="31">January 2016</th><th colspan="29">February 2016</th><th colspan="31">March 2016</th><th colspan="30">April 2016</th><th colspan="31">May 2016</th><th colspan="30">June 2016</th><th colspan="5">July 2016</th></tr>
<tr>
  <th>&nbsp;</th>
  <th>S</th>
  <th>S</th>
  <th>M</th>
  <th>T</th>