Flask CRUD Application Full Course With SQLAlchemy | Python Flask

[@ParwizForogh]

You can join the new and updated of this course with AWS features, this is the link kzbin.info/www/bejne/l4qYipqXrMdsis0

[@Islam-and-boxing]

Do you have this code available to copy?

[@tompis1442]

So this guys right here started my whole career. I watched this video a year ago and this video game me so much confidence, that now I have a full time job. I cant believe I just saw this video on my recommends! THAT YOU BRO!

[@revanthshahukaru7883]

The Bootstrap 5 Navbar still uses flexbox, but the concept of right and left, have changed to start and end for new RTL support. So, instead of float-right, use float-end Also, take attention that bootstrap 5 changed data-toggle to data-bs-toggle and data-target to data-bs-target

[@rahmadilhamsani7227]

thank you bro

[@drogokhal3058]

thank you very much !

[@sukardiLayarda]

thank you,

[@bebekkarki6162]

thanks bro thank you soo much

[@alanpolato831]

Thanks man! This does also apply for "data-dismiss" that became "data-bs-dismiss" in button configuration.

[@birusingh410]

Explanation is clear specially frontend part. Being a backend developer I feel frontend is tough but you made such a nice page with simple steps.

[@megafunny789]

You just taught what my professor has tried teaching the past 10 class periods. Each class is 2 hours long.

[@VoiceThatMatter]

Thank You. First time I have learned something on flask. Rudraprasad Mohapatra

[@tahep3906]

I'm glad that I've also learned how to use bootstrap modals, they are very useful for this kind of operations, thanks a lot for this helpful video!

[@mainak_das]

THIS IS THE BEST TUTORIAL FOR FLASK CRUD APPLICATION

[@techdevrpa]

You are amazing. I met your channel when I was learning qt and now flask Thanks again dude

[@geertvancompernolle2586]

First off, excellent intro of both Flask and CRUD principles. One question though: I'm trying to get the first input field of the modal Add or Edit box to be in focus. I know bootstrap doesn't have the autofocus attribute so I tried to add the HTML5 attribute "autofocus" in the input tag of my first input field like so: . However, that doesn't seem to work. What should be done to get the focus on the first input field of the modal boxes?

[@hilaryeins1]

Thank you very much for these series of videos. I am new using flask, but I have learnt from your clear explanation.

[@danielpaloma6435]

Hello Parwiz, thank you so much for sharing your knowledge!! I enjoyed the tutorial and your explanation was clear. This encourage me to develop my own app and learn more about Flask. Regards.

[@SaudBako]

Thank you so much. For the update method I used string query parameters to retrieve the employee id we are trying to edit. I made the form action go to "/update?id={{row.id}}", and used request.args['id'] to pull the ID from the url.

[@amaramw]

hi, I have a problem with my Edit button. the form cannot be displayed. and no error message either. do you know how to fix this problem? :')

[@andressahelum5071]

Assistindo em 2021. Muito boa didática! Fiz algumas coisas diferentes do vídeo pois já tinha um conhecimento, mas aprendi demais sobre post e get dentro do flask. Estava precisando justamente disso. Muito obrigada!

[@cathym9803]

Thank you so much!!! Excellent course from the beginning to the end. I would recommend this to anyone who is willing to learn. Thanks again.

[@ParwizForogh]

You're very welcome!

[@yousaymyname5174]

A very good step by step lecture bro. Please a video how to add multiple form fields dynamically and bring them to the database (without modals adding multiple employees with the same submit button).

[@JessicaHombal]

Thank you so much for this video. I did the same for banking system. It is working well.

[@jangronewald3788]

Thank you very much for the great Tutorial! It rly helped me to get into Bootstrap and to make progress in my project. THX!

[@austindonovan4162]

Thank you so much, this is exactly what I needed to break down how to do the update and delete functions in python. You are amazing!!

[@ParwizForogh]

You're welcome!

[@felixutomo6365]

