WriteableTable

The WriteableTable class represents an IDBObjectStore opened from an "rw" transaction or retrieved from Dexie.table()

Inheritance Hierarchy

• Table
  • WriteableTable

Properties

name

The name of the object store represented by this Table instance.

schema

The table schema of this object store.

Methods

add()

Insert an object into store.

update()

Apply given changes to an existing object.

put()

Replace or insert object.

delete()

Delete an object from store.

bulkAdd()

Same as add() but takes array arguments and is optimized for adding a large number of objects.

bulkPut()

Same as put() but takes array arguments and is optimized for putting a large number of objects.

bulkDelete()

Same as delete() but takes and array of keys and is optimized for deleting a large number of objects.

clear()

Clear all objects in store.

Methods derived from Table

get()

Retrieve object by primary key.

where()

Retrieve objects using a query.

filter()

Apply javascript filter on all items in the object store

count()

Count all objects.

offset()

Return a Collection ordered by primary key, where the first N items in the table are ignored.

limit()

Return a Collection ordered by primary key, limited to N items.

each()

Iterate all objects in store.

toArray()

Get an array containing all objects in store.

toCollection()

Get a Collection containing all objects in store.

orderBy()

Returns a Collection instance ordered by given index.

reverse()

Returns a Collection instance with reversed order of the primary key.

mapToClass()

Map this table to javascript constructor function.

defineClass()

Define a javascript constructor function and map to this table.