Flask-SQL Project

Kevin Wang: kwang10082000@gmail.com

Objectives

1. Create a front-end interface with Flask that will communicate with SQL Server on local machine
2. Use Libraries and Tools to create connection with Local SQL Databases.
3. Apply functions to manipulate SQL Databases (ie. add user, delete user, update user, etc.)
4. Design User-Friendy Interface with HTML, CSS

Future Objectives

• Add Second Database
• Connect Two Databases (ie. Customer and Orders Tables)
• Adding sorting function to table based on column

Showcase of Product

1. The Main Landing Page:
2. Database connected with local SQL Database
3. Adding user and updates database promptly
4. SQL Management Studio - Changes are in real time
5. Deleting user
6. Updating user information

Languages - Frameworks - Tools used

• Python (SQL ALchemy)
• HTML/CSS
• Flask
• Javascript

Prerequiste Steps (Very Important)

1. Download SQL Express: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
2. Download SQL Management Studio: https://www.google.com/search?rlz=1C1CHBF_enUS857US857&sxsrf=ALeKk00i4a1GM8qjyRA8IlamzRXdAMEFuw%3A1597936066781&ei=wpE-X7OtL-bF_QbKxqroDw&q=sql+management+studio&oq=sql+ma&gs_lcp=CgZwc3ktYWIQARgAMgcIABCxAxBDMgQIABBDMgQIABBDMgQIABBDMgIIADIFCAAQsQMyAggAMgIIADICCAAyAggAOgQIABBHOggIABCxAxCDAVD5C1jjDWClEWgAcAJ4AIABTIgBkwGSAQEymAEAoAEBqgEHZ3dzLXdpesABAQ&sclient=psy-ab
3. Download Visual Studio: https://visualstudio.microsoft.com/ Make sure you download Python packages shown on the installer
4. Create your own SQL server. Plenty of youtube tutorials.
5. In \Flask-SQL\FlaskSQL\FlaskSQL\views.py, line 16, you must add your respective SQL Server URL. The website on how to do that is in the comments above that line

Once prerequisite software is downloaded, open the solution file (\Flask-SQL\FlaskSQL\FlaskSQL.sln) with VS. Click Run Web Server and it will be on your local host.