<commit_before># -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import migrations


class Migration(migrations.Migration):

    dependencies = [
        ('kbadge', '0001_initial'),
    ]

    operations = [
        migrations.RunSQL(
            "UPDATE badger_badge SET image = CONCAT('uploads/', image) WHERE image NOT LIKE 'uploads/%'"
        )
    ]<commit_msg>Update SQL data migration to exclude NULL and blank image values.<commit_after># -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import migrations


class Migration(migrations.Migration):

    dependencies = [
        ('kbadge', '0001_initial'),
    ]

    operations = [
        migrations.RunSQL(
            "UPDATE badger_badge SET image = CONCAT('uploads/', image) WHERE image NOT LIKE 'uploads/%' AND image IS NOT NULL AND image != ''"
        )
    ]
{'fraction_non_alphanumeric': 0.11199095022624435, 'fraction_numerical': 0.011312217194570135, 'mean_word_length': 2.831168831168831, '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': '7654839', 'n_tokens_mistral': 265, 'n_tokens_neox': 249, 'n_words': 75}