Page MenuHomePhabricator
Files F3408833

D7455.diff
No OneTemporary
Actions

D7455.diff
View Options

diff --git a/keyserver/src/database/migration-config.js b/keyserver/src/database/migration-config.js
--- a/keyserver/src/database/migration-config.js
+++ b/keyserver/src/database/migration-config.js
@@ -2,14 +2,20 @@
import fs from 'fs';
+import bots from 'lib/facts/bots.js';
import { policyTypes } from 'lib/facts/policies.js';
import { messageTypes } from 'lib/types/message-types-enum.js';
+import { threadTypes } from 'lib/types/thread-types-enum.js';
import { dbQuery, SQL } from '../database/database.js';
import { processMessagesInDBForSearch } from '../database/search-utils.js';
+import { createScriptViewer } from '../session/scripts.js';
import { updateRolesAndPermissionsForAllThreads } from '../updaters/thread-permission-updaters.js';
+import { updateThread } from '../updaters/thread-updaters.js';
import { createPickledOlmAccount } from '../utils/olm-utils.js';
+const botViewer = createScriptViewer(bots.commbot.userID);
+
const migrations: $ReadOnlyMap<number, () => Promise<void>> = new Map([
[
0,
@@ -425,6 +431,41 @@
await createOlmAccounts();
},
],
+ [
+ 38,
+ async () => {
+ const [result] = await dbQuery(SQL`
+ SELECT t.id
+ FROM threads t
+ INNER JOIN memberships m ON m.thread = t.id AND m.role > 0
+ INNER JOIN users u ON u.id = m.user
+ WHERE t.type = ${threadTypes.PRIVATE}
+ AND t.name = u.ethereum_address
+ `);
+ const threadIDs = result.map(({ id }) => id.toString());
+ while (threadIDs.length > 0) {
+ // Batch 10 updateThread calls at a time
+ const batch = threadIDs.splice(0, 10);
+ await Promise.all(
+ batch.map(threadID =>
+ updateThread(
+ botViewer,
+ {
+ threadID,
+ changes: {
+ name: '',
+ },
+ },
+ {
+ silenceMessages: true,
+ ignorePermissions: true,
+ },
+ ),
+ ),
+ );
+ }
+ },
+ ],
]);
const newDatabaseVersion: number = Math.max(...migrations.keys());

File Metadata

Mime Type
text/plain
Expires
Thu, Dec 5, 2:02 PM (17 h, 21 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2617172
Default Alt Text
D7455.diff (2 KB)

Event Timeline