Skip to content

File List

Steven Rollo edited this page Aug 17, 2018 · 13 revisions

ClassDB Home | Table of Contents


File List

Author: Steven Rollo

This document lists the files located in the ClassDB repository. Each section lists the files in the corresponding folder.

Root (./)

Contains the README and LICENSE files, as well as each ClassDB sub-folder.

  • LICENSE.md
  • README.md

docs (./docs)

Contains a copy of the ClassDB documentation for the corresponding release. The contents of the docs folder is a copy of the ClassDB wiki at the time of release - the wiki holds the current development version of the docs.

examples (./examples)

Contains script files for the shelter example schema. More information can be found on the Scripts page.

  • createShelterSchema.sql
  • dropShelterSchema.sql
  • populateShelterSchema.sql

src (./src)

Contains the source code for ClassDB. All files need to install ClassDB are in this folder. More information can be found on the Scripts page.

  • ./src/
    • db/
      • addAllToDB.psql
      • removeAllFromDB.sql
      • core/
        • addAllDBCore.psql
        • addClassDBRolesMgmtCore.sql
        • addClassDBRolesViewsCore.sql
        • addHelpersCore.sql
        • addRoleBaseMgmtCore.sql
        • addServerVersionComparersCore.sql
        • addUserMgmtCore.sql
        • initializeDBCore.sql
      • opt/
        • addAllDBOpt.psql
        • addCatalogMgmtOpt.sql
      • reco/
        • addAllDBReco.psql
        • addConnectionActivityLoggingReco.sql
        • addConnectionMgmtReco.sql
        • addDDLActivityLoggingReco.sql
        • addDisallowSchemaDropReco.sql
        • addFrequentViewsReco.sql
    • server/
      • addAllToServer.psql
      • removeAllFromServer.sql
      • core/
        • addAllServerCore.psql
        • initializeServerCore.sql
      • reco/
        • addAllServerReco.psql
        • assertAlterSystemAvailability.sql
        • disableConnectionLoggingReco.psql
        • enableConnectionLoggingReco.psql

tests (./tests)

This folder contains scripts to test the functionality of ClassDB, along with the privileges sub-folder

  • testConnectionActivityLogging.psql
  • testDDLActivityLogging.sql
  • testClassDBRolesMgmt.sql
  • testHelpers.sql
  • testRoleBaseMgmt.sql
  • testUserMgmt.sql

privileges (./tests/privileges)

This folder contains a sequence of scripts to test the functionality of ClassDB's privilege management

  • 0_setup.sql
  • 1_instructorPass.sql
  • 2_studentPass.sql
  • 3_dbmanagerPass.sql
  • 4_instructorPass2.sql
  • 5_instructorFail.sql
  • 6_studentFail.sql
  • 7_dbmanagerFail.sql
  • 8_cleanup.sql
  • testPrivilegesREADME.txt

Clone this wiki locally