OpenACS / openacs-4 / packages / categories / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 2,156
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 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -35
    • +0
    ./categories-init.sql
    • -2
    • +2
    ./category-package.sql
    • -0
    • +286
    ./upgrade/upgrade-1.1.5d1-1.1.5d2.sql
    • -0
    • +12
    ./upgrade/upgrade-1.1.5d3-1.1.5d4.sql
  5. … 8096 more files in changeset.
Wednesday 10 Mar 2021
4:18 pm

antoniop

Final phasing out of acs_named_objects

- remove table creation

- update documentation

- provide an optional upgrade script to delete the table and the object type (commented out by default, as people might have defined object subtypes downstream).

Context: this table and the related machinery were created at a time where acs_objects where not as mature as they are now and would not include the "title" information. To retrieve the object name, the only option was the stored procedure acs_object.name, which was not scalable.

From an excerpt of the Changelog file:

.....

2004-03-31 jeffd

......

* packages/categories/tcl/category-trees-procs-oracle.xql:

* packages/categories/tcl/category-trees-procs-postgresql.xql:

acs_named_objects superflous now that title is in

acs_objects. need to fix the rest of the occurances though

......

This tells us that the phasing out has already been decided back in 2004, but delayed. One technical reason, could be that the acs_named_objects table would also materialize the translation, while the title column would store sometimes a message key, that would need to be translated manually. This is helpful when e.g. sorting by name in sql. However, only the faq and categories package would seem to make any use of the table and only the faq package would seem to maintain its values... This would make some UIs in the categories package practically useless since a long time.

Options
    • -35
    • +0
    ./categories-init.sql
    • -0
    • +12
    ./upgrade/upgrade-1.1.5d3-1.1.5d4.sql
  3. … 6 more files in changeset.
4:18 pm

antoniop

file upgrade-1.1.5d3-1.1.5d4.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.1.5d3-1.1.5d4.sql
  2. … 1 more file in changeset.
Wednesday 17 Apr 2019
11:07 am

antoniop

Add missing where clause from previous upgrade... Oracle was indeed affected as well

Options
    • -2
    • +2
    ./category-package.sql
    • -0
    • +286
    ./upgrade/upgrade-1.1.5d1-1.1.5d2.sql
  3. … 3 more files in changeset.
11:07 am

antoniop

file upgrade-1.1.5d1-1.1.5d2.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.1.5d1-1.1.5d2.sql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -3
    • +3
    ./categories-create.sql
    • -3
    • +3
    ./upgrade/upgrade-1.0d3-1.0d4.sql
  3. … 7833 more files in changeset.
Friday 21 Apr 2017
10:25 pm

gustafn

Fix spelling errors

Options
    • -3
    • +3
    ./categories-create.sql
    • -3
    • +3
    ./upgrade/upgrade-1.0d3-1.0d4.sql
  3. … 8 more files in changeset.
Thursday 24 Apr 2008
8:52 pm

daveb

Fix typo, require_category_p duplicated. Should be widget instead.

Options
    • -1
    • +1
    ./category-tree-package.sql
Wednesday 23 Apr 2008
11:44 am

gustafn

Fix missing column "widget" in category_tree_map in Oracle; strangely enough, the upgrade script was available.

Options
    • -0
    • +4
    ./categories-create.sql
  2. … 1 more file in changeset.
Tuesday 22 Apr 2008
6:04 pm

gustafn

Fix missing column "widget" in category_tree_map in Oracle

Options
    • -0
    • +4
    ./categories-create.sql
  2. … 1 more file in changeset.
Wednesday 09 Apr 2008
10:30 am

marioa

Fixed problem with repeat parameter on category_tree.map procedure

Options
    • -1
    • +1
    ./category-tree-package.sql
Sunday 16 Sep 2007
12:35 pm

maltes

Fixing problem with missing widget

Options
    • -4
    • +6
    ./category-tree-package.sql
    • -0
    • +9
    ./upgrade/upgrade-1.1.2d1-1.1.2d2.sql
  3. … 4 more files in changeset.
Wednesday 22 Jun 2005
6:12 pm

andrewg

sequence.nextval doesn't have trailing parentheses on Oracle

Options
    • -1
    • +1
    ./category-link-package.sql
    • -2
    • +2
    ./category-synonym-package.sql
Thursday 24 Feb 2005
2:32 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

Options
    • -2
    • +2
    ./category-synonym-package.sql
  2. … 321 more files in changeset.
Tuesday 08 Feb 2005
5:00 pm

andrewg

Adding another 'or replace'.

Options
    • -1
    • +1
    ./category-synonym-package.sql
4:52 pm

andrewg

create -> create or replace for rolling the failed 1.0d3 -> 1.0d4 upgrade

Options
    • -1
    • +1
    ./category-synonym-package.sql
Sunday 06 Feb 2005
7:42 pm

jeffd

make the category tree acs_object.title the tree name

Options
    • -1
    • +2
    ./category-package.sql
    • -1
    • +2
    ./category-tree-package.sql
    • -0
    • +8
    ./upgrade/upgrade-1.1d2-1.1d3.sql
  4. … 4 more files in changeset.
Monday 06 Dec 2004
1:05 pm

timoh

fixed small bug in usage of sequence

Options
    • -1
    • +1
    ./category-link-package.sql
    • -2
    • +2
    ./category-synonym-package.sql
Thursday 19 Feb 2004
8:11 pm

timoh

bugfix: get triggers to compile

Options
    • -5
    • +9
    ./category-synonym-package.sql
Wednesday 11 Feb 2004
2:25 pm

timoh

added category synonym feature

Options
    • -0
    • +164
    ./categories-create.sql
    • -0
    • +11
    ./categories-drop.sql
    • -0
    • +300
    ./category-synonym-package.sql
    • -0
    • +177
    ./upgrade/upgrade-1.0d3-1.0d4.sql
  5. … 24 more files in changeset.
11:54 am

timoh

removed unused procs

Options
    • -65
    • +0
    ./category-tree-package.sql
  2. … 1 more file in changeset.
Sunday 08 Feb 2004
6:30 pm

timoh

added category-links feature

Options
    • -1
    • +41
    ./categories-create.sql
    • -1
    • +5
    ./categories-drop.sql
    • -0
    • +50
    ./category-link-package.sql
    • -0
    • +39
    ./upgrade/upgrade-1.0d2-1.0d3.sql
  5. … 33 more files in changeset.
6:27 pm

timoh

changed email

Options
    • -1
    • +1
    ./categories-init.sql
    • -1
    • +1
    ./categories-permissions.sql
    • -1
    • +1
    ./category-package.sql
    • -1
    • +1
    ./category-tree-package.sql
  5. … 4 more files in changeset.
Sunday 01 Feb 2004
8:12 pm

timoh

added support for single/multiple categorizations / forcing users to map at least one category

Options
    • -0
    • +9
    ./categories-create.sql
    • -4
    • +10
    ./category-tree-package.sql
    • -0
    • +11
    ./upgrade/upgrade-1.0d1-1.0d2.sql
  4. … 46 more files in changeset.
Sunday 11 Jan 2004
6:37 pm

lars

Added helpful view for getting categories

Options
    • -0
    • +8
    ./categories-create.sql
    • -0
    • +12
    ./upgrade/upgrade-0.1d-1.0d1.sql
  3. … 3 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -1
    • +1
    ./category-package.sql
    • -1
    • +1
    ./category-tree-package.sql
  3. … 274 more files in changeset.
Friday 09 May 2003
8:08 am

timoh

renamed function index_childs to index_children (it's better english i guess)

Options
    • -2
    • +7
    ./categories-init.sql
    • -5
    • +5
    ./category-tree-package.sql
Wednesday 23 Apr 2003
2:29 pm

peterm

Importing the categories package developed by Timo Hentschel

Options
    • -0
    • +0
    ./categories-create.sql
    • -0
    • +0
    ./categories-drop.sql
    • -0
    • +0
    ./categories-init.sql
    • -0
    • +0
    ./categories-permissions.sql
    • -0
    • +0
    ./category-package.sql
    • -0
    • +0
    ./category-tree-package.sql
  7. … 87 more files in changeset.
2:29 pm

peterm

Initial revision

Options
    • -0
    • +189
    ./categories-create.sql
    • -0
    • +57
    ./categories-drop.sql
    • -0
    • +70
    ./categories-init.sql
    • -0
    • +22
    ./categories-permissions.sql
    • -0
    • +351
    ./category-package.sql
    • -0
    • +404
    ./category-tree-package.sql
  7. … 87 more files in changeset.