@@ParwizForogh hello my friend why when i try to implement this app, this error comes up : TypeError: __init__() takes 1 positional argument but 3 were given, can u help me ?

[@richardmilesagyemang1233]

Thanks this video is very helpful. I was doing my with sequel query. Kind of stressful with the delete feature but I managed to fix after some long hours😂 Once again, thanks 🙏

[@SAfanasyev]

Parwiz, thanks a lot for your time to put it together

[@bhaswatiroy1433]

Very nice explanation !! One of the best videos on Flask

[@iwanguanteng5010]

Did it use jsquery to transfer the data between the table and the modal?

[@Kydenius]

How could I implement so I'd have a time + date function instead of ID on each line? Something that would be editable by the user?

[@mariagitateresafebriani913]

thank you so much, your website really helped me on using modals and Flask Python

[@mofiathamin4908]

You are awsome make an e-commerce Web site with flask and mysql alckemy please in one Corse 😘

[@ParwizForogh]

thanks i will do

[@ezarasheed3868]

Hi, is there a way to insert multiple rows/employees into a table at once using the form field, rather than just one at a time?

[@peterprakash4758]

Anyone else facing issues at 25:20 - bootstrap models ? Kindly help

[@paulbull5318]

Great tutorial, just one thing i struggled with the well and jumbotron and couldn't get the header to work. It turns out that boostrap 4 uses cards and not wells.

[@lightyagami7085]

Can you tell me how did you make jumbotron work.

[@paulbull5318]

@@lightyagami7085 i stuck with it but used a card instead of a well

[@lightyagami7085]

@@paulbull5318 Okkk, I switched to bootstrap 4 and it is working for me now

[@idk____idk6530]

Thanks Bro 😄 You help Me to Make My first Freelance Project ❤️🥺❤️❤️❤️❤️

[@nowenator]

Thank you, great tutorial, I have fully enjoyed! Couple of questions: When adding a new record line it goes to the bottom of the table. Can it go to the top row? Also, when updating a record (row) it goes to the bottom as well maintaining the ID number, that doesn't look right. Any thoughts please?

[@SaudBako]

I used order_by in my index function. all_data = Data.query.order_by(Data.id).all()

[@techdevrpa]

@@SaudBako can you send me your discord for talking about flask?

[@tonysjc]

Congratulations ! Very good.

[@ParwizForogh]

Thank you very much!

[@Sammycmp]

You didn't include the fact that one would have to install a driver before it connects to MySQL database. Although I have been using postreSQL with PyCharm(Python) following your interesting tutorial trying to connect it with MySQl, I have been having many errors, like... return __import__("MySQLdb") ModuleNotFoundError: No module named 'MySQLdb' but when I installed psycopg2 for PostgreSQL immediately it worked. So what do I need to do for this application to connect to MySQL 8.0?

[@cauanasz]

I have the same issue

[@realnycmoments]

good stuff. what do you recommend for deploying this app to a cloud server on production?

[@bizindavyileonce2224]

RuntimeError: Working outside of application context. This typically means that you attempted to use functionality that needed the current application. To solve this, set up an application context with app.app_context(). See the documentation for more information.

[@reenayadav8468]

Use this code after you enter in python shell 1: from app import app, db 2: app.app_context().push() 3: db.create_all()

[@riddhikpankhania325]

After Bootstrap Models chapter, after copying 'add employee' part, I am not able to open "Add New Employees" . I checked many times and did same from friend too, but still not getting. Pls help

[@riyatiwari7178]

Hi Riddhik, Was this issue solved when you were learning this course? Could you please spare a moment to help me with this? I also have been facing the same issue. Thank you in advance, though!

[@saucecode5544]

Thanks for the tutorial, I Really learned a lot.

[@JimSawa]

Thank you for the wonderful video. It is extremely helpful.

[@prathmeshsananse7064]

getting this error while pip install Flask-SQLAlchemy : --plat-name must be one of ('win32', 'win-amd64', 'win-arm32', 'win-arm64')

[@gsv202000]

Thank you so much Parwiz. Learned a lot

