Flask SQLalchemy, password is not stored in database

Jay

I am trying to store users in a database when they register to my flask website using SQL alchemy, the username and income stores correctly but the hashed password does not appear in the database and I don't know why. My register function is here:

def register():
    # connect database to flask

    # name = username
    username = request.form.get("username")
    if request.method == "POST":
        # ensure username is entered
        if not username:
            flash("must enter username")
            return render_template("register.html")
        # ensure password is entered
        elif not request.form.get("password"):
            flash("must enter password")
            return render_template("register.html")

        # ensure password has been confirmed
        elif not request.form.get("confirmation"):
            flash("must confirm password")
            return render_template("register.html")
        # ensure income has been entered
        elif not request.form.get("income"):
            flash("must enter Monthly income to proceed")
            return render_template("register.html")

        # ensure password and confirmation password match
        elif request.form.get("password") != request.form.get("confirmation"):
            flash("passwords do not match")
            return render_template("register.html")

        # query database to see if username is already taken
        founduser = users.query.filter_by(username=username).first()

        # hash password
        _hash = generate_password_hash(request.form.get("password"))
        income = request.form.get("income")
        if founduser:
            flash("username is already taken")
            return render_template("register.html")
        else:
            registereduser = users(username, _hash, income)
            db.session.add(registereduser)
            db.session.commit()
            _id = registereduser._id
        session["user_id"] = _id
        flash("registered successfully!")
        return redirect("/home")

    else:
        return render_template("register.html")

the user table is here:

class users(db.Model):
    __tablename__ = "users"

    _id = db.Column("id", db.Integer, primary_key=True, autoincrement=True)
    username = db.Column("username", db.String(100))
    _hash = db.Column("hash", db.String(100))
    income = db.Column("income", db.Float)

    def __init__(self, username, _hash, income):
        self.username = username
        self._hash = _hash
        self.income = income
        return f"<User: {self.username}"
konawige

I didn't test, but i believe it is just a typo issue:

self.hash = _hash

According to your model , it should be self._hash = _hash

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Rendering HTML stored in Database Flask SQLAlchemy

From Dev

Flask and sqlalchemy: Get uploaded file using path stored on database

From Dev

Creating database with SQLAlchemy in Flask

From Dev

Creating a database in flask sqlalchemy

From Dev

The password is stored as plain text in the database

From Java

Flask to return image stored in database

From Dev

Flask - authenticate hashed password from SQLAlchemy

From Dev

Storing admin username/password - FLASK-SQLAlchemy

From Dev

How to recreate database in SQLAlchemy from Flask?

From Dev

Flask SQLAlchemy reflect database objects dynamically

From Dev

Database is not updated in Celery task with Flask and SQLAlchemy

From Dev

Connect to MSSQL Database using Flask-SQLAlchemy

From Dev

Pandas df to database using flask-sqlalchemy

From Dev

Flask SQLAlchemy does not close MySQL database connections

From Dev

flask sqlalchemy example around existing database

From Dev

how to receive link from database in flask sqlalchemy

From Mysql

Can't connect flask sqlAlchemy to the mysql database

From Dev

Adding a comments field to database with flask/SQLAlchemy?

From Dev

Sqlite database backup and restore in flask sqlalchemy

From Dev

This is not work Flask Rq Queue with SqlAlchemy database table

From Dev

Pre-populate a Flask SQLAlchemy database

From Dev

Use Flask-SqlAlchemy to query relationship database

From Dev

Flask-SQLAlchemy not saving database updates

From Dev

Python Flask SQLAlchemy not commiting changes to the database

From Dev

Connection problem with flask-sqlalchemy and Docker database

From Dev

Flask SqlAlchemy DB2 SQLALCHEMY_DATABASE_URI

From Dev

Celery with Flask and Flask-SQLAlchemy cannot update a database record

From Dev

How to execute a MySQL stored procedure or function in Flask-SQLAlchemy

From Dev

How to execute stored procedure form a flask_sqlalchemy app

Related Related

  1. 1

    Rendering HTML stored in Database Flask SQLAlchemy

  2. 2

    Flask and sqlalchemy: Get uploaded file using path stored on database

  3. 3

    Creating database with SQLAlchemy in Flask

  4. 4

    Creating a database in flask sqlalchemy

  5. 5

    The password is stored as plain text in the database

  6. 6

    Flask to return image stored in database

  7. 7

    Flask - authenticate hashed password from SQLAlchemy

  8. 8

    Storing admin username/password - FLASK-SQLAlchemy

  9. 9

    How to recreate database in SQLAlchemy from Flask?

  10. 10

    Flask SQLAlchemy reflect database objects dynamically

  11. 11

    Database is not updated in Celery task with Flask and SQLAlchemy

  12. 12

    Connect to MSSQL Database using Flask-SQLAlchemy

  13. 13

    Pandas df to database using flask-sqlalchemy

  14. 14

    Flask SQLAlchemy does not close MySQL database connections

  15. 15

    flask sqlalchemy example around existing database

  16. 16

    how to receive link from database in flask sqlalchemy

  17. 17

    Can't connect flask sqlAlchemy to the mysql database

  18. 18

    Adding a comments field to database with flask/SQLAlchemy?

  19. 19

    Sqlite database backup and restore in flask sqlalchemy

  20. 20

    This is not work Flask Rq Queue with SqlAlchemy database table

  21. 21

    Pre-populate a Flask SQLAlchemy database

  22. 22

    Use Flask-SqlAlchemy to query relationship database

  23. 23

    Flask-SQLAlchemy not saving database updates

  24. 24

    Python Flask SQLAlchemy not commiting changes to the database

  25. 25

    Connection problem with flask-sqlalchemy and Docker database

  26. 26

    Flask SqlAlchemy DB2 SQLALCHEMY_DATABASE_URI

  27. 27

    Celery with Flask and Flask-SQLAlchemy cannot update a database record

  28. 28

    How to execute a MySQL stored procedure or function in Flask-SQLAlchemy

  29. 29

    How to execute stored procedure form a flask_sqlalchemy app

HotTag

Archive