mirror of
https://github.com/alexgo-io/stacks-blockchain-api.git
synced 2026-01-12 08:34:40 +08:00
3a02f5741f
* fix: change mempool_digest into a table * fix: change digest to be last updated timestamp * fix: build * fix: update count on reconcile * test: mempool renconcile
28 lines
701 B
JavaScript
28 lines
701 B
JavaScript
/* eslint-disable camelcase */
|
|
|
|
exports.shorthands = undefined;
|
|
|
|
exports.up = pgm => {
|
|
pgm.addColumn('chain_tip', {
|
|
mempool_tx_count: {
|
|
type: 'int',
|
|
default: 0,
|
|
},
|
|
mempool_updated_at: {
|
|
type: 'timestamptz',
|
|
default: pgm.func('(NOW())'),
|
|
},
|
|
});
|
|
pgm.sql(`
|
|
UPDATE chain_tip SET
|
|
mempool_tx_count = (SELECT COUNT(*)::int FROM mempool_txs WHERE pruned = FALSE),
|
|
mempool_updated_at = NOW()
|
|
`);
|
|
pgm.alterColumn('chain_tip', 'mempool_tx_count', { notNull: true });
|
|
pgm.alterColumn('chain_tip', 'mempool_updated_at', { notNull: true });
|
|
};
|
|
|
|
exports.down = pgm => {
|
|
pgm.dropColumn('chain_tip', ['mempool_tx_count', 'mempool_updated_at']);
|
|
};
|