[@Lukas-dt9km]

Muchas gracias Parwiz!!! Muy buen tutorial excelente!! saludos desde Argentina!!

[@alexgora7530]

Hello, you said in video that we can copy "modal add employee" code in the description to this video, but I can't find the link?

[@ola7540]

IF YOU HAVE ISSUE WITH MODAL: Your title block in index.html should look something like this: {% block title %} {% endblock %} not {% block title %} Home {% endblock %}

[@remixowlz]

Very good explanation sir! But please change your editor to Visual Studio Code or make it white pycharm

[@ParwizForogh]

Ok next time

[@baopham981]

Your tutorial is awesome! But can you all so make the add to cart function

[@shilpak5561]

Hello parwiz.....Please make a vedio on add search button to this application

[@dasunsucharith2834]

This was very helpful! Thank you very much for this tutorial!!!

[@rencooper]

Where can we get the source code you mentioned?

[@halderpradipta]

thank you very much Sir

[@devendrap9659]

At the time of production level what is uri for sqlalchemy?

[@leomaredcampos4941]

May, I ask you to create an inventory system using flask?

[@malikjavadov366]

really good , keep it coming!

[@ChupoCro]

header.html should *not* extend base.html because that results in index.html's source consisting of *two* HTML documents (doctype, html, head, body and *again* doctype, html, head, body). Every .html which extends base.html will have all the tags contained in base.html and if inside index.html (which extends base.html) is included header.html which would extend base.html too, then index.html cosists of twice base.html (browser > View page source). header.html should consist only of: ... and all {% %} blocks should be removed from that file.

[@shilpak5561]

Do you have a vedio about searching , and the task is done and undo the todos

[@luchinilvp]

Excelente vídeo, gracias por compartir tus conocimientos y tiempo. Saludos.

[@rasikmohamed500]

Simply Awesome✌️

[@prashantpandit2031]

Thank you Sir wonderful Teaching.

[@twakskawt]

you da man Parwiz!

[@joryaock]

Is there a way have edit take you to another page instead of using a modal?

[@priscilapower3781]

Really good material. Thanks for sharing and congratulations !

[@ParwizForogh]

Thank you too!

[@vijaypratap7429]

Please make a method for search operation too

[@ashokaddanki4230]

How can we implement filter and search functionalities for it

[@bular8757]

thanks so much it really helped me but i have one little issue, i use SQLite3 and if i try displaying my entries on the table, it displays the number of columns i have in the database but its blank.

[@baizeedrony]

How will I implement this with oracle database?

[@didierarbeyjoaquigomez6646]

Very good video, greetings from Colombia, I want to ask for some help, what happens is that I have a registration form, I am using Flask and Mysql framework, I want to load the data from the database in a select that I have in the form Registration, could you help me on that, thank you very much.

[@hartimat]

Very useful. Thanks for posting!

[@erangiwijerathne9654]

Thank you very much. You saved my day.

[@bricesifoua-ig9vy]

Thanks. But where can we find js, font and css files ?

[@maelevy957]

Hi. I have a question. I have an error it says 'ModuleNotFoundError: No module named 'MySQLdb' I tried to download pymysql but it didn't work. And also the delete and edit button is not working. Help hahaha

[@donteo3105]

me having the problem… frustrating

[@willianoliveirapires3413]

I exclude the button but it does not delete the data, in the terminal it displays the id in the get method, but it does not delete the wave

[@taimoorneutron2940]

amazing tutorial appreciated, sir i need to get static files but in source code there are no

[@waqasarqum]

Awesome tutorial

[@cydy80229]

Thank you! It's really useful!

[@rudyr6759]

how can I use sqlite3 instead of MySQL?

[@rakshithkota]

Can you please share the source code or the repo link. This tutorial was much helpful but as of Dec 2022 few settings need to be added especially on M1/M2 Macs...

[@zaenalenal1721]

Thank you so much. Good tutorial

[@amanjoshi7259]

