SQLAlchemy NameError: Name 'db' is not defined (?)

Question

I am working on a Udemy course using flask to record heights. I am at the point where we are using PostgreSQL, and I have it installed, and I have his code copied exactly:

from flask import Flask, render_template, request
from flask.ext.sqlalchemy import SQLAlchemy

app=Flask(__name__) 

app.config(['SQLALCHEMY_DATABASE_URI']='postgresql://postgres:password
@localhost/height_collector')

db=SQLAlchemy(app)

class Data(db.Model):
__tablename__='data'
id=db.Column(db.Integer, primary_key=True)
email_=db.Column(db.String(120), unique=True)
height_=db.Column(db.Integer)

def __init__(self, email_, height_):
    self.email_=email_
    self.height_=height_
@app.route("/")
def index():
   return render_template("index.html")

@app.route("/success", methods=["post"])
 def success():
if request.method=='POST':
    email=request.form['email_name']
    height=request.form['height_name']
    print(height,email)
return render_template("success.html")

if __name__=='__main__':
   app.debug=True
app.run()

Problem comes into play, when he says to run python in a virtual env, and then enter :db.create_all() to create a database in PostgreSQL and I get this error : File <'stdin'>, line 1 in NameError: Name 'db' is not defined

Not sure how to proceed, any input would be appreciated.

Jay · Accepted Answer · 2017-07-21 07:56:07Z

3

you can make a db.py where you can store the code db = SQLAlchemy(). Then import in in app.py. now you can able to call db. or just remove APP in db=SQLAlchemy(app)

answered Jul 21, 2017 at 7:56

Jay

939 bronze badges

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

Comments

Andrew Guy · Accepted Answer · 2017-07-21 03:35:47Z

2

I think you probably need to run some of the other code first so that you define db and your table schema. Then you can run db.create_all().

from flask import Flask, render_template, request
from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__) 

app.config(['SQLALCHEMY_DATABASE_URI'] = 
           'postgresql://postgres:password@localhost/height_collector')

db = SQLAlchemy(app)

class Data(db.Model):
    __tablename__ = 'data'
    id = db.Column(db.Integer, primary_key=True)
    email_ = db.Column(db.String(120), unique=True)
    height_ = db.Column(db.Integer)

    def __init__(self, email_, height_):
        self.email_ = email_
        self.height_ = height_

db.create_all()

answered Jul 21, 2017 at 3:35

Andrew Guy

10.1k3 gold badges30 silver badges42 bronze badges

Comments

clemens · Accepted Answer · 2018-01-11 05:56:10Z

1

Start python shell by running the command python. Then import db to define it:

from main import db
db.drop_all()
db.create_all()

edited Jan 11, 2018 at 5:56

clemens

17.9k12 gold badges52 silver badges71 bronze badges

answered Jan 11, 2018 at 5:47

user9202135

111 bronze badge

Comments

Darren Odi · Accepted Answer · 2022-08-01 07:33:01Z

1

I just faced this error and it is because I didn't import db before calling the db function. If you're running in terminal, 'from yourappname import db' and any other functions you are running.

//IN TERMINAL
from yourappname import db

answered Aug 1, 2022 at 7:33

Darren Odi

211 bronze badge

Comments

Ger Mc · Accepted Answer · 2019-10-13 12:26:52Z

0

You need to set the FLASK env variable.

create a .flaskenv file in the top directory of your project Add this to your .flaskenv file:

export FLASK_APP=myappfile.py

Install dotenv to your environment

pip install python-dotenv

Now if you run the app it should pick up your env variable.

answered Oct 13, 2019 at 12:26

Ger Mc

6403 gold badges11 silver badges23 bronze badges

Comments

Khaled · Accepted Answer · 2021-04-22 16:19:54Z

0

Type the Following and it will work:

cd flask-app
venv\scripts\activate
python3
from app import db
db.create_all()

edited Apr 22, 2021 at 16:19

Khaled

5731 gold badge9 silver badges35 bronze badges

answered Apr 22, 2021 at 13:56

Zani Kastrati

111 bronze badge

Collectives™ on Stack Overflow

SQLAlchemy NameError: Name 'db' is not defined (?)

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related