OpenACS / openacs-4 / packages / assessment

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

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

gustafn

merge from oacs-5-10

Options
    • -1
    • +1
    ./oracle/assessment-actions-package-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.11-0.12.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.12-0.13.sql
    • -0
    • +162
    ./oracle/upgrade/upgrade-2.10.0d4-2.10.0d5.sql
    • -1
    • +1
    ./postgresql/assessment-actions-create.sql
    • -0
    • +121
    ./postgresql/upgrade/upgrade-2.10.0d4-2.10.0d5.sql
  7. … 8094 more files in changeset.
Saturday 12 Feb 2022
9:11 pm

gustafn

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.11-0.12.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.12-0.13.sql
  3. … 7 more files in changeset.
Thursday 21 Nov 2019
7:54 pm

antoniop

Replace occurrences of exists_and_not_null with plain tcl idioms, as the goal is to deprecate this proc shortly

This required an upgrade script as some code is actually stored in the database

Options
    • -1
    • +1
    ./oracle/assessment-actions-package-create.sql
    • -0
    • +162
    ./oracle/upgrade/upgrade-2.10.0d4-2.10.0d5.sql
    • -1
    • +1
    ./postgresql/assessment-actions-create.sql
    • -0
    • +121
    ./postgresql/upgrade/upgrade-2.10.0d4-2.10.0d5.sql
  5. … 3 more files in changeset.
7:54 pm

antoniop

file upgrade-2.10.0d4-2.10.0d5.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.10.0d4-2.10.0d5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.10.0d4-2.10.0d5.sql
Thursday 12 Jul 2018
11:00 am

antoniop

Align case of acs_object_type with that of the actual table (fixes automated tests), remove reference to non-existing stored procedure acs_action__name (fixes automated tests), comment out leftover sql script referenced nowhere

Options
    • -122
    • +125
    ./postgresql/assessment-actions-create-p.sql
    • -1
    • +1
    ./postgresql/assessment-actions-create.sql
    • -2
    • +2
    ./postgresql/assessment-checks-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
  5. … 1 more file in changeset.
Thursday 05 Jul 2018
12:42 pm

antoniop

Fix acs_attribute datatype to match table type (fixes automated tests)

Options
    • -0
    • +34
    ./postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql
  2. … 2 more files in changeset.
Thursday 03 May 2018
10:09 pm

hectorr

Replace deprecated proc 'ad_parameter' with 'parameter::get'

Options
    • -1
    • +1
    ./postgresql/assessment-actions-create-p.sql
Wednesday 28 Mar 2018
7:00 pm

hectorr

Fix typos

Options
    • -6
    • +6
    ./oracle/assessment-item-type-create.sql
    • -1
    • +1
    ./oracle/assessment-section-create.sql
    • -1
    • +1
    ./postgresql/assessment-section-create.sql
  4. … 74 more files in changeset.
Tuesday 27 Mar 2018
7:08 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.03d-0.04d.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.11-0.12.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.22d3-0.22d4.sql
    • -6
    • +6
    ./postgresql/assessment-item-type-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.03d-0.04d.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.11-0.12.sql
  7. … 65 more files in changeset.
Saturday 24 Mar 2018
12:53 am

hectorr

Fix more typos

Options
    • -1
    • +1
    ./oracle/assessment-section-create.sql
    • -1
    • +1
    ./postgresql/assessment-section-create.sql
  3. … 83 more files in changeset.
Thursday 25 Jan 2018
1:16 pm

gustafn

fix typos

Options
    • -1
    • +1
    ./oracle/assessment-item-create.sql
    • -1
    • +1
    ./oracle/assessment-section-create.sql
    • -1
    • +1
    ./postgresql/assessment-item-create.sql
    • -1
    • +1
    ./postgresql/assessment-section-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.04d-0.05d.sql
  6. … 22 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -1
    • +11
    ./postgresql/assessment-actions-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.23d3-0.23d4.sql
    • -0
    • +7
    ./postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
  4. … 7832 more files in changeset.
Friday 12 May 2017
5:52 pm

hectorr