27:34 i'm getting error when i refreshed the page.. it show me this ------ werkzeug.routing.BuildError: Could not build url for endpoint 'insert'. Did you mean 'index' instead?

[@buildwithmacduff699]

I am getting the same thing.

[@saikatjaman2004]

@@buildwithmacduff699 anyone fixed this issue??

[@SaudBako]

In app.py, make sure that your insert method's route is '/insert', and try again. Otherwise, go to index.html, then find the add modal (because this modal calls '/insert'), then find the form action inside it, then change "{{url_for('insert'}}" to "/insert" and make sure that "method" is set to "POST".

[@ParwizForogh]

i have added the complete code in my blog codeloop.org/flask-crud-application-with-sqlalchemy/, i dont know why it was broken

[@shyamrangasamys3165]

thanks a lot.. very good teaching skills bro..

[@ParwizForogh]

welcome

[@gowthamns8228]

But every time when I am pressing edit or delete my page is reloading, How to use prevent default here and only disappear the content which I need to delete

[@_itsmeKHawaR]

its very help full

[@souravkumarsingh1345]

Explain how you link your local database with CRUD app ?

[@omg432111]

could u do a tutorial on dynamic field?

[@kshitijgupta6175]

from where did he copy that href code for bootstrap and js at 12:13?

[@brunoillipronti8641]

I already checked 3 of your videos and I didnt find any SELECT section in the CRUD :(

[@ParwizForogh]

check i have the selecting method but not in the name of selecting i have used get()

[@minaturabio2023]

how to make a search field and filter the data, it could be by phone number

[@luismedinamachaca4814]

very good

[@bartoszcwiakala8916]

Great tutorial, thank you:)

[@ParwizForogh]

You're very welcome!

[@3ng279]

sir . i have one problem in app.py on line 2 : from flask_sqlalchemy import SQLAlchemy (when i run code it error ) it have install package SQLAlchemy i install ready but it have error can you breakup my problem?

[@sadowsky]

Same hereee :(

[@ΓιώργοςΛειβαδιάς]

install this: pip install -U Flask-SQLAlchemy

[@prateeksingh1141]

d.create_all() is giving me error when i am running your code in my system, please help

[@notyourpasta]

Sahi baat hai.

[@prateeksingh1141]

@@notyourpasta haha 😂

[@yoelsama3313]

Did you find the solution? I have the same error :/

[@amaramw]

hi, I have a problem with my Edit button. the form cannot be displayed. and no error message either. anyone know how to fix this problem? :')

[@sumitluitel4212]

Why use ['GET, 'POST'] methods when 'DELETE' (when creating deleting route) is available. I tried but i had an error and couldn't make it work. anyone?

[@rawrrawr-ns7ck]

Thank you! This is a great tutorial

[@ParwizForogh]

You're very welcome!

[@madhusudanj4557]

I'm not able to delete data please help me ERROR: "The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again."

[@jamielevorne449]

thank you sir for this video. can i please get the source code?

[@ritiksharma4322]

Which data base has been used here

[@parandooshrahimi4238]

Hi I make the base.html file , index.html When I run it ,it doesn't work ?

[@oludedavid9706]

while trying to edit the next data apart from the first I get an error: sqlalchemy.exc.PendingRollbackError, aside from this error everything works fine, but I am in flask-admin baseview

[@fassoyangce1075]

Thank you so much for sharing your knowledge. However, I faced the problem while deleting the entire database, the ID doesn't restart from 0, but continues the counting from where it stopped. Can you please help me to fix that issue?

[@zack-aihtizaz]

Id is auto_increment. So, when we delete the data, the id is not return to previous number. Even we delete all data, id is not going to zero (but it will continue to add from last id number)

[@fassoyangce1075]

@@zack-aihtizaz Thank you so much for the clear answer! :)

[@amirahammami7799]

Great tutorial, thank you

[@ParwizForogh]

Glad it was helpful!

[@wahidahanuar7620]

thanks for the tuts. i failed to insert data, im using sqlite3. 😔