advanced-software

To run the programme: python GUI.py

SQL Database Guidance:

1. Ensure SQL Workbench is installed
2. Create your own local connection
3. Click 'Server' - 'Data Import'
4. Select File - 'horizon_cinema
5. Click 'start import'

You will now have the SQL database on your own system. Remember any word done to the database will need to be exported and pushed back onto gitlab with the coding. To export:

1. Click 'server' - 'data export'
2. Select Database
3. Click 'Export to Self-Contained File (.sql)'
4. This will create a file of the database - this needs to be pushed on gitlab with any coding change

To get database connected within coding:

1. Each person will need to update constants.py file
2. In file find row 4-7.
3. Update username & password with your own SQL workbench credentials.

questions for clarification:

• in user.createBooking and tblBookings is the 'booking_date' the time that the booking is created or the time of the showing?