<commit_before><commit_msg>Script for testing creating indeces in Postgresql.<commit_after>REF_GENOME_UID = '92c717c3'

cols = [
    'id',
    'uid',
    'position',
    'chromosome',
    'ref',
    'va_id',
    'alt',
    'ag_id',
    'vccd_id',
    've_id',
    'es_id',
    'experiment_sample_uid',
    'experiment_sample_label',
    'variant_set_uid',
    'variant_set_label',
    'va_data',
    'vccd_data',
    've_data',
    'es_data',
]

with open('millstone_create_indeces_cmd.txt', 'w') as fh:
    for c in cols:
        fh.write(
            'CREATE INDEX mmv_{ref_uid}_{col} on materialized_melted_variant_{ref_uid} ({col});\n'.format(
                ref_uid=REF_GENOME_UID,
                col=c))

{'fraction_non_alphanumeric': 0.1446629213483146, 'fraction_numerical': 0.008426966292134831, 'mean_word_length': 2.7526315789473683, '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': '138652', 'n_tokens_mistral': 287, 'n_tokens_neox': 274, 'n_words': 46}