Try   HackMD
tags: Lesson Notes Python MySQL PythonFlask2021

MySQL - Workbench Intro

For the rest of our Python stack we will be using the workbench a lot. It becomes our database and how we create them. So here are some images to help navigate the workbench

Creating your Database

  • So creating your database sounds hard but with a few images I think you will be good to go.

    Image Not Showing Possible Reasons
    • The image file may be corrupted
    • The server hosting the image is unavailable
    • The image path is incorrect
    • The image format is not supported
    Learn More →

  • From this 1st Screen shot once you click that You should see the following screen

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

  • Click that top + to add a new moddle
  • One the next screen you will want to then double click mydb and rename it

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

  • Now follow the stems in this screenshot

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

  • After this you might need to scroll up a bit to see this part but you will want to doulbe click add diagram so you can start designing your database

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

  • You should see a grid now and on the left a bunch of icons (you might need to go to full screen to see them)
  • Here is what each of those icons mean and what we will be using.

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

View Databases

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Last changed by 
 
Python w/Flask
0
229

Read more

Classes

So now we went over what the 4 pillars are and we did use classes but just what are they?

Feb 10, 2024
Python Main Notebook (July/August 2022 Cohort)

Python.org

Aug 29, 2023
Python Main Notebook (July/August 2022 Cohort)

Python.org

Nov 8, 2022
Creating Your ERD

There are several steps to creating a good ERD. Click the table icon Click anywhere in the grid to place the table Double click the table to open the information section and rename the table Click the AI check box Make sure that the column name for the one you just checked is id Now your not done but your first table is now created. Next we need to create each of the feilds that will be a part of that table Remember that these feilds are what we put in the init section of our class (with a few additions like id and createdAt and updatedAt)

Dec 17, 2021
Read more from Python w/Flask
Published on HackMD