CLASS {{p}}t16_test DEFINITION PUBLIC FINAL CREATE PUBLIC
  FOR TESTING DURATION SHORT RISK LEVEL HARMLESS.

  PRIVATE SECTION.
    CLASS-DATA go_env TYPE REF TO if_cds_test_environment.
    CLASS-METHODS class_setup.
    CLASS-METHODS class_teardown.
    METHODS setup.
    METHODS price_and_town FOR TESTING.
ENDCLASS.


CLASS {{p}}t16_test IMPLEMENTATION.

  METHOD class_setup.
    go_env = cl_cds_test_environment=>create( i_for_entity = '{{P}}I_STAY' ).
  ENDMETHOD.

  METHOD class_teardown.
    go_env->destroy( ).
  ENDMETHOD.

  METHOD setup.
    DATA lt_hotel TYPE STANDARD TABLE OF {{p}}hotel WITH EMPTY KEY.
    DATA lt_stay  TYPE STANDARD TABLE OF {{p}}stay WITH EMPTY KEY.

    go_env->clear_doubles( ).

    lt_hotel = VALUE #( ( hotel_id = 'X1' city_name = 'BONN' star_rating = 3 ) ).
    lt_stay = VALUE #( ( stay_id = 'T1' hotel_id = 'X1' guest = 'EVE' nights = 4 price_per_night = '25.00' ) ).

    go_env->insert_test_data( lt_hotel ).
    go_env->insert_test_data( lt_stay ).
  ENDMETHOD.

  METHOD price_and_town.
    SELECT SINGLE total_price, city_name FROM {{p}}i_stay WHERE stay_id = 'T1' INTO @DATA(ls_row).
    cl_abap_unit_assert=>assert_equals( exp = CONV decfloat34( '100.00' ) act = CONV decfloat34( ls_row-total_price ) ).
    cl_abap_unit_assert=>assert_equals( exp = 'BONN' act = ls_row-city_name ).
  ENDMETHOD.

ENDCLASS.