CLASS {{p}}t31_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 load_of_one_tutor FOR TESTING.
ENDCLASS.


CLASS {{p}}t31_test IMPLEMENTATION.
  METHOD class_setup.
    go_env = cl_cds_test_environment=>create( i_for_entity = '{{P}}I_TUTOR_LOAD' ).
  ENDMETHOD.

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

  METHOD setup.
    go_env->clear_doubles( ).
  ENDMETHOD.

  METHOD load_of_one_tutor.
    DATA lt_tutor  TYPE STANDARD TABLE OF {{p}}tutor WITH EMPTY KEY.
    DATA lt_lesson TYPE STANDARD TABLE OF {{p}}lesson WITH EMPTY KEY.
    lt_tutor = VALUE #( ( tutor_id = 'A' tutor_name = 'ANNA' subject = 'PIANO' ) ).
    lt_lesson = VALUE #( ( lesson_id = 'X1' tutor_id = 'A' dur_min = 20 )
                         ( lesson_id = 'X2' tutor_id = 'A' dur_min = 40 )
                         ( lesson_id = 'X3' tutor_id = 'A' dur_min = 60 ) ).
    go_env->insert_test_data( lt_tutor ).
    go_env->insert_test_data( lt_lesson ).
    SELECT SINGLE lesson_count, total_minutes FROM {{p}}i_tutor_load
      WHERE tutor_id = 'A' INTO @DATA(ls_load).
    cl_abap_unit_assert=>assert_equals( exp = 3 act = CONV i( ls_load-lesson_count ) ).
    cl_abap_unit_assert=>assert_equals( exp = CONV decfloat34( 120 )
                                        act = CONV decfloat34( ls_load-total_minutes ) ).
  ENDMETHOD.
ENDCLASS.