OpenACS / openacs-4 / packages / acs-kernel

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 44
Last Commit: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 85,961
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 23 Feb 2003
6:58 am

danw

Eliminated acs_privilege_hierarchy_index in favor of using acs_privilege_descendant_map. In addition, rewrote trigger for creating acs_privilege_descendant_map as permissions creation was getting too slow on .LRN. .LRN has somewhere in the neighborhood of 90 entries in the privilege hierarchy, which is much higher than anticipated.

Options
    • -151
    • +134
    ./postgresql/acs-permissions-create.sql
Wednesday 19 Feb 2003
10:54 pm

donb

My upgrade invalidated the acs_group package.

Options
    • -0
    • +182
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
9:26 am

jeffd

merge bug 180 fix to 4.6 branch

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2-4.2.1.sql
Tuesday 18 Feb 2003
9:53 pm

donb

Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

Options
    • -27
    • +60
    ./oracle/acs-create.sql
    • -1
    • +17
    ./oracle/acs-install.sql
    • -18
    • +37
    ./oracle/acs-objects-create.sql
    • -19
    • +60
    ./oracle/groups-body-create.sql
    • -37
    • +208
    ./oracle/rel-segments-create.sql
    • -45
    • +0
    ./postgresql/acs-create.sql
    • -4
    • +25
    ./postgresql/acs-install.sql
    • -24
    • +26
    ./postgresql/acs-objects-create.sql
    • -64
    • +111
    ./postgresql/groups-body-create.sql
    • -161
    • +201
    ./postgresql/rel-segments-create.sql
  11. … 8 more files in changeset.
9:54 am

peterm

the upgrade scripts for message_catalog file type must check if the file type is already there since the upgrade script came so late

Options
    • -1
    • +14
    ./oracle/upgrade/upgrade-4.7d-4.7.2d.sql
    • -1
    • +18
    ./postgresql/upgrade/upgrade-4.7d-4.7.2d.sql
2:43 am

donb

1. Got rid of the "create or replace function" decls used for triggers, due

to the brand-new PG 7.3 "opaque" vs. "trigger" issue.

2. Added a new "fs::get_folder_object_ids" for use when you just need the

object ids rather than a bunch of (slow) permissions information,

(slow) counts of items in folders and subfolders, last modified info,

etc. dotLRN was calling "fs::get_folder_contents" when cloning folders

despite making use of only the object_id and that proc used to be unimaginably

slow. It's faster now due to the new permissions code but it's still slow

enough to warrant avoiding it when possible.

3. Fixed typo in my last commit.

Options
    • -2
    • +18
    ./postgresql/groups-body-create.sql
  2. … 4 more files in changeset.
12:55 am

peterm

trying to fix issue with APM upgrade UI breaking on new APM filetype message_catalog described here: http://openacs.org/forums/message-view?message_id=80178 Issuing warning in log file instead of erroring out on un-recognized filetypes. Adding upgrade script to acs-kernel that adds the message_catalog filetype

Options
    • -0
    • +1
    ./oracle/upgrade/upgrade-4.7d-4.7.2d.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-4.7d-4.7.2d.sql
  3. … 2 more files in changeset.
Monday 17 Feb 2003
4:32 pm

jeffd

rollback Dons commit which should have gone in on 4.6 rather than HEAD

Options
    • -76
    • +89
    ./postgresql/acs-create.sql
    • -24
    • +2
    ./postgresql/acs-install.sql
    • -24
    • +16
    ./postgresql/acs-objects-create.sql
    • -27
    • +185
    ./postgresql/acs-permissions-create.sql
    • -206
    • +46
    ./postgresql/groups-body-create.sql
    • -1
    • +1
    ./postgresql/groups-create.sql
    • -93
    • +160
    ./postgresql/rel-segments-create.sql
    • -1
    • +2
    ./postgresql/rel-segments-drop.sql
Sunday 16 Feb 2003
3:15 am

donb

Minor bug fix tweaks to the Oracle version, and some rewriting on the

PostgreSQL side to better match the structure of the Oracle side.

Options
    • -2
    • +3
    ./oracle/groups-body-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -37
    • +19
    ./postgresql/groups-body-create.sql
    • -18
    • +35
    ./postgresql/rel-segments-create.sql
    • -90
    • +162
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
1:01 am

peterm

