query problem

[nim4n]

Hi
I use UserMixin to create my User class:

class User(UserMixin):
    email = db.Column(db.String(255), unique=True, nullable=False)
    password = db.Column(db.String(255), nullable=False)
    registered_on = db.Column(db.DateTime, nullable=False)
    admin = db.Column(db.Boolean, nullable=False, default=False)

I can save data to the database but I can't fetch anything from database! I think the problem is on type part, when I check the query statement I can see this:

print(User.query)
SELECT fp_user.id AS fp_user_id, fp_user.type AS fp_user_type, fp_user.email AS fp_user_email, fp_user.password AS fp_user_password, fp_user.registered_on AS fp_user_registered_on, fp_user.admin AS fp_user_admin 
FROM fp_user 
WHERE fp_user.type IN (NULL)

and because of this where part nothing coming out from this query!

[seafoodfriedrice]

Having the same problem also. No problem adding a user, which shows up in the database:

# select * from fp_user;
 id | type | username |                                           password                                            
----+------+----------+-----------------------------------------------------------------------------------------------
  1 |      | flask    | pbkdf2:sha256:50000$32tQqbEE$57c91570bb2b508d8ce4233facbe4154dba14feefbd20b1671b56fe17aea5ddf
(1 row)

But when I query the User class in Python I get an empty list:

>>> User.query.all()
[]

[Saravanakumar46]

_ tablename _ = 'fp_user'
_ table_args _ = {'extend_existing': True}

Add these lines in User model. That's worked for me.