This is a final web application project for database management course using modern technologies like flask and react-native. This project for hospital managment system to maniplute the internal interactions between the hospital's stuff and the external interactions between the hospital stuff's and the patients.
- Ahmed Alaa El-Sayed Arabi Zidan (Team Leader)
- Mahmoud Reda
- Ahmed Sabry
- Mohamed Nabil
- Run the following commands :
pip install virtualenv
virtualenv venv
.\venv\Scripts\activate
pip install -r requirements.txt
- Every function must be well documented.
- Format:
#===================================================================================================
# Function: function's name
# Input: <type:name> => Parameter1's description, <type:name> => Parameter2's description,...
# Output: <type:name> => Output1's description, <type:name> => Output1's description,...
# Prerequistes: Any needed prerequirements
# Description: Detailed description for the function
#===================================================================================================
- Ex:
#===================================================================================================
# Function: open_connection
# Input: <sting:db_name> => the relative path of required database to be connected with
# Output: <(Sqlite3::Connection):connection> => An object of class connection from sqlite3 module
# Prerequistes: None
# Description: Open connection with the required database
#===================================================================================================
def open_connection(db_name):
connection = sqlite3.connect(db_name)
return connection
-
To execute a sql query, follow the following:
I. In the beginning of the file, you should write:connection = open_connection("hospital.db")
II. After the connection is constructed, you have to get the cursor:
cursor = get_cursor(connection)
III. Each time you want to execute a sql query, Do the following:
cursor.execute("""_your_query_""")
IV. After you finish your work in the file with database connection, You *must close the connection:
close_connection(connection)
Warning: Not closing the database connection will cause many unexpected problems!
- Every One must have his own branch on the repository.
- No one is allowed to push his changes direct on master branch.
- Make sure before you make any changes on your local that:
I. You working on your local branch not on local master. II. Your local master is up to date with the global master.III. Your local branch is merged by the up to dated local master.git checkout master git pull
IV. Don't forget to return to your branchgit checkout <your branch's name> git merge master
git checkout <your branch's name>