peewee sqlite migration bug, https://github.com/coleifer/peewee/issues/474

README.md

$ rm -f test.sqlite && python bug_models.py create && python bug_add.py && echo '.schema' | sqlite3 test.sqlite
CREATE TABLE "device" ("id" INTEGER NOT NULL PRIMARY KEY, "name" VARCHAR(20) NOT NULL, "owner_id" INTEGER, "network_id" INTEGER, FOREIGN KEY ("owner_id") REFERENCES "user" ("id"));
CREATE TABLE "network" ("id" INTEGER NOT NULL PRIMARY KEY, "name" TEXT NOT NULL);
CREATE TABLE "user" ("id" INTEGER NOT NULL PRIMARY KEY, "full_name" VARCHAR(128) NOT NULL);
CREATE INDEX "device_network_id" ON "device" ("network_id");
CREATE INDEX "device_owner_id" ON "device" ("owner_id");

$ rm -f test.sqlite && python bug_models.py create && python bug_drop.py
…
peewee.OperationalError: unknown column "owner_id" in foreign key definition

bug_add.py

from peewee import ForeignKeyField
from playhouse.migrate import migrate, SqliteMigrator
from bug_models import Network, db

migrator = SqliteMigrator(db)

migrate(
    migrator.add_column('device', 'network_id', ForeignKeyField(Network, null=True, to_field=Network.id)),
    migrator.add_index('device', ('network_id',)),
)

bug_drop.py

from playhouse.migrate import migrate, SqliteMigrator
from bug_models import db

migrator = SqliteMigrator(db)

migrate(
    migrator.drop_index('device', 'device_owner_id'),
    migrator.drop_column('device', 'owner_id'),
)

bug_models.py

import sys

import peewee

db = peewee.SqliteDatabase('test.sqlite')

class BaseModel(peewee.Model):
    class Meta:
        database = db

class User(BaseModel):
    full_name = peewee.CharField(max_length=128)

class Network(BaseModel):
    name = peewee.TextField()

class Device(BaseModel):
    name = peewee.CharField(max_length=20)
    owner = peewee.ForeignKeyField(User, related_name='devices', null=True)

if __name__ == '__main__':
    if len(sys.argv) >= 2 and sys.argv[1] == 'create':
        User.create_table()
        Device.create_table()
        Network.create_table()

        user = User.create(full_name='Admin')
        network = Network.create(name='Demo network')

        Device.create(name='device 1', owner=user)
        Device.create(name='device 2')