Clear roles on test bootstrap

porsager · porsager · commit 31f9856477a5 · 2023-10-10T15:56:39.000+02:00
diff --git a/tests/bootstrap.js b/tests/bootstrap.js
@@ -1,15 +1,19 @@
 import { spawnSync } from 'child_process'
 
+exec('dropdb', ['postgres_js_test'])
+
 exec('psql', ['-c', 'alter system set ssl=on'])
+exec('psql', ['-c', 'drop user postgres_js_test'])
 exec('psql', ['-c', 'create user postgres_js_test'])
 exec('psql', ['-c', 'alter system set password_encryption=md5'])
 exec('psql', ['-c', 'select pg_reload_conf()'])
+exec('psql', ['-c', 'drop user if exists postgres_js_test_md5'])
 exec('psql', ['-c', 'create user postgres_js_test_md5 with password \'postgres_js_test_md5\''])
 exec('psql', ['-c', 'alter system set password_encryption=\'scram-sha-256\''])
 exec('psql', ['-c', 'select pg_reload_conf()'])
+exec('psql', ['-c', 'drop user if exists postgres_js_test_scram'])
 exec('psql', ['-c', 'create user postgres_js_test_scram with password \'postgres_js_test_scram\''])
 
-exec('dropdb', ['postgres_js_test'])
 exec('createdb', ['postgres_js_test'])
 exec('psql', ['-c', 'grant all on database postgres_js_test to postgres_js_test'])
 exec('psql', ['-c', 'alter database postgres_js_test owner to postgres_js_test'])
