Direct Alembic to ignore the sqlite_sequence table (#586)

* Direct Alembic to ignore the sqlite_sequence table

* Direct Alembic to ignore the sqlite_sequence table

* Fix "Skipping unsupported ALTER" warning on database migration

1 files changed, 8 insertions, 1 deletions

diff --git a/ihatemoney/migrations/env.py b/ihatemoney/migrations/env.py
index 4d4729c..0bd0031 100755
--- a/ihatemoney/migrations/env.py
+++ b/ihatemoney/migrations/env.py
@@ -41,7 +41,7 @@ def run_migrations_offline():
 
     """
     url = config.get_main_option("sqlalchemy.url")
-    context.configure(url=url)
+    context.configure(url=url, include_object=include_object)
 
     with context.begin_transaction():
         context.run_migrations()
@@ -75,6 +75,7 @@ def run_migrations_online():
     context.configure(
         connection=connection,
         target_metadata=target_metadata,
+        include_object=include_object,
         process_revision_directives=process_revision_directives,
         **current_app.extensions["migrate"].configure_args
     )
@@ -86,6 +87,12 @@ def run_migrations_online():
         connection.close()
 
 
+def include_object(object, name, type_, reflected, compare_to):
+    if name == "sqlite_sequence":
+        return False
+    return True
+
+
 if context.is_offline_mode():
     run_migrations_offline()
 else: