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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Monday 06 Jul 2009
2:04 pm

emmar

Removed drop statement of two triggers that actually wouldn't exist in previous version.

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.23d1-0.23d2.sql
Thursday 14 May 2009
3:15 pm

daveb

Points has changed to float

Options
    • -2
    • +2
    ./oracle/assessment-collected-data-create.sql
    • -2
    • +2
    ./postgresql/assessment-collected-data-create.sql
Thursday 16 Apr 2009
2:31 pm

emmar

Fix typo

Options
    • -1
    • +1
    ./postgresql/assessment-collected-data-create.sql
Saturday 14 Feb 2009
9:03 pm

donb

Partially fixed assessment for oracle.

Options
    • -1
    • +0
    ./oracle/assessment-collected-data-create.sql
Wednesday 04 Feb 2009
7:47 pm

daveb

Fix typo in create script.

Options
    • -1
    • +2
    ./oracle/assessment-collected-data-create.sql
    • -1
    • +1
    ./postgresql/assessment-collected-data-create.sql
Monday 01 Dec 2008
5:57 pm

daveb

Merge assessment from oacs-5-4

Options
    • -6
    • +4
    ./oracle/upgrade/upgrade-0.17-0.18.sql
    • -6
    • +4
    ./postgresql/upgrade/upgrade-0.17-0.18.sql
  3. … 107 more files in changeset.
Wednesday 05 Nov 2008
8:19 pm

daveb

Fix typos in upgrade script

Options
    • -3
    • +3
    ./postgresql/upgrade/upgrade-0.23d1-0.23d2.sql
8:13 pm

daveb

Add correct upgrade script versions

Options
    • -0
    • +5
    ./oracle/upgrade/upgrade-0.22d5-0.22d6.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-0.22d5-0.22d6.sql
8:12 pm

daveb

Remove old wrong upgrade scipts

Options
    • -81
    • +0
    ./oracle/upgrade/upgrade-0.22d5-0.22d6.sql
    • -57
    • +0
    ./postgresql/upgrade/upgrade-0.22d5-0.22d6.sql
8:08 pm

daveb

Fix upgrade version numbers

Options
    • -0
    • +81
    ./oracle/upgrade/upgrade-0.23d1-0.23d2.sql
    • -0
    • +64
    ./oracle/upgrade/upgrade-0.23d2-0.23d3.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-0.23d1-0.23d2.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-0.23d2-0.23d3.sql
  5. … 1 more file in changeset.
Tuesday 09 Sep 2008
7:28 pm

daveb

Revert ajax dependency. More fix for fractional points

Options
    • -1
    • +1
    ./oracle/assessment-collected-data-create.sql
    • -1
    • +1
    ./oracle/assessment-item-create.sql
    • -1
    • +1
    ./oracle/assessment-section-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-0.22d5-0.22d6.sql
    • -0
    • +9
    ./oracle/upgrade/upgrade-0.22d6-0.22d7.sql
    • -1
    • +1
    ./postgresql/assessment-collected-data-create.sql
    • -1
    • +1
    ./postgresql/assessment-item-create.sql
    • -3
    • +3
    ./postgresql/assessment-section-create.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-0.22d6-0.22d7.sql
  10. … 3 more files in changeset.
Sunday 07 Sep 2008
11:22 pm

daveb

Fix reference in trigger to use CR view to get title.

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.22d5-0.22d6.sql
9:38 pm

daveb

Finish work to support fractional points. All tables switched to

float. Forms switched to validate float.

Options
    • -0
    • +33
    ./oracle/upgrade/upgrade-0.22d6-0.22d7.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-0.22d6-0.22d7.sql
  3. … 3 more files in changeset.
Tuesday 02 Sep 2008
5:34 pm

daveb

Add define function args

Options
    • -0
    • +1
    ./postgresql/assessment-actions-create.sql
3:21 am

daveb

Change points to float to allow partial credit

Options
    • -0
    • +22
    ./oracle/upgrade/upgrade-0.22d6-0.22d7.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-0.22d6-0.22d7.sql
3:08 am

daveb

UpUpgrade denormalizaton to make it possible to generate reports in a scalable manner

Options
    • -1
    • +32
    ./oracle/assessment-collected-data-create.sql
    • -0
    • +80
    ./oracle/upgrade/upgrade-0.22d5-0.22d6.sql
    • -1
    • +30
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-0.22d5-0.22d6.sql
  5. … 1 more file in changeset.
Monday 02 Jun 2008
11:06 am

emmar

Fix oracle syntax

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.17-0.18.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.22d5-0.22d6.sql
Sunday 01 Jun 2008
3:35 pm

emmar

More fixes for bug 3139. The creation script was out of sync in dotlrn 2.3 too so it needs to be upgraded in 2.4. The upgrade is harmless for installation that already have the fix.

Options
    • -6
    • +4
    ./oracle/upgrade/upgrade-0.17-0.18.sql
    • -0
    • +5
    ./oracle/upgrade/upgrade-0.22d5-0.22d6.sql
    • -6
    • +4
    ./postgresql/upgrade/upgrade-0.17-0.18.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-0.22d5-0.22d6.sql
  5. … 1 more file in changeset.
3:35 pm

emmar

file upgrade-0.22d5-0.22d6.sql was initially added on branch oacs-5-4.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.22d5-0.22d6.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.22d5-0.22d6.sql
Tuesday 27 May 2008
6:27 pm

daveb

Fix bug#3139

Options
    • -2
    • +2
    ./postgresql/assessment-section-create.sql
6:15 pm

daveb

Patch#864 from Åsmund Realfsen for bug#3139, create script was out of synch

Options
    • -2
    • +2
    ./postgresql/assessment-section-create.sql
Monday 08 Oct 2007
12:36 am

donb

Merged oacs-5-3 branch to HEAD

Options
    • -0
    • +6
    ./oracle/upgrade/upgrade-0.22d3-0.22d4.sql
    • -3
    • +6
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +7
    ./postgresql/upgrade/upgrade-0.22d3-0.22d4.sql
  4. … 185 more files in changeset.
Saturday 15 Sep 2007
1:58 am

daveb

Fix upgrade to work with correct constraint names

Options
    • -6
    • +6
    ./oracle/upgrade/upgrade-0.22d3-0.22d4.sql
    • -3
    • +6
    ./postgresql/assessment-collected-data-create.sql
  3. … 2 more files in changeset.
Friday 14 Sep 2007
10:38 pm

daveb

Add on delete cascade on as_session_items mapping table.

Options
    • -0
    • +6
    ./oracle/upgrade/upgrade-0.22d3-0.22d4.sql
    • -0
    • +7
    ./postgresql/upgrade/upgrade-0.22d3-0.22d4.sql
Tuesday 15 May 2007
10:14 pm

donb

Merged changes to HEAD ...

Options
    • -8
    • +8
    ./oracle/assessment-actions-package-create.sql
    • -32
    • +65
    ./oracle/assessment-collected-data-create.sql
    • -8
    • +16
    ./oracle/assessment-item-create.sql
    • -9
    • +45
    ./oracle/assessment-item-type-create.sql
    • -9
    • +17
    ./oracle/assessment-section-create.sql
    • -2
    • +6
    ./oracle/assessment-types-create.sql
    • -26
    • +36
    ./oracle/upgrade/upgrade-0.22d2-0.22d3.sql
    • -0
    • +299
    ./oracle/upgrade/upgrade-0.22d3-0.22d4.sql
    • -1
    • +1
    ./postgresql/assessment-actions-create.sql
    • -25
    • +48
    ./postgresql/assessment-collected-data-create.sql
    • -8
    • +16
    ./postgresql/assessment-item-create.sql
    • -10
    • +21
    ./postgresql/assessment-item-type-create.sql
    • -9
    • +17
    ./postgresql/assessment-section-create.sql
    • -2
    • +4
    ./postgresql/assessment-types-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-0.20-0.21.sql
  16. … 1542 more files in changeset.