1 | #!/bin/sh |
---|
2 | |
---|
3 | # Steps to reproduce the bug |
---|
4 | # 1. build the project |
---|
5 | # 2. run bootstrap to initialize the database |
---|
6 | # 3. during bootstrap db migrations is run via call_command('migrate'): |
---|
7 | # - openvpn_server table is created |
---|
8 | # - openvpn_client table is created; it uses foreign key to openvpn_server |
---|
9 | # - openvpn_server table is renamed to openvpn_server__old |
---|
10 | # - openvpn_client foreign key is re-linked to openvpn_server__old |
---|
11 | # - openvpn_server is created and data from openvpn_server__old is copied |
---|
12 | # - openvpn_server__old is dropped |
---|
13 | # - openvpn_client still references openvpn_sever__old - ForeignKey constraint is not updated |
---|
14 | # 3. try creating Client object - SQL cannot be executed |
---|
15 | |
---|
16 | make devel |
---|
17 | cd backend |
---|
18 | source ./env/bin/activate |
---|
19 | ./manage.py bootstrap |
---|
20 | |
---|
21 | echo ' |
---|
22 | Now type that: |
---|
23 | |
---|
24 | ./manage.py shell |
---|
25 | In [1]: from openvpnathome.apps.openvpn.models import Server, Client |
---|
26 | |
---|
27 | In [2]: Client.objects.create() |
---|
28 | |
---|
29 | ... snip ... |
---|
30 | |
---|
31 | OperationalError: no such table: main.openvpn_server__old |
---|
32 | ' |
---|
33 | |
---|