Guest User

Untitled

a guest
Jul 18th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. @Formula("(SELECT SUM(dividend) || '/' || SUM(divisor) " +
  2. "FROM (SELECT CAST(substr(sr.result, 1, position('/' in sr.result)-1 ) AS int) AS dividend ," +
  3. "CAST(substr(sr.result, position('/' in sr.result)+1 ) AS int) AS divisor " +
  4. "FROM suite_results as sr WHERE sr.execution_history=id) AS division)")
  5. private String result;
  6.  
  7. select executionh0_.id as id7_1_, executionh0_.execution_plan as execution3_7_1_, executionh0_.start_time as start2_7_1_,
  8. (SELECT SUM(sr.duration) FROM suite_results as sr WHERE sr.execution_history=executionh0_.id) as formula0_1_,
  9. (SELECT SUM(executionh0_.dividend) || '/' || SUM(executionh0_.divisor) FROM
  10. (SELECT CAST(substr(sr.result, 1, position('/' in sr.result)-1 ) AS executionh0_.int) AS executionh0_.dividend ,
  11. CAST(substr(sr.result, position('/' in sr.result)+1 ) AS executionh0_.int) AS executionh0_.divisor
  12. FROM suite_results as sr WHERE sr.execution_history=executionh0_.id) AS executionh0_.division) as
  13. formula1_1_, executionp1_.id as id6_0_, executionp1_.build_number as
  14. build2_6_0_, executionp1_.name as name6_0_, executionp1_.owner as owner6_0_, executionp1_.sut as sut6_0_,
  15. executionp1_.wait_for_page_to_load as wait6_6_0_ from execution_history executionh0_
  16. left outer join execution_plans executionp1_ on executionh0_.execution_plan=executionp1_.id where executionh0_.id=?
Add Comment
Please, Sign In to add comment