public class | 來源

Db2QueryInterface

繼承

QueryInterface → Db2QueryInterface

Sequelize 用於與 Db2 資料庫溝通的介面

繼承摘要

來自類別 QueryInterface
public	async addColumn(table: string, key: string, attribute: object, options: object): Promise 在表格中新增一個新的欄位
public	async addConstraint(tableName: string, options: object): Promise 在表格中新增一個約束
public	async addIndex(tableName: string \| object, attributes: Array, options: object, rawTablename: string): Promise 在欄位中新增索引
public	async bulkDelete(tableName: string, where: object, options: object, model: Model): Promise 從表格中刪除多筆記錄
public	async bulkInsert(tableName: string, records: Array, options: object, attributes: object): Promise 將多筆記錄插入表格
public	async bulkUpdate(tableName: string, values: object, identifier: object, options: object, attributes: object): Promise 更新表格中的多筆記錄
public	async changeColumn(tableName: string, attributeName: string, dataTypeOrOptions: object, options: object): * 變更欄位定義
public	async createDatabase(database: string, options: object): Promise 建立資料庫
public	async createFunction(functionName: string, params: Array, returnType: string, language: string, body: string, optionsArray: Array, options: object): Promise 建立 SQL 函數
public	async createSchema(schema: string, options: object): Promise 建立結構描述
public	async createTable(tableName: string, attributes: object, options: object, model: Model): Promise 使用給定的屬性集建立表格
public	async describeTable(tableName: string, options: object): Promise<object> 描述表格結構
public	async dropAllSchemas(options: object): Promise 捨棄所有結構描述
public	async dropAllTables(options: object): Promise 從資料庫中捨棄所有表格
public	async dropDatabase(database: string, options: object): Promise 捨棄資料庫
public	async dropFunction(functionName: string, params: Array, options: object): Promise 捨棄 SQL 函數
public	async dropSchema(schema: string, options: object): Promise 捨棄結構描述
public	async dropTable(tableName: string, options: object): Promise 從資料庫中捨棄表格
public	async getForeignKeyReferencesForTable(tableName: string, options: object): * 取得表格的外鍵參考詳細資訊
public	async getForeignKeysForTables(tableNames: string[], options: object): Promise 傳回所請求表格的所有外鍵約束
public	quoteIdentifier(identifier: string, force: boolean): string 將識別符清單依「.」分割並加上引號
public	quoteIdentifiers(identifiers: string): string 將識別符清單依「.」分割並加上引號。
public	async removeColumn(tableName: string, attributeName: string, options: object): * 從表格中移除欄位
public	async removeConstraint(tableName: string, constraintName: string, options: object): * 從表格中移除約束
public	async removeIndex(tableName: string, indexNameOrAttributes: string \| string[], options: object): Promise 從資料表中移除已存在的索引
public	async renameColumn(tableName: string, attrNameBefore: string, attrNameAfter: string, options: object): Promise 重新命名欄位
public	async renameFunction(oldFunctionName: string, params: Array, newFunctionName: string, options: object): Promise 重新命名 SQL 函式
public	async renameTable(before: string, after: string, options: object): Promise 重新命名資料表
public	async showAllSchemas(options: object): Promise<Array> 顯示所有結構描述
public	async tableExists(tableName: TableName, options: QueryOptions): Promise<boolean> 返回一個 Promise，如果資料表存在於資料庫中則解析為 true，否則解析為 false。
public	async upsert(tableName: string, insertValues: object, updateValues: object, where: object, options: object): Promise<boolean, ?number> 更新插入 (Upsert)