From 310b1c52620e64e89e0886c160db60b64dfd7429 Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Wed, 28 Jul 2021 15:59:13 -0700 Subject: add deletion of users with names longer than 32 chars.. and accounts referencing these (or non-existent) users --- db/migrations/20210714123455_data_fixes_merge.js | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'db/migrations') diff --git a/db/migrations/20210714123455_data_fixes_merge.js b/db/migrations/20210714123455_data_fixes_merge.js index 70740ce8..d6ba3a3a 100644 --- a/db/migrations/20210714123455_data_fixes_merge.js +++ b/db/migrations/20210714123455_data_fixes_merge.js @@ -7,6 +7,11 @@ exports.up = function(knex) { knex.raw("alter table orders drop rate"), knex.raw("alter table orders add rate double"), knex.raw("update orders set rate = v1/v2"), + + knex.raw('update accounts left join users on accounts.user_id = users.id set user_id = null where length(username) > 32') + knex.raw('update accounts left join users on accounts.user_id = users.id set user_id = null where users.id is null') + knex.raw('delete from accounts where users.id is null'), + knex.raw('delete from users where length(username) > 32') ]) } -- cgit v1.2.3