TypeScript Sequelize.QueryInterface类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› TypeScript›TypeScript教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了TypeScript中Sequelize.QueryInterface类的典型用法代码示例。如果您正苦于以下问题：TypeScript QueryInterface类的具体用法？TypeScript QueryInterface怎么用？TypeScript QueryInterface使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

在下文中一共展示了QueryInterface类的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的TypeScript代码示例。

示例1: up

export async function up(queryInterface: QueryInterface, Sequelize: DataTypes) {
  return await queryInterface.createTable(AccountTable, {
    id: {
      allowNull: false,
      primaryKey: true,
      type: Sequelize.STRING,
    },
    provider_id: {
      type: Sequelize.INTEGER,
      references: { model: "provider", key: "id" }
    },
    first_name: {
      type: Sequelize.STRING
    },
    last_name: {
      type: Sequelize.STRING
    },
    email: {
      type: Sequelize.STRING
    },
    gender: {
      type: Sequelize.STRING
    },
    password: {
      type: Sequelize.CHAR(76)
    }
  });
}

开发者ID:KShewengerz，项目名称:ngx-express-passport-setup，代码行数:28，代码来源:20180521105528-create-account.ts

示例2: up

export async function up(queryInterface: QueryInterface, Sequelize: DataTypes) {
  return await queryInterface.createTable(ProviderTable, {
    id: {
      allowNull: false,
      primaryKey: true,
      type: Sequelize.INTEGER
    },
    name: {
      allowNull: false,
      type: Sequelize.STRING
    }
  })
  .then(async () => {
    const providers = [
      { id: 1, name: "google" },
      { id: 2, name: "facebook" },
      { id: 3, name: "twitter" },
      { id: 4, name: "local" }
    ];
    
    return await queryInterface.bulkInsert(ProviderTable, providers);
  });
}

开发者ID:KShewengerz，项目名称:ngx-express-passport-setup，代码行数:23，代码来源:20180521014423-create-provider.ts

示例3: down

export async function down(queryInterface: QueryInterface, Sequelize: DataTypes) {
  return await queryInterface.dropTable(ProviderTable);
}

开发者ID:KShewengerz，项目名称:ngx-express-passport-setup，代码行数:3，代码来源:20180521014423-create-provider.ts

示例4:

 .then(async () => {
   const providers = [
     { id: 1, name: "google" },
     { id: 2, name: "facebook" },
     { id: 3, name: "twitter" },
     { id: 4, name: "local" }
   ];
   
   return await queryInterface.bulkInsert(ProviderTable, providers);
 });

开发者ID:KShewengerz，项目名称:ngx-express-passport-setup，代码行数:10，代码来源:20180521014423-create-provider.ts

注：本文中的Sequelize.QueryInterface类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。