alexandra is a thin abstraction over pycassa to interact with Cassandra from Django.

Requires Django and pycassa 1.40 or greater:

pip install -e git+http://github.com/podshumok/alexandra.git#egg=alexandra

add CASSANDRA CLUSTER and KEYSPACE to settings.py

CASSANDRA = {
    'default': {
        'CLUSTER':  ('localhost:9160',),
        'KEYSPACE': 'my_keyspace'
    },
}

Syntax for model definition is similar to Django's, but because rows can have as many columns as you want, there's no need to define them.

import pycassa
from alexandra import cass

class EventManager(cass.Manager):

    def get_for_uuid(self, uuid):
        return self.get(uuid)

class Event(cass.ColumnFamily):
    """
    Event = {
        "89c23f26377e439a8e52fadec8f6bf19" = {
            "uuid": "804e39e29a6148039633e5a69f0c0870",
            "action": "landing:home"
            "ip_address": "127.0.0.1",
            "gender": "1",
        }
        ...
    }
    """
    objects = EventManager()

    class Meta:
        # defaults to pycassa.ConsistencyLevel.ONE
        read_consistency_level = pycassa.ConsistencyLevel.ONE
        # defaults to pycassa.ConsistencyLevel.ONE
        write_consistency_level = pycassa.ConsistencyLevel.QUORUM
        # defaults to 'default', see settings.CASSANDRA keys
        server_name = 'another_one'
        # defaults to False. Set to True if this is a super column family
        super_cf = False
        # and any other cf options, known to pycassa


    def save(self, *args, **kwargs):
        super(Event, self).save(*args, **kwargs)
        TrackingUUID.objects.add_event(self['uuid'], self.pk)

You can create keyspace and column families for your apps by adding alexandra to your settings.INSTALLED_APPS and running:

./manage.py sync_cassandra

Queries use the pycassa query api, along with whatever other methods you want to define in your manager.

import uuid

event = Event()
event['uuid'] = "804e39e29a6148039633e5a69f0c0870"
event['action'] = 'landing: home'
event['gender'] = "1"
event.pk = uuid.uuid4().hex
event.save()

# or you could do this
event = Event(uuid="804e39e29a6148039633e5a69f0c0870", action='landing: home', gender='1')
Event.objects.insert(uuid.uuid4().hex, event)