Index: lams_tool_laqa/.classpath =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/.classpath,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/.classpath 21 Jun 2005 05:43:44 -0000 1.1 +++ lams_tool_laqa/.classpath 24 Jun 2005 08:57:12 -0000 1.2 @@ -4,6 +4,7 @@ - + + Index: lams_tool_laqa/build.properties =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/build.properties,v diff -u -r1.4 -r1.5 --- lams_tool_laqa/build.properties 21 Jun 2005 22:50:23 -0000 1.4 +++ lams_tool_laqa/build.properties 24 Jun 2005 08:57:12 -0000 1.5 @@ -2,7 +2,7 @@ #name of this project name=lams_tool_questionAnswer -product=lams-tool-laqa11 +product=lams-tool-questionAnswer # Directory where third party jars reside. sharedlib=../lams_build/lib @@ -20,7 +20,9 @@ #web application properties sessiontimeout=120 -signature=laqa11 +#signature=laqa11 +signature=questionAnswer + # the URL used to access LAMS toolContext=/lams/tool/laqa11 Index: lams_tool_laqa/build.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/build.xml,v diff -u -r1.4 -r1.5 --- lams_tool_laqa/build.xml 21 Jun 2005 22:50:37 -0000 1.4 +++ lams_tool_laqa/build.xml 24 Jun 2005 08:57:12 -0000 1.5 @@ -292,6 +292,22 @@ + + + + + + + + + + + + + + Index: lams_tool_laqa/JUnit/junit-3.7/lib/junit-3.7.jar =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/JUnit/junit-3.7/lib/Attic/junit-3.7.jar,v diff -u Binary files differ Index: lams_tool_laqa/conf/hibernate/mappings/Activity.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Activity.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Activity.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,262 @@ + + + + + + + + @hibernate.class table="lams_learning_activity" + true + + + @hibernate.id generator-class="identity" type="java.lang.Long" column="activity_id" + + + + + + + + @hibernate.property column="activity_ui_id" length="11" + + + + @hibernate.property column="description" length="65535" + + + + @hibernate.property column="title" length="255" + + + + @hibernate.property column="help_text" length="65535" + + + + @hibernate.property column="xcoord" length="11" + + + + @hibernate.property column="ycoord" length="11" + + + + @hibernate.property column="order_id" length="11" + + + + @hibernate.property column="define_later_flag" length="4" not-null="true" + + + + @hibernate.property column="create_date_time" length="19" not-null="true" + + + + @hibernate.property column="offline_instructions" length="65535" + + + + @hibernate.property column="online_instructions" length="65535" + + + + + @hibernate.property column="run_offline_flag" length="4" not-null="true" + + + + @hibernate.property column="parent_ui_id" length="11" + + + @hibernate.property column="grouping_ui_id" length="11" + + + + @hibernate.property column="learning_activity_type_id" length="11" + + + + @hibernate.property column="activity_category_id" length="11" + + + + @hibernate.property column="library_activity_ui_image" length="255" + + + + + + + + + + + + + @hibernate.column name="learning_library_id" + + + + + + + + @hibernate.column name="parent_activity_id" + + + + + + + @hibernate.column name="libraryActivity" + + + + + + + @hibernate.column name="learning_design_id" + + + + + + + @hibernate.column name="grouping_id" + + + + + + + @hibernate.class + public abstract + + + @hibernate.class + + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="tool_session_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.tool.ToolSession" + + + + + + + + + + + + + @hibernate.class + + + @hibernate.property column="create_grouping_ui_id" length="11" + + + + + + + + + + @hibernate.class + + + + + + + + + @hibernate.class + + + @hibernate.property column="gate_start_time_offset" length="20" + true + + + + @hibernate.property column="gate_end_time_offset" length="20" + true + + + + @hibernate.property column="gate_start_date_time" length="19" + true + + + + @hibernate.property column="gate_end_date_time" length="19" + true + + + + + @hibernate.class + + + @hibernate.class + + + + + + @hibernate.class + public abstract + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="parent_activity_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + @hibernate.class + + + @hibernate.property column="max_number_of_options" length="5" + true + + + + @hibernate.property column="min_number_of_options" length="5" + true + + + + @hibernate.property column="options_instructions" length="65535" + + + + + @hibernate.class + + + @hibernate.class + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/AuthenticationMethod.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/AuthenticationMethod.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/AuthenticationMethod.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,101 @@ + + + + + + + + + @hibernate.class + table="lams_authentication_method" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="authentication_method_id" + + + + true + + + + + + @hibernate.property + column="authentication_method_name" + unique="true" + length="64" + not-null="true" + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="authentication_method_type_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="authentication_method_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/AuthenticationMethodType.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/AuthenticationMethodType.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/AuthenticationMethodType.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,86 @@ + + + + + + + + + @hibernate.class + table="lams_authentication_method_type" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="authentication_method_type_id" + + + + true + + + + + + @hibernate.property + column="description" + length="64" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="authentication_method_type_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.AuthenticationMethod" + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Group.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Group.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Group.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,117 @@ + + + + + + + + + @hibernate.class + table="lams_group" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="group_id" + + + + + + + + + @hibernate.property + column="order_id" + length="6" + not-null="true" + + + + + + + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="group_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.tool.ToolSession" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="grouping_id" + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Grouping.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Grouping.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Grouping.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,93 @@ + + + + + + + + + + + + + + + @hibernate.property column="grouping_ui_id" length="11" + + + + + + + + + + + @hibernate.set lazy="true" inverse="true" cascade="none" + @hibernate.collection-key column="grouping_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.Group" + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/LearnerProgress.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/LearnerProgress.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/LearnerProgress.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,83 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/LearningDesign.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/LearningDesign.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/LearningDesign.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,217 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + @hibernate.property + column="valid_design_flag" + length="4" + not-null="true" + + + + + + + + + + + + + + + + + + + + @hibernate.property + column="version" + length="56" + + + + + @hibernate.property column ="duration" + + + @hibernate.property column ="license_text" + + + + @hibernate.property column ="lesson_org_id" + + + @hibernate.property column ="lesson_org_name" + + + @hibernate.property column ="lesson_id" + + + @hibernate.property column ="lesson_name" + + + @hibernate.property column ="lesson_start_date_time" + + + @hibernate.property column ="last_modified_date_time" + + + + + + + @hibernate.column name="license_id" + + + + + + + @hibernate.column name="first_activity_id" + + + + + + + + @hibernate.column name="parent_learning_design_id" + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/LearningLibrary.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/LearningLibrary.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/LearningLibrary.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,80 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Lesson.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Lesson.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Lesson.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,106 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + SELECT DISTINCT {lesson.*} + FROM lams_lesson {lesson}, + lams_grouping, + lams_group, + lams_user_group + WHERE ({lesson}.class_grouping_id = lams_grouping.grouping_id) + AND (lams_grouping.grouping_id = lams_group.grouping_id) + AND (lams_group.group_id = lams_user_group.group_id) + AND ({lesson}.lesson_state_id IN (3,4,5)) + AND (lams_user_group.user_id = :userId) + + + + + SELECT DISTINCT {learner.*} + FROM lams_user {learner}, + lams_learner_progress + WHERE ({learner}.user_id = lams_learner_progress.user_id) + AND (lams_learner_progress.lesson_id = :lessonId) + + Index: lams_tool_laqa/conf/hibernate/mappings/License.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/License.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/License.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,21 @@ + + + + + + + + true + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Organisation.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Organisation.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Organisation.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,226 @@ + + + + + + + + + @hibernate.class + table="lams_organisation" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="organisation_id" + + + + true + + + + + + @hibernate.property + column="name" + length="250" + + + + + @hibernate.property + column="description" + length="250" + + + + + @hibernate.property + column="create_date" + length="19" + not-null="true" + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="workspace_id" + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="organisation_type_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisation" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="parent_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="parent_organisation_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="base_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.Lesson" + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/OrganisationType.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/OrganisationType.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/OrganisationType.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,103 @@ + + + + + + + + + @hibernate.class + table="lams_organisation_type" + proxy="org.lamsfoundation.lams.usermanagement.OrganisationType" + + true + + + + @hibernate.id + generator-class="increment" + type="java.lang.Integer" + column="organisation_type_id" + + + + true + + + + + + @hibernate.property + column="name" + unique="true" + length="64" + not-null="true" + + + + + @hibernate.property + column="description" + length="255" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="organisation_type_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Role.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Role.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Role.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,98 @@ + + + + + + + + + @hibernate.class + table="lams_role" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="role_id" + + + + + + + + true + + @hibernate.property + column="name" + length="64" + not-null="true" + + + + + @hibernate.property + column="description" + length="65535" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="delete-orphan" + + @hibernate.collection-key + column="role_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisationRole" + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Tool.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Tool.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Tool.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,334 @@ + + + + + + + + + @hibernate.class + table="lams_tool" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="tool_id" + + + + + + + + + @hibernate.property + column="learner_url" + length="65535" + not-null="true" + + + + + @hibernate.property + column="grouping_support_type_id" + length="3" + not-null="true" + + + + + @hibernate.property + column="author_url" + length="65535" + + + + + @hibernate.property + column="supports_define_later_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_moderation_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_run_offline_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_contribute_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="valid_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="define_later_url" + length="65535" + + + + + @hibernate.property + column="default_tool_content_id" + length="20" + not-null="false" + + + + + @hibernate.property + column="tool_signature" + length="64" + not-null="true" + + + + + @hibernate.property + column="tool_display_name" + length="255" + not-null="true" + + + + + @hibernate.property + column="description" + length="65535" + + + + + + @hibernate.property column="create_date_time" + length="19" not-null="true" + + + + + + @hibernate.property + column="class_name" + length="65535" + not-null="true" + + + + + @hibernate.property + column="export_portfolio_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="monitor_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="moderation_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="contribute_url" + length="65535" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="tool_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/ToolContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/ToolContent.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/ToolContent.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,76 @@ + + + + + + + + + @hibernate.class + table="lams_tool_content" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="tool_content_id" + + + + + + + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="tool_content_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/ToolSession.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/ToolSession.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/ToolSession.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,75 @@ + + + + + + + + + @hibernate.class table="lams_tool_session" + + true + + + + @hibernate.id generator-class="identity" + type="java.lang.Long" column="tool_session_id" + + + + + + + + + + + + + + + + + + + @hibernate.property column="create_date_time" + length="19" not-null="true" + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Transition.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Transition.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Transition.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,122 @@ + + + + + + + + + @hibernate.class + table="lams_learning_transition" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="transition_id" + + + + + + + + @hibernate.property column="transition_ui_id" length="11" + + + @hibernate.property column="to_ui_id" length="11" + + + @hibernate.property column="from_ui_id" length="11" + + + + + @hibernate.property + column="description" + length="65535" + + + + + @hibernate.property + column="title" + length="255" + + + + + @hibernate.property + column="create_date_time" + length="19" + not-null="true" + + + + + + + + @hibernate.many-to-one unique="true" + @hibernate.column name="to_activity_id" + + + + + + + @hibernate.many-to-one unique="true" + @hibernate.column name="from_activity_id" + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="learning_design_id" + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/User.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/User.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/User.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,399 @@ + + + + + + + + + @hibernate.class + table="lams_user" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_id" + + + + + + + + true + + @hibernate.property + column="login" + unique="true" + length="20" + not-null="true" + + + + + @hibernate.property + column="password" + length="50" + not-null="true" + + + + + @hibernate.property + column="title" + length="32" + + + + + @hibernate.property + column="first_name" + length="64" + + + + + @hibernate.property + column="last_name" + length="128" + + + + + @hibernate.property + column="address_line_1" + length="64" + + + + + @hibernate.property + column="address_line_2" + length="64" + + + + + @hibernate.property + column="address_line_3" + length="64" + + + + + @hibernate.property + column="city" + length="64" + + + + + @hibernate.property + column="state" + length="64" + + + + + @hibernate.property + column="country" + length="64" + + + + + @hibernate.property + column="day_phone" + length="64" + + + + + @hibernate.property + column="evening_phone" + length="64" + + + + + @hibernate.property + column="mobile_phone" + length="64" + + + + + @hibernate.property + column="fax" + length="64" + + + + + @hibernate.property + column="email" + length="128" + + + + + @hibernate.property + column="disabled_flag" + length="1" + not-null="true" + + + + + @hibernate.property + column="create_date" + length="19" + not-null="true" + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="workspace_id" + + + + + + + @hibernate.set + lazy="false" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisation" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="authentication_method_id" + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="base_organisation_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.LearnerProgress" + + + + + + + + + + + @hibernate.set lazy="true" inverse="true" cascade="none" + @hibernate.collection-key column="user_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.LearningDesign" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.Lesson" + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/UserOrganisation.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/UserOrganisation.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/UserOrganisation.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,99 @@ + + + + + + + + + @hibernate.class + table="lams_user_organisation" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_organisation_id" + + + + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="user_id" + + + + + + + @hibernate.set + lazy="false" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="user_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisationRole" + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="organisation_id" + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/UserOrganisationRole.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/UserOrganisationRole.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/UserOrganisationRole.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,73 @@ + + + + + + + + + @hibernate.class + table="lams_user_organisation_role" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_organisation_role_id" + + + + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="user_organisation_id" + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="role_id" + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/Workspace.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/Workspace.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/Workspace.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,115 @@ + + + + + + + + + @hibernate.class + table="lams_workspace" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="workspace_id" + + + + true + + + + + @hibernate.property column="name" length="65535" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="workspace_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="workspace_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="root_folder_id" + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/WorkspaceFolder.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/WorkspaceFolder.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/WorkspaceFolder.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,166 @@ + + + + + + + + + @hibernate.class + table="lams_workspace_folder" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="workspace_folder_id" + + + + + + + + + @hibernate.property + column="name" + length="64" + not-null="true" + + + + + @hibernate.property column="user_id" length="11" + + + @hibernate.property column="lams_workspace_folder_type_id" length="11" + + + @hibernate.property column="create_date_time" length="19" not-null="true" + + + @hibernate.property column="last_modified_date_time" length="19" not-null="true" + + + + + @hibernate.property + column="workspace_id" + length="11" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="root_folder_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Workspace" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="parent_folder_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.WorkspaceFolder" + + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="parent_folder_id" + + + + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="user_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.LearningDesign" + + + + + + + + + + + + + Index: lams_tool_laqa/conf/hibernate/mappings/WorkspaceFolderContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/Attic/WorkspaceFolderContent.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/conf/hibernate/mappings/WorkspaceFolderContent.hbm.xml 24 Jun 2005 08:49:22 -0000 1.1 @@ -0,0 +1,59 @@ + + + + + + true + + + + + + + + + + + + + + + + + + + + \ No newline at end of file Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/create_lams_tool_qa.sql,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 21 Jun 2005 05:42:52 -0000 1.1 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 24 Jun 2005 08:50:23 -0000 1.2 @@ -1,3 +1,10 @@ +DROP TABLE IF EXISTS lams.tl_laqa11_usr_resp; +DROP TABLE IF EXISTS lams.tl_laqa11_que_usr; +DROP TABLE IF EXISTS lams.tl_laqa11_que_content; +DROP TABLE IF EXISTS lams.tl_laqa11_session; +DROP TABLE IF EXISTS lams.tl_laqa11_content; + + CREATE TABLE lams.tl_laqa11_content ( qa_content_id BIGINT(20) NOT NULL , title VARCHAR(100) DEFAULT 'Questions and Answers' @@ -70,3 +77,17 @@ REFERENCES lams.tl_laqa11_que_usr (que_usr_id) )TYPE=InnoDB; + + +-- test data for content table +INSERT INTO tl_laqa11_content (qa_content_id, + creation_date + ) +VALUES (${default_content_id}, + NOW()); + + + + + + Index: lams_tool_laqa/db/sql/insert_tool_qa_data.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/Attic/insert_tool_qa_data.sql,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/db/sql/insert_tool_qa_data.sql 21 Jun 2005 05:42:52 -0000 1.1 +++ lams_tool_laqa/db/sql/insert_tool_qa_data.sql 24 Jun 2005 08:50:23 -0000 1.2 @@ -13,7 +13,7 @@ INSERT INTO tl_laqa11_que_content (qa_que_content_id, question, display_order, - qa_content_id) VALUES (20,'What is the capital of Uruguay?',1,10); + qa_content_id) VALUES (20,'What is the name of this activity?',1,10); Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Activity.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Activity.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Activity.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,262 @@ + + + + + + + + @hibernate.class table="lams_learning_activity" + true + + + @hibernate.id generator-class="identity" type="java.lang.Long" column="activity_id" + + + + + + + + @hibernate.property column="activity_ui_id" length="11" + + + + @hibernate.property column="description" length="65535" + + + + @hibernate.property column="title" length="255" + + + + @hibernate.property column="help_text" length="65535" + + + + @hibernate.property column="xcoord" length="11" + + + + @hibernate.property column="ycoord" length="11" + + + + @hibernate.property column="order_id" length="11" + + + + @hibernate.property column="define_later_flag" length="4" not-null="true" + + + + @hibernate.property column="create_date_time" length="19" not-null="true" + + + + @hibernate.property column="offline_instructions" length="65535" + + + + @hibernate.property column="online_instructions" length="65535" + + + + + @hibernate.property column="run_offline_flag" length="4" not-null="true" + + + + @hibernate.property column="parent_ui_id" length="11" + + + @hibernate.property column="grouping_ui_id" length="11" + + + + @hibernate.property column="learning_activity_type_id" length="11" + + + + @hibernate.property column="activity_category_id" length="11" + + + + @hibernate.property column="library_activity_ui_image" length="255" + + + + + + + + + + + + + @hibernate.column name="learning_library_id" + + + + + + + + @hibernate.column name="parent_activity_id" + + + + + + + @hibernate.column name="libraryActivity" + + + + + + + @hibernate.column name="learning_design_id" + + + + + + + @hibernate.column name="grouping_id" + + + + + + + @hibernate.class + public abstract + + + @hibernate.class + + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="tool_session_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.tool.ToolSession" + + + + + + + + + + + + + @hibernate.class + + + @hibernate.property column="create_grouping_ui_id" length="11" + + + + + + + + + + @hibernate.class + + + + + + + + + @hibernate.class + + + @hibernate.property column="gate_start_time_offset" length="20" + true + + + + @hibernate.property column="gate_end_time_offset" length="20" + true + + + + @hibernate.property column="gate_start_date_time" length="19" + true + + + + @hibernate.property column="gate_end_date_time" length="19" + true + + + + + @hibernate.class + + + @hibernate.class + + + + + + @hibernate.class + public abstract + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="parent_activity_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + @hibernate.class + + + @hibernate.property column="max_number_of_options" length="5" + true + + + + @hibernate.property column="min_number_of_options" length="5" + true + + + + @hibernate.property column="options_instructions" length="65535" + + + + + @hibernate.class + + + @hibernate.class + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/AuthenticationMethod.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/AuthenticationMethod.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/AuthenticationMethod.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,101 @@ + + + + + + + + + @hibernate.class + table="lams_authentication_method" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="authentication_method_id" + + + + true + + + + + + @hibernate.property + column="authentication_method_name" + unique="true" + length="64" + not-null="true" + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="authentication_method_type_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="authentication_method_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/AuthenticationMethodType.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/AuthenticationMethodType.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/AuthenticationMethodType.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,86 @@ + + + + + + + + + @hibernate.class + table="lams_authentication_method_type" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="authentication_method_type_id" + + + + true + + + + + + @hibernate.property + column="description" + length="64" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="authentication_method_type_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.AuthenticationMethod" + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Group.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Group.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Group.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,117 @@ + + + + + + + + + @hibernate.class + table="lams_group" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="group_id" + + + + + + + + + @hibernate.property + column="order_id" + length="6" + not-null="true" + + + + + + + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="group_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.tool.ToolSession" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="grouping_id" + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Grouping.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Grouping.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Grouping.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,93 @@ + + + + + + + + + + + + + + + @hibernate.property column="grouping_ui_id" length="11" + + + + + + + + + + + @hibernate.set lazy="true" inverse="true" cascade="none" + @hibernate.collection-key column="grouping_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.Group" + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/LearnerProgress.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/LearnerProgress.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/LearnerProgress.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,83 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/LearningDesign.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/LearningDesign.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/LearningDesign.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,217 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + @hibernate.property + column="valid_design_flag" + length="4" + not-null="true" + + + + + + + + + + + + + + + + + + + + @hibernate.property + column="version" + length="56" + + + + + @hibernate.property column ="duration" + + + @hibernate.property column ="license_text" + + + + @hibernate.property column ="lesson_org_id" + + + @hibernate.property column ="lesson_org_name" + + + @hibernate.property column ="lesson_id" + + + @hibernate.property column ="lesson_name" + + + @hibernate.property column ="lesson_start_date_time" + + + @hibernate.property column ="last_modified_date_time" + + + + + + + @hibernate.column name="license_id" + + + + + + + @hibernate.column name="first_activity_id" + + + + + + + + @hibernate.column name="parent_learning_design_id" + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/LearningLibrary.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/LearningLibrary.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/LearningLibrary.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,80 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Lesson.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Lesson.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Lesson.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,106 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + SELECT DISTINCT {lesson.*} + FROM lams_lesson {lesson}, + lams_grouping, + lams_group, + lams_user_group + WHERE ({lesson}.class_grouping_id = lams_grouping.grouping_id) + AND (lams_grouping.grouping_id = lams_group.grouping_id) + AND (lams_group.group_id = lams_user_group.group_id) + AND ({lesson}.lesson_state_id IN (3,4,5)) + AND (lams_user_group.user_id = :userId) + + + + + SELECT DISTINCT {learner.*} + FROM lams_user {learner}, + lams_learner_progress + WHERE ({learner}.user_id = lams_learner_progress.user_id) + AND (lams_learner_progress.lesson_id = :lessonId) + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/License.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/License.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/License.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,21 @@ + + + + + + + + true + + + + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Organisation.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Organisation.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Organisation.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,226 @@ + + + + + + + + + @hibernate.class + table="lams_organisation" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="organisation_id" + + + + true + + + + + + @hibernate.property + column="name" + length="250" + + + + + @hibernate.property + column="description" + length="250" + + + + + @hibernate.property + column="create_date" + length="19" + not-null="true" + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="workspace_id" + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="organisation_type_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisation" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="parent_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="parent_organisation_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="base_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.Lesson" + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/OrganisationType.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/OrganisationType.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/OrganisationType.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,103 @@ + + + + + + + + + @hibernate.class + table="lams_organisation_type" + proxy="org.lamsfoundation.lams.usermanagement.OrganisationType" + + true + + + + @hibernate.id + generator-class="increment" + type="java.lang.Integer" + column="organisation_type_id" + + + + true + + + + + + @hibernate.property + column="name" + unique="true" + length="64" + not-null="true" + + + + + @hibernate.property + column="description" + length="255" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="organisation_type_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaAppConstants.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaAppConstants.java,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaAppConstants.java 21 Jun 2005 05:43:03 -0000 1.1 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/QaAppConstants.java 24 Jun 2005 08:55:18 -0000 1.2 @@ -18,6 +18,8 @@ * Currently we are hardcoding the default content id. * This will be replaced when the deploy logic automatically assigns a default content id in the deploy script. */ + + public static final String MY_SIGNATURE ="laqa11"; public static final long DEFAULT_CONTENT_ID =10; public static final long DEFAULT_QUE_CONTENT_ID =20; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Role.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Role.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Role.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,98 @@ + + + + + + + + + @hibernate.class + table="lams_role" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="role_id" + + + + + + + + true + + @hibernate.property + column="name" + length="64" + not-null="true" + + + + + @hibernate.property + column="description" + length="65535" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="delete-orphan" + + @hibernate.collection-key + column="role_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisationRole" + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Tool.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Tool.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Tool.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,336 @@ + + + + + + + + + @hibernate.class + table="lams_tool" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="tool_id" + + + + + + + + + @hibernate.property + column="learner_url" + length="65535" + not-null="true" + + + + + @hibernate.property + column="grouping_support_type_id" + length="3" + not-null="true" + + + + + @hibernate.property + column="author_url" + length="65535" + + + + + @hibernate.property + column="supports_define_later_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_moderation_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_run_offline_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_contribute_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="valid_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="define_later_url" + length="65535" + + + + + @hibernate.property + column="default_tool_content_id" + length="20" + not-null="false" + + + + + @hibernate.property + column="tool_signature" + length="64" + not-null="true" + + + + + @hibernate.property + column="tool_display_name" + length="255" + not-null="true" + + + + + @hibernate.property + column="description" + length="65535" + + + + + + + + @hibernate.property + column="class_name" + length="65535" + not-null="true" + + + + + @hibernate.property + column="export_portfolio_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="monitor_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="moderation_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="contribute_url" + length="65535" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="tool_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/ToolContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/ToolContent.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/ToolContent.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,76 @@ + + + + + + + + + @hibernate.class + table="lams_tool_content" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="tool_content_id" + + + + + + + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="tool_content_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/ToolSession.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/ToolSession.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/ToolSession.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,75 @@ + + + + + + + + + @hibernate.class table="lams_tool_session" + + true + + + + @hibernate.id generator-class="identity" + type="java.lang.Long" column="tool_session_id" + + + + + + + + + + + + + + + + + + + @hibernate.property column="create_date_time" + length="19" not-null="true" + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Transition.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Transition.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Transition.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,122 @@ + + + + + + + + + @hibernate.class + table="lams_learning_transition" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="transition_id" + + + + + + + + @hibernate.property column="transition_ui_id" length="11" + + + @hibernate.property column="to_ui_id" length="11" + + + @hibernate.property column="from_ui_id" length="11" + + + + + @hibernate.property + column="description" + length="65535" + + + + + @hibernate.property + column="title" + length="255" + + + + + @hibernate.property + column="create_date_time" + length="19" + not-null="true" + + + + + + + + @hibernate.many-to-one unique="true" + @hibernate.column name="to_activity_id" + + + + + + + @hibernate.many-to-one unique="true" + @hibernate.column name="from_activity_id" + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="learning_design_id" + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/User.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/User.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/User.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,399 @@ + + + + + + + + + @hibernate.class + table="lams_user" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_id" + + + + + + + + true + + @hibernate.property + column="login" + unique="true" + length="20" + not-null="true" + + + + + @hibernate.property + column="password" + length="50" + not-null="true" + + + + + @hibernate.property + column="title" + length="32" + + + + + @hibernate.property + column="first_name" + length="64" + + + + + @hibernate.property + column="last_name" + length="128" + + + + + @hibernate.property + column="address_line_1" + length="64" + + + + + @hibernate.property + column="address_line_2" + length="64" + + + + + @hibernate.property + column="address_line_3" + length="64" + + + + + @hibernate.property + column="city" + length="64" + + + + + @hibernate.property + column="state" + length="64" + + + + + @hibernate.property + column="country" + length="64" + + + + + @hibernate.property + column="day_phone" + length="64" + + + + + @hibernate.property + column="evening_phone" + length="64" + + + + + @hibernate.property + column="mobile_phone" + length="64" + + + + + @hibernate.property + column="fax" + length="64" + + + + + @hibernate.property + column="email" + length="128" + + + + + @hibernate.property + column="disabled_flag" + length="1" + not-null="true" + + + + + @hibernate.property + column="create_date" + length="19" + not-null="true" + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="workspace_id" + + + + + + + @hibernate.set + lazy="false" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisation" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="authentication_method_id" + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="base_organisation_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.LearnerProgress" + + + + + + + + + + + @hibernate.set lazy="true" inverse="true" cascade="none" + @hibernate.collection-key column="user_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.LearningDesign" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.Lesson" + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/UserOrganisation.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/UserOrganisation.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/UserOrganisation.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,99 @@ + + + + + + + + + @hibernate.class + table="lams_user_organisation" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_organisation_id" + + + + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="user_id" + + + + + + + @hibernate.set + lazy="false" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="user_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisationRole" + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="organisation_id" + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/UserOrganisationRole.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/UserOrganisationRole.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/UserOrganisationRole.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,73 @@ + + + + + + + + + @hibernate.class + table="lams_user_organisation_role" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_organisation_role_id" + + + + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="user_organisation_id" + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="role_id" + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Workspace.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/Workspace.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Workspace.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,115 @@ + + + + + + + + + @hibernate.class + table="lams_workspace" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="workspace_id" + + + + true + + + + + @hibernate.property column="name" length="65535" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="workspace_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="workspace_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="root_folder_id" + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/WorkspaceFolder.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/WorkspaceFolder.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/WorkspaceFolder.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,166 @@ + + + + + + + + + @hibernate.class + table="lams_workspace_folder" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="workspace_folder_id" + + + + + + + + + @hibernate.property + column="name" + length="64" + not-null="true" + + + + + @hibernate.property column="user_id" length="11" + + + @hibernate.property column="lams_workspace_folder_type_id" length="11" + + + @hibernate.property column="create_date_time" length="19" not-null="true" + + + @hibernate.property column="last_modified_date_time" length="19" not-null="true" + + + + + @hibernate.property + column="workspace_id" + length="11" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="root_folder_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Workspace" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="parent_folder_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.WorkspaceFolder" + + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="parent_folder_id" + + + + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="user_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.LearningDesign" + + + + + + + + + + + + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/WorkspaceFolderContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/Attic/WorkspaceFolderContent.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/WorkspaceFolderContent.hbm.xml 24 Jun 2005 08:55:18 -0000 1.1 @@ -0,0 +1,59 @@ + + + + + + true + + + + + + + + + + + + + + + + + + + + \ No newline at end of file Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml 21 Jun 2005 05:43:03 -0000 1.1 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml 24 Jun 2005 08:55:18 -0000 1.2 @@ -39,6 +39,30 @@ /WEB-INF/QaQueContent.hbm.xml /WEB-INF/QaQueUsr.hbm.xml /WEB-INF/QaUsrResp.hbm.xml + + /WEB-INF/Tool.hbm.xml + /WEB-INF/Activity.hbm.xml + /WEB-INF/ToolSession.hbm.xml + /WEB-INF/Lesson.hbm.xml + /WEB-INF/User.hbm.xml + /WEB-INF/Transition.hbm.xml + /WEB-INF/Group.hbm.xml + /WEB-INF/Grouping.hbm.xml + /WEB-INF/LearnerProgress.hbm.xml + /WEB-INF/LearningDesign.hbm.xml + /WEB-INF/LearningLibrary.hbm.xml + /WEB-INF/License.hbm.xml + /WEB-INF/AuthenticationMethod.hbm.xml + /WEB-INF/AuthenticationMethodType.hbm.xml + /WEB-INF/Organisation.hbm.xml + /WEB-INF/Role.hbm.xml + /WEB-INF/ToolContent.hbm.xml + /WEB-INF/UserOrganisation.hbm.xml + /WEB-INF/OrganisationType.hbm.xml + /WEB-INF/UserOrganisationRole.hbm.xml + /WEB-INF/Workspace.hbm.xml + /WEB-INF/WorkspaceFolder.hbm.xml + /WEB-INF/WorkspaceFolderContent.hbm.xml @@ -64,6 +88,11 @@ + + + + + @@ -106,7 +135,14 @@ + + + + + - + PROPAGATION_REQUIRED,-QaApplicationException @@ -160,7 +196,8 @@ - + + Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/IQaService.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/IQaService.java,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/IQaService.java 21 Jun 2005 05:43:03 -0000 1.1 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/IQaService.java 24 Jun 2005 08:55:26 -0000 1.2 @@ -20,6 +20,7 @@ */ package org.lamsfoundation.lams.tool.qa.service; +import org.lamsfoundation.lams.tool.Tool; import org.lamsfoundation.lams.tool.qa.QaContent; import org.lamsfoundation.lams.tool.qa.QaQueContent; import org.lamsfoundation.lams.tool.qa.QaQueUsr; @@ -178,6 +179,10 @@ */ public String leaveToolSession(Long toolSessionId, User learner); + public Tool getToolBySignature(String toolSignature); + + public long getToolDefaultContentIdBySignature(String toolSignature); + public int countSessionUser(QaSession qaSession); } Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/QaServicePOJO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/QaServicePOJO.java,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/QaServicePOJO.java 21 Jun 2005 05:43:03 -0000 1.1 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/service/QaServicePOJO.java 24 Jun 2005 08:55:26 -0000 1.2 @@ -26,6 +26,7 @@ import org.apache.log4j.Logger; import org.lamsfoundation.lams.lesson.Lesson; +import org.lamsfoundation.lams.tool.Tool; import org.lamsfoundation.lams.tool.ToolContentManager; import org.lamsfoundation.lams.tool.ToolSessionExportOutputData; import org.lamsfoundation.lams.tool.ToolSessionManager; @@ -47,7 +48,6 @@ import org.springframework.dao.DataAccessException; - /** * The POJO implementation of Survey service. All business logics of survey tool * are implemented in this class. It translate the request from presentation @@ -80,7 +80,7 @@ private IUserManagementService userManagementService; private ILamsToolService toolService; - + static Logger logger = Logger.getLogger(QaMonitoringAction.class.getName()); @@ -1067,6 +1067,22 @@ // TODO Auto-generated method stub throw new UnsupportedOperationException("not yet implemented"); } + + public Tool getToolBySignature(String toolSignature) + { + logger.debug(logger + " " + this.getClass().getName() + "attempt retrieving tool with signature : " + toolSignature); + Tool tool=toolService.getToolBySignature(toolSignature); + logger.debug(logger + " " + this.getClass().getName() + " " + "retrieved tool: " + tool); + return tool; + } + + public long getToolDefaultContentIdBySignature(String toolSignature) + { + long contentId=toolService.getToolDefaultContentIdBySignature(toolSignature); + logger.debug(logger + " " + this.getClass().getName() + " " + "tool default contentId : " + contentId); + return contentId; + } + /** * @return Returns the qaDAO. Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaStarterAction.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaStarterAction.java,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaStarterAction.java 21 Jun 2005 05:43:12 -0000 1.1 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaStarterAction.java 24 Jun 2005 08:56:54 -0000 1.2 @@ -12,7 +12,6 @@ import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; -import org.lamsfoundation.lams.usermanagement.User; import org.apache.log4j.Logger; import org.apache.struts.Globals; @@ -30,6 +29,7 @@ import org.lamsfoundation.lams.tool.qa.QaUtils; import org.lamsfoundation.lams.tool.qa.service.IQaService; import org.lamsfoundation.lams.tool.qa.service.QaServiceProxy; +import org.lamsfoundation.lams.usermanagement.User; /** * TODO: change DEVELOPMENT_FLAG to false once the container creates and passes users to the tool @@ -76,6 +76,10 @@ request.getSession().setAttribute(TOOL_SERVICE, qaService); } + logger.debug(logger + " " + this.getClass().getName() + "attempte retrieving tool with signatute : " + MY_SIGNATURE); + long contentId=qaService.getToolDefaultContentIdBySignature(MY_SIGNATURE ); + logger.debug(logger + " " + this.getClass().getName() + "retrieved tool default contentId: " + contentId); + /** * mark the http session as an authoring activity */ Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/User.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/Attic/User.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/User.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,399 @@ + + + + + + + + + @hibernate.class + table="lams_user" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_id" + + + + + + + + true + + @hibernate.property + column="login" + unique="true" + length="20" + not-null="true" + + + + + @hibernate.property + column="password" + length="50" + not-null="true" + + + + + @hibernate.property + column="title" + length="32" + + + + + @hibernate.property + column="first_name" + length="64" + + + + + @hibernate.property + column="last_name" + length="128" + + + + + @hibernate.property + column="address_line_1" + length="64" + + + + + @hibernate.property + column="address_line_2" + length="64" + + + + + @hibernate.property + column="address_line_3" + length="64" + + + + + @hibernate.property + column="city" + length="64" + + + + + @hibernate.property + column="state" + length="64" + + + + + @hibernate.property + column="country" + length="64" + + + + + @hibernate.property + column="day_phone" + length="64" + + + + + @hibernate.property + column="evening_phone" + length="64" + + + + + @hibernate.property + column="mobile_phone" + length="64" + + + + + @hibernate.property + column="fax" + length="64" + + + + + @hibernate.property + column="email" + length="128" + + + + + @hibernate.property + column="disabled_flag" + length="1" + not-null="true" + + + + + @hibernate.property + column="create_date" + length="19" + not-null="true" + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="workspace_id" + + + + + + + @hibernate.set + lazy="false" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisation" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="authentication_method_id" + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="base_organisation_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.LearnerProgress" + + + + + + + + + + + @hibernate.set lazy="true" inverse="true" cascade="none" + @hibernate.collection-key column="user_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.LearningDesign" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.Lesson" + + + + + + + + + Index: lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/Attic/QaContent.hbm.xml,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaContent.hbm.xml 21 Jun 2005 05:43:13 -0000 1.1 +++ lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaContent.hbm.xml 24 Jun 2005 08:56:54 -0000 1.2 @@ -41,11 +41,31 @@ column="instructions" length="255" /> - + + + + + + + + + - + + + + + + + - - - - - - - - - - + + + - - - - - Index: lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaSession.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/Attic/QaSession.hbm.xml,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaSession.hbm.xml 21 Jun 2005 05:43:13 -0000 1.1 +++ lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaSession.hbm.xml 24 Jun 2005 08:56:54 -0000 1.2 @@ -22,7 +22,7 @@ + + + - - + + - Index: lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaUsrResp.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/Attic/QaUsrResp.hbm.xml,v diff -u -r1.1 -r1.2 --- lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaUsrResp.hbm.xml 21 Jun 2005 05:43:13 -0000 1.1 +++ lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/QaUsrResp.hbm.xml 24 Jun 2005 08:56:54 -0000 1.2 @@ -24,14 +24,46 @@ length="65535" > + + + + + + + + + + + + + + + + + + + + + + + + + /WEB-INF/dbConnection.properties + + + + + + + + ${jdbc.driverClassName} + ${jdbc.url} + ${jdbc.username} + ${jdbc.password} + + + + + + + + + /WEB-INF/QaContent.hbm.xml + /WEB-INF/QaSession.hbm.xml + /WEB-INF/QaQueContent.hbm.xml + /WEB-INF/QaQueUsr.hbm.xml + /WEB-INF/QaUsrResp.hbm.xml + + + + + ${hibernate.dialect} + ${hibernate.show_sql} + ${hibernate.c3p0.minPoolSize} + ${hibernate.c3p0.maxPoolSize} + ${hibernate.c3p0.timeout} + ${hibernate.c3p0.max_statement} + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + PROPAGATION_REQUIRED,-QaApplicationException + PROPAGATION_REQUIRED,-QaApplicationException + PROPAGATION_REQUIRED, -QaApplicationException + PROPAGATION_REQUIRED,-QaApplicationException + PROPAGATION_REQUIRED,readOnly,-QacpApplicationException + PROPAGATION_REQUIRED,-QaApplicationException + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + PROPAGATION_REQUIRED,-QaApplicationException + + + + + + + + + Fisheye: Tag 1.2 refers to a dead (removed) revision in file `lams_tool_laqa/test/java/org/lamsfoundation/lams/tool/qa/qaCompactApplicationContext.xml'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_laqa/web/WEB-INF/Activity.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Activity.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Activity.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,262 @@ + + + + + + + + @hibernate.class table="lams_learning_activity" + true + + + @hibernate.id generator-class="identity" type="java.lang.Long" column="activity_id" + + + + + + + + @hibernate.property column="activity_ui_id" length="11" + + + + @hibernate.property column="description" length="65535" + + + + @hibernate.property column="title" length="255" + + + + @hibernate.property column="help_text" length="65535" + + + + @hibernate.property column="xcoord" length="11" + + + + @hibernate.property column="ycoord" length="11" + + + + @hibernate.property column="order_id" length="11" + + + + @hibernate.property column="define_later_flag" length="4" not-null="true" + + + + @hibernate.property column="create_date_time" length="19" not-null="true" + + + + @hibernate.property column="offline_instructions" length="65535" + + + + @hibernate.property column="online_instructions" length="65535" + + + + + @hibernate.property column="run_offline_flag" length="4" not-null="true" + + + + @hibernate.property column="parent_ui_id" length="11" + + + @hibernate.property column="grouping_ui_id" length="11" + + + + @hibernate.property column="learning_activity_type_id" length="11" + + + + @hibernate.property column="activity_category_id" length="11" + + + + @hibernate.property column="library_activity_ui_image" length="255" + + + + + + + + + + + + + @hibernate.column name="learning_library_id" + + + + + + + + @hibernate.column name="parent_activity_id" + + + + + + + @hibernate.column name="libraryActivity" + + + + + + + @hibernate.column name="learning_design_id" + + + + + + + @hibernate.column name="grouping_id" + + + + + + + @hibernate.class + public abstract + + + @hibernate.class + + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="tool_session_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.tool.ToolSession" + + + + + + + + + + + + + @hibernate.class + + + @hibernate.property column="create_grouping_ui_id" length="11" + + + + + + + + + + @hibernate.class + + + + + + + + + @hibernate.class + + + @hibernate.property column="gate_start_time_offset" length="20" + true + + + + @hibernate.property column="gate_end_time_offset" length="20" + true + + + + @hibernate.property column="gate_start_date_time" length="19" + true + + + + @hibernate.property column="gate_end_date_time" length="19" + true + + + + + @hibernate.class + + + @hibernate.class + + + + + + @hibernate.class + public abstract + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="parent_activity_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + @hibernate.class + + + @hibernate.property column="max_number_of_options" length="5" + true + + + + @hibernate.property column="min_number_of_options" length="5" + true + + + + @hibernate.property column="options_instructions" length="65535" + + + + + @hibernate.class + + + @hibernate.class + + + + + + + Index: lams_tool_laqa/web/WEB-INF/AuthenticationMethod.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/AuthenticationMethod.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/AuthenticationMethod.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,101 @@ + + + + + + + + + @hibernate.class + table="lams_authentication_method" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="authentication_method_id" + + + + true + + + + + + @hibernate.property + column="authentication_method_name" + unique="true" + length="64" + not-null="true" + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="authentication_method_type_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="authentication_method_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/AuthenticationMethodType.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/AuthenticationMethodType.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/AuthenticationMethodType.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,86 @@ + + + + + + + + + @hibernate.class + table="lams_authentication_method_type" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="authentication_method_type_id" + + + + true + + + + + + @hibernate.property + column="description" + length="64" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="authentication_method_type_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.AuthenticationMethod" + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/Group.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Group.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Group.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,117 @@ + + + + + + + + + @hibernate.class + table="lams_group" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="group_id" + + + + + + + + + @hibernate.property + column="order_id" + length="6" + not-null="true" + + + + + + + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="group_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.tool.ToolSession" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="grouping_id" + + + + + + Index: lams_tool_laqa/web/WEB-INF/Grouping.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Grouping.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Grouping.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,93 @@ + + + + + + + + + + + + + + + @hibernate.property column="grouping_ui_id" length="11" + + + + + + + + + + + @hibernate.set lazy="true" inverse="true" cascade="none" + @hibernate.collection-key column="grouping_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.Group" + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/LearnerProgress.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/LearnerProgress.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/LearnerProgress.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,83 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/LearningDesign.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/LearningDesign.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/LearningDesign.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,217 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + @hibernate.property + column="valid_design_flag" + length="4" + not-null="true" + + + + + + + + + + + + + + + + + + + + @hibernate.property + column="version" + length="56" + + + + + @hibernate.property column ="duration" + + + @hibernate.property column ="license_text" + + + + @hibernate.property column ="lesson_org_id" + + + @hibernate.property column ="lesson_org_name" + + + @hibernate.property column ="lesson_id" + + + @hibernate.property column ="lesson_name" + + + @hibernate.property column ="lesson_start_date_time" + + + @hibernate.property column ="last_modified_date_time" + + + + + + + @hibernate.column name="license_id" + + + + + + + @hibernate.column name="first_activity_id" + + + + + + + + @hibernate.column name="parent_learning_design_id" + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/LearningLibrary.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/LearningLibrary.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/LearningLibrary.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,80 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/Lesson.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Lesson.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Lesson.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,106 @@ + + + + + + + + + true + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + SELECT DISTINCT {lesson.*} + FROM lams_lesson {lesson}, + lams_grouping, + lams_group, + lams_user_group + WHERE ({lesson}.class_grouping_id = lams_grouping.grouping_id) + AND (lams_grouping.grouping_id = lams_group.grouping_id) + AND (lams_group.group_id = lams_user_group.group_id) + AND ({lesson}.lesson_state_id IN (3,4,5)) + AND (lams_user_group.user_id = :userId) + + + + + SELECT DISTINCT {learner.*} + FROM lams_user {learner}, + lams_learner_progress + WHERE ({learner}.user_id = lams_learner_progress.user_id) + AND (lams_learner_progress.lesson_id = :lessonId) + + Index: lams_tool_laqa/web/WEB-INF/License.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/License.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/License.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,21 @@ + + + + + + + + true + + + + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/Organisation.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Organisation.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Organisation.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,226 @@ + + + + + + + + + @hibernate.class + table="lams_organisation" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="organisation_id" + + + + true + + + + + + @hibernate.property + column="name" + length="250" + + + + + @hibernate.property + column="description" + length="250" + + + + + @hibernate.property + column="create_date" + length="19" + not-null="true" + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="workspace_id" + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="organisation_type_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisation" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="parent_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="parent_organisation_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="base_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.Lesson" + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/OrganisationType.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/OrganisationType.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/OrganisationType.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,103 @@ + + + + + + + + + @hibernate.class + table="lams_organisation_type" + proxy="org.lamsfoundation.lams.usermanagement.OrganisationType" + + true + + + + @hibernate.id + generator-class="increment" + type="java.lang.Integer" + column="organisation_type_id" + + + + true + + + + + + @hibernate.property + column="name" + unique="true" + length="64" + not-null="true" + + + + + @hibernate.property + column="description" + length="255" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="organisation_type_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/Role.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Role.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Role.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,98 @@ + + + + + + + + + @hibernate.class + table="lams_role" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="role_id" + + + + + + + + true + + @hibernate.property + column="name" + length="64" + not-null="true" + + + + + @hibernate.property + column="description" + length="65535" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="delete-orphan" + + @hibernate.collection-key + column="role_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisationRole" + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/Tool.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Tool.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Tool.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,336 @@ + + + + + + + + + @hibernate.class + table="lams_tool" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="tool_id" + + + + + + + + + @hibernate.property + column="learner_url" + length="65535" + not-null="true" + + + + + @hibernate.property + column="grouping_support_type_id" + length="3" + not-null="true" + + + + + @hibernate.property + column="author_url" + length="65535" + + + + + @hibernate.property + column="supports_define_later_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_moderation_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_run_offline_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="supports_contribute_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="valid_flag" + length="1" + not-null="true" + + + + + + @hibernate.property + column="define_later_url" + length="65535" + + + + + @hibernate.property + column="default_tool_content_id" + length="20" + not-null="false" + + + + + @hibernate.property + column="tool_signature" + length="64" + not-null="true" + + + + + @hibernate.property + column="tool_display_name" + length="255" + not-null="true" + + + + + @hibernate.property + column="description" + length="65535" + + + + + + + + @hibernate.property + column="class_name" + length="65535" + not-null="true" + + + + + @hibernate.property + column="export_portfolio_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="monitor_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="moderation_url" + length="65535" + not-null="true" + + + + + + @hibernate.property + column="contribute_url" + length="65535" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="tool_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/ToolContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/ToolContent.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/ToolContent.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,76 @@ + + + + + + + + + @hibernate.class + table="lams_tool_content" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="tool_content_id" + + + + + + + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="tool_content_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.learningdesign.Activity" + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/ToolSession.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/ToolSession.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/ToolSession.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,75 @@ + + + + + + + + + @hibernate.class table="lams_tool_session" + + true + + + + @hibernate.id generator-class="identity" + type="java.lang.Long" column="tool_session_id" + + + + + + + + + + + + + + + + + + + @hibernate.property column="create_date_time" + length="19" not-null="true" + + + + + + + + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/Transition.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Transition.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Transition.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,122 @@ + + + + + + + + + @hibernate.class + table="lams_learning_transition" + + true + + + + @hibernate.id + generator-class="identity" + type="java.lang.Long" + column="transition_id" + + + + + + + + @hibernate.property column="transition_ui_id" length="11" + + + @hibernate.property column="to_ui_id" length="11" + + + @hibernate.property column="from_ui_id" length="11" + + + + + @hibernate.property + column="description" + length="65535" + + + + + @hibernate.property + column="title" + length="255" + + + + + @hibernate.property + column="create_date_time" + length="19" + not-null="true" + + + + + + + + @hibernate.many-to-one unique="true" + @hibernate.column name="to_activity_id" + + + + + + + @hibernate.many-to-one unique="true" + @hibernate.column name="from_activity_id" + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="learning_design_id" + + + + + + Index: lams_tool_laqa/web/WEB-INF/User.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/User.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/User.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,399 @@ + + + + + + + + + @hibernate.class + table="lams_user" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_id" + + + + + + + + true + + @hibernate.property + column="login" + unique="true" + length="20" + not-null="true" + + + + + @hibernate.property + column="password" + length="50" + not-null="true" + + + + + @hibernate.property + column="title" + length="32" + + + + + @hibernate.property + column="first_name" + length="64" + + + + + @hibernate.property + column="last_name" + length="128" + + + + + @hibernate.property + column="address_line_1" + length="64" + + + + + @hibernate.property + column="address_line_2" + length="64" + + + + + @hibernate.property + column="address_line_3" + length="64" + + + + + @hibernate.property + column="city" + length="64" + + + + + @hibernate.property + column="state" + length="64" + + + + + @hibernate.property + column="country" + length="64" + + + + + @hibernate.property + column="day_phone" + length="64" + + + + + @hibernate.property + column="evening_phone" + length="64" + + + + + @hibernate.property + column="mobile_phone" + length="64" + + + + + @hibernate.property + column="fax" + length="64" + + + + + @hibernate.property + column="email" + length="128" + + + + + @hibernate.property + column="disabled_flag" + length="1" + not-null="true" + + + + + @hibernate.property + column="create_date" + length="19" + not-null="true" + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="workspace_id" + + + + + + + @hibernate.set + lazy="false" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisation" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="authentication_method_id" + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="base_organisation_id" + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.LearnerProgress" + + + + + + + + + + + @hibernate.set lazy="true" inverse="true" cascade="none" + @hibernate.collection-key column="user_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.LearningDesign" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="user_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.lesson.Lesson" + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/UserOrganisation.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/UserOrganisation.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/UserOrganisation.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,99 @@ + + + + + + + + + @hibernate.class + table="lams_user_organisation" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_organisation_id" + + + + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="user_id" + + + + + + + @hibernate.set + lazy="false" + inverse="true" + cascade="all-delete-orphan" + + @hibernate.collection-key + column="user_organisation_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.UserOrganisationRole" + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="organisation_id" + + + + + + Index: lams_tool_laqa/web/WEB-INF/UserOrganisationRole.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/UserOrganisationRole.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/UserOrganisationRole.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,73 @@ + + + + + + + + + @hibernate.class + table="lams_user_organisation_role" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="user_organisation_role_id" + + + + + + + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="user_organisation_id" + + + + + + true + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="role_id" + + + + + + Index: lams_tool_laqa/web/WEB-INF/Workspace.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/Workspace.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/Workspace.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,115 @@ + + + + + + + + + @hibernate.class + table="lams_workspace" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="workspace_id" + + + + true + + + + + @hibernate.property column="name" length="65535" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="workspace_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.User" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="workspace_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Organisation" + + + + + + + + + + @hibernate.many-to-one + not-null="true" + @hibernate.column name="root_folder_id" + + + + + + Index: lams_tool_laqa/web/WEB-INF/WorkspaceFolder.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/WorkspaceFolder.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/WorkspaceFolder.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,166 @@ + + + + + + + + + @hibernate.class + table="lams_workspace_folder" + + true + + + + @hibernate.id + generator-class="native" + type="java.lang.Integer" + column="workspace_folder_id" + + + + + + + + + @hibernate.property + column="name" + length="64" + not-null="true" + + + + + @hibernate.property column="user_id" length="11" + + + @hibernate.property column="lams_workspace_folder_type_id" length="11" + + + @hibernate.property column="create_date_time" length="19" not-null="true" + + + @hibernate.property column="last_modified_date_time" length="19" not-null="true" + + + + + @hibernate.property + column="workspace_id" + length="11" + not-null="true" + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="root_folder_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.Workspace" + + + + + + + + + + @hibernate.set + lazy="true" + inverse="true" + cascade="none" + + @hibernate.collection-key + column="parent_folder_id" + + @hibernate.collection-one-to-many + class="org.lamsfoundation.lams.usermanagement.WorkspaceFolder" + + + + + + + + + + @hibernate.many-to-one + @hibernate.column name="parent_folder_id" + + + + + + + @hibernate.set lazy="false" inverse="true" cascade="none" + @hibernate.collection-key column="user_id" + @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.LearningDesign" + + + + + + + + + + + + + Index: lams_tool_laqa/web/WEB-INF/WorkspaceFolderContent.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/WorkspaceFolderContent.hbm.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/WorkspaceFolderContent.hbm.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,59 @@ + + + + + + true + + + + + + + + + + + + + + + + + + + + \ No newline at end of file Index: lams_tool_laqa/web/WEB-INF/qaApplicationContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/web/WEB-INF/Attic/qaApplicationContext.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/web/WEB-INF/qaApplicationContext.xml 24 Jun 2005 08:56:54 -0000 1.1 @@ -0,0 +1,177 @@ + + + + + + + + + + + + + /WEB-INF/dbConnection.properties + + + + + + + + ${jdbc.driverClassName} + ${jdbc.url} + ${jdbc.username} + ${jdbc.password} + + + + + + + + + /WEB-INF/QaContent.hbm.xml + /WEB-INF/QaSession.hbm.xml + /WEB-INF/QaQueContent.hbm.xml + /WEB-INF/QaQueUsr.hbm.xml + /WEB-INF/QaUsrResp.hbm.xml + + + + + ${hibernate.dialect} + ${hibernate.show_sql} + ${hibernate.c3p0.minPoolSize} + ${hibernate.c3p0.maxPoolSize} + ${hibernate.c3p0.timeout} + ${hibernate.c3p0.max_statement} + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + PROPAGATION_REQUIRED,-QaApplicationException + PROPAGATION_REQUIRED,-QaApplicationException + PROPAGATION_REQUIRED, -QaApplicationException + PROPAGATION_REQUIRED,-QaApplicationException + PROPAGATION_REQUIRED,readOnly,-QacpApplicationException + PROPAGATION_REQUIRED,-QaApplicationException + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + PROPAGATION_REQUIRED,-QaApplicationException + + + + + + + + +