help = [ "1) The required setups are:", " a) setup sam_python", " b) setup oracle_instant_client", " c) setup cx_Oracle", "2) The special purpose arguments are any argument without an equal sign", " with either a question mark or in any case the word 'help' and the", " argument showquery with a equal sign followed by a boolean value.", "3) The all tests are of the general form of name=value for table column", " tests and category.type=value for request parameter test. The name", " field are case insensitive.", "4) The table column tests are request_id, request_type, request_status,", " work_grp_name, username, number_of_events, request_snap_id, comments,", ' is_archived, data_tier with a default of "thumbnail",' " created_on_or_after, created_before, updated_on_or_after", " updated_before, history and facility. The names of the tests are", " case insensitive. Except for history and facility, all the tests are", " on values in the work request table. History is on the associated work", " request status histories. The format of the history test is discussed", " below. Facility is on the facility name associated with the asociated", " work request handler.", "5) the processing time test, time, takes a colon (:) separated pair of", " floating point numbers, either of which may be omitted. The test is", " time >= left and time < right with the respective test omitted if the", " number is omitted.", "6) The only date formats supported are yyyy/mm/dd hh24:mi:ss,", " yyyy/mm/dd-hh24:mi:ss (so that it does not have to be quoted) and", " yyyy/mm/dd with an implication of yyyy/mm/dd-00:00:00.", "7) All defined category.type pairs are supported; only those in use", " with work requests will return useful results.", "8) Except for the issue of possible performance issues due to a large", " number of tests, the program should work with any number of request", " parameter, history and facility tests.", "9) The comments test supports both equality tests and wildcard tests.", " The type of test is determined by the presence of a % in the string.", "10) The is_archived test accepts arguments of 0, 1 or X (do not care).", " If no is_archived test is given, then an implicit is_archived=0", " test is automatically supplied.", "11) showquery=true requests printing of a 'chunked' (into reasonable", " sized lines version of the query for work requests.", "12) history=status,on_or_after,before", " search for work requests with a work request status history entry with", " that status and effective dates with those limits. The two commas", " are necessary. The status is required. The dates are optional and", " absence implies no limit of that type.", "13) status and facility names are checked for validity.", "14) report=selection provides a restriction the output from the program", " The selection values supported are ids (request ids only), events", " (event counts only, at the request level and over-all) or summary", " (request ids and event counts only).", ]