Insert row Postgresql with SQL-ALCHEMY with default value

Question

I have some table in postgresql that have an ID that is automatically created thank to sequences. But now that I am using flask with SQLALCHEMY, when I try to insert a value, It says that I have a parameter left because I am not passing the ID value because it is postgres that will make it. I think that I should change the model but don´t know how.

I join you, my model:

class User(UserMixin, db.Model):
    __tablename__ = 'user'

    id = db.Column(db.Integer, primary_key=True) # primary keys are required by SQLAlchemy
    email = db.Column(db.String(100), unique=True)
    password = db.Column(db.String(100))
    name = db.Column(db.String(1000))
    permitido = db.Column(db.BOOLEAN)
    admin = db.Column(db.BOOLEAN)
    superuser = db.Column(db.BOOLEAN)

    def __init__(self, id, email, password, name, permitido, admin, superuser):
        self.id = id

        self.email = email
        self.password = password
        self.name = name
        self.permitido = permitido
        self.admin = admin
        self.superuser = superuser

And here is my insert code:

@app.route('/insertinternalusers', methods=['POST'])
def insertinternalusers():
    if request.method == 'POST':
        email = request.form['email']
        password = request.form['password']
        name = request.form['name']

        if request.form.get('permitido'):
            permitido = True
        else:
            permitido = False

        if request.form.get('admin'):
            admin = True
        else:
            admin = False

        superuser = False

        my_data = User(email, password, name, permitido, admin, superuser)
        db.session.add(my_data)
        db.session.commit()

        flash("¡Se agrego satisfactoriamente un Usuario!")

        return redirect(url_for('show_internalusers'))

Thank you,

Jonathan Prieto

KiDoo Song · Accepted Answer · 2020-06-19 05:08:44Z

1

User classes take the 'id' argument.

Called like this

 my_data = User(None, email, password, name, permitido, admin, superuser)

or

def __init__(self, email, password, name, permitido, admin, superuser):
    self.email = email
    self.password = password
    self.name = name
    self.permitido = permitido
    self.admin = admin
    self.superuser = superuser

answered Jun 19, 2020 at 5:08

KiDoo Song

1865 bronze badges

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

1 Comment

KiDoo Song Over a year ago

Please refer to the corresponding document for the contents of the sequence. docs.sqlalchemy.org/en/13/core/…

Collectives™ on Stack Overflow

Insert row Postgresql with SQL-ALCHEMY with default value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related