Inital SQL Statements - Githubissues

uwstout-cs458-s22 / advisor001-api

This repository is the RESTFUL API back-end for the UW-Stout CS458-001 Advisor web app.

0 stars 0 forks source link

Inital SQL Statements #8

Open ErikDrake27 opened 2 years ago

ErikDrake27 commented 2 years ago

As a User, I would like Advisor to deliver reliable information based on the parameters I enter so that I do not receive confusing or wrong data back.

if parameters have been filled out, the application returns the correct data based on the parameters.
if there is a bad parameter, the program responds with an empty query.
if there is no parameter, the program responds with an empty table.
if good values with good parameters have been inserted, the program inserts those values.
otherwise, the program responds with the proper error message.

ErikDrake27 commented 2 years ago

What I am attempting to say here is that SQL statements should be correct and return good data.

joshua-elmer commented 2 years ago

Just to clarify, do you mean this task to be creating a batch of generic SQL statements that will the user will choose parameters for?

Something like: SELECT FROM 'CLASSES' WHERE 'startTime' = 10am

And that these statements give back the correct results obviously

huseinr2493 commented 2 years ago

Do we mean we want to improve the existing SQL utilities/helpers and add new ones as we go along (order by, join, etc)? This seems broad as it's something we'll inevitably have to keep going back to as we add new DB dependent features

huseinr2493 commented 2 years ago

Self-assigned ("claimed") and will tweak this as soon as I get the chance

huseinr2493 commented 2 years ago

Nevermind, this one seems in danger of being a duplicate