Pierre Ducroquet
|
7209ea81a1
|
sql: optimize the hand written queries (#49580)
gitea/docbow/pipeline/head Build started...
Details
|
2022-05-23 17:42:49 +02:00 |
Emmanuel Cazenave
|
dc5509e16e
|
run black (#51394)
|
2021-02-24 11:54:53 +01:00 |
Emmanuel Cazenave
|
baebc42524
|
misc: reformat using black (#49290)
|
2021-01-29 18:13:53 +01:00 |
Emmanuel Cazenave
|
5145db8747
|
restore raw sql queries (#48320)
|
2020-11-06 02:01:53 +01:00 |
Emmanuel Cazenave
|
50619c3f8a
|
avoid raw SQL queries (#44909)
|
2020-10-08 12:33:32 +02:00 |
Benjamin Dauvergne
|
7257c32e4f
|
sql: use placeholder to pass boolean parameters as the syntax differ between backends
|
2014-05-06 10:51:10 +02:00 |
Benjamin Dauvergne
|
e50a7be2d2
|
sql: hide deleted document in listings
regression appeared when raw SQL were introduced
|
2014-05-05 13:31:42 +02:00 |
Benjamin Dauvergne
|
7a2d333133
|
sql: [private-flag] only show private documents to real recipients
|
2014-05-05 13:31:42 +02:00 |
Benjamin Dauvergne
|
379c5e04f4
|
sql: adapt raw sql queries to work with sqlite3 too
sqlite3 does not support tuple in query placeholders, you must flatten
the tuple in the query parameters and the template first.
|
2014-04-26 10:46:25 +02:00 |
Benjamin Dauvergne
|
58140c6d61
|
sql: do not mix mailbox from the inbox and the outbox
|
2014-01-31 16:08:11 +01:00 |
Benjamin Dauvergne
|
558ca2b14a
|
models: use 'inbox-message' url endpoint in Document.url()
fixes #4249
|
2014-01-23 16:43:29 +01:00 |
Benjamin Dauvergne
|
9ead810522
|
sql: add d.date to GROUP BY to comply with Postgresql 8.4
Postgresql 9.1 is able to infer that d.date depends on d.id
|
2014-01-16 09:22:27 +01:00 |
Benjamin Dauvergne
|
143399e47f
|
sql: new module for storing optimized SQL queries
|
2014-01-16 09:02:43 +01:00 |