Query improvement to reduce duplicate binds

[MikeNeilson]

rest_api/opendcs-rest-api/src/main/java/org/opendcs/odcsapi/sec/cwms/CwmsAuthorizationDAO.java

Line 47 in 5613794

String q = "select user_group_id " +

By using a Common Table expression we can reduce the number of binds to 2.

with inputs as (select ? as username, ? as office_id from dual)
select avsu.user_group_id 
from cwms_20.av_sec_users avsu, inputs
where avsu.db_office_code = cwms_20.cwms_util.get_db_office_code(inputs.office_id) 
  and upper(avsu.username) = case 
     when instr(inputs.username, '.', -1) > 0 then 
        (select userid 
           from cwms_20.at_sec_cwms_users 
           where edipi = substr(inputs.username, instr(inputs.username, '.', -1) + 1)) 
         else 
            upper(inputs.username) 
      end 
  and avsu.is_member = 'T'