tests.sql

set serveroutput on;
set define on;

define office_id = '&1';
define cwms_schema = '&2';
define upass_id = '&3';
define eroc = '&4';
define multiuser2 = '&eroc.hectest_multiuser2';
-- make sure the info required for the below users are present
begin
    cwms_sec.add_cwms_user('OTHER_DIST', char_32_array_type('CWMS Users'),'HQ');
    cwms_20.cwms_sec.add_cwms_user ('&&multiuser2',
                                        CHAR_32_ARRAY_TYPE ('CWMS Users','TS ID Creator', 'Viewer Users'),
                                        '&&office_id');
    cwms_20.cwms_sec.add_user_to_group('&&multiuser2','CWMS Users','POA');
    cwms_20.cwms_sec.add_user_to_group('&&eroc' || 'cwmspd','CWMS DBA Users', '&&office_id');
    cwms_20.cwms_sec.add_user_to_group('&&eroc' || 'webtest','CWMS DBA Users', '&&office_id');

    
end;
/

@test_cwms_stream;
@test_cwms_measurements.sql;
@test_cwms_lock.sql;
@test_cwms_prop.sql;
@test_cwms_msg.sql;
@test_aaa.sql;
show errors;
@test_aaa_normaluserfails.sql
show errors;
@test_ro.sql;
@test_up.sql;
@test_dba.sql;
@test_lrts_updates.sql;
@test_update_ts_extents.sql;
@test_probability_parameter.sql;
@test_cwms_util.sql;
@test_cwms_err.sql;
@test_cwms_loc.sql;
@test_cwms_loc_normal_user.sql;
@test_cwms_project.sql;
@test_cwms_ts.sql;
@test_cwms_rating.sql;
@test_cwms_pool.sql;
@test_clean_all.sql;
@test_versioned_time_series.sql;
@test_timeseries_snapping.sql;
@test_cwms_cat.sql;
@test_cwms_level.sql;
@test_cwms_water_supply.sql;
@test_cwms_display.sql;
@test_cwms_data_dissem.sql;
@test_cwms_fcst.sql;
@test_cwms_forecast.sql;
@test_cwms_xchg.sql;
@test_cwms_cache.sql;
@test_aq_user.sql;
@test_webuser_abilities.sql;
@test_cwms_ts_profile.sql;
@test_level_as_ts.sql
@test_cwms_outlet.sql;
@test_cwms_text.sql;
@views/test_av_ts_grp_assgn.sql;
@views/test_av_loc_grp_assgn.sql;
@views/test_av_location_level_ref_values.sql;
show errors;
@test_multiple_office_perms.sql;
show errors;