Hi @Mayank2808sharma I hope you are doing well

closes: #20

I completed the task

Schema Changes

• I create two tables : Compartments and Seats
• Train and Compartments (one to many)
• Compartments and Seats (one to many)

Code Changes

• create train

  • when the admin create the train schema they also need to give the compartments data
    Request :

    {
        "train_name":"Train_1",
        "source":"Chennai",
        "destination" : "Coimbatore",
        "compartments" : [{
                "name":"T-1-C-1",
                "total_seats":10
            },{
                "name":"T-1-C-2",
                "total_seats":5
            }]
    }

    Response :

    {
        "train_name":"Train_1",
        "source":"Chennai",
        "destination" : "Coimbatore",
        "compartments" : [{
                "name":"T-1-C-1",
                "total_seats":10
            },{
                "name":"T-1-C-2",
                "total_seats":5
            }]
    }

• update train

  • Admin can able to add new compartments in for a train

    request :

      ```json
      {
      "additionalCompartments":[{
              "name":"T-1-C-3",
              "total_seats":10
          },{
              "name":"T-1-C-4",
              "total_seats":15
          }]
      }
      ```
    

    Response :

    {
        "message": "Train and compartments updated successfully.",
        "train": {
            "id": 1,
            "train_name": "train_1",
            "source": "chennai",
            "destination": "coimbatore",
            "createdAt": "2024-05-14T09:56:31.994Z",
            "updatedAt": "2024-05-14T09:56:31.994Z",
            "Compartments": [
                {
                    "id": 1,
                    "compartment_name": "T-1-C-1",
                    "createdAt": "2024-05-14T09:56:31.999Z",
                    "updatedAt": "2024-05-14T09:56:31.999Z",
                    "TrainId": 1
                },
                {
                    "id": 2,
                    "compartment_name": "T-1-C-2",
                    "createdAt": "2024-05-14T09:56:32.000Z",
                    "updatedAt": "2024-05-14T09:56:32.000Z",
                    "TrainId": 1
                },
                {
                    "id": 3,
                    "compartment_name": "T-1-C-3",
                    "createdAt": "2024-05-14T09:58:16.161Z",
                    "updatedAt": "2024-05-14T09:58:16.161Z",
                    "TrainId": 1
                },
                {
                    "id": 4,
                    "compartment_name": "T-1-C-4",
                    "createdAt": "2024-05-14T09:58:16.161Z",
                    "updatedAt": "2024-05-14T09:58:16.161Z",
                    "TrainId": 1
                }
            ]
        }
    }

• Ticket Booking :

  • the use can book the ticket based on the compartment like how the real IRCTC is

  • And clear the edge case like

    • if the use book 5 ticke and the there is no seats in any compartment
    • And Built based on ACID Property

    Request :

        {
            "train_id":1,
            "no_of_seats":2
        }

    Response :

        {
            [
                {
                    "status": "Booked",
                    "train_id": 1,
                    "train_name": "train_1",
                    "seat_id": 3,
                    "seat_no": "T-1-C-1_3"
                },
                {
                    "status": "Booked",
                    "train_id": 1,
                    "train_name": "train_1",
                    "seat_id": 4,
                    "seat_no": "T-1-C-1_4"
                }
            ]
        }

  • If there is no Enough seats

    Request :

        {
            "train_id":1,
            "no_of_seats":50
        }

    Response :

    {
        "message": "Seat not available"
    }

• Booked Ticket details :

  • User can get the ticket details as well as seat number base on the compartment

  Request :
  details?booking_id=17

  Response :

          {
              "bookingId": 17,
              "bookingTime": "2024-05-14T11:20:13.571Z",
              "trainName": "train_1",
              "source": "chennai",
              "destination": "coimbatore",
              "username": "harish_admin",
              "seatNos": [
                  "T-1-C-3_2",
                  "T-1-C-3_2"
              ]
          }