Frédéric Péters
53812ecd8e
tests: use force_str() in sql fts test ( #36515 )
2019-11-19 15:55:49 +01:00
Frédéric Péters
7bd1967fc4
tests: expand ranges for comparisons ( #36515 )
2019-11-19 15:55:48 +01:00
Frédéric Péters
78c4a5f640
misc: use print as function ( #36515 )
2019-11-19 15:48:07 +01:00
Frédéric Péters
210409896d
tests: add check for user_label migration ( #34179 )
2019-06-20 22:19:42 +02:00
Thomas NOËL
447368ea95
sql: add evo.who on evolution update ( #31472 )
2019-04-23 09:43:59 +02:00
Frédéric Péters
4f6895a7b1
misc: add evolution messages to fulltext search ( #22651 )
2019-01-17 09:55:53 +01:00
Thomas NOËL
ce94b90179
do not add an evolution on static jump ( #22236 )
2018-05-16 13:47:30 +02:00
Thomas NOËL
3961764ac9
sql: delay re-index operations on first cron ( #22383 )
2018-04-20 14:38:32 +02:00
Thomas NOËL
0b56cd640e
tests: use sql_mode publisher creation in test_sql
2018-04-20 14:38:25 +02:00
Thomas NOËL
f724295485
sql: make select a possible iterator ( #23305 )
2018-04-20 13:59:55 +02:00
Frédéric Péters
b5293358bf
sql: add indexes on formdata id in evolution tables ( #22234 )
2018-03-14 14:44:20 +01:00
Frédéric Péters
def9802431
sql: unaccent strings for full text search ( #9112 )
2018-01-02 14:52:21 +01:00
Frédéric Péters
c3be61b8d1
formdef: add internal identifier attribute, separated from url_name ( #15663 )
...
This will allow changing url name behaviour without impacting on storage
matters.
2017-07-31 10:40:25 +02:00
Frédéric Péters
c754ac53bc
sql: add possibility to drop formdef table ( #17524 )
2017-07-17 15:33:05 +02:00
Frédéric Péters
b52dbf27f2
sql: get varchar/text values as unicode ( #15802 )
...
This matches what's being done in Django and will help integrating
w.c.s. with Django applications.
2017-06-26 17:57:03 +02:00
Frédéric Péters
1f1ebe035f
general: search for users without looking at accents ( #13061 )
2017-04-05 17:03:28 +02:00
Thomas NOËL
8aad054330
sql: create new id for new formdef ( #15662 )
2017-04-03 13:21:25 +02:00
Frédéric Péters
e385356263
sql: add geolocation to views ( #14784 )
2017-03-01 13:23:11 +01:00
Frédéric Péters
1fa7d23494
sql: add support for empty list in (Not)Contains criteria ( #14392 )
2016-12-21 10:14:11 +01:00
Frédéric Péters
c0ac1fe543
sql: add user name to fulltext index ( #13524 )
2016-10-21 14:46:24 +02:00
Frédéric Péters
611fdf3cbb
sql: drop materialized view support ( #12534 )
...
It's no longer necessary as requests on wcs_all_forms are now as fast.
2016-07-13 10:24:54 +02:00
Frédéric Péters
1aa890c826
sql: store computed last_update_time in table ( #12534 )
...
Even with indices the last_updatet_ime subselect are too slow for the global
view and statistics.
2016-07-13 10:24:54 +02:00
Frédéric Péters
ce9a73f690
general: add geolocation to formdata ( #10581 )
2016-05-04 09:42:43 +02:00
Frédéric Péters
17f0bca426
backoffice: add a channel filter to global listing ( #10504 )
2016-04-13 14:48:29 +02:00
Frédéric Péters
ba9827f31f
general: add handling of criticality levels ( #10134 )
2016-03-10 17:31:55 +01:00
Frédéric Péters
0be2bc1a9f
sql: fix postgresql version number comparisons
2016-03-04 17:30:01 +01:00
Frédéric Péters
98ae3b0581
sql: use materialized views if available, for statistics ( #9553 )
2016-03-04 15:27:19 +01:00
Frédéric Péters
f1e59b2bc3
sql: expose backoffice_submission into views ( #9767 )
2016-02-04 15:13:29 +01:00
Frédéric Péters
d1cb3060bf
tests: fix typo in field insertion in sql migration tests
2016-01-04 08:39:14 +01:00
Frédéric Péters
bab79fef2b
sql: remove formdef references from global views after formdef removal ( #8979 )
2015-11-23 17:27:26 +01:00
Frédéric Péters
ab17cc81cb
sql: add a criteria to do full text matching ( #8974 )
2015-11-13 16:34:45 +01:00
Frédéric Péters
e80b23ea15
sql: add fts column to users table ( #8973 )
2015-11-13 16:34:45 +01:00
Frédéric Péters
11fdd4cea0
backoffice: make global listing sortable ( #8542 )
2015-11-10 15:46:38 +01:00
Frédéric Péters
7c5f54ea9f
formdata: move submission channel to its own attribute ( #8888 )
2015-11-10 15:46:35 +01:00
Frédéric Péters
5954e10d37
sql: add a "last_update_time" column to views ( #8886 )
2015-11-05 19:06:36 +01:00
Frédéric Péters
ff4b2c152c
formdata: add actions_roles index ( #8281 )
2015-09-22 16:52:07 +02:00
Frédéric Péters
1c20613197
sql: add a way to select() over different formdefs ( #8179 )
2015-09-22 16:52:07 +02:00
Frédéric Péters
2b41e9e1da
sql: add fts column to aggregation views ( #7926 )
2015-08-31 13:44:04 +02:00
Frédéric Péters
fb32cc5f38
sql: add concerned_roles and is_at_endpoint columns to views ( #7925 )
2015-08-31 13:44:03 +02:00
Frédéric Péters
a634a69265
sql: make sure all formdef have up-to-date tables ( #7034 )
2015-04-27 18:24:51 +02:00
Frédéric Péters
cbab6a94ed
sql: don't set highest sql level when creating meta table in migrations ( #7034 )
2015-04-27 18:24:51 +02:00
Frédéric Péters
929c40d7d5
sql: migrate views on startup ( #6877 )
...
This introduces a "SQL level" to sql.py, that should be bumped whenever
incompatible SQL changes have to be run at startup, it relies on a new
key/value table (wcs_meta) to hold the database current sql level.
2015-04-23 11:04:08 +02:00
Frédéric Péters
0b455795ed
sql: add method to load evolutions in batch ( #7015 )
2015-04-22 17:11:43 +02:00
Frédéric Péters
f19d6b9375
misc: factor check for postgresql usage
2015-03-23 08:35:34 +01:00
Frédéric Péters
c4e4e839ca
tests: use new parametrized mode to run tracking code tests ( #6598 )
2015-03-04 07:41:38 +01:00
Frédéric Péters
402e6f65fb
general: add tracking code object ( #656 )
2015-02-24 14:13:16 +01:00
Frédéric Péters
2f93ab70c6
tests: don't mess with sys.modules, to avoid sideeffects
2014-12-27 17:30:48 +01:00
Thomas NOËL
0325eab1c8
tests: mark sql test_count as requiring postgresql
2014-12-26 13:23:04 +01:00
Frédéric Péters
afad4d33d8
tests: regroup common functions into an utility module
2014-12-24 11:44:11 +01:00
Frédéric Péters
c47ac9a487
storage, sql: add ILike criteria ( #6191 )
2014-12-24 08:50:48 +01:00