Skip to content

GitLab

Switch branch/tag
  1. 17 Dec, 2018 1 commit
  3. 23 Nov, 2018 1 commit
  5. 21 Nov, 2018 1 commit
  7. 15 Nov, 2018 2 commits
  9. 08 Nov, 2018 1 commit
  11. 09 Oct, 2018 1 commit
  13. 05 Oct, 2018 1 commit
  15. 01 Oct, 2018 1 commit
  17. 26 Sep, 2018 2 commits
  19. 28 May, 2018 3 commits
  21. 22 May, 2018 1 commit
  23. 19 May, 2018 1 commit
  25. 17 May, 2018 1 commit
  27. 15 May, 2018 1 commit
  29. 17 Jul, 2017 1 commit
  31. 14 Jul, 2017 1 commit
  33. 12 Apr, 2017 1 commit
  35. 10 Apr, 2017 2 commits
  37. 07 Apr, 2017 1 commit
  39. 06 Apr, 2017 3 commits
  41. 08 Feb, 2017 6 commits
  43. 02 Dec, 2016 1 commit
  45. 07 Mar, 2016 1 commit
  47. 01 Mar, 2016 2 commits
    • Edvard Rejthar's avatar
      malá vylepšení UI · 7c3449f3
      Edvard Rejthar authored
      7c3449f3
    • Edvard Rejthar's avatar
      Občas nefungovalo voting. · a2c7179f
      Edvard Rejthar authored 
      Zjistil jsem, že to bylo, protože se použával (INNER) JOIN místo LEFT JOINu.
Ale opravdu, opravdu jsem nepochopil, proč INNER JOIN nefungoval:


SELECT status FROM `turris` AS t1
left outer  JOIN `status` AS t2 ON (`t2`.`id` = `t1`.`status`)
WHERE (`t1`.`remoteHost` = 'api.w.org') LIMIT 1 # vraci status = 1
SELECT status FROM `turris` AS t1
outer JOIN `status` AS t2 ON (`t2`.`id` = `t1`.`status`)
WHERE (`t1`.`remoteHost` = 'api.w.org') LIMIT 1 # vraci status = 0. A to prestoze t1.status samo o sobe je rovno 1 (v tabulce status je pod id = 1 -> name = allow, místo name = n/a, které mi to házelo do prezentace.)
      a2c7179f
  49. 25 Feb, 2016 1 commit
  51. 30 Jan, 2016 1 commit
  53. 29 Jan, 2016 1 commit