<commit_before>#!/bin/bash


# get config
source /systemapic/config/env.sh

# PGPASSWORD=docker psql -U docker -d $1 -h postgis -c "CREATE TABLE owner_info ( name text, uuid text, created_at integer);"
# PGPASSWORD=docker psql -U docker -d systemapic -h postgis -c "SELECT row_to_json(t) FROM ( SELECT PostGIS_full_version()) t;"
PGPASSWORD=$SYSTEMAPIC_PGSQL_PASSWORD psql -U $SYSTEMAPIC_PGSQL_USERNAME -d $SYSTEMAPIC_PGSQL_DBNAME -h postgis -c "SELECT row_to_json(t) FROM ( SELECT PostGIS_full_version()) t;"<commit_msg>Report default postgis extension version<commit_after>#!/bin/bash


# get config
source /systemapic/config/env.sh

export PGUSER=$SYSTEMAPIC_PGSQL_USERNAME
export PGPASSWORD=$SYSTEMAPIC_PGSQL_PASSWORD
export PGHOST=postgis
export PGDATABASE=template1

psql -c "select row_to_json(t) from ( SELECT default_version from pg_available_extensions where name = 'postgis' ) t";
{'fraction_non_alphanumeric': 0.09764309764309764, 'fraction_numerical': 0.002244668911335578, 'mean_word_length': 6.193548387096774, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '2542289', 'n_tokens_mistral': 339, 'n_tokens_neox': 321, 'n_words': 82}