Flask-SQLalchemy error saying my table has no column named x

Question

I am just trying to create a simple database, add a word, print it, then drop it, but I am getting an error message that I can't make any sense out of.

Error message:

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table post has no column named word
[SQL: INSERT INTO post (word) VALUES (?)]
[parameters: ('Cheese 0',)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)

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


class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    word = db.Column(db.String(10))


def create_db():
    db.create_all()

    for x in range(5):
        p = Post(word='Cheese ' + str(x))
        db.session.add(p)
        db.session.commit()

The provided link. I am new to Flask and SQLalchemy; I can't quite make out what the information is trying to say to me.

Complete the create_all() with a commit and without creating objects. — Klaus D.
– Klaus D., Commented Nov 27, 2020 at 21:47

Pouya Esmaeili · Accepted Answer · 2020-11-27 22:32:22Z

1

You missed db.session.commit()

def create_db():
    db.create_all()
    db.session.commit()

    for x in range(5):
        p = Post(word= f'Cheese {x}')
        db.session.add(p)
        db.session.commit()

answered Nov 27, 2020 at 22:32

Pouya Esmaeili

1,2614 gold badges15 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Flask-SQLalchemy error saying my table has no column named x

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related