django-cats/cats/migrations/0024_refactor_statistics_table.py

36 lines
1,019 B
Python
Raw Permalink Normal View History

2024-09-20 08:57:25 +00:00
# Generated by Django 4.2.16 on 2024-09-20 08:29
from django.db import migrations, models
import django.db.models.deletion
class Migration(migrations.Migration):
dependencies = [
("cats", "0023_fill_new_incorrect_answers"),
]
operations = [
# remove invalid entries
migrations.RunSQL("DELETE FROM cats_statistics WHERE q_id NOT IN (SELECT id FROM cats_question)"),
migrations.AlterField(
model_name="statistics",
name="q_id",
field=models.ForeignKey(
help_text="question",
on_delete=django.db.models.deletion.CASCADE,
to="cats.question",
),
),
migrations.RenameField(
model_name="statistics",
old_name="q_id",
new_name="question",
),
migrations.AlterField(
model_name="statistics",
name="count",
field=models.IntegerField(help_text="count of answers"),
),
]