Using Databases With Flask - Python and Flask #8 

▶️ Watch Entire Flask Playlist ✅ Subscribe To My RU-vid Channel: bit.ly/2TU96lm bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt! Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN

Just thought i'd thank you for carrying me through one of my CS assignments, cheers, I'd be in the bin without these videos

This force is very strong with this one. Indeed a Jedi of his craft. Indeed is he.

I had problems with understanding flask, You made it so easy for me. I now get it .. From the botom of my heart, Thank you... Happy new year

I had been waiting for this video for so long, finally

very simple and easy to follow tutorial, thank you very much

I get the following error a 11min in when you are using the gitbash terminal to create the "db ImportError: cannot import name 'db' from 'app' (C:\my_flask\app.py)"

Say that your friends.html page has multiple types of input and you had another .html page that has only one input variable that also posts to your friends.html. If you were to have two different .html pages going to your friends.html with the post method, how could you distinguish between them? Say, friends.html would update the database and itself but the other .html would bring only a friends name and you were to have a dropdown menu which default value needs to be that posted friends name. How would you do that?

Thank you for sharing your knowledge Sir we love you

very useful, thanks

Hi, thanks for your easy-to-follow videos, could you do a video for searching through a database with Flask?

Explained really clearly, thanks alot!

Man i love your flask videos

It would be cool to inform the last commit on starting the tutorial - so we pick up exactly where you are starting from.

Hi, I wanna know how to make a gallery (flask-html) using images taked from a sql database (sqlite3) Thanks

If I made a User model and created it via de Python Interpreter. How can I add a new rows? For example, if you wanted to add a row 'Gender' to your existing database after you did the command db.create_all()?

Hey, where can I get code files?

Quite Informative, Any reason why you're not using PyCharm or VSCode, would make life easier with imports etc..,

It’s showing “ there was an error adding your friend...” How to resolve it?

I'm having an error when tyring to import db >>> from app import db C:\Users\user\AppData\Local\Programs\Python\Python310\lib\site-packages\flask_sqlalchemy\__init__.py:851: UserWarning: Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set. Defaulting SQLALCHEMY_DATABASE_URI to "sqlite:///:memory:". Can someone help me pls?

what if I have multiple apps in the Blueprint structure, how can I create a database with its model for each app separately ?

Finnaly some databases tnx man

When someone put the details in our subscribe web page, how to store that information in database?

Can you help me with this error? ModuleNotFoundError: No module named 'app'

i like his energy

Hi I love your videos! But I am having a problem... the db file is not creating after the db.creat_all() can you please help me?

how to connect to existing database(SQL) with SQLALchemy?

sir when i write "from app import db" i get the error "ImportError: cannot import name 'SQLALchemy' from 'flask_sqlalchemy'" pls help me

Love your videos.

i'm on mac osx and having trouble using "winpty python". is there a mac version of this command or do i have to take extra steps to install the necessary libraries for this command?

I am getting an error(ModuleNotFoundError: No module named 'flask_sqlalchemy') but I have already installed. Can u help me?

can this work with programs such a SQLight Studio?

can you point to where is this database series listed since I could not find sqlite database related coverage in the Flask course on your website.

how to access db object in sub modules

I am not able to display the information after submitting the form. Can you tell me where I could be wrong? I followed the video step by step but instead I just used more variables than just a name.

I'm currently at 12:20 and I've followed all of these steps and get errors so I've decided to follow some troubleshooting steps on StackOverflow to the point where.I do db.create_all() I get no errors. However, for some reason the database doesn't appear on my file explorer nor my IDE project explorer (PyCharm). Has the database been created? Thanks. UPDATE - can confirm the database was created as searched for 'friends.db' in finder on Mac.

So helpful!

Sir i got unresolved reference for SQLAlchemy

sir kindly help me i'm getting error: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file (Background on this error at: sqlalche.me/e/13/e3q8)

Great!!!

I have trouble in loading the data into db, what I get from db is , etc.. rather than the info that I entered into the form...

When I try to set default=datetime.utcnow I get an error saying the equals sign does not belong there.

I get error.. [ no module found MYSQLdb] How can I solve

do you have a video on how to remove a friend from the list?

can you help me with my css, i write this on my code when i change background to blue (from the previous tutorial) it changed, but when i want to change it to white in this tutorial, it wont change, and stay at dark blue, even when i deleted the css file it still doesnt change, my background still dark blue :'(

Why do you have to create a db using gitbash? Why can't it be written in the code?

What is the best way to add multiple user inputs as far as the db.session.add is concerned in the app.py file? i.e. db.session.add(this_db_column, that_db_column, this_other_db_column)

Please don't delete Bob.

Beautiful 💞💞💞

Just wonder, if anyone is able to run on google app engine?

Not showing my database c:\users\medion\desktop\wb env\virtual\lib\site-packages\flask_sqlalchemy\__init__.py:812: UserWarning: Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set. Defaulting SQLALCHEMY_DATABASE_URI to "sqlite:///:memory:". warnings.warn( EDIT:never mind i forgot the A in DATABASE

ModuleNotFoundError: No module named 'flask_sqlalchemy' ....

i get "500 internal server error" when i created the db and go the friends page.

really usefull video thanks!! when i hit the "add name" button, nothing happend. Someont know why?

It won't let me import the db When I try it runs the server and exits python

nice doggy

Where is the Django?

can you create tutorial on simple user management system in flask api something like this ------------------------- I have the following tables: Table name= group Attributes: id name Here simply the group is created. ------------------------------------------------------------------------------ Table name = group permission Attributes: id group_id Permission_id Here simply the permission for the group is assigned ----------------------------------------------------------------------------- Table name =permission Attributes: id name code name Here permission is created Table name =user Attributes: id username password ------------------------------------------------------------------------------- Here the user is created Table name =user_groups Attributes: Id User_id Group_id Here the group for the user is assigned and all the permission inside this group should also be assigned to that user -------------------------------------------------------------------------------------------------------------------------- Table name =user_permission Attributes: Id User_id Permission_id Here the user might get more permission other than the permission assigned from the group. For example, if the user has only access for reading and writes from it’s defined group then if the admin user wants then he/she can directly assign permission to access a certain menu to the specific user without assigning to the other user of the same group. I haven't seen anyone on youtube have done this stuff

Thanks a lot for the tutorial. However, I meet sqlalchemy.exe.OperationalError: (sqlite3.OperationalError) no such column when I try the same steps you showed. Could I know what is the potential thing that I missed here? Thanks a lot!