nshillin/291miniproject1

291miniproject1's Issues

Setup OurSQLInitializer

Basically this class is a wrapper that allows us to login to SQLPlus. It should also have an option to import all of the necessary tables of the project.

Optional: Support search and booking of flights with three connecting flights

One of three optional tasks. We must do two. In its default setting, your system will search for flights with two connections at most. In implementing this functionality, your system should offer an option to raise this maximum to three connections. Again this is an option to be set by user when running your system and cannot be the default setting of your application.

Add Jar File ojdbc

Search for flights

Your system should prompt the user for a source, a destination and a departure date.

Add a User to the System After Booking

The system should get the name of the passenger and check if the name is listed in the passenger table with the user email. If not, the name and the country of the passenger should be added to the passenger table with the user email. Your system should add rows to tables bookings and tickets to indicate that the booking is done (a unique ticket number should be generated by the system).

Make a Booking

A user should be able to select a flight (or flights when there are connections) from those returned for a search and book it.

Optional: Support search and booking for parties of size larger than one

One of three optional tasks. We must do two. There should be an option for the user to state the number of passengers. The search component of your system will only list flights that have enough seats for all party members. Both the seat pricing and the booking will be based on filling the lowest fare seats first before moving to the next fare. For example, suppose there are 2 seats available in the lowest fare and 5 seats in some higher-priced fare. For a party of size 4, your system will book those 2 lowest fare seats and another 2 seats in the next fare type that is available.

On Logout Add Last_Login

Ticket Confirmation Message

The system should return the ticket number and a confirmation message if a ticket is issued or a descriptive message if a ticket cannot be issued for any reason. (Can be rejected if the seat is unavailable)

Create Flight Object

Object that returns flight data from the server and returns it to the view.

Close Connection after you Query

So I've learned It's super duper important to close your connection after you query. I made a method for it because you need to handle your result set before you close the connection. Otherwise we get a "too many simultaneous users" SQL exception. Can you guys just make sure that after every query you execute you close the connection once you are done with your data. There are too many calls for me to be able to catch them all myself. @jero1994 @nshillin

Optional: Support search and booking of round-trips

One of three optional tasks. We must do two. If this option is selected, your system will get a return date from the user, and will list the flights in both directions, sorted by the sum of the price (from lowest to the highest). The user should be able to select an option and book it.

Support for Multiple Users

Multiple users have to be able to use the system at the same time.

Overbooking

Include checks for overbooking as it is not permitted.

List Existing Bookings

A user should be able to list all of their existing bookings. The result will be given in a list form and will include for each booking, the ticket number, the passenger name, the departure date and the price. The user should be able to select a row and get more detailed information about the booking.

Design Document and Self Documentation

It might cut down on our crunch workload if everyone documents their code as they complete an issue , doing a writeup to that related issue in the wiki page I just created when appropriate.

Here is the assignment information on what our design document contains:

The design document should include (a) a general overview of your system with a small user guide, (b) a detailed design of your software with a focus on the components required to deliver the major functions of your application, (c) your testing strategy, and (d) your group work break-down strategy. The general overview of the system gives a high level introduction and may include a diagram showing the flow of data between different components; this can be useful for both users and developers of your application. The detailed design of your software should describe the responsibility and interface of each primary class (not secondary utility classes) and the structure and relationships among them. Depending on the programming language being used, you may have methods or functions instead of classes. The testing strategy discusses your general strategy for testing, with the scenarios being tested, the coverage of your test cases and (if applicable) some statistics on the number of bugs found and the nature of those bugs. The group work strategy must list the break-down of the work items among partners, both the time spent (an estimate) and the progress made by each partner, and your method of coordination to keep the project on track. The design document should also include a documentation of any decision you have made which is not in the project specification or any coding you have done beyond or different from what is required.

Your design document must not include the source code. However your source code (which is submitted electronically) would be inspected for source code quality (whether the code is easy to read and if data processing is all done in SQL) and self-documentation (whether the code is properly commented).

Oracle Login Screen

Create a way for the user to enter their oracle information to be used throughout their session.

Search Flights Formatting

For source and destination, the user may enter an airport code or a text that can be used to find an airport code. If the entered text is not a valid airport code, your system should search for airports that have the entered text in their city or name fields (partial match is allowed) and display a list of candidates from which an airport can be selected by the user. Your search for source and destination must be case-insensitive.

Cancel a Booking

The user should be able to select a booking from those listed under "list existing bookings" and cancel it. The proper tables should be updated to reflect the cancellation and the cancelled seat should be returned to the system and is made available for future bookings.

Create Booking Object

Object that holds all relevant data for returning booking information. Fetches booking information from the database, or returns data from the database.

User can Logout

There must be an option to log out of the system. At logout, the field last_login in users is set to the current system date.

Create User Object

Create an object to store the appropriate user data.

Add New User

Unregistered users should be able to sign up by providing an email and a password. After a successful login or signup, users should be able to perform the subsequent operations (possibly chosen from a menu) as discussed next.

Record a Flight Departure

After a plane takes off, the user may want to record the departure (Only airline agents). Your system should support the task and make necessary updates such as updating the act_dep_time.

Bug - Major: Second Autocomplete field stops working

After selecting one field, the second one stops autocompleting on typing the second letter if no city is chosen.

Record a flight arrival

After a landing, the user may want to record the arrival and your system should support the task.

Bug - Minor: Tab not working correctly when registering User

Repro:

1. Go to register a user.
2. Start on the enter username box.
3. Press tab once and you get to the first password entry box.
4. Press tab again leaves you highlighting the enter button.
   Expected: The second password entry box should be highlighted as opposed to Enter button.

User Can Login

User can log into the system. The first screen should provide options for both registered and unregistered users. There must be also an option to exit the program. Registered users should be able to login using a valid email and password, respectively referred to as email and pass in table users.

User that is an Airline Agent

Airline agents must be able to do issues #1 - #11, but also have special permissions found in #13 and #14 .

Issues Running on Lab Machine

Have to add missing swt linux library.

This is the message:
Can't load library: /cshome/makepeac/.swt/lib/linux/x86_64/libswt-cocoa-4528.so
Can't load library: /cshome/makepeac/.swt/lib/linux/x86_64/libswt-cocoa.so

Suggested Airports

When the user types in their search item the system should suggest possible airport matches if no airport code is found.

Flight Search Return Formatting

Your system should search for flights between the source and the destination on the given date(s) and return all those that have a seat available. The search result will include both direct flights and flights with one connection (i.e. two flights with a stop between). The result will include flight details (including flight number, source and destination airport codes, departure and arrival times), the number of stops, the layover time for non-direct flights, the price, and the number of seats at that price. The result should be sorted based on price (from the lowest to the highest); the user should also have the option to sort the result based on the number of connections (with direct flights listed first) as the primary sort criterion and the price as the secondary sort criterion.