Edit This Page

Methods

getConnection()

Returns current Adapter's connection

dropTableOfCollection(collection)

Drops the table for given collection.

Returns a promise.

createTableFromCollection(collection)

Create table from given collection.

Schema can build the table from the information available in collection.schema.

dropTable(tableName)

Drops/deletes the table.

Returns a promise.

tableExists(tableName)

Returns a promise, resolving with a boolean value.

renameTable(from, to)

Renames an existing table.

Returns a promise.

createTable(tableName, collectionSchema)

Creates a table from a schema object in the format of collection.schema.

Example collectionSchema:

{
  id: {
    type: 'integer',
    primary: true
  },
  title: {
    type: 'string',
    length: 100,
    nullable: true
  }
}

Read more in Types for column types.

Returns a promise.

columnExists(tableName, columnName)

Returns a promise, resolving with a boolean value.

dropColumn(tableName, columnName)

Drops the column from table.

Returns a promise.

dropColumns(tableName, columnNames)

Drops the columns given as an array from table.

Returns a promise.

createColumn(tableName, columnName, fieldSchema)

Creates a single column for an existing table.

Returns a promies.

createColumns(tableName, collectionSchema)

Creates multiple columns for an existing table.

Returns a promise.

renameColumn(tableName, from, to)

Renames a table column.

Returns a promise.

createIndex(tableName, columns, indexName, indexType)

Creates a new index.

Returns a promise.

dropIndex(tableName, columns, indexName)

Drops the index.

Returns a promise.