Differential D6492 Diff 21838 keyserver/src/scripts/force-policy-acknowledgment.js

Changeset View

Standalone View

	// @flow			// @flow

	import { policyTypes } from 'lib/facts/policies.js';			import { policyTypes } from 'lib/facts/policies.js';

	import { dbQuery, SQL } from '../database/database.js';			import { dbQuery, SQL } from '../database/database.js';
	import { main } from './utils.js';			import { main } from './utils.js';

	// time when policy was officially published for users			// time when policy was officially published for users
	const policyUpdateTime = new Date('2022-12-30T00:00:00').getTime();			const policyUpdateTime = new Date('2023-02-03T00:00:00').getTime();

	async function forcePolicyAcknowledgment() {			async function forcePolicyAcknowledgment() {
	await dbQuery(SQL`			await dbQuery(SQL`
	UPDATE policy_acknowledgments			UPDATE policy_acknowledgments
	SET confirmed = 0			SET confirmed = 0
	WHERE date <= ${policyUpdateTime}			WHERE date <= ${policyUpdateTime}
	AND policy = ${policyTypes.tosAndPrivacyPolicy}			AND policy = ${policyTypes.tosAndPrivacyPolicy}
	`);			`);
	}			}

	main([forcePolicyAcknowledgment]);			main([forcePolicyAcknowledgment]);