<commit_before>-- ------------------------------------------------------------
-- File: _import_all.sql
-- ------------------------------------------------------------
-- The following command sequence will do an initial bulk load.
--
-- 1. Run "File > Export in native format to file…" menu in the ISAAC Komet Application
-- 2. Run "File > Import from native format file…" menu item in the Komet
--    These resulting CSV files are written into …/komet/application/target/csv
-- 3. Quit Komet

-- \set ECHO all

-- 4. Create all tables and sequences created by the ISAAC Komet application.
\i /PATH_TO/…/provider/datastore-postgres/README_files/sql_scripts/drop_all.sql

-- 5. Create new tables
\i /PATH_TO/…/provider/datastore-postgres/README_files/sql_scripts/create_table_schema.sql

-- 6. Change directories to folder where the CSV files were created.
\cd /PATH_TO/…/komet/application/target/csv

-- \! pwd
-- \! ls<commit_msg>adds `\connect isaac_db isaac_user`<commit_after>-- ------------------------------------------------------------
-- File: _import_all.sql
-- ------------------------------------------------------------
-- The following command sequence will do an initial bulk load.
--
-- 1. Run "File > Export in native format to file…" menu in the ISAAC Komet Application
-- 2. Run "File > Import from native format file…" menu item in the Komet
--    These resulting CSV files are written into …/komet/application/target/csv
-- 3. Quit Komet

-- \set ECHO all

-- 4. Create all tables and sequences created by the ISAAC Komet application.
-- -- Note: load databases as the same user that will be run with application.
-- \du                           -- display user and roles
\connect isaac_db isaac_user
\i /PATH_TO/…/provider/datastore-postgres/README_files/sql_scripts/drop_all.sql

-- 5. Create new tables
\i /PATH_TO/…/provider/datastore-postgres/README_files/sql_scripts/create_table_schema.sql

-- 6. Change directories to folder where the CSV files were created.
\cd /PATH_TO/…/komet/application/target/csv

-- \! pwd
-- \! ls
{'fraction_non_alphanumeric': 0.2138334145153434, 'fraction_numerical': 0.0058451047247929854, 'mean_word_length': 1.9811320754716981, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 7, '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': '2407553', 'n_tokens_mistral': 607, 'n_tokens_neox': 577, 'n_words': 203}