Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-288

grouper now requires DB views

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.0
    • Fix Version/s: 1.5.0
    • Component/s: API
    • Labels:
      None

      Description

      Currently we have views in the Grouper registry which are not used by Grouper itself, so if the views weren't there, its wouldn't affect the operation of the registry itself. However, we now have a need to use views in Grouper. Shilen added support for HSQL in the grouper ddl (views already were supported in Oracle, MySQL, and postgres). So going forward we will assume the registry runs in a database that supports views, and we will use views in Grouper when convenient. This will allow us to re-use sql logic, have simpler queries, and will make the registry more transparent to administrators. If administrators are going to use the views for their applications, it is probably a good idea to build a view on top of the grouper views (that do not start with grouper_ ) so that if things change you will know since your view wont compile, it will be easy to fix.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                shilen.patel@at.internet2.edu Shilen Patel (duke.edu)
                Reporter:
                chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: