summaryrefslogtreecommitdiff
path: root/app/media/migrations/0006_auto_20201201_2145.py
blob: 9827416f2523b77b0a1a602a72b0ceb3096c1c00 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
# Generated by Django 3.1 on 2020-12-01 21:45

from django.db import migrations


class Migration(migrations.Migration):

    dependencies = [
        ('media', '0005_auto_20201201_2141'),
    ]

    operations = [
        migrations.RunSQL("""
            INSERT INTO media_luxaudio (
                id,
                title,
                subtitle,
                slug,
                body_html,
                body_markdown,
                pub_date,
                mp3,
                ogg,
                point,
                location_id
            )
            SELECT 
                id,
                title,
                subtitle,
                slug,
                body_html,
                body_markdown,
                pub_date,
                mp3,
                ogg,
                point,
                location_id
            FROM
                recordings_audio;
        """, reverse_sql="""
            INSERT INTO recordings_audio (
                id,
                title,
                subtitle,
                slug,
                body_html,
                body_markdown,
                pub_date,
                mp3,
                ogg,
                point,
                location_id
            )
            SELECT
                id,
                title,
                subtitle,
                slug,
                body_html,
                body_markdown,
                pub_date,
                mp3,
                ogg,
                point,
                location_id
            FROM
                media_luxaudio;
        """)
    ]