<commit_before>"""recreate no country codes mview

Revision ID: 5123489dfc7c
Revises: 17a6e4a91778
Create Date: 2015-12-08 20:44:01.602569

"""

# revision identifiers, used by Alembic.
revision = '5123489dfc7c'
down_revision = '<KEY>'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.execute('DROP MATERIALIZED VIEW countries_no')
    op.execute('''
    CREATE MATERIALIZED VIEW countries_no AS (
        SELECT
            r.rb_id, i.name, i.iso_code
        FROM
            country_codes_no i, rb_countries_mapped r
        WHERE
            r.iso_code = r.iso_code);
    ''')


def downgrade():
    pass<commit_msg>fix country codes view ffsgit add .<commit_after>"""recreate no country codes mview

Revision ID: 5123489dfc7c
Revises: <KEY>8
Create Date: 2015-12-08 20:44:01.602569

"""

# revision identifiers, used by Alembic.
revision = '5123489dfc7c'
down_revision = '<KEY>'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.execute('DROP MATERIALIZED VIEW countries_no')
    op.execute('''
    CREATE MATERIALIZED VIEW countries_no AS (
        SELECT
            r.rb_id, i.name, i.iso_code
        FROM
            country_codes_no i, rb_countries_mapped r
        WHERE
            r.iso_code = i.iso_code);
    ''')


def downgrade():
    pass
{'fraction_non_alphanumeric': 0.09202898550724638, 'fraction_numerical': 0.059420289855072465, 'mean_word_length': 2.991329479768786, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, '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': '980847', 'n_tokens_mistral': 552, 'n_tokens_neox': 479, 'n_words': 129}