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 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 24 Jan 2005
10:34 pm

annyf

add files to allow branching and triggers

Options
    • -0
    • +91
    ./postgresql/assessment-actions-create.sql
    • -0
    • +95
    ./postgresql/assessment-checks-create.sql
    • -0
    • +90
    ./postgresql/upgrade/assessment-actions-create.sql
  4. … 4 more files in changeset.
Sunday 23 Jan 2005
7:10 pm

timoh

check constraints before starting assessment; check time constraints when submitting responses; added ip_mask to as_assessments; added indexes to speed up datamodel

Options
    • -1
    • +24
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +2
    ./postgresql/assessment-item-create.sql
    • -2
    • +12
    ./postgresql/assessment-section-create.sql
    • -1
    • +2
    ./postgresql/assessment-types-create.sql
    • -0
    • +37
    ./postgresql/upgrade/upgrade-0.10d2-0.10d3.sql
  6. … 29 more files in changeset.
Wednesday 19 Jan 2005
5:49 pm

timoh

added support for resubmit of answers; removed unnecessary empty revisions when creating a new item

Options
    • -1
    • +16
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +25
    ./postgresql/upgrade/upgrade-0.10d1-0.10d2.sql
  3. … 18 more files in changeset.
Tuesday 18 Jan 2005
3:44 pm

timoh

fixed naming of file

Options
    • -1
    • +0
    ./postgresql/upgrade/upgrade-0.09d-0.10d.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.09d1-0.10d1.sql
1:42 pm

timoh

fixes: back button in item-add, dates in assessment add/edit; added calculating result of section and session

Options
    • -1
    • +2
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.09d-0.10d.sql
  3. … 45 more files in changeset.
Thursday 13 Jan 2005
6:51 pm

eduardop

remove the as_files content type, replaced by content_revision

Options
    • -14
    • +0
    ./oracle/assessment-files.sql
    • -54
    • +0
    ./postgresql/assessment-files.sql
  3. … 2 more files in changeset.
Friday 07 Jan 2005
5:10 pm

timoh

added support for images in items and choices

Options
    • -0
    • +2
    ./postgresql/upgrade/upgrade-0.07d-0.08d.sql
  2. … 58 more files in changeset.
Wednesday 05 Jan 2005
1:39 pm

timoh

added field fixed_position to item choices

Options
    • -0
    • +2
    ./postgresql/assessment-item-create.sql
1:39 pm

timoh

added field num_items to sections

Options
    • -0
    • +2
    ./postgresql/assessment-section-create.sql
Wednesday 22 Dec 2004
9:52 pm

timoh

added tables as_session_sections, as_session_items, as_session_choices and got player to work

Options
    • -0
    • +49
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +47
    ./postgresql/upgrade/upgrade-0.06d-0.07d.sql
  3. … 40 more files in changeset.
Thursday 16 Dec 2004
10:36 am

eduardop

unless specified default to show all the feedback

Options
    • -1
    • +1
    ./oracle/assessment-section-create.sql
    • -1
    • +1
    ./postgresql/assessment-section-create.sql
Tuesday 14 Dec 2004
3:29 pm

eduardop

missing assessment-types-create.sql script to source

Options
    • -0
    • +1
    ./postgresql/assessment-create.sql
Saturday 11 Dec 2004
12:22 pm

timoh

added item-type procs to process the user response and award points; moved the answered choice_ids from as_item_data to seperate mapping table as_item_data_choices

Options
    • -8
    • +16
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +31
    ./postgresql/upgrade/upgrade-0.05d-0.06d.sql
  3. … 8 more files in changeset.
Friday 10 Dec 2004
12:42 pm

timoh

changed datamodel for items, sections, item-section-map, assessment-section-map; added section display types; added support to move/delete multiple choices; added item and section catalog

Options
    • -7
    • +5
    ./postgresql/assessment-item-create.sql
    • -57
    • +33
    ./postgresql/assessment-section-create.sql
    • -0
    • +57
    ./postgresql/upgrade/upgrade-0.04d-0.05d.sql
  4. … 67 more files in changeset.
Wednesday 08 Dec 2004
4:30 pm

timoh

added admin pages to edit items, copy items, copy sections

Options
    • -4
    • +21
    ./oracle/assessment-item-type-create.sql
    • -2
    • +17
    ./oracle/assessment-types-create.sql
    • -0
    • +39
    ./oracle/upgrade/upgrade-0.03d-0.04d.sql
    • -5
    • +22
    ./postgresql/assessment-item-type-create.sql
    • -2
    • +17
    ./postgresql/assessment-types-create.sql
    • -0
    • +39
    ./postgresql/upgrade/upgrade-0.03d-0.04d.sql
  7. … 121 more files in changeset.
Monday 06 Dec 2004
1:26 pm

timoh

changed as_assessments.mode to run_mode because oracle wouldnt allow it

Options
    • -1
    • +1
    ./postgresql/assessment-section-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.02d-0.03d.sql
  3. … 6 more files in changeset.
1:06 pm

timoh

shortened constraint names for oracle; changed column mode to run_mode in as_assessments because this name is not allowed

Options
    • -15
    • +15
    ./oracle/assessment-collected-data-create.sql
    • -36
    • +0
    ./oracle/assessment-files.sql
    • -9
    • +9
    ./oracle/assessment-item-create.sql
    • -21
    • +21
    ./oracle/assessment-item-type-create.sql
    • -24
    • +24
    ./oracle/assessment-section-create.sql
Sunday 05 Dec 2004
6:08 pm

timoh

added new table to map item types to display types

Options
    • -0
    • +2
    ./oracle/assessment-drop.sql
    • -0
    • +40
    ./oracle/assessment-types-create.sql
    • -0
    • +40
    ./oracle/upgrade/upgrade-0.01d-0.02d.sql
    • -0
    • +2
    ./postgresql/assessment-drop.sql
    • -0
    • +40
    ./postgresql/assessment-types-create.sql
    • -0
    • +40
    ./postgresql/upgrade/upgrade-0.01d-0.02d.sql
Friday 26 Nov 2004
9:49 pm

timoh

removed editable_p since this is done via permissioning

Options
    • -4
    • +0
    ./postgresql/assessment-section-create.sql
9:44 pm

timoh

added oracle support

Options
    • -0
    • +114
    ./oracle/assessment-collected-data-create.sql
    • -0
    • +12
    ./oracle/assessment-create.sql
    • -0
    • +15
    ./oracle/assessment-drop.sql
    • -0
    • +50
    ./oracle/assessment-files.sql
    • -0
    • +124
    ./oracle/assessment-item-create.sql
    • -0
    • +146
    ./oracle/assessment-item-type-create.sql
    • -0
    • +197
    ./oracle/assessment-section-create.sql
  8. … 17 more files in changeset.
Monday 22 Nov 2004
12:40 pm

eduardop

survey & assessment differentiation

Options
    • -1
    • +5
    ./postgresql/assessment-section-create.sql
  2. … 5 more files in changeset.
Wednesday 17 Nov 2004
6:16 pm

eduardop

comments from Natalia Perez <nperper@it.uc3m.es>

Options
    • -3
    • +12
    ./postgresql/assessment-collected-data-create.sql
    • -0
    • +1
    ./postgresql/assessment-files.sql
    • -2
    • +17
    ./postgresql/assessment-item-create.sql
    • -0
    • +37
    ./postgresql/assessment-item-type-create.sql
    • -7
    • +50
    ./postgresql/assessment-section-create.sql
  6. … 9 more files in changeset.
Monday 25 Oct 2004
6:05 pm

eduardop

Hack to add file adding and viewing, since OpenACS still lacks a common way to manage files without using file-storage

Options
    • -0
    • +1
    ./postgresql/assessment-create.sql
    • -0
    • +53
    ./postgresql/assessment-files.sql
  3. … 5 more files in changeset.
Thursday 30 Sep 2004
3:44 pm

eduardop

more SQL datamodel schema and CR registry

Options
    • -0
    • +25
    ./postgresql/assessment-item-create.sql
    • -0
    • +26
    ./postgresql/assessment-item-type-create.sql
  3. … 1 more file in changeset.
11:33 am

eduardop

two more display tables

Options
    • -0
    • +22
    ./postgresql/assessment-item-type-create.sql
Tuesday 28 Sep 2004
4:42 pm

eduardop

add feedback_right & feedback_wrong. new way to show a session

Options
    • -1
    • +2
    ./postgresql/assessment-item-create.sql
  2. … 6 more files in changeset.
Thursday 23 Sep 2004
8:46 pm

eduardop

parse QTI feedback and add the necesary changes to the datamodel

Options
    • -1
    • +3
    ./postgresql/assessment-item-create.sql
  2. … 3 more files in changeset.
Monday 13 Sep 2004
5:22 pm

eduardop

definition can be null

Options
    • -3
    • +1
    ./postgresql/assessment-section-create.sql
Saturday 28 Aug 2004
5:35 pm

eduardop

import QTI using the new datamodel

Options
    • -3
    • +0
    ./postgresql/assessment-section-create.sql
  2. … 8 more files in changeset.
Wednesday 11 Aug 2004
1:50 pm

eduardop

missing cr_revisions reference in as_assessments

Options
    • -1
    • +3
    ./postgresql/assessment-section-create.sql