Adding parameter PermissionCacheTimeout that determines the lifetime of the permissions cache. Adding comment to PermissionCacheP parameter saying server must be restarted after change. Removing instantiation of acs-kernel in acs-install.sql (not needed as its done in apm_install_package).

Options
    • -13
    • +0
    ./postgresql/acs-install.sql
  2. … 1 more file in changeset.
Saturday 15 Feb 2003
11:30 pm

jeffd

change the delete from acs_permissions to be a dynamic sql delete since the table is not defined at the time the package body is created. Its a hack but further cleanup will have to wait for 4.7

Options
    • -2
    • +9
    ./oracle/acs-objects-create.sql
    • -1
    • +8
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
9:56 pm

donb

Fixed various problems with the new permissions and minor main site changes

Options
    • -0
    • +19
    ./oracle/acs-create.sql
    • -3
    • +4
    ./oracle/acs-install.sql
    • -2
    • +2
    ./oracle/acs-objects-create.sql
    • -49
    • +35
    ./oracle/groups-body-create.sql
    • -2
    • +2
    ./oracle/rel-segments-create.sql
    • -31
    • +79
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
9:42 pm

jeffd

remove conflict markers from Dons commit. fixes bug 243

Options
    • -3
    • +0
    ./postgresql/acs-install.sql
2:10 pm

jeffd

finish my sentence about why the pkg body being replaced. Thanks Don.

Options
    • -1
    • +2
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
4:23 am

donb

First cut at Oracle perm rewrite and some whacking around on the PG version

Options
    • -41
    • +55
    ./oracle/acs-create.sql
    • -1
    • +16
    ./oracle/acs-install.sql
    • -18
    • +37
    ./oracle/acs-objects-create.sql
    • -139
    • +28
    ./oracle/acs-permissions-create.sql
    • -1
    • +55
    ./oracle/groups-body-create.sql
    • -37
    • +208
    ./oracle/rel-segments-create.sql
    • -0
    • +595
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -39
    • +0
    ./postgresql/community-core-create.sql
    • -140
    • +29
    ./postgresql/groups-body-create.sql
    • -19
    • +109
    ./postgresql/rel-segments-create.sql
    • -153
    • +47
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
Friday 14 Feb 2003
3:47 am

donb

More mucking around with the denormalized party_approved_member_map ...

Options
    • -89
    • +76
    ./postgresql/acs-create.sql
    • -2
    • +40
    ./postgresql/acs-install.sql
    • -16
    • +24
    ./postgresql/acs-objects-create.sql
    • -185
    • +27
    ./postgresql/acs-permissions-create.sql
    • -46
    • +206
    ./postgresql/groups-body-create.sql
    • -1
    • +1
    ./postgresql/groups-create.sql
    • -160
    • +93
    ./postgresql/rel-segments-create.sql
    • -2
    • +1
    ./postgresql/rel-segments-drop.sql
Thursday 13 Feb 2003
11:30 pm

jeffd

delete direct permissions in acs_object__delete (oracle and postgres) upgrade provided, bug 234 patch 74 Tilmann Singer

Options
    • -1
    • +4
    ./oracle/acs-objects-create.sql
    • -2
    • +623
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -0
    • +3
    ./postgresql/acs-objects-create.sql
    • -2
    • +59
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
Tuesday 11 Feb 2003
6:03 pm

donb

1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

Options
    • -89
    • +76
    ./postgresql/acs-create.sql
    • -34
    • +28
    ./postgresql/acs-install.sql
    • -20
    • +26
    ./postgresql/acs-objects-create.sql
    • -186
    • +54
    ./postgresql/acs-permissions-create.sql
    • -46
    • +206
    ./postgresql/groups-body-create.sql
    • -1
    • +1
    ./postgresql/groups-create.sql
    • -160
    • +93
    ./postgresql/rel-segments-create.sql
    • -1
    • +742
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
  9. … 16 more files in changeset.
Friday 31 Jan 2003
5:17 pm

peterm

acs-install.sql doesn't need to instantiate acs-kernel as this is done during install of that package (since it's a singleton)

Options
    • -17
    • +3
    ./oracle/acs-install.sql
    • -24
    • +2
    ./postgresql/acs-install.sql
3:01 pm

peterm

Adding missing piece to the db upgrade of acs-kernel 4.6.1-4.7d - the callbacks were not being copied when upgrading a package through the edit package page. Changing to create or replace syntax for functions in PG (works in 7.2 and 7.1 is deprecated)

