Postgres 10

ClassDB has so far been developed and tested extensively using version 9.6 of PostgreSQL. Although we do not foresee major any issues, ClassDB has not been officially tested using version 10 of PostgresQL.

Testing

The following is a proposed list of tasks that should be performed in order to fully test ClassDB on a newer version of PostgreSQL.

• Perform a trial-run of ClassDB on most recent release of PostgreSQL (10.1 as of 01/05/2018).
  • Test current installation procedure
  • Run and verify unit tests
  • Run and verify privilege tests
  • Import test roster located in ClassDB/tests/importStudents
  • Perform full system test which involves adding artificial activity and verifying all functionality of ClassDB
    • No integration or system tests have been defined for ClassDB - this last step may involve the creation of these tests, or at the very least, precisely documenting what steps have been taken and with what data, to the point that they can then be repeated by other contributors. Working through the ClassDB documentation may be helpful in this task. Possible examples of activity may include:
    • CRUD operations by Student, DBManager, and Instructor roles
    • Importing and reading user activity
    • Testing connection management
    • Testing statement timeouts and connection limits
    • ...and so on
• Update production server to most recent tested release of Postgres.
• Investigate any new features introduced with version 10 for possible current and future use.