Milestone M3

This page lists the goals and tasks for ClassDB Milestone M3. Tasks completed in this milestone contribute to release/version 2.x (exact version number TBD).

Please attempt to add documentation as issues are fixed and features are added.

Please add tasks to lists in appropriate section. If a list or a section does not exist, add it. Choose a task to work on and write your last name at the end of the task text in bold. When the task is complete, place a check mark the task's list item.

Issues

• Add issues
  • Review comments to PR 150 for possible issues
• Address issues marked for this milestone (no need to re-list issues here)

User and Team management

Design

• Possible use of OIDs to more reliably manage users, schemas, and other objects
• Teams

Database

• ER Schema
• addRoleBaseMgmt.sql
  • Table RoleBase --Murthy
• addUserMgmt.sql
  • Tables DDLActivity and ConnectionActivity
  • Views User and Team
• addClassDBRolesMgmt.sql
  • Views Instructor, Student, and DBManager

Core Functions

• addRoleBaseMgmt.sql
  • createRole
  • revokeClassDBRole
  • dropRole

GroupRole-specific Functions

• addClassDBRolesMgmt.sql
  • Functions for teams

Other Functions

• Prohibit DROP SCHEMA with DDL trigger

Logging

Connection logging

• Log disconnections (log_disconnections)
• Add functions isConnectionLoggingEnabled and isLoggingCollectorEnabled to return the current state of connection log_connections and logging_collector respectively

DDL logging

• Add function isDDLoggingEnabled to return the current state of DDL logging

Uninstall Scripts

• Ensure any new functions / objects are removed from a ClassDB database

Documentation

• Team management

Postgres Version upgrade

Updating from Version 2.0

• Remove ClassDB.PostgresLog (now a temporary table)
• Remove ClassDB.importConnectionLog(DATE) (return type changed)