Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Flask migrate sqlalchemy not found
#1
Good day,

I am trying to make migration via Flask/Migrate/SQLAlchemy and getting the following error:
    'The sqlalchemy extension was not registered to the current ' \
AssertionError: The sqlalchemy extension was not registered to the current application.  Please make sure to call init_app() first.
What could be the reason?

My run.py file is inside project folder. run.py contains code:
from flaskblog import app, db
from flask import Flask

db.init_app(app)
if __name__ == '__main__':
	app.run(debug=True, port=5002)
	socketio.run(app)
Inside project folder there is flaskblog folder. Then __init__ file there contains code:
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_migrate import Migrate
#... other packages..

basedir = os.path.abspath(os.path.dirname(__file__))
app = Flask(__name__)
app.config['SECRET_KEY'] = 'dfjkfjkfdjklfjlkfdlfdlkj'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////home/tomas/searvice/flaskblog/site.db'
#...

db = SQLAlchemy(metadata=MetaData(naming_convention=naming_convention))

migrate = Migrate(app, db)
migrate.init_app(app, db, render_as_batch=True)

#...
So in terminal inside project folder I was not sure how to set
FLASK_APP=WhatToTypeHere?"
Instead I wrote command
export FLASK_APP=flaskblog
 flask db init
worked, but
flask db migrate 
returns the error I have mentioned. Cry
Reply
#2
Miguel Grinberg goes over this in detail.
I can't point out the exact location in Miguel Grinberg's tutorial on migrations, but it's somewhere around here:
https://blog.miguelgrinberg.com/post/the...v-database
Reply
#3
Heart
Error was in this line:

db = SQLAlchemy(metadata=MetaData(naming_convention=naming_convention))
should be db =SQLAlchemy(app)
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Flask: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked pythonpaul32 1 2,130 Apr-04-2023, 07:44 AM
Last Post: Larz60+
  Flask error sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint pythonpaul32 2 3,709 Feb-21-2023, 03:13 AM
Last Post: noisefloor
  Flask and SQLAlchemy question: Database is being created but tables aren't adding pythonpaul32 3 4,740 Feb-07-2023, 10:48 AM
Last Post: pythonpaul32
  Error updating one to many relationship in Flask/ SQLAlchemy atindra 0 3,346 Apr-15-2021, 10:29 PM
Last Post: atindra
  python 3.7 on windows using flask and flask-sqlalchemy. Alpy 2 4,017 Aug-12-2020, 07:24 PM
Last Post: Alpy
  Flask-Sqlalchemy count products in specific category imawesome 2 30,046 Mar-12-2020, 08:14 PM
Last Post: imawesome
  Flask-SqlAlchemy - Relationship failed to locate a name - Please Help howardrwb 0 5,223 Jan-31-2020, 08:38 PM
Last Post: howardrwb
  [Flask] No application found. SheeppOSU 1 3,140 Jun-01-2019, 02:58 PM
Last Post: SheeppOSU
  flask-SQLAlchemy query with keyword as function argument pascale 2 3,504 Mar-13-2019, 08:45 PM
Last Post: Ecniv
  Having Trouble with Flask and SQLAlchemy FakeDeveloperFakeSociologist 2 2,989 Nov-23-2018, 03:43 PM
Last Post: FakeDeveloperFakeSociologist

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020