From 8198ea6beec15f33015483cb911a58a0bc8f0d2e Mon Sep 17 00:00:00 2001
From: Ran Guin <rguin@iMac.local>
Date: Tue, 24 Aug 2021 13:43:11 -0700
Subject: add fix to cull usernames

---
 db/migrations/20210821013757_cull_usernames.js | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 db/migrations/20210821013757_cull_usernames.js

diff --git a/db/migrations/20210821013757_cull_usernames.js b/db/migrations/20210821013757_cull_usernames.js
new file mode 100644
index 00000000..a4a48f21
--- /dev/null
+++ b/db/migrations/20210821013757_cull_usernames.js
@@ -0,0 +1,11 @@
+
+exports.up = function(knex) {
+  return Promise.all([
+    knex.raw("UPDATE users SET username = REPLACE(username, ' ', '') WHERE username like '% '"), // just in case valid users have trailing spaces in their username
+    knex.raw("DELETE FROM users WHERE !(username REGEXP '^[a-zA-Z0-9\.\_\@\-]{3,32}$'"),
+  ])
+};
+
+exports.down = function(knex) {
+  
+};
-- 
cgit v1.2.3