TypeScript node-pg-migrate.MigrationBuilder類代碼示例

本文整理匯總了TypeScript中node-pg-migrate.MigrationBuilder類的典型用法代碼示例。如果您正苦於以下問題：TypeScript MigrationBuilder類的具體用法？TypeScript MigrationBuilder怎麽用？TypeScript MigrationBuilder使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。

在下文中一共展示了MigrationBuilder類的8個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的TypeScript代碼示例。

示例1:

export const up = (pgm: MigrationBuilder) => {
  pgm.createTable(
    tableName,
    {
      id: {
        type: 'UUID',
        default: pgm.func('uuid_generate_v4()'),
        primaryKey: true,
        notNull: true,
        comment: null
      },
      title: { type: 'TEXT', notNull: true, comment: null },
      description: 'TEXT',
      token_address: {
        type: 'TEXT',
        references: Token.tableName,
        notNull: true,
        comment: null
      },
      balance: { type: 'DECIMAL', notNull: true, default: 0, comment: null },
      submitter: { type: 'TEXT', notNull: true, comment: null },
      closes_at: { type: 'BIGINT', notNull: true, comment: null },
      created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
      updated_at: { type: 'TIMESTAMP', comment: null }
    },
    { ifNotExists: true, comment: null }
  )
}

開發者ID:decentraland，項目名稱:agora，代碼行數:28，代碼來源:1527706985005_polls-create.ts

示例2:

export const up = (pgm: MigrationBuilder) => {
  pgm.createTable(
    tableName,
    {
      id: {
        type: 'UUID',
        default: pgm.func('uuid_generate_v4()'),
        primaryKey: true,
        notNull: true,
        comment: null
      },
      address: { type: 'TEXT', notNull: true, comment: null },
      token_address: {
        type: 'TEXT',
        notNull: true,
        references: Token.tableName,
        comment: null
      },
      balance: { type: 'DECIMAL', notNull: true, default: '0', comment: null }
    },
    { ifNotExists: true, comment: null }
  )

  pgm.createIndex(tableName, ['address', 'token_address'], { unique: true })
}

開發者ID:decentraland，項目名稱:agora，代碼行數:25，代碼來源:1527707064752_accounts-create.ts

示例3:

export const up = (pgm: MigrationBuilder) => {
  pgm.createTable(
    tableName,
    {
      address: { type: 'TEXT', primaryKey: true, notNull: true, comment: null },
      name: { type: 'TEXT', notNull: true, comment: null },
      symbol: { type: 'TEXT', notNull: true, comment: null }
    },
    { ifNotExists: true, comment: null }
  )

  pgm.createIndex(tableName, 'symbol', { unique: true })
}

開發者ID:decentraland，項目名稱:agora，代碼行數:13，代碼來源:1527706973005_tokens-create.ts

示例4:

export const up = (pgm: MigrationBuilder) => {
  pgm.addColumns(tableName, {
    timestamp: {
      type: 'DECIMAL',
      notNull: true,
      comment: null
    }
  })
}

開發者ID:decentraland，項目名稱:agora，代碼行數:9，代碼來源:1530201653559_votes-add-timestamp.ts

示例5:

export const up = (pgm: MigrationBuilder) => {
  pgm.createTable(
    tableName,
    {
      id: {
        type: 'UUID',
        default: pgm.func('uuid_generate_v4()'),
        primaryKey: true,
        notNull: true,
        comment: null
      },
      account_address: { type: 'TEXT', notNull: true, comment: null },
      account_balance: {
        type: 'DECIMAL',
        notNull: true,
        default: '0',
        comment: null
      },
      poll_id: {
        type: 'UUID',
        references: Poll.tableName,
        notNull: true,
        comment: null
      },
      option_id: {
        type: 'UUID',
        references: Option.tableName,
        notNull: true,
        comment: null
      },
      message: { type: 'TEXT', notNull: true, comment: null },
      signature: { type: 'TEXT', notNull: true, comment: null },
      created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
      updated_at: { type: 'TIMESTAMP', comment: null }
    },
    { ifNotExists: true, comment: null }
  )

  pgm.createIndex(tableName, ['account_address', 'poll_id'], {
    unique: true
  })

  pgm.createIndex(tableName, 'poll_id')
}

開發者ID:decentraland，項目名稱:agora，代碼行數:44，代碼來源:1527707259148_votes-create.ts

示例6:

export const up = (pgm: MigrationBuilder) => {
  pgm.createTable(
    tableName,
    {
      id: {
        type: 'UUID',
        default: pgm.func('uuid_generate_v4()'),
        primaryKey: true,
        notNull: true,
        comment: null
      },
      value: { type: 'TEXT', notNull: true, comment: null },
      poll_id: { type: 'UUID', references: Poll.tableName, comment: null },
      created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
      updated_at: { type: 'TIMESTAMP', comment: null }
    },
    { ifNotExists: true, comment: null }
  )
}

開發者ID:decentraland，項目名稱:agora，代碼行數:19，代碼來源:1527707071189_options-create.ts

示例7:

export const up = (pgm: MigrationBuilder) => {
  pgm.createTable(
    tableName,
    {
      id: {
        type: 'UUID',
        default: pgm.func('uuid_generate_v4()'),
        primaryKey: true,
        comment: null
      },
      server_signature: { type: 'TEXT', notNull: true, comment: null },
      server_message: { type: 'TEXT', notNull: true, comment: null },
      account_message: { type: 'TEXT', notNull: true, comment: null },
      account_signature: { type: 'TEXT', notNull: true, comment: null },
      account_address: { type: 'TEXT', notNull: true, comment: null },
      option_value: { type: 'TEXT', notNull: true, comment: null },
      vote_id: {
        type: 'UUID',
        notNull: true,
        comment: null
      },
      nonce: { type: 'SERIAL', comment: null },
      created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
      updated_at: { type: 'TIMESTAMP', comment: null }
    },
    { ifNotExists: true, comment: null }
  )

  pgm.createIndex(tableName, ['server_signature', 'server_message'], {
    unique: true
  })
  pgm.createIndex(tableName, ['account_signature', 'account_message'], {
    unique: true
  })
  pgm.createIndex(tableName, 'account_address')
}

開發者ID:decentraland，項目名稱:agora，代碼行數:36，代碼來源:1529057165916_receipt-create.ts

示例8:

export const up = (pgm: MigrationBuilder) => {
  pgm.createExtension('uuid-ossp', { ifNotExists: true })
}

開發者ID:decentraland，項目名稱:agora，代碼行數:3，代碼來源:1527706973000_uuid-extension-create.ts

注：本文中的node-pg-migrate.MigrationBuilder類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。