/lug-slotbooking

Primary LanguagePython

Slot Booking Flask App

  • Fork this repository and clone the forked repository.
  • open terminal and run pip install Flask Flask-SQLAlchemy
  • Run the app.py
  • By default it is using a mysql database, fill in the credentials for mysql in line number 6 of app.py.
  • You can also use a sqlite database.
  • To change database, just modify line number 6 in app.py
  • When it is executed for the first time, it will automatically create the required tables.
  • Login credentials are the records stored in the SlotBookedApplicants table.
    • To login, you must create a record in the above mentioned table. You need to use the value of the regno field and the password will be the value of the Phoneno field.
    • Therefore create a sample record to login.
      • Sample Record Example:
        • name: test
        • regno: 22BCE1111
        • email: example@example.com
        • phoneNo: 1234567890
        • department1: Technical Department - Backend
        • department2: Media Department
        • slot1_status:
        • slot2_status:
        • slot1:
        • slot2:
      • slot 1 status, slot 2 status , slot 1, slot 2 will be automatically filled when a slot is booked.
      • Now since this person in the sample record was shortlisted for Technical Department - Backend and Media Department also, you need to create a record in both those tables also for this same person.
      • Then you need to add an available slot for both the department in the Slots table.
        • Example Record for Slots table.
          • slot_id: 1
          • slot_num: 1
          • department: Technical Department - Backend
          • slot: September 28 1:00 PM - 2:00 PM
          • seats: 10
          • seats_left: 10
        • The slots you create here, will be displayed when the user is trying to book the slots.
        • Every time a slot is booked, the seats left for the slot will decrease. Once there is no seat left in a slot, that slot will be no longer displayed in the slot booking page.
        • Make sure you create slots for all the departments an applicant is shortlisted.
        • For example, here our test applicant is shortlisted for Technical Department - Backend and Media Department. So make sure a slot is created for both the departments.
  • If you face any issue, you can reach our technical support team at Linux Club Forums
  • Once you have made any improvements or modifications, you can create a pull request.
  • Linux Club Technical Team will review it and if it passes the review, it will be merged to main repository.

Deploy using Docker

  • Make the necessary changes to the app.py file.

  • Run docker compose up -d

Developed by Rahul Vijayakumar

Frontend developed by Dhananjay Chauhan