<data name="chf_insert">
<config id="cassandra_chf">
<property name="url">jdbc:cassandra://localhost:9160/chf</property>
<property name="driverClassName">org.apache.cassandra.cql.jdbc.CassandraDriver</property>
</config>
<query id="insert_new_patient" useConfig="cassandra_chf">
<sql>INSERT INTO patients (patient_uuid,external_id,password_hash) VALUES (?,?,?)</sql>
<param name="patient_uuid" sqlType="STRING"/>
<param name="external_id" sqlType="STRING"/>
<param name="password_hash" sqlType="STRING"/>
</query>
<query id="insert_new_measurement" useConfig="cassandra_chf">
<sql>INSERT INTO measurements (measurement_uuid,age_years,answers_csv,blood_glucose_milligrams_per_deciliter,blood_pressure_diastolic_millimeters_mercury,blood_pressure_systolic_millimeters_mercury,electrocardiogram_1khz_16bit,height_inches,oxygen_saturation_milligrams_per_litre,pain_scale_0_to_10,patient_uuid,photoplethysmogram_1khz_16bit,pulse_beats_per_minute,pulse_oximetry_percent,questions_csv,respiratory_rate_breaths_per_minute,weight_pounds) VALUES (:measurement_uuid,:age_years,:answers_csv,:blood_glucose_milligrams_per_deciliter,:blood_pressure_diastolic_millimeters_mercury,:blood_pressure_systolic_millimeters_mercury,:electrocardiogram_1khz_16bit,:height_inches,:oxygen_saturation_milligrams_per_litre,:pain_scale_0_to_10,:patient_uuid,:photoplethysmogram_1khz_16bit,:pulse_beats_per_minute,:pulse_oximetry_percent,:questions_csv,:respiratory_rate_breaths_per_minute,:weight_pounds)</sql>
<param defaultValue="NaN" name="age_years" sqlType="DOUBLE"/>
<param defaultValue="null" name="answers_csv" sqlType="STRING"/>
<param defaultValue="NaN" name="blood_glucose_milligrams_per_deciliter" sqlType="DOUBLE"/>
<param defaultValue="NaN" name="blood_pressure_diastolic_millimeters_mercury" sqlType="DOUBLE"/>
<param defaultValue="NaN" name="blood_pressure_systolic_millimeters_mercury" sqlType="DOUBLE"/>
<param defaultValue="0" name="electrocardiogram_1khz_16bit" sqlType="BLOB"/>
<param defaultValue="NaN" name="height_inches" sqlType="DOUBLE"/>
<param name="measurement_uuid" sqlType="STRING"/>
<param defaultValue="NaN" name="oxygen_saturation_milligrams_per_litre" sqlType="DOUBLE"/>
<param defaultValue="-1" name="pain_scale_0_to_10" sqlType="INTEGER"/>
<param name="patient_uuid" sqlType="STRING"/>
<param defaultValue="null" name="photoplethysmogram_1khz_16bit" sqlType="BLOB"/>
<param defaultValue="NaN" name="pulse_beats_per_minute" sqlType="DOUBLE"/>
<param defaultValue="NaN" name="pulse_oximetry_percent" sqlType="DOUBLE"/>
<param defaultValue="0" name="questions_csv" sqlType="STRING"/>
<param defaultValue="NaN" name="respiratory_rate_breaths_per_minute" sqlType="DOUBLE"/>
<param defaultValue="NaN" name="weight_pounds" sqlType="DOUBLE"/>
</query>
<operation name="insert_new_patient" returnRequestStatus="true">
<call-query href="insert_new_patient">
<with-param name="patient_uuid" query-param="patient_uuid"/>
<with-param name="external_id" query-param="external_id"/>
<with-param name="password_hash" query-param="password_hash"/>
</call-query>
</operation>
<operation name="insert_new_measurement" returnRequestStatus="true">
<call-query href="insert_new_measurement">
<with-param name="age_years" query-param="age_years"/>
<with-param name="answers_csv" query-param="answers_csv"/>
<with-param name="blood_glucose_milligrams_per_deciliter" query-param="blood_glucose_milligrams_per_deciliter"/>
<with-param name="blood_pressure_diastolic_millimeters_mercury" query-param="blood_pressure_diastolic_millimeters_mercury"/>
<with-param name="blood_pressure_systolic_millimeters_mercury" query-param="blood_pressure_systolic_millimeters_mercury"/>
<with-param name="electrocardiogram_1khz_16bit" query-param="electrocardiogram_1khz_16bit"/>
<with-param name="height_inches" query-param="height_inches"/>
<with-param name="measurement_uuid" query-param="measurement_uuid"/>
<with-param name="oxygen_saturation_milligrams_per_litre" query-param="oxygen_saturation_milligrams_per_litre"/>
<with-param name="pain_scale_0_to_10" query-param="pain_scale_0_to_10"/>
<with-param name="patient_uuid" query-param="patient_uuid"/>
<with-param name="photoplethysmogram_1khz_16bit" query-param="photoplethysmogram_1khz_16bit"/>
<with-param name="pulse_beats_per_minute" query-param="pulse_beats_per_minute"/>
<with-param name="pulse_oximetry_percent" query-param="pulse_oximetry_percent"/>
<with-param name="questions_csv" query-param="questions_csv"/>
<with-param name="respiratory_rate_breaths_per_minute" query-param="respiratory_rate_breaths_per_minute"/>
<with-param name="weight_pounds" query-param="weight_pounds"/>
</call-query>
</operation>
</data>