Databases & SQLAlchemy - Flask Tutorial Series #7

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 พ.ย. 2024

ความคิดเห็น • 26

  • @wonkywombat
    @wonkywombat 8 หลายเดือนก่อน +8

    Great episode. I too will need to redo this with an existing MySQL db.

  • @cvicvicvi
    @cvicvicvi 7 หลายเดือนก่อน +1

    Hey, thank you so much for this tutorial series, it's very well thought and easy to understand for beginners like me. Currently trying to develop my first web app, that's exactly what I needed.

  • @leonardomoreiralouzas3995
    @leonardomoreiralouzas3995 4 หลายเดือนก่อน

    Relly good! I changed the detail and delete to a single view to make it less code, I think it looks better that way. All the code is in my github repo

  • @pawjast
    @pawjast หลายเดือนก่อน +2

    In 12:49 you run `flask db init`.
    It works but is a bit confusing (unless it's explained further in the video).
    How does Flask know where to look for a `db` to initiate?
    I think it only works because we defined our app inside `app.py` which is sort of a convention so this is a default place for an app to be in.
    So Flask checks `app.py` by default - finds the `db` in it and all is good.
    But if you change the name to anything, e.g. `my_app.py` - then the `flask db init` throws an error ("Error: Could not locate a Flask application.")
    So first you need to tell Flask where your actual `app` and `db` is by setting `FLASK_APP` variable or calling `flask --app my_app:app` where:
    - `my_app` is the name of the file you're app is in (so `my_app.py`)
    - `app` is the name of the variable the Flask app was assigned to inside that file (in the tutorial we actually use `flask_app` inside `run.py`)

  • @johnraz99
    @johnraz99 8 หลายเดือนก่อน +1

    Thank You. I just need to get it to work with my MySQL database now!

    • @johnraz99
      @johnraz99 8 หลายเดือนก่อน

      Got it working with MySQL. Just had to change SQLALCHEMY_DATABASE_URI prefix to 'mysql+mysqlconnector://'. I also installed mysql-connector-python

  • @FrozenShield
    @FrozenShield 8 หลายเดือนก่อน +2

    Thanks for the tutorial, it helped me understand flask-sqlalchmey! I am trying to understand at 15:10 you mentioned that it loops from the other python files. Is it necessary to loop it like that? I also looked at the quick start instructions for flask-sqlalchemy and it looks like you can do it all in app.py. When you write flask run in the terminal it looks for app.py to run that so is it best practice to keep everything in app.py or split it out like how you did it?

    • @frontetatico
      @frontetatico 6 หลายเดือนก่อน

      Hi, I think it's a better practice to split

  • @samannwaysil4412
    @samannwaysil4412 6 หลายเดือนก่อน +1

    Keep these tutorials coming brother!

  • @jayewastaken9486
    @jayewastaken9486 8 หลายเดือนก่อน +1

    I love this series!

  • @kylec.5476
    @kylec.5476 7 หลายเดือนก่อน +2

    Great series!

  • @eklownr4566
    @eklownr4566 8 หลายเดือนก่อน +1

    Nice tutorial.

  • @michaelrobson3092
    @michaelrobson3092 7 หลายเดือนก่อน

    Awesome , could you show how we could use a DB like Redis with SQLite & SQLAlchemy

  • @gerlannoharrisson9210
    @gerlannoharrisson9210 2 หลายเดือนก่อน +1

    top! thank you bro!

  • @mugomuiruri2313
    @mugomuiruri2313 3 หลายเดือนก่อน

    good see u again

  • @aafan.kuware
    @aafan.kuware 8 หลายเดือนก่อน

    27:56 was not htmx will be the best choice to do this crud operations instead of writing these long JS?
    if possible, please make one separate video and all futher operation with HTMX.

  • @RocketLR
    @RocketLR 8 หลายเดือนก่อน

    my problem is with the db.Model classes is that the __init__ does not do anything when creating a object from those classes..
    So i have to make classes that inherit from Base. But then they dont get created as far as i can tell..
    As im writing this, im wodnering if should create a db.Model table then another class that inherins from that class that inherited from db.Model..

  • @mhmmdalfatehhishahmuddin2670
    @mhmmdalfatehhishahmuddin2670 6 หลายเดือนก่อน +2

    My problem is when migrating SQL when I run the command: flask db init it say 'Could not import 'db'. How to fix it?

    • @dishuu2714
      @dishuu2714 4 หลายเดือนก่อน

      same

    • @DavidVeraAlvarez
      @DavidVeraAlvarez 3 หลายเดือนก่อน

      @@dishuu2714 1. Make a clean vevn
      2. install flask, flask-sqlalchemy, flask-migrate
      3. run the flask db commands (it should work now)
      4. make sure you have sqlite3 installed
      5. pay attention to pycharm advices to install sqlite3 related content if it's the first time you are using sqlite3
      6. Add a new sqlite3 data source clicking the plus icon in the database window that you can access in at the right of your screen inside pycharm
      7. Set the sample database 'testdb.db' in the file field browsing your directories
      8. Test Connection
      That worked for me.

  • @spaff_hazz
    @spaff_hazz 2 หลายเดือนก่อน

    after sending a post request, if i reload the page, i get the form resubmission alert and if i continue it takes the data that i last filled the form with even though it's not in the input field. how do i prevent this?

  • @saulvera5469
    @saulvera5469 4 หลายเดือนก่อน

    dont know why but when I try to migrate it doesn't add any table, I ended up creating it in SQL

    • @spacecoder0526
      @spacecoder0526 4 หลายเดือนก่อน

      I have same issue.

  • @masoooomx
    @masoooomx 6 หลายเดือนก่อน

    which OS and which IDE ????

    • @bengaltiger8401
      @bengaltiger8401 5 หลายเดือนก่อน

      Popos with pycharm professional edition

  • @masteradvisor594
    @masteradvisor594 หลายเดือนก่อน

    15:40