Passenger User Story: Selecting and Joining a Trip

[ecse321-fall2018]

Passenger User Story: Selecting and Joining a Trip

[RyanDotsikas]

Should be relatively easy to solve given the array data type of the table, using a command such as the following:
UPDATE trip_table SET passenger_id = array_append(passenger_id,'new item') WHERE ...

Where, 'new item' would be the userID you wish to add to the trip and the WHERE statement looks for a tripID that matches the trip you wish to join. The available seating should then be updated

[RyanDotsikas]

• Added methods to allow for joining and leaving a trip
• Takes userID and tripID as inputs
• Updates the passenger_id array column in the table and the available seats column
• Realize we do not need the setter method in Trip class that was meant to do this, so it is currently commented out
• ***Cannot check functionality yet, waiting on database column data types to be changed to arrays

[RyanDotsikas]

Functionality works properly as expected. Closed by eafcf7f