本文整理汇总了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 }
)
}示例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 })
}示例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 })
}示例4:
export const up = (pgm: MigrationBuilder) => {
pgm.addColumns(tableName, {
timestamp: {
type: 'DECIMAL',
notNull: true,
comment: null
}
})
}示例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')
}示例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 }
)
}示例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')
}示例8:
export const up = (pgm: MigrationBuilder) => {
pgm.createExtension('uuid-ossp', { ifNotExists: true })
}