<commit_before>-- Drop database
DROP DATABASE IF EXISTS social;

-- Drop role
DROP OWNED BY social CASCADE;
DROP ROLE IF EXISTS social;

-- Drop user
DROP OWNED BY socialapplication CASCADE;
DROP USER IF EXISTS socialapplication;

-- Drop tablespaces
DROP TABLESPACE IF EXISTS social;
DROP TABLESPACE IF EXISTS socialbig;


CREATE ROLE social;

CREATE USER socialapplication PASSWORD '<PASSWORD>';

GRANT social TO socialapplication WITH ADMIN OPTION;

CREATE TABLESPACE social LOCATION '/data/postgresql/tablespace/social';

CREATE TABLESPACE socialbig LOCATION '/data/postgresql/tablespace/socialbig';

GRANT create ON TABLESPACE socialbig to social;

CREATE DATABASE social  OWNER social ENCODING 'UTF8' TABLESPACE social;
<commit_msg>social: style fixes for SQL<commit_after>-- Drop database
DROP DATABASE IF EXISTS social;

-- Drop role
DROP OWNED BY social CASCADE;
DROP ROLE IF EXISTS social;

-- Drop user
DROP OWNED BY socialapplication CASCADE;
DROP USER IF EXISTS socialapplication;

-- Drop tablespaces
DROP TABLESPACE IF EXISTS social;
DROP TABLESPACE IF EXISTS socialbig;


CREATE ROLE social;

CREATE USER socialapplication PASSWORD '<PASSWORD>';

GRANT social TO socialapplication WITH ADMIN OPTION;

CREATE TABLESPACE social LOCATION '/data/postgresql/tablespace/social';

CREATE TABLESPACE socialbig LOCATION '/data/postgresql/tablespace/socialbig';

GRANT CREATE ON TABLESPACE socialbig TO social;

CREATE DATABASE social OWNER social ENCODING 'UTF8' TABLESPACE social;

{'fraction_non_alphanumeric': 0.05842847548690396, 'fraction_numerical': 0.001343183344526528, 'mean_word_length': 5.313559322033898, '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': '4818003', 'n_tokens_mistral': 478, 'n_tokens_neox': 465, 'n_words': 174}