workbox.precaching.precacheAndRoute([
  {
    "url": "index.html",
    "revision": "4f8109353581284e76b88e568d642376"
  },
  {
    "url": "0.js",
    "revision": "2af14762103b4c1f18e620bd30a53d2e"
  },
  {
    "url": "main.js",
    "revision": "ef2fb7f5913e6614c9ee3621ad299d1b"
  }
])

var open = indexedDB.open("MyDatabase", 1);

open.onupgradeneeded = () => {
    const db = open.result;
    const store = db.createObjectStore("MyObjectStore", {keyPath: "id"});
    const index = store.createIndex("NameIndex", ["name.last", "name.first"]);
};

const getJohn = store.get(12345); // by id
const getBob = index.get(["Smith", "Bob"]); // by index

open.onsuccess = () => {
    const db = open.result
    const tx = db.transaction("MyObjectStore", "readwrite");
    const store = tx.objectStore("MyObjectStore");
    const index = store.index("NameIndex");
}

getJohn.onsuccess = () => {
    console.log(getJohn.result.name.first);  // => "John"
};
getBob.onsuccess = () => {
    console.log(getBob.result.name.first);   // => "Bob"
};

tx.oncomplete = function() {
    db.close();
};

const schemaBuilder = lf.schema.create('KEEPSOLID_SIGN_DB', 1.0);

schemaBuilder.createTable('Documents')
    .addColumn('id', lf.Type.STRING)
    .addColumn('parentId', lf.Type.OBJECT)
    .addColumn('type', lf.Type.STRING)
    .addColumn('signOrder', lf.Type.NUMBER)
    .addColumn('encryptionKey', lf.Type.STRING)
    .addIndex('idxSignOrder', ['signOrder'], false, lf.Order.DESC);
    .addPrimaryKey(['id']);

schemaBuilder.connect().then((db) => {
  // Now we can work with database
});

SELECT *
  FROM Documents
  WHERE type = "TEMPLATE"

Database
  .select()
  .from(document)
  .where(document.type.eq('TEMPLATE'))
  .exec()
    

SELECT encryptionKey
  FROM Documents
  WHERE signOrder >= 1
  ORDER BY signOrder DESC
  LIMIT 10

Database
  .select(document.encryptionKey)
  .from(document)
  .where(document.signOrder.gte(1))
  .orderBy(document.signOrder, lf.Order.DESC)
  .limit(10)
  .exec()
    

SELECT *
  FROM Documents d, Files f
  WHERE d.fileId = f.id
  AND d.id = '123'

Database
  .select()
  .from(document, file)
  .where(lf.op.and(
     document.fileId.eq(file.id),
     document.id.eq('123'),
  ))
  .exec()
    

SELECT * FROM document
  INNER JOIN file
  ON document.fileId = file.id
  WHERE document.id = '123'

Database
   .select()
   .from(document)
   .innerJoin(
     file,
     document.fileId.eq(file.id)
   )
   .where(document.id.eq('123'))
   .exec()

var query = db.select()
              .from(documents)
              .where(documents.id.eq('1'));

var handler = function(changes) {
  // Will be called whenever data change occurs.
};
db.observe(query, handler);

db.update(documents)
  .set(documents.title, 'New Title')
  .where(documents.id.eq('1'))
  .exec();

db.unobserve(query, handler);

const newDocument = clone({
    id: 1,
    name: 'Test'
})
myWorker.postMessage(JSON.stringify(newDocument));

navigator.storage.estimate().then(estimate => {
  // estimate.quota - how much bytes is available
  // estimate.usage - how many bytes of storage is used
});

navigator.storage.persist().then(function(persistent) {
    if (persistent)
     // The browser will not clean Storage
    else
     // Browser will clear Storage in case of low memory
}