15b1069bcc
This PR moves the entire project to Typescript. Due to the ~1000 ignores this will lead to a messy codebase for a while, but the churn is worth it – all of those ignore comments are places that were never type-safe previously. closes #1282
36 lines
1021 B
JavaScript
36 lines
1021 B
JavaScript
module.exports = {
|
|
up: async (queryInterface, Sequelize) => {
|
|
await queryInterface.addColumn("documents", "publishedAt", {
|
|
type: Sequelize.DATE,
|
|
allowNull: true,
|
|
});
|
|
const [documents, metaData] = await queryInterface.sequelize.query(
|
|
`SELECT * FROM documents`
|
|
);
|
|
|
|
for (const document of documents) {
|
|
await queryInterface.sequelize.query(`
|
|
update documents
|
|
set "publishedAt" = '${new Date(document.createdAt).toISOString()}'
|
|
where id = '${document.id}'
|
|
`);
|
|
}
|
|
|
|
await queryInterface.removeIndex("documents", ["id", "atlasId"]);
|
|
await queryInterface.addIndex("documents", [
|
|
"id",
|
|
"atlasId",
|
|
"publishedAt",
|
|
]);
|
|
},
|
|
down: async (queryInterface, Sequelize) => {
|
|
await queryInterface.removeColumn("documents", "publishedAt");
|
|
await queryInterface.removeIndex("documents", [
|
|
"id",
|
|
"atlasId",
|
|
"publishedAt",
|
|
]);
|
|
await queryInterface.addIndex("documents", ["id", "atlasId"]);
|
|
},
|
|
};
|