It looks like the SQLALCHEMY_DATABASE_URI isn't set, which basically is the location to your database. See how I set that at in the video? Are you sure you're spelling it correctly and putting the underscores in the correct place?
@ are we inheriting the Model class to User class?
@ you created db.Model, what is this .Model ? is it the method within SQLAlchemy?
when you created the User table at , why did you not need to use the __init__ method?
I get this error at , "unresolved attribute reference 'Column' for class.
.ec2c36a, Oct 20 2018, 14:57:15) [MSC v.1915 64 bit (AMD64)] on win32Type "help", "copyright", "credits" or "license" for more information.>>> from flaskblog import dbTraceback (most recent call last):File "<stdin>", line 1, in <module>ModuleNotFoundError: No module named 'flaskblog'
Hi Mohamed - If you go to in the video, Corey creates a __repr__ definition. This definition determines what is displayed when the object (the instance of the user class in this case) is printed to the screen, and you will see that Corey did not include the password or id in the definition, hence it is missing when the user object is printed to the screen. It's worth experimenting with the repr definition, so you can see how it works; perhaps add the user id so it is printed to the screen.
I am noobie in web app .. can someone please give the code he did on for python 2.6 ... Pls plz I need it
made me so happy when you noticed that and fixed it. I had a solid 10 minutes of anxiety.
😁 ,,, Great tutorial - Easily understandable - Thank you Very much
I'm stuck on , I'm using Pycharm and I don't know how to create the database like you did. Please help.
I am getting an error "ImportError: cannot import name db" while executing from CLI ... ( minutes)"from flaskblog import db", can somebody help on how to get this resolved?I rechecked the video and have same code. Still it is failing.
Awesome video! Anyone know why at why I get a 'syntaxError: invalid syntax' on the 'return f"User('{self.username}' ,'{self.email}', '{self.image_file}')"^
On the same note, there was an important caveat he didn't mention at when he said "That should have created our database".Yes, the database was created, but without any tables. That only happened only after he committed a few lines later.
At I don't understand the steps to create de site.db file in the same directory.
Around , for those who are having module error or name error at terminal, please try to write python -m pip install flask_wtf or whatever.
checkpoint
Everything went fine until . when typing in the user_1=... in the terminal I get following error:"sqlalchemy.exc.InvalidRequestError: One or more mappers failed to initialize - can't proceed with initialization of other mappers. Triggering mapper: 'Mapper|User|user'. Original exception was: Could not determine join condition between parent/child tables on relationship User.posts - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression."
im getting TypeError: 'email' is an invalid keyword argument for User
Hi after db.session.commit, I'm getting an error ofUNIQUE constraint failed: user.image_file[SQL: INSERT INTO user (username, email, image_file, password) VALUES (?, ?, ?, ?)][parameters: ('JohnDoe', '[email protected]', 'default.jpg', 'password')]Please help, Thanks.
on db.session.commit() I got long error.
If someone manages to mess up at and now are getting an error do remember to close of the session before trying again using db.session.close().
Hi Corey. First, congratulations! High level work. I'm having problems following the steps at . After I added the users 1 and 2 I got an error using db.session.commit(). Any clue what am I doing wrong?
At when I try to execute the command Usr.query.all() it throws me an error like this
At why doesn't it show the password too?
At minute I am getting just these:>>> User.query.all()
at why didn't it show the Password or id columns?
Please Help! Error: File "<stdin>", line 1, in <module>AttributeError: 'list' object has no attribute 'id'
i successfully commited the user posts to the database. but when i try to show the posts in the terminal all i got was this response: <sqlalchemy.orm.dynamic.AppenderBaseQuery object at 0x7f51238fcd10>edit: i typed in user_1.postsany idea why?Thanks for the awesome Videos Corey!!!!
