¿Cómo se escribe una consulta de prueba de unidad para este documento de mapeo?

votos
0

Este es el documento de mapeo

Me pidieron que escribiera una prueba de unidad para probar este documento de mapeo. ¿Hice la consulta correctamente?

Tengo varias sentencias de selección y no estoy seguro si estoy haciendo esto correctamente. Tengo una instrucción de selección para cada una de las filas en el documento de mapeo.

Estoy haciendo esto prueba de unidad correctamente?

SELECT agreement_id
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT data_source_type_cd
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT rc
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT channel
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT sub_channel
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT event_start_dttm
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT event_subtype_cd
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'SELECT agreement_id

SELECT event_activity_type_cd
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT event_desc
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id

SELECT employeeid
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'
WHERE event_activity_type_cd = 'update_address_phone_number'

FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'
Publicado el 07/11/2018 a las 22:38
fuente por usuario
En otros idiomas...                            

Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more