<?xml version="1.0"?> <queryset> <rdbms><type>postgresql</type><version>7.1</version></rdbms> <fullquery name="as::assessment::check_session_conditions.cur_wait_time"> <querytext> select round(date_part('epoch', now() - completed_datetime)) as cur_wait_time from as_sessions where session_id = :last_session_id </querytext> </fullquery> <fullquery name="as::assessment::new.update_clobs"> <querytext> update as_assessments set instructions=:instructions, consent_page=:consent_page where assessment_id=:as_assessment_id </querytext> </fullquery> <fullquery name="as::assessment::edit.update_clobs"> <querytext> update as_assessments set instructions=:instructions, consent_page=:consent_page where assessment_id=:new_rev_id </querytext> </fullquery> <fullquery name="as::assessment::new_revision.update_clobs"> <querytext> update as_assessments set instructions=:instructions, consent_page=:consent_page where assessment_id=:new_rev_id </querytext> </fullquery> </queryset>