Skip to content

Latest commit

 

History

History
33 lines (26 loc) · 1.1 KB

sqlite.md

File metadata and controls

33 lines (26 loc) · 1.1 KB

SQLite Additions

These 'sqlite' query objects have additional SQLite-specific behaviors.

INSERT

  • orAbort() to add or remove an OR ABORT flag
  • orFail() to add or remove an OR FAIL flag
  • orIgnore() to add or remove an OR IGNORE flag
  • orReplace() to add or remove an OR REPLACE flag
  • orRollback() to add or remove an OR ROLLBACK flag

UPDATE

  • orAbort() to add or remove an OR ABORT flag
  • orFail() to add or remove an OR FAIL flag
  • orIgnore() to add or remove an OR IGNORE flag
  • orReplace() to add or remove an OR REPLACE flag
  • orRollback() to add or remove an OR ROLLBACK flag
  • orderBy() to add an ORDER BY clause
  • limit() to set a LIMIT count
  • offset() to set an OFFSET count

DELETE

  • orAbort() to add or remove an OR ABORT flag
  • orFail() to add or remove an OR FAIL flag
  • orIgnore() to add or remove an OR IGNORE flag
  • orReplace() to add or remove an OR REPLACE flag
  • orRollback() to add or remove an OR ROLLBACK flag
  • orderBy() to add an ORDER BY clause
  • limit() to set a LIMIT count
  • offset() to set an OFFSET count