Options
    • -1
    • +6
    ./oracle/apm-create.sql
    • -0
    • +5
    ./oracle/upgrade/upgrade-4.6.1-4.7d.sql
    • -0
    • +5
    ./postgresql/apm-create.sql
    • -6
    • +8
    ./postgresql/upgrade/upgrade-4.6.1-4.7d.sql
Thursday 30 Jan 2003
5:28 pm

danw

Modified permissions code to materialize acs_privilege_descendant_map view. Needed to speed up queries on acs_object_grantee_priv_map view.

Options
    • -1
    • +27
    ./postgresql/acs-permissions-create.sql
3:08 pm

peterm

moving instantiation and mounting of all core packages (acs-lang, acs-admin, api-doc etc.) except acs-kernel and main site (retained because they are needed during install) from the acs-install.sql file to the Tcl proc apm_mount_core_packages that is invoked on first startup. Note that this unfortunately means that callbacks will not be invoked for the main site node and for the acs-kernel instance.

Options
    • -94
    • +1
    ./oracle/acs-install.sql
    • -188
    • +0
    ./postgresql/acs-install.sql
  3. … 4 more files in changeset.
Wednesday 29 Jan 2003
10:43 am

peterm

as part of the sql upgrade of acs-kernel from 4.6.1 to 4.7d I forgot to change views and plsql code. Adding these changes now to make the upgrade complete

Options
    • -6
    • +11
    ./oracle/apm-create.sql
    • -1
    • +638
    ./oracle/upgrade/upgrade-4.6.1-4.7d.sql
    • -11
    • +14
    ./postgresql/apm-create.sql
    • -1
    • +173
    ./postgresql/upgrade/upgrade-4.6.1-4.7d.sql
Monday 27 Jan 2003
11:36 am

peterm

upgrading acs-kernel from 4.6.1 to 4.7d to support APM auto mounting of packages, and Tcl procedure package callbacks such as after-install, after-instantiate, and after-mount. Upgrade scripts supplied to add table apm_package_callbacks and add column auto_mount to table apm_package_versions.

Options
    • -1
    • +8
    ./oracle/apm-create.sql
    • -0
    • +34
    ./oracle/upgrade/upgrade-4.6.1-4.7d.sql
    • -0
    • +7
    ./postgresql/apm-create.sql
    • -0
    • +34
    ./postgresql/upgrade/upgrade-4.6.1-4.7d.sql
  5. … 1 more file in changeset.
Friday 24 Jan 2003
11:16 pm

jeffd

An upgrade script from almost 2 years ago is patched. yay. closes bug 180

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.2-4.2.1.sql
Thursday 23 Jan 2003
6:46 pm

peterm

adding a table to the APM for holding Tcl proc callbacks invoked after installation, instantiation etc. of packages

Options
    • -1
    • +26
    ./oracle/apm-create.sql
    • -10
    • +35
    ./postgresql/apm-create.sql
Wednesday 22 Jan 2003
3:26 am

rmello

- Fixed double declaration of function acs_attribute__create_attribute, with

same arguments. Thanks for Stan Kaufman on #openacs for reporting this.

Options
    • -5
    • +0
    ./postgresql/acs-metadata-create.sql
Tuesday 21 Jan 2003
6:34 pm

lars

Merged in changes to make acs-workflow not part of initial install from HEAD to 4.6 branch

Options
    • -16
    • +1
    ./oracle/acs-install.sql
    • -25
    • +0
    ./postgresql/acs-install.sql
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -1
    • +1
    ./postgresql/acs-create.sql
    • -0
    • +12
    ./postgresql/acs-metadata-create.sql
    • -5
    • +3
    ./postgresql/acs-objects-create.sql
    • -6
    • +6
    ./postgresql/apm-create.sql
    • -3
    • +3
    ./postgresql/community-core-create.sql
    • -1
    • +1
    ./postgresql/groups-body-create.sql
    • -1
    • +1
    ./postgresql/journal-create.sql
    • -1
    • +77
    ./postgresql/postgresql.sql
    • -1
    • +1
    ./postgresql/rel-segments-body-create.sql
    • -0
    • +38
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  11. … 45 more files in changeset.
Thursday 16 Jan 2003
2:27 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -0
    • +2
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -1
    • +1
    ./postgresql/acs-create.sql
    • -0
    • +25
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
  4. … 31 more files in changeset.