hungryzi

# Defining schema
IndexedDBBackbone.describe('todos')
  .createStore('todos', { keyPath: 'id' })
  .createIndex('todos', 'nameIndex', 'name', unique: false)

# Models & Collections
app.Todos = Backbone.Collection.extend
  database: 'todos'
  storeName: 'todos'
  #  ...

hungryzi

# Defining schema
schema =
  id: 'todos-database'
  migrations: [
    {
      version: '1',
      migrate: (db, req, next) ->
        store = db.createObjectStore('todos')
        next();
    },

hungryzi

# Sample record for 'catalog_items'
catalog_item =
  id: 42
  serialized: 1
  category_id: 8
  
# Sample record for 'inventory_items'
inventory_item =
  id: 1
  catalog_item_id: 42

hungryzi

# Sample record for 'catalog_items'
catalog_item =
  id: 42
  serialized: 1
  category_id: 8
  location_with_quantity: [1, 3]
  
# Sample record for 'inventory_items'
inventory_item =
  id: 1

hungryzi

# Sample record for 'catalog_items'
catalog_item =
  id: 42
  serialized: 1
  category_id: 2
  
# Sample record for 'inventory_items'
inventory_item =
  id: 1
  catalog_item_id: 42

hungryzi

@schema = IndexedDBBackbone.describe('experiment1')
  .createStore('catalog_items', keyPath: 'id')
  .createStore('inventory_items', keyPath: 'id')
  .createIndex('inventory_items', 'queryIndex', ['location_id', 'catalog_item.serialized', 'catalog_item.category_id'], unique: false)
  .createIndex('inventory_items', 'catalogItemIndex', 'catalog_item_id', unique: false)

hungryzi

@schema = IndexedDBBackbone.describe('experiment1')
  .createStore('catalog_items', keyPath: 'id')
  .createStore('inventory_items', keyPath: 'id')
  .createIndex( 'inventory_items',
                'queryIndex', 
                ['location_id',
                 'catalog_item.serialized',
                 'catalog_item.category_id'], 
                { unique: false })
  .createIndex('inventory_items', 'catalogItemIndex', 'catalog_item_id', unique: false)

hungryzi

@schema = IndexedDBBackbone.describe('experiment1')
  .createStore('catalog_items', keyPath: 'id')
  .createStore('inventory_items', keyPath: 'id')
  .createIndex( 'catalog_items',
                'queryIndex', 
                ['serialized',
                 'category_id',
                 'locations_with_quantity'],
                { unique: false, multiEntry: true })
  .createIndex('inventory_items', 'catalogItemIndex', 'catalog_item_id', unique: false)

hungryzi

@schema = IndexedDBBackbone.describe('experiment1')
  .createStore('catalog_items', keyPath: 'id')
  .createStore('inventory_items', keyPath: 'id')
  .createIndex('catalog_items', 'serializedIndex', 'serialized', unique: false)
  .createIndex('catalog_items', 'categoryIndex', 'category_id', unique: false)
  .createIndex('inventory_items', 'locationIndex', 'location_id', unique: false)
  .createIndex('inventory_items', 'catalogItemIndex', 'catalog_item_id', unique: false)

hungryzi

var request = indexedDB.open('beer_czar');
request.onsuccess = function(event){
  var db = event.target.result;
  var transaction = db.transaction(['beer'], 'readwrite');
  transaction.oncomplete = function(event){
    // handle transaction errors here
  }
  
  var beerObjectStore = transaction.objectStore('beer');
  var operation = beerObjectStore.add(beer)