Skip to content

Milestone 2

Jump to bottom
Kevin Kelly edited this page Dec 18, 2018 · 1 revision

This page lists the goals and tasks for LearnSQL Mielstone M2. Tasks completed in this checkpoint contribute to second release of LearnSQL with the primary goal of resolving bugs. New features and enhancements to existing functionality will be of secondary focus.

This Milestone was changed to fit into the scope of a school project. This list is now updated to reflect the changes we made to complete that project. The old, unfinished goals are marked with a strike-through and will be finished in a future milestone

Bugs

Front-end Bugs

  • When registering a new account, if a user presses Enter instead of Register, the following error message appears: User Or Password Is Incorrect. Issue: #55
  • The navbar on some of the pages does not collapse when the size of the browser window is resized down. Issue: #75
  • On the homepage when the browser window is resized down, the page content overlaps. Issue: #75
  • Some of the pages are missing the LearnSQL branded footer and on other pages, the footer overlaps the page content. Issue: #75
  • [ ] Some buttons which link to pages return an HTTP error 404. Issue: #80
  • The Semantic UI stylesheet uses conflicting font sizes compared to other pages which do not include this stylesheet. Issue: #76
  • Some navigation tabs are missing from certain pages.
  • If a user manually navigates to http://localhost:3000/views/, an unstyled version of the homepage is displayed. Issue: #80
  • If a user manually navigates to a page requiring authorization without logging in, the page is displayed without content. Without user login, the server should redirect to an error page. Issue: #80
  • Any pages which use AngularJS do not display or function correctly in Internet Explorer 11. Issue: #59

Back-end Bugs

  • On the contact.html page, when the submit button is clicked, an email is sent regardless of whether the user filled in all of the fields. Issue: #72
  • Alert messages need proper formatting and content. Issue: #77

New Features and Other Enhancements

Teacher Class Section

  • Make it possible to edit class information Issue: #79
  • DB Functions to create and drop classes (ClassDB instances)
  • View ClassDB student activity for each class
  • View Student/Team Schema
  • View List of Teams
  • Connect teacherClass.html and studentClass.html to tables.html

Student Class Section

  • View List of Classes
  • View Schema for Each Class (ClassDB instance)

Workshop Section

  • Create UI for input and output of SQL and PL/pgSQL
  • Create API for sending queries and receiving related data from ClassDB Instances

Profile Section

  • Make it possible to edit user information Issue: #82

Move Some Node.js Functions to DB and DB issues

For better portability and performance we have decided to move as many functions as possible to the LearnSQL database. To do this we will have to find the best methods of creating and manipulating multiple databases. Also, for security we will have to decide how we will do hashing and comparing of hashed values.

Login

  • [] Verification tokens for forgotPassword and EmailVerification should be considered invalid after a specified amount of time. Consider making configuration file for this and similar attributes. Issue #43
  • Add Forgot Username Issue #44

Tests

  • Develop Unit tests for any the SQL functions created. Issue 14
  • Develop Load test to see how the webapp/db reacts under load. Issue #34

Clone this wiki locally