refactor channel positions in guild

1 files changed, 40 insertions, 0 deletions

diff --git a/src/util/migration/mariadb/1696420827239-guildChannelOrdering.ts b/src/util/migration/mariadb/1696420827239-guildChannelOrdering.ts
new file mode 100644
index 00000000..bbab72e7
--- /dev/null
+++ b/src/util/migration/mariadb/1696420827239-guildChannelOrdering.ts
@@ -0,0 +1,40 @@
+import { MigrationInterface, QueryRunner } from "typeorm";
+
+export class guildChannelOrdering1696420827239 implements MigrationInterface {
+	name = "guildChannelOrdering1696420827239";
+
+	public async up(queryRunner: QueryRunner): Promise<void> {
+		const guilds = await queryRunner.query(
+			`SELECT id FROM guilds`,
+			undefined,
+			true,
+		);
+
+		await queryRunner.query(
+			`ALTER TABLE guilds ADD channelOrdering text NOT NULL DEFAULT '[]'`,
+		);
+
+		for (const guild_id of guilds.records.map((x) => x.id)) {
+			const channels: Array<{ position: number; id: string }> = (
+				await queryRunner.query(
+					`SELECT id, position FROM channels WHERE guild_id = ?`,
+					[guild_id],
+					true,
+				)
+			).records;
+
+			channels.sort((a, b) => a.position - b.position);
+
+			await queryRunner.query(
+				`UPDATE guilds SET channelOrdering = ? WHERE id = ?`,
+				[JSON.stringify(channels.map((x) => x.id)), guild_id],
+			);
+		}
+
+		await queryRunner.query(`ALTER TABLE channels DROP COLUMN position`);
+	}
+
+	public async down(): Promise<void> {
+		// don't care actually, sorry.
+	}
+}