courses routes proposal

[natebrennand]

current routes:

dumps records for each section of a course
http://data.adicu.com/courses
finds all sections for each course and combines for one record
http://data.adicu.com/courses/v2/sections
contains all info for a course as well as all sections
http://data.adicu.com/courses/v2/courses

proposed routes:

apply filters on columns, includes all data including description and sections list
http://data.adicu.com/courses/
find options for columns
http://data.adicu.com/courses/options/< ATTR NAME >
find an individual core (helps with #32) would return all course info w/o section list
`http://data.adicu.com/courses/call/< number >

thoughts?
CC @brishin @rbtying @danrschlosser @anshulkgupta

[brishin]

Could you explain what find options means?

Does that mean that I can filter /courses with query parameters?

[natebrennand]

For example, on the housing endpoints I can get all the options for a certain attribute.
There are certain uses for this as well as it makes building queries easier when you can figure out what all the possible options actually are.

/housing/buildings/options/building
{
    attribute: "building",
    results: [
        "47 Claremont",
        "548 West 113th",
        "600 West 113th",
        "Broadway",
        "Brownstones",
        "Carman",
        "East Campus",
        "Furnald",
        "Harmony",
        "Hartley",
        "Hogan",
        "John Jay",
        "McBain",
        "River",
        "Ruggles",
        "Schapiro",
        "Wallach",
        "Watt",
        "Wien",
        "Woodbridge"
    ],
    status: 200
}

[rbtying]

so "options" <-> "SELECT DISTINCT"?

On 07/03/2014 09:09 AM, Nate wrote:

For example, on the housing endpoints I can get all the options for a
certain attribute.
There are certain uses for this as well as it makes building queries
easier when you can figure out what all the possible options actually are.

|/housing/buildings/options/building
{
attribute: "building",
results: [
"47 Claremont",
"548 West 113th",
"600 West 113th",
"Broadway",
"Brownstones",
"Carman",
"East Campus",
"Furnald",
"Harmony",
"Hartley",
"Hogan",
"John Jay",
"McBain",
"River",
"Ruggles",
"Schapiro",
"Wallach",
"Watt",
"Wien",
"Woodbridge"
],
status: 200
}
|

—
Reply to this email directly or view it on GitHub
#106 (comment).

Robert Ying

B.S. Candidate in Computer Science
Undergraduate Researcher, Columbia University Robotics Group
Engineering Student Council Academic Affairs Representative
Teaching Assistant, COMS W3157
Residential Advisor, John Jay 6
Phone: (408) 982-7485 (cell)
Email: rbtying@aeturnalus.com

[natebrennand]

yes, but it only returns values from the specified column