DBMS project to create an app to facilitate the faculty coordination in Pulchowk Campus
MySQL connection with Django:
- Edit the database backend setting in settings.py file
- import connection, transaction (for data modification operations) from django.db
- connection.cursor returns a cursor object that is used to execute(), fetchone(), fetchall() results of the query execution
- We avoid the django model layer completely and make our own classes for each table and custom methods for insert, update, list or filter operations
Note: You need a database named 'departmentDatabase' and a running mysql server to establish a connection with the django app.