1. 26 Jan, 2021 3 commits
  2. 19 Jan, 2021 3 commits
  3. 21 Jan, 2021 1 commit
  4. 19 Jan, 2021 6 commits
  5. 15 Jan, 2021 2 commits
  6. 19 Jan, 2021 1 commit
  7. 26 Jan, 2021 4 commits
  8. 19 Jan, 2021 1 commit
  9. 12 Jan, 2021 1 commit
  10. 06 Jan, 2021 1 commit
  11. 17 Dec, 2020 2 commits
    • Simon Chabot's avatar
      fix(ci): use **/*.py to match all python files · 826328052e46
      Simon Chabot authored
      826328052e46
    • Simon Chabot's avatar
      fix(rql2sql): properly handle date and datetime operations with SQLite · be2138f52fb6
      Simon Chabot authored
      Different DB backends are used by CW, mainly postgresql and sqlite.
      According to RQL's documentation:
      
          Any N WHERE N is Note, N written_on D, D day> (today -10), N written_by P, P name 'jphc' or P name 'ocy'
      
      should return all the notes less than 10 days old written by jphc or ocy.
      
      but, as described in #109, it only works with postgresql, which is *not*
      mentioned in the documentation.
      
      TODAY is working well in sqlite, but not the operations with TODAY.
      TODAY is translated to 'CURRENT_DATE' in sqlite, and `SELECT CURRENT_DATE - 3`
      return the current year minus three, and *not the current date minus 3 days* as
      expected according to the documentation.
      
      A lot of tests in CW are performed with SQLite (because it's fast to set up!),
      so… let's make it work !
      
      This patch suggests to adapt the 'visit_mathexpression' method, to write the
      expected SQL when were are dealing with:
      
      - sqlite
      - a date(time) on the left (left-hand-side, lhs)
      - a integer (treated as an amount of days) on the right (right-hand-side, rhs)
      
      
      The tests have been updated to check that the conversion rql to sql is the
      expected one, according to the backend.
      
      
      close #109
      be2138f52fb6
  12. 08 Dec, 2020 1 commit
  13. 08 Jan, 2021 1 commit
  14. 07 Jan, 2021 1 commit
  15. 14 Dec, 2020 1 commit
  16. 04 Jan, 2021 2 commits
  17. 07 Jan, 2021 1 commit
  18. 14 Dec, 2020 1 commit
  19. 18 Dec, 2020 1 commit
  20. 02 Dec, 2020 1 commit
  21. 16 Dec, 2020 1 commit
  22. 14 Dec, 2020 2 commits
  23. 15 Dec, 2020 2 commits