Index: openacs-4/packages/assessment/assessment.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/assessment.info,v
diff -u -r1.29 -r1.30
--- openacs-4/packages/assessment/assessment.info 14 Feb 2005 17:52:24 -0000 1.29
+++ openacs-4/packages/assessment/assessment.info 15 Feb 2005 15:03:10 -0000 1.30
@@ -7,7 +7,7 @@
f
f
-
+
Eduardo Perez Ureta
Assessment package that will replace the survey,
quizz, complex survey, poll and other data collection packages
@@ -17,7 +17,7 @@
Create assessments and evalueate.
0
-
+
Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.10d7-0.10d8.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.10d7-0.10d8.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.10d7-0.10d8.sql 15 Feb 2005 15:03:10 -0000 1.1
@@ -0,0 +1,24 @@
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_items'
+and attribute_name in ('feedback_right', 'feedback_wrong');
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_sections'
+and attribute_name in ('instructions', 'feedback_text');
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_assessments'
+and attribute_name in ('instructions', 'consent_page');
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_section_display_types'
+and attribute_name = 'adp_chunk';
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_item_data'
+and attribute_name = 'clob_answer';
Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.10d7-0.10d8.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.10d7-0.10d8.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.10d7-0.10d8.sql 15 Feb 2005 15:03:10 -0000 1.1
@@ -0,0 +1,24 @@
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_items'
+and attribute_name in ('feedback_right', 'feedback_wrong');
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_sections'
+and attribute_name in ('instructions', 'feedback_text');
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_assessments'
+and attribute_name in ('instructions', 'consent_page');
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_section_display_types'
+and attribute_name = 'adp_chunk';
+
+update acs_attributes
+set datatype = 'text'
+where object_type = 'as_item_data'
+and attribute_name = 'clob_answer';
Index: openacs-4/packages/assessment/tcl/as-install-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-install-procs.tcl,v
diff -u -r1.23 -r1.24
--- openacs-4/packages/assessment/tcl/as-install-procs.tcl 14 Feb 2005 17:20:34 -0000 1.23
+++ openacs-4/packages/assessment/tcl/as-install-procs.tcl 15 Feb 2005 15:03:10 -0000 1.24
@@ -118,37 +118,37 @@
content::type::attribute::new -content_type {as_items} -attribute_name {required_p} -datatype {boolean} -pretty_name {Item Required} -column_spec {char(1)}
content::type::attribute::new -content_type {as_items} -attribute_name {data_type} -datatype {string} -pretty_name {Item Data Type} -column_spec {varchar(50)}
content::type::attribute::new -content_type {as_items} -attribute_name {max_time_to_complete} -datatype {number} -pretty_name {Item Max Time to Complete} -column_spec {integer}
-content::type::attribute::new -content_type {as_items} -attribute_name {feedback_wrong} -datatype {string} -pretty_name {Item Right Feedback} -column_spec {text}
-content::type::attribute::new -content_type {as_items} -attribute_name {feedback_right} -datatype {string} -pretty_name {Item Wrong Feedback} -column_spec {text}
+content::type::attribute::new -content_type {as_items} -attribute_name {feedback_wrong} -datatype {text} -pretty_name {Item Right Feedback} -column_spec {text}
+content::type::attribute::new -content_type {as_items} -attribute_name {feedback_right} -datatype {text} -pretty_name {Item Wrong Feedback} -column_spec {text}
content::type::attribute::new -content_type {as_items} -attribute_name {points} -datatype {number} -pretty_name {Points awarded for this item} -column_spec {integer}
# Sections
content::type::attribute::new -content_type {as_sections} -attribute_name {display_type_id} -datatype {number} -pretty_name {Section Display Type} -column_spec {integer}
-content::type::attribute::new -content_type {as_sections} -attribute_name {instructions} -datatype {string} -pretty_name {Section Instructions} -column_spec {text}
+content::type::attribute::new -content_type {as_sections} -attribute_name {instructions} -datatype {text} -pretty_name {Section Instructions} -column_spec {text}
content::type::attribute::new -content_type {as_sections} -attribute_name {num_items} -datatype {number} -pretty_name {Number of items displayed in this section} -column_spec {integer}
-content::type::attribute::new -content_type {as_sections} -attribute_name {feedback_text} -datatype {string} -pretty_name {Section Feedback} -column_spec {text}
+content::type::attribute::new -content_type {as_sections} -attribute_name {feedback_text} -datatype {text} -pretty_name {Section Feedback} -column_spec {text}
content::type::attribute::new -content_type {as_sections} -attribute_name {max_time_to_complete} -datatype {number} -pretty_name {Section Max Time to Complete} -column_spec {integer}
content::type::attribute::new -content_type {as_sections} -attribute_name {points} -datatype {number} -pretty_name {Points awarded for this section} -column_spec {integer}
# Section Display Types
content::type::attribute::new -content_type {as_section_display_types} -attribute_name {num_items} -datatype {number} -pretty_name {Number of items displayed per page} -column_spec {integer}
-content::type::attribute::new -content_type {as_section_display_types} -attribute_name {adp_chunk} -datatype {string} -pretty_name {Section Display Template} -column_spec {text}
+content::type::attribute::new -content_type {as_section_display_types} -attribute_name {adp_chunk} -datatype {text} -pretty_name {Section Display Template} -column_spec {text}
content::type::attribute::new -content_type {as_section_display_types} -attribute_name {branched_p} -datatype {boolean} -pretty_name {Section Branched} -column_spec {char(1)}
content::type::attribute::new -content_type {as_section_display_types} -attribute_name {back_button_p} -datatype {boolean} -pretty_name {Back button allowed} -column_spec {char(1)}
content::type::attribute::new -content_type {as_section_display_types} -attribute_name {submit_answer_p} -datatype {boolean} -pretty_name {Seperate submit for each answer} -column_spec {char(1)}
content::type::attribute::new -content_type {as_section_display_types} -attribute_name {sort_order_type} -datatype {string} -pretty_name {Item sort order type} -column_spec {varchar(20)}
# Assessments
content::type::attribute::new -content_type {as_assessments} -attribute_name {creator_id} -datatype {number} -pretty_name {Assessment Creator Identifier} -column_spec {integer}
-content::type::attribute::new -content_type {as_assessments} -attribute_name {instructions} -datatype {string} -pretty_name {Assessment Creator Instructions} -column_spec {text}
+content::type::attribute::new -content_type {as_assessments} -attribute_name {instructions} -datatype {text} -pretty_name {Assessment Creator Instructions} -column_spec {text}
content::type::attribute::new -content_type {as_assessments} -attribute_name {run_mode} -datatype {string} -pretty_name {Assessment Mode} -column_spec {varchar(25)}
content::type::attribute::new -content_type {as_assessments} -attribute_name {anonymous_p} -datatype {boolean} -pretty_name {Assessment Anonymous} -column_spec {char(1)}
content::type::attribute::new -content_type {as_assessments} -attribute_name {secure_access_p} -datatype {boolean} -pretty_name {Assessment Secure Access} -column_spec {char(1)}
content::type::attribute::new -content_type {as_assessments} -attribute_name {reuse_responses_p} -datatype {boolean} -pretty_name {Assessment Reuse Responses} -column_spec {char(1)}
content::type::attribute::new -content_type {as_assessments} -attribute_name {show_item_name_p} -datatype {boolean} -pretty_name {Assessment Show question titles} -column_spec {char(1)}
content::type::attribute::new -content_type {as_assessments} -attribute_name {entry_page} -datatype {string} -pretty_name {Assessment Customizable Entry page} -column_spec {varchar(50)}
content::type::attribute::new -content_type {as_assessments} -attribute_name {exit_page} -datatype {string} -pretty_name {Assessment Customizable Thank/Exit page} -column_spec {varchar(50)}
-content::type::attribute::new -content_type {as_assessments} -attribute_name {consent_page} -datatype {string} -pretty_name {Assessment Consent Pages} -column_spec {text}
+content::type::attribute::new -content_type {as_assessments} -attribute_name {consent_page} -datatype {text} -pretty_name {Assessment Consent Pages} -column_spec {text}
content::type::attribute::new -content_type {as_assessments} -attribute_name {return_url} -datatype {string} -pretty_name {Assessment Return URL} -column_spec {varchar(50)}
content::type::attribute::new -content_type {as_assessments} -attribute_name {start_time} -datatype {number} -pretty_name {Assessment Start Time} -column_spec {timestamptz}
content::type::attribute::new -content_type {as_assessments} -attribute_name {end_time} -datatype {number} -pretty_name {Assessment End Time} -column_spec {timestamptz}
@@ -190,7 +190,7 @@
content::type::attribute::new -content_type {as_item_data} -attribute_name {section_id} -datatype {number} -pretty_name {Section ID} -column_spec {integer}
content::type::attribute::new -content_type {as_item_data} -attribute_name {is_unknown_p} -datatype {boolean} -pretty_name {Is Unknown} -column_spec {char(1)}
content::type::attribute::new -content_type {as_item_data} -attribute_name {boolean_answer} -datatype {boolean} -pretty_name {Boolean Answer} -column_spec {boolean}
-content::type::attribute::new -content_type {as_item_data} -attribute_name {clob_answer} -datatype {string} -pretty_name {Clob Answer} -column_spec {text}
+content::type::attribute::new -content_type {as_item_data} -attribute_name {clob_answer} -datatype {text} -pretty_name {Clob Answer} -column_spec {text}
content::type::attribute::new -content_type {as_item_data} -attribute_name {numeric_answer} -datatype {number} -pretty_name {Numeric Answer} -column_spec {numeric}
content::type::attribute::new -content_type {as_item_data} -attribute_name {integer_answer} -datatype {number} -pretty_name {Integer Answer} -column_spec {integer}
content::type::attribute::new -content_type {as_item_data} -attribute_name {text_answer} -datatype {string} -pretty_name {Text Answer} -column_spec {varchar(500)}