38 lines
1.2 KiB
ABAP
38 lines
1.2 KiB
ABAP
CLASS {{p}}seed_data DEFINITION PUBLIC FINAL CREATE PUBLIC.
|
|
PUBLIC SECTION.
|
|
INTERFACES if_oo_adt_classrun.
|
|
PRIVATE SECTION.
|
|
METHODS fill_tables.
|
|
ENDCLASS.
|
|
|
|
|
|
CLASS {{p}}seed_data IMPLEMENTATION.
|
|
|
|
METHOD if_oo_adt_classrun~main.
|
|
fill_tables( ).
|
|
out->write( 'Hotel and stay data written.' ).
|
|
ENDMETHOD.
|
|
|
|
METHOD fill_tables.
|
|
DATA lt_hotel TYPE STANDARD TABLE OF {{p}}hotel WITH EMPTY KEY.
|
|
DATA lt_stay TYPE STANDARD TABLE OF {{p}}stay WITH EMPTY KEY.
|
|
|
|
lt_hotel = VALUE #(
|
|
( hotel_id = 'H1' city_name = 'HAMBURG' star_rating = 4 )
|
|
( hotel_id = 'H2' city_name = 'MUNICH' star_rating = 5 )
|
|
( hotel_id = 'H3' city_name = 'COLOGNE' star_rating = 3 ) ).
|
|
|
|
lt_stay = VALUE #(
|
|
( stay_id = 'S1' hotel_id = 'H1' guest = 'ADA' nights = 3 price_per_night = '100.00' )
|
|
( stay_id = 'S2' hotel_id = 'H1' guest = 'BOB' nights = 1 price_per_night = '99.99' )
|
|
( stay_id = 'S3' hotel_id = 'H2' guest = 'CARA' nights = 2 price_per_night = '10.50' )
|
|
( stay_id = 'S4' hotel_id = 'H3' guest = 'DAN' nights = 5 price_per_night = '1.00' ) ).
|
|
|
|
DELETE FROM {{p}}stay.
|
|
DELETE FROM {{p}}hotel.
|
|
INSERT {{p}}hotel FROM TABLE @lt_hotel.
|
|
INSERT {{p}}stay FROM TABLE @lt_stay.
|
|
ENDMETHOD.
|
|
|
|
ENDCLASS.
|