as-section-procs-postgresql.xql

  • last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergencies between oracle and postgres codebase

  1. … 5 more files in changeset.
Allow richtext xinha editor for question text. Rename title to question text in the form so we know what we are editing. Allow any length text in question text now that its stored in blob/text column.

  1. … 5 more files in changeset.
Switch QUESTION text to use cr_revisions.content instead of

cr_revisions.title. Upgrade included, tested on Oracle 10g and PG 8.0.

Added automated test for as::item::new

Fix division with empty string in pretty_time proc and added test.

Beginning of work to allow question text (and other CLOB/BLOB columns)

to include HTML from Xinha rich text editor to allow images etc in the

question text, feedback etc. Mainly this allow an arbitrary number of

images or links to files, instead of just one allowed per question.

  1. … 8 more files in changeset.
Merge oacs-5-2 to HEAD

  1. … 226 more files in changeset.
Added feedback in clobs list to update

  1. … 1 more file in changeset.
Fix for inserting clob when creating items

  1. … 5 more files in changeset.
Update clobs properly on Oracle. content::revision::new can't tell if

the database datatype is a clob.

  1. … 6 more files in changeset.
Added Validation Block field when creating a question. This allows validation of the answer entered by the user. This is especially useful in a registration assessment -- it allows the email entered to be checked if it already exists and prevent the assessment from continuing.

The value of this field must be multiples of a TCL boolean expression and an error message separated by spaces.

  1. … 12 more files in changeset.
added support for likert scale and horizontal mc display

  1. … 14 more files in changeset.
added support to edit result points; added support for assessment password; added message to mark at least one correct choice; bugfix in browsing catalog to next page

  1. … 78 more files in changeset.
check constraints before starting assessment; check time constraints when submitting responses; added ip_mask to as_assessments; added indexes to speed up datamodel

  1. … 33 more files in changeset.
added support for resubmit of answers; removed unnecessary empty revisions when creating a new item

  1. … 19 more files in changeset.
fixes: back button in item-add, dates in assessment add/edit; added calculating result of section and session

  1. … 46 more files in changeset.
added support for images in items and choices

    • -0
    • +47
    ./as-section-procs-postgresql.xql
  1. … 58 more files in changeset.