Fixed regression on upgrade script

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.23d3-0.23d4.sql
Thursday 07 Jul 2016
7:18 am

gustafn

- reduce depency on acs_permission_all on PostgreSQL

Options
    • -1
    • +11
    ./postgresql/assessment-actions-create.sql
    • -0
    • +7
    ./postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
  3. … 1 more file in changeset.
7:18 am

gustafn

file upgrade-2.9.0-2.9.1d1.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
Monday 27 Apr 2015
5:28 pm

victorg

Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

Options
    • -0
    • +6
    ./oracle/assessment-collected-data-create.sql
    • -0
    • +2
    ./oracle/assessment-item-create.sql
    • -0
    • +4
    ./oracle/assessment-types-create.sql
    • -0
    • +26
    ./oracle/upgrade/upgrade-2.8.1-2.8.2d1.sql
    • -0
    • +4
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +2
    ./postgresql/assessment-item-create.sql
    • -0
    • +4
    ./postgresql/assessment-types-create.sql
    • -0
    • +25
    ./postgresql/upgrade/upgrade-2.8.1-2.8.2d1.sql
  9. … 513 more files in changeset.
Sunday 22 Feb 2015
10:59 pm

gustafn

- add missing indices

- bump version number to 2.8.2d1

Options
    • -0
    • +6
    ./oracle/assessment-collected-data-create.sql
    • -0
    • +2
    ./oracle/assessment-item-create.sql
    • -0
    • +4
    ./oracle/assessment-types-create.sql
    • -0
    • +26
    ./oracle/upgrade/upgrade-2.8.1-2.8.2d1.sql
    • -0
    • +4
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +2
    ./postgresql/assessment-item-create.sql
    • -0
    • +4
    ./postgresql/assessment-types-create.sql
    • -0
    • +25
    ./postgresql/upgrade/upgrade-2.8.1-2.8.2d1.sql
  9. … 1 more file in changeset.
10:59 pm

gustafn

file upgrade-2.8.1-2.8.2d1.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.8.1-2.8.2d1.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.8.1-2.8.2d1.sql
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -1
    • +1
    ./oracle/assessment-actions-insert.sql
    • -2
    • +2
    ./oracle/assessment-actions-package-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-0.22d3-0.22d4.sql
    • -0
    • +150
    ./oracle/upgrade/upgrade-2.8.1a1-2.8.1a2.sql
    • -32
    • +50
    ./postgresql/assessment-actions-create.sql
    • -1
    • +1
    ./postgresql/assessment-actions-insert.sql
    • -24
    • +42
    ./postgresql/assessment-checks-create.sql
    • -9
    • +25
    ./postgresql/assessment-collected-data-create.sql
    • -6
    • +13
    ./postgresql/assessment-drop.sql
    • -23
    • +41
    ./postgresql/upgrade/upgrade-0.10d3-0.10d4.sql
    • -60
    • +94
    ./postgresql/upgrade/upgrade-0.10d6-0.10d7.sql
    • -6
    • +12
    ./postgresql/upgrade/upgrade-0.22d3-0.22d4.sql
    • -15
    • +39
    ./postgresql/upgrade/upgrade-0.23d1-0.23d2.sql
    • -4
    • +4
    ./postgresql/upgrade/upgrade-0.23d3-0.23d4.sql
    • -0
    • +103
    ./postgresql/upgrade/upgrade-2.8.1a1-2.8.1a2.sql
  16. … 2533 more files in changeset.
Thursday 28 Aug 2014
1:27 pm

victorg

Removing what seems to be a backup file (not sourced from anywhere) and removing unused function from upgrade script.

Options
    • -167
    • +0
    ./postgresql/assessment-actions-create-p.sql
    • -1
    • +1
    ./postgresql/assessment-actions-create.sql
    • -76
    • +1
    ./postgresql/upgrade/upgrade-2.8.1a1-2.8.1a2.sql
Tuesday 26 Aug 2014
1:53 pm

gustafn

- fixing presumably dead code (??) from assessment-actions-create-p.sql

Options
    • -0
    • +150
    ./oracle/upgrade/upgrade-2.8.1a1-2.8.1a2.sql
    • -15
    • +14
    ./postgresql/assessment-actions-create-p.sql
    • -0
    • +178
    ./postgresql/upgrade/upgrade-2.8.1a1-2.8.1a2.sql
1:53 pm

gustafn

file upgrade-2.8.1a1-2.8.1a2.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.8.1a1-2.8.1a2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.8.1a1-2.8.1a2.sql
1:36 pm

gustafn

- fix calls to deprecated function ad_parameter stored in SQL (this should be actually replaced to a single call to a proc performing the logic)

Options
    • -1
    • +1
    ./oracle/assessment-actions-insert.sql
    • -2
    • +2
    ./oracle/assessment-actions-package-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-0.22d3-0.22d4.sql
    • -1
    • +1
    ./postgresql/assessment-actions-create-p.sql
    • -10
    • +13
    ./postgresql/assessment-actions-create.sql
    • -1
    • +1
    ./postgresql/assessment-actions-insert.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.10d6-0.10d7.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.23d3-0.23d4.sql
  9. … 1 more file in changeset.
Tuesday 19 Aug 2014
7:57 pm

gustafn

- fix deprecated api call embedded in sql code

Options
    • -2
    • +2
    ./postgresql/assessment-actions-create.sql
7:50 pm

gustafn

- fix quoting

Options
    • -1
    • +1
    ./postgresql/assessment-actions-create.sql
Monday 18 Aug 2014
10:37 pm

gustafn

- modernize sql (dollar quoting, named arguments, fix and complete function_args)

Options
    • -43
    • +70
    ./postgresql/assessment-actions-create-p.sql
    • -22
    • +37
    ./postgresql/assessment-actions-create.sql
    • -24
    • +42
    ./postgresql/assessment-checks-create.sql
    • -9
    • +25
    ./postgresql/assessment-collected-data-create.sql
    • -6
    • +13
    ./postgresql/assessment-drop.sql
    • -23
    • +41
    ./postgresql/upgrade/upgrade-0.10d3-0.10d4.sql
    • -59
    • +93
    ./postgresql/upgrade/upgrade-0.10d6-0.10d7.sql
    • -6
    • +12
    ./postgresql/upgrade/upgrade-0.22d3-0.22d4.sql
    • -15
    • +39
    ./postgresql/upgrade/upgrade-0.23d1-0.23d2.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.23d3-0.23d4.sql
Monday 02 Dec 2013
9:56 am

gustafn

- replace deprecated ns_sendmail by acs_mail_lite::send;

- assessment stores tcl-code in the db. someone with assessement knowledge should take care about updating this code!

- needs to be tested

Options
    • -1
    • +1
    ./oracle/assessment-actions-insert.sql
    • -2
    • +2
    ./oracle/assessment-actions-package-create.sql
    • -1
    • +1
    ./postgresql/assessment-actions-create-p.sql
    • -2
    • +2
    ./postgresql/assessment-actions-create.sql
    • -2
    • +1
    ./postgresql/assessment-actions-insert.sql
    • -0
    • +101
    ./postgresql/upgrade/upgrade-0.23d3-0.23d4.sql
  7. … 1 more file in changeset.
Thursday 21 Feb 2013
3:39 pm

victorg

Using dollar-quoting ( partly ) in order to make the package installable on pg 9.2.

Options
    • -27
    • +27
    ./postgresql/assessment-actions-create.sql
Sunday 11 Oct 2009
12:38 am

donb

Merged oacs-5-5 branch of .LRN packages to HEAD.

Options
    • -2
    • +2
    ./oracle/assessment-collected-data-create.sql
    • -2
    • +2
    ./postgresql/assessment-collected-data-create.sql
  3. … 86 more files in changeset.
Monday 17 Aug 2009
1:21 am

donb

Changed a query to use cr_revisions directly rather than as_item_choice's

select view, because (ahem) assessment doesn't actually create type metadata

for its types so the view is never created.

Options
    • -2
    • +2
    ./oracle/assessment-collected-data-create.sql
    • -2
    • +2
    ./postgresql/assessment-collected-data-create.sql