Skip to content

Course offerings have incorrect level data #105

@xyspg

Description

@xyspg

Description

Course offerings in the database have incorrect undergraduate/graduate level assignments that conflict with their parent course definitions.

The seed.zip file contains inconsistent level data between the courses and courseOfferings tables:

courses table (correct):

{"code":"CS-UY 3113", "level":"undergraduate", ...}

courseOfferings table (incorrect):

{"courseCode":"CS-UY 3113", "level":"graduate", ...}

Image

Known Affected Courses

All CS-UY 3xxx courses in courseOfferings have incorrect graduate level:

Verification Commands

  1. Check courses table (correct)
 unzip -p seed.zip courses/documents.jsonl | grep '"code":"CS-UY 3' | jq -r '.code + " " + .level'
  1. Check courseOfferings table (incorrect)
  unzip -p seed.zip courseOfferings/documents.jsonl | grep '"courseCode":"CS-UY 3' | jq -r '.courseCode + " " + .level' | sort -u

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions