Index: openacs-4/packages/assessment/assessment.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/assessment.info,v
diff -u -r1.55 -r1.56
--- openacs-4/packages/assessment/assessment.info 29 Mar 2018 23:07:34 -0000 1.55
+++ openacs-4/packages/assessment/assessment.info 5 Jul 2018 10:42:47 -0000 1.56
@@ -7,7 +7,7 @@
f
f
-
+
Eduardo Perez Ureta
Assessment package that will replace the surveys
quizz, complex survey, poll and other data collection packages
@@ -18,7 +18,7 @@
2
#assessment.Assessment#
-
+
Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql 5 Jul 2018 10:42:47 -0000 1.1
@@ -0,0 +1,34 @@
+
+DO $$
+BEGIN
+ update acs_attributes set
+ datatype = 'timestamp'
+ where object_type = 'as_assessments'
+ and attribute_name in ('start_time', 'end_time');
+
+ update acs_attributes set
+ datatype = 'timestamp'
+ where object_type = 'as_item_data'
+ and attribute_name in ('timestamp_answer');
+
+ update acs_attributes set
+ datatype = 'boolean'
+ where object_type = 'as_item_display_sb'
+ and attribute_name in ('multiple_p', 'prepend_empty_p');
+
+ update acs_attributes set
+ datatype = 'timestamp'
+ where object_type = 'as_section_data'
+ and attribute_name in ('creation_datetime', 'completed_datetime');
+
+ update acs_attributes set
+ datatype = 'timestamp'
+ where object_type = 'as_sessions'
+ and attribute_name in (
+ 'target_datetime',
+ 'creation_datetime',
+ 'first_mod_datetime',
+ 'last_mod_datetime',
+ 'completed_datetime'
+ );
+END$$;
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.47 -r1.48
--- openacs-4/packages/assessment/tcl/as-install-procs.tcl 5 Jul 2018 10:16:02 -0000 1.47
+++ openacs-4/packages/assessment/tcl/as-install-procs.tcl 5 Jul 2018 10:42:47 -0000 1.48
@@ -263,7 +263,7 @@
content::type::attribute::new \
-content_type {as_item_display_sb} \
-attribute_name {multiple_p} \
- -datatype {string} \
+ -datatype {boolean} \
-pretty_name {Allow Multiple} \
-column_spec {char(1)}
content::type::attribute::new \
@@ -281,7 +281,7 @@
content::type::attribute::new \
-content_type {as_item_display_sb} \
-attribute_name {prepend_empty_p} \
- -datatype {string} \
+ -datatype {boolean} \
-pretty_name {Prepend Empty Item} \
-column_spec {char(1)}
content::type::attribute::new \
@@ -759,14 +759,14 @@
-column_spec {varchar(50)}
content::type::attribute::new \
-content_type {as_assessments} \
- -attribute_name {start_time} \
- -datatype {number} \
+ -attribute_name {start_time} \
+ -datatype {timestamp} \
-pretty_name {Assessment Start Time} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_assessments} \
- -attribute_name {end_time} \
- -datatype {number} \
+ -attribute_name {end_time} \
+ -datatype {timestamp} \
-pretty_name {Assessment End Time} \
-column_spec {timestamptz}
content::type::attribute::new \
@@ -840,33 +840,33 @@
-column_spec {integer}
content::type::attribute::new \
-content_type {as_sessions} \
- -attribute_name {target_datetime} \
- -datatype {number} \
- -pretty_name {Target Date Time} \
+ -attribute_name {target_datetime} \
+ -datatype {timestamp} \
+ -pretty_name {Target Date Time} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_sessions} \
- -attribute_name {creation_datetime} \
- -datatype {number} \
- -pretty_name {Creation Date Time} \
+ -attribute_name {creation_datetime} \
+ -datatype {timestamp} \
+ -pretty_name {Creation Date Time} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_sessions} \
- -attribute_name {first_mod_datetime} \
- -datatype {number} \
+ -attribute_name {first_mod_datetime} \
+ -datatype {timestamp} \
-pretty_name {First Submission} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_sessions} \
- -attribute_name {last_mod_datetime} \
- -datatype {number} \
- -pretty_name {Most Recent Submission} \
+ -attribute_name {last_mod_datetime} \
+ -datatype {timestamp} \
+ -pretty_name {Most Recent Submission} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_sessions} \
- -attribute_name {completed_datetime} \
- -datatype {number} \
- -pretty_name {Final Submission} \
+ -attribute_name {completed_datetime} \
+ -datatype {timestamp} \
+ -pretty_name {Final Submission} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_sessions} \
@@ -926,14 +926,14 @@
-column_spec {float}
content::type::attribute::new \
-content_type {as_section_data} \
- -attribute_name {creation_datetime} \
- -datatype {number} \
- -pretty_name {Creation Date Time} \
+ -attribute_name {creation_datetime} \
+ -datatype {timestamp} \
+ -pretty_name {Creation Date Time} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_section_data} \
- -attribute_name {completed_datetime} \
- -datatype {number} \
+ -attribute_name {completed_datetime} \
+ -datatype {timestamp} \
-pretty_name {Final Submission} \
-column_spec {timestamptz}
@@ -1006,9 +1006,9 @@
-column_spec {varchar(500)}
content::type::attribute::new \
-content_type {as_item_data} \
- -attribute_name {timestamp_answer} \
- -datatype {number} \
- -pretty_name {TimeStamp Answer} \
+ -attribute_name {timestamp_answer} \
+ -datatype {timestamp} \
+ -pretty_name {TimeStamp Answer} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_item_data} \
@@ -1258,13 +1258,13 @@
content::type::attribute::new \
-content_type {as_section_data} \
-attribute_name {creation_datetime} \
- -datatype {number} \
+ -datatype {timestamp} \
-pretty_name {Creation Date Time} \
-column_spec {timestamptz}
content::type::attribute::new \
-content_type {as_section_data} \
-attribute_name {completed_datetime} \
- -datatype {number} \
+ -datatype {timestamp} \
-pretty_name {Final Submission} \
-column_spec {timestamptz}
content::type::attribute::new \