CDN Cassandra Schema

From Sirikata Wiki
Jump to: navigation, search

Sirikata

Users

Users {
   'jterrace': {
      'name': 'Jeff Terrace',
      'email': 'jterrace@gmail.com',
      'openid_name': 'Jeff Terrace',
      'openid_email': 'jterrace@gmail.com'
      'openid_identity': 'https://www.google.com/accounts/o8/id?id=AItOawlcO0O-myv8W1nBduUdjJslJDjl',
      'uploaded:/jterrace/duck.dae:0': ,
      'uploaded:/jterrace/whatever.dae:4': ,
      'uploading:taskid': '{"main_rowkey":"ddd", "filename":"xyz.dae", "subfiles":[{"name":"dude.jpg","rowkey":"xyz"}]}',
      ...
   }
}

Names

Names {
   '/jterrace/duck.dae': {
      'type':'collada'
      'latest':'0',
      '0': json{
         'title': 'A Duck',
         'description': 'A really cool duck',
         'types': {
            'original': {
               hash: 'ddde4f8bed9a8bc97d8cbd4137c63efd5e625fabbbe695bc26756a3f5f430aa4',
               size: 4988,
               subfiles: ['/jterrace/duck.dae/original/duck.tga/0']
            },
            'cleaned': {
               hash: '550c7dc3550c7dc3550c7dc3550c7dc3550c7dc3550c7dc3550c7dc3550c7dc3',
               size: 4990,
               subfiles: ['/jterrace/duck.dae/cleaned/duck.jpg/0']
            },
         }
      },
      ...
   },
   '/jterrace/duck.dae/original/duck.tga': {
      'type':'image'
      'latest':'0',
      '0': json{
            hash: '7dc35507dc35507dc35507dc35507dc35507dc35507dc35507dc35507dc3550',
            size: 16000,
         },
      },
      ...
   },
   ...
}

NameTimestampIndex

NameTimestampIndex {
   '1298662146:/jterrace/duck.dae/0': {}
   '1298662147:/jterrace/duck.dae/1': {}
}

Files

Files {
   'ddde4f8bed9a8bc97d8cbd4137c63efd5e625fabbbe695bc26756a3f5f430aa4': {
      'mimetype': 'image/jpeg',
      'data': <BLOB>
   },
   ...
}

ProgressiveStreams

ProgressiveStreams {
   '56561dab611a2637c1d7d1cdd29e951e9574956864d49488129611188a59f602': {
      ...
   },
   ...
}

Temporary File Uploads

TempFiles

TempFiles {
   '885c671b1dcc4aa6a4ae24973d379a29': {
      'username': 'jterrace',
      'size': 141312,
      'chunk_list': '0,65536,131072',
      '0': <BLOB of size 64KB>,
      '65536': <BLOB of size 64KB>,
      '131072': <BLOB of size 10KB>
   },
   ...
}

OpenID Storage

OpenIdAssocs

OpenIdAssocs {
   'b95134d39b0e43bfe1b17bdeaace942120c6ff0e4960c73b5ef7d5547cb61b7e_7b6b48fbe0c5fd4a59813d76034bae139f8c8828b672373f4a4b8e8a2e81dd77': {
      'serverurl': 'https://www.google.com/accounts/o8/ud',
      'handle': 'AOQobUe22QNZJcMto1XkcAspZpQgAZP_N9VKKzQ-45G9vMyJLzpuerpI',
      'secret': 8faae495a43922e6876f352620999513291876f5,
      'issued': 1297809129,
      'lifetime': 46800,
      'assoc_type': 'HMAC-SHA1'
   },
   ...
}

OpenIdNonces

OpenIdNonces {
   'serverurl_timestamp_salt': {
      'serverurl': 'http://...',
      'timestamp': 13235,
      'salt': 'dddd'
   },
   ...
}

Session Storage

Sessions

Sessions {
   '99e30ee7b1508fa73c5f1a8a57ada5bb': {
      'serialized': 'gAJ9cQEuOGU4ZGU3ZGQ3ZTExNDMzMDFhMTBlYWUwZWIzMjg3YmU=',
   }
}

Celery Task Result Storage

CeleryResults

CeleryResults {
   'dc9a5e50-966e-4c94-bdac-f36c16f5a4a1': {
      'date_done': ,
      'status':,
      'result':,
      'traceback':
   }
}