<commit_before>"""update db functions

Revision ID: 8a786f9bf241
Revises: <KEY>
Create Date: 2017-09-27 00:11:13.429144

"""
from alembic import op
import sqlalchemy as sa
from db.alembic.helper import execute_file

# revision identifiers, used by Alembic.

revision = '<KEY>'
down_revision = '<KEY>'
branch_labels = None
depends_on = None


def upgrade():
    conn = op.get_bind()
    conn.execute('drop function if exists update_courses(jsonb)')

    execute_file('db/functions/update_departments.sql')
    execute_file('db/functions/update_courses.sql')


def downgrade():
    pass
<commit_msg>Fixed migration<commit_after>"""update db functions

Revision ID: 8a786f9bf241
Revises: <KEY>
Create Date: 2017-09-27 00:11:13.429144

"""
from alembic import op
import sqlalchemy as sa
from db.alembic.helper import execute_file

# revision identifiers, used by Alembic.

revision = '8a786f9bf241'
down_revision = '<KEY>'
branch_labels = None
depends_on = None


def upgrade():
    conn = op.get_bind()
    conn.execute('drop function if exists update_courses(numeric, jsonb)')

    execute_file('db/functions/update_departments.sql')
    execute_file('db/functions/update_courses.sql')


def downgrade():
    pass

{'fraction_non_alphanumeric': 0.10973597359735973, 'fraction_numerical': 0.052805280528052806, 'mean_word_length': 4.917073170731707, 'pattern_counts': {'":': 0, '<': 8, '<?xml version=': 0, '>': 8, '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': '4936906', 'n_tokens_mistral': 462, 'n_tokens_neox': 408, 'n_words': 104}