api.put('/datasets/:datasetId', async (req: Request, res: Response) => {
const datasetId = expectInt(req.params.datasetId)
const dataset = await Dataset.findOne({ id: datasetId })
if (!dataset)
throw new JsonError(`No dataset by id ${datasetId}`, 404)
await db.transaction(async t => {
const newDataset = (req.body as { dataset: any }).dataset
await t.execute(`UPDATE datasets SET name=?, description=?, isPrivate=?, metadataEditedAt=?, metadataEditedByUserId=? WHERE id=?`, [newDataset.name, newDataset.description||"", newDataset.isPrivate, new Date(), res.locals.user.id, datasetId])
const tagRows = newDataset.tags.map((tag: any) => [tag.id, datasetId])
await t.execute(`DELETE FROM dataset_tags WHERE datasetId=?`, [datasetId])
if (tagRows.length)
await t.execute(`INSERT INTO dataset_tags (tagId, datasetId) VALUES ?`, [tagRows])
const source = newDataset.source
const description = _.omit(source, ['name', 'id'])
await t.execute(`UPDATE sources SET name=?, description=? WHERE id=?`, [source.name, JSON.stringify(description), source.id])
})
// Note: not currently in transaction
try {
await syncDatasetToGitRepo(datasetId, { oldDatasetName: dataset.name, commitName: res.locals.user.fullName, commitEmail: res.locals.user.email })
} catch (err) {
log.error(err)
// Continue
}
return { success: true }
})
async function main() {
await db.connect()
for (const dataset of await Dataset.find({ namespace: 'owid' })) {
if (!dataset.isPrivate)
await syncDatasetToGitRepo(dataset.id, { commitOnly: true })
}
await db.end()
}