A simple web app to show data manipulation via Flask and SSMS.
Copy the script from this file and execute it in SQL Server.
Once you've created the tables in SSMS, go to main.py and edit the credentials. (you only have to change server and database in line 7 and 8)
Type py main.py in the project's directory or directly run main.py
If all goes well, your webapp will be deployed on localhost:5000 (127.0.0.1:5000)
Type /admin in url (127.0.0.1:5000/admin) to manipulate data in your database.
Install via pip
- Pyodbc
- Flask
- Requests
or run pip freeze > requirements.txt
then pip install -r requirements.txt
- if you'd like to see the data manipulation using c# and asp.net core mvc check out this repo by blurryface
