<commit_before>DROP DATABASE IF EXISTS "gpdb_test_database";
DROP DATABASE IF EXISTS "gpdb_test_database_priv";
DROP DATABASE IF EXISTS "gpdb_test_database_with_''_";
DROP DATABASE IF EXISTS "gpdb_test_database_wo_pub";
DROP ROLE IF EXISTS "user_with_restricted_access";
-- DROP DATABASE IF EXISTS "gpdb_test_database_with_""_";

CREATE ROLE "user_with_restricted_access" PASSWORD '<PASSWORD>';
CREATE DATABASE "gpdb_test_database" OWNER gpadmin;
REVOKE CONNECT ON DATABASE "gpdb_test_database" FROM PUBLIC;
CREATE DATABASE "gpdb_test_database_priv" OWNER gpadmin;
CREATE DATABASE "gpdb_test_database_with_''_" OWNER gpadmin;
CREATE DATABASE "gpdb_test_database_wo_pub" OWNER gpadmin;
-- CREATE DATABASE "gpdb_test_database_with_""_" OWNER gpadmin;<commit_msg>use transactions for drop and recreate to try to avoid concurrent tuple updates<commit_after>BEGIN;
DROP DATABASE IF EXISTS "gpdb_test_database";
DROP DATABASE IF EXISTS "gpdb_test_database_priv";
DROP DATABASE IF EXISTS "gpdb_test_database_with_''_";
DROP DATABASE IF EXISTS "gpdb_test_database_wo_pub";
DROP ROLE IF EXISTS "user_with_restricted_access";
-- DROP DATABASE IF EXISTS "gpdb_test_database_with_""_";
COMMIT;

BEGIN;
CREATE ROLE "user_with_restricted_access" PASSWORD '<PASSWORD>';
CREATE DATABASE "gpdb_test_database" OWNER gpadmin;
REVOKE CONNECT ON DATABASE "gpdb_test_database" FROM PUBLIC;
CREATE DATABASE "gpdb_test_database_priv" OWNER gpadmin;
CREATE DATABASE "gpdb_test_database_with_''_" OWNER gpadmin;
CREATE DATABASE "gpdb_test_database_wo_pub" OWNER gpadmin;
-- CREATE DATABASE "gpdb_test_database_with_""_" OWNER gpadmin;
COMMIT;
{'fraction_non_alphanumeric': 0.07425742574257425, 'fraction_numerical': 0.0, 'mean_word_length': 8.920245398773005, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5137045', 'n_tokens_mistral': 653, 'n_tokens_neox': 583, 'n_words': 149}