Skip to content

GitLab

cubicweb
cubicweb
Switch branch/tag
  1. 12 Jan, 2021 1 commit
  3. 06 Jan, 2021 1 commit
  5. 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
  7. 08 Dec, 2020 1 commit
  9. 08 Jan, 2021 1 commit
  11. 07 Jan, 2021 1 commit
  13. 14 Dec, 2020 1 commit
  15. 04 Jan, 2021 2 commits
  17. 07 Jan, 2021 1 commit
  19. 14 Dec, 2020 1 commit
  21. 18 Dec, 2020 1 commit
  23. 02 Dec, 2020 1 commit
  25. 16 Dec, 2020 1 commit
  27. 14 Dec, 2020 2 commits
  29. 15 Dec, 2020 2 commits
  31. 14 Dec, 2020 1 commit
  33. 09 Dec, 2020 2 commits
  35. 10 Dec, 2020 1 commit
    • Nicola Spanti's avatar
      [server] Set language of connection in all cases · 0bf284839d6f
      Nicola Spanti authored 
      If `self.lang` was already defined (aka not `None`), the language
was not set. In consequence, when a pview was called, the language
was always considered to be english, this piece of information is
used by gettext, so it resulted in translation always done in
english language instead of using user preference as excepted.

closes #87
      0bf284839d6f
  37. 09 Dec, 2020 8 commits
  39. 08 Dec, 2020 4 commits
  41. 27 Nov, 2020 1 commit
  43. 03 Dec, 2020 1 commit
  45. 02 Dec, 2020 1 commit
  47. 27 Nov, 2020 2 commits