Creating a database using flask, Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set [duplicate]

Question

I have a problem creating a database using flask, Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set; I always get this error

Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set. Defaulting SQLALCHEMY_DATABASE_URI to "sqlite:///:memory:".

from flask import Flask, render_template, request
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
db = SQLAlchemy(app)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///friends.db'

class Friends(db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(200), nullable=False)
    date_created = db.Column(db.DateTime, default = datetime.utcnow)

    def __repr__(self):
            return '<Name %r>' % self.id

Your question might not be well-received for such a non-descriptive and verbose non-title. — Razzle Shazl
– Razzle Shazl, Commented Feb 28, 2021 at 15:13
Does this answer your question? Flask-SQLAlchemy: Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set. Defaulting SQLALCHEMY_DATABASE_URI to "sqlite:///:memory:" — SuperShoot
– SuperShoot, Commented Feb 28, 2021 at 21:31

tbjorch · Accepted Answer · 2021-02-28 15:34:42Z

1

You need to move the db URI config to the line before instantiating a sqlalchemy object. Otherwise SQLAlchemy won't receive that data during instantiation.

Solution

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///friends.db' # Don't have this line below the next
db = SQLAlchemy(app)

answered Feb 28, 2021 at 15:34

tbjorch

1,8261 gold badge15 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating a database using flask, Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set [duplicate]

1 Answer 1

Solution

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Solution

Comments

Linked

Related