flask_sqlalchemy got "Column() got an unexpected keyword argument 'primary_key'"

I first time decided to create some database for collecting bookings. I created my site with Flask and in official documentation I found a quick start with flask-sqlalchemy. I copied a lot of quick start code but got an error with 'primary_key':

from flask import Flask, render_template
from flask_sqlalchemy import SQLAlchemy

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


class Bookings(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    phone = db.Column(db.String(25), nullable=False)
    name = db.Column(db.String(50), nullable=False)
    date = db.Column(db.Date, nullable=False)
    time = db.Column(db.Time, nullable=False)
    address = db.Column(db.String(20), nullable=False)
    work = db.Column(db.String(255), nullable=False)
    comment = db.Column(db.String(255), nullable=True)

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


@app.route('/')
def panda():
    return render_template('index.html')

But I got:

Traceback (most recent call last):
  File "/Users/ushankax/pandabrow/panda.py", line 9, in <module>
    class Bookings(db.Model):
  File "/Users/ushankax/pandabrow/panda.py", line 10, in Bookings
    id = db.Column(db.Integer, primary_key=True)
TypeError: Column() got an unexpected keyword argument 'primary_key'

Why is it happens? Thanks!


Ответы (0 шт):