Class: Table

SeLiteData.Table

new Table(prototype)

Parameters:
Name Type Description
prototype Object Anonymous object { db: SeLiteData.Db instance, noNamePrefix: boolean, optional; if true, then it cancels effect of prototype.db.tableNamePrefix (if set), name: string table name, columns: array of string column names, primary: string primary key name (one column), or array of multiple string column names; optional - 'id' by default, generateInsertKey: boolean, like parameter generateInsertKey of SeLiteData.Db(). If specified and different to prototype.db.generateInsertKey, then prototype.generateInsertKey overrides it (even if db.generateInsertKey is true but here prototype.generateInsertKey is false).
Source:

Members

db :SeLiteData.Db

Type:
Source:

Methods

formula(paramsopt, prototypeopt) → {SeLiteData.RecordSetFormula}

Create on-the-fly a new SeLiteData.RecordSetFormula instance. Do not store/cache it anywhere.
Parameters:
Name Type Attributes Description
params object <optional>
 See parameter params of SeLiteData.RecordSetFormula(). This is on top of (or it overrides) 'table' and 'columns'.
prototype object <optional>
 See parameter prototype of SeLiteData.RecordSetFormula().
Source:
Returns:
Type
SeLiteData.RecordSetFormula

insert(record)

Insert the given record to the DB.
Parameters:
Name Type Description
record SeLiteData.Record
Source:
To Do:
  • - save primary key, if auto-generated: table.db.storage.lastInsertedRow( table.nameWithPrefix(), [table.primary] )[ table.primary ]; - if record is linked to a RecordHolder, update .originals