534 Commits

Author	SHA1	Message	Date
Frédéric Péters	2de770338e	sql: initialize search tokens data asynchronously (#90237)	2024-05-02 14:06:35 +02:00
Pierre Ducroquet	cb806c6b61	sql: implement new FTS for cards (#86903)	2024-05-02 14:06:21 +02:00
Valentin Deniaud	5497197478	applification: add test users (#89640)	2024-04-29 16:52:41 +02:00
Valentin Deniaud	e11bf0e9ff	sql: add class to manipulate test users (#89640)	2024-04-29 16:52:41 +02:00
Valentin Deniaud	51fa01ccd1	admin: add snashots of test users (#89640)	2024-04-29 16:46:44 +02:00
Frédéric Péters	27125f9830	sql: add indexes (#89988)	2024-04-29 16:21:20 +02:00
Pierre Ducroquet	f2bc14827b	wcs_search_tokens: new FTS mechanism with fuzzy-match (#86527) ... introduce a new mechanism to implement FTS with fuzzy-match. This is made possible by adding and maintaining a table of the FTS tokens, wcs_search_tokens, fed with searchable_formdefs and wcs_all_forms. When a query is issued, its tokens are matched against the tokens with a fuzzy match when no direct match is found, and the query is then rebuilt.	2024-04-29 08:53:53 +02:00
Frédéric Péters	cc0f8dda1c	cron: log basic resource usage summary (#89037)	2024-04-26 15:23:58 +02:00
Valentin Deniaud	fa60aba429	testdef: add snapshots (#88755)	2024-04-15 10:59:27 +02:00
Valentin Deniaud	310fb84f0f	sql: exclude test users by default from select (#88951)	2024-04-08 12:03:44 +02:00
Valentin Deniaud	ec19de0756	sql: create test users for existing tests (#88951)	2024-04-08 12:03:44 +02:00
Valentin Deniaud	dd5e34097d	admin: use test users instead of real users (#88951)	2024-04-08 12:03:44 +02:00
Valentin Deniaud	bd33723448	sql: add test_uuid column to users table (#88951)	2024-04-08 12:03:44 +02:00
Frédéric Péters	575fe5a4fa	sql: do not update relations on new cards (#89030)	2024-04-03 16:33:52 +02:00
Frédéric Péters	df99864ada	misc: only update related objects if digest has changed (#89018)	2024-04-03 14:54:58 +02:00
Frédéric Péters	1c2314f9a7	sql: check card/formdef tables integrity (#78196)	2024-04-02 09:46:25 +02:00
Frédéric Péters	781e4e4c52	sql: update wcs_all_forms category column on category change (#87800)	2024-03-29 14:24:05 +01:00
Frédéric Péters	69249df789	misc: do not allow storing AnyFormData objects (#88338)	2024-03-20 17:07:33 +01:00
Benjamin Dauvergne	2d619766b7	sql: normalize phonenumbers in fts index (#76875) ... * restricted to values of less than 30 characters * indexed with weight 'D' to decrease the score compared to field with the phonenumber validation	2024-03-15 10:27:48 +01:00
Frédéric Péters	96af0663eb	general: store/display error context stack (#74791)	2024-03-15 07:38:23 +01:00
Frédéric Péters	c77812450b	cards: update related cards/forms on digest change (#68427)	2024-03-15 07:21:51 +01:00
Frédéric Péters	658aff404e	backoffice: support existing criteria when filtering statistics (#87909)	2024-03-08 11:07:18 +01:00
Valentin Deniaud	8d709bcc10	testdef: add clean job to remove old test results (#87214)	2024-02-26 10:17:41 +01:00
Frédéric Péters	7d045d44af	sql: update timestamptz migration to not reindex data (#86917)	2024-02-13 16:32:10 +01:00
Frédéric Péters	f77806433f	sql: pass itersize from select to select_iterator (#86913)	2024-02-13 14:16:57 +01:00
Valentin Deniaud	3a3ed59748	admin: add context to workflow test error (#83593)	2024-02-13 11:08:03 +01:00
Valentin Deniaud	31d3c64c58	admin: allow setting agent in workflow tests (#83593)	2024-02-13 11:08:03 +01:00
Valentin Deniaud	1bc4855675	testdef: remove slug field (#86587)	2024-02-13 10:30:11 +01:00
Pierre Ducroquet	a41e90ac59	sql: properly mark sqlindexes as done (#86868)	2024-02-12 17:04:13 +01:00
Frédéric Péters	bd34baa1ab	sql: fix dropping of form views (#86873)	2024-02-12 16:36:08 +01:00
Frédéric Péters	e45dd098b3	formdata: store datetimes with timezone (#52057)	2024-02-12 14:26:22 +01:00
Emmanuel Cazenave	71ba4dbce0	formdata: add a page_id attribute (#85091)	2024-02-09 15:55:40 +01:00
Valentin Deniaud	cddae1547e	backoffice: support not_in criteria when filtering statistics (#86299)	2024-01-30 15:58:36 +01:00
Frédéric Péters	8b5c92fcc8	backoffice: use dedicated SQL query to get resolution times (#7107)	2024-01-29 12:11:37 +01:00
Frédéric Péters	d54ecd3731	misc: always create translation messages table (#86143)	2024-01-26 09:45:37 +01:00
Frédéric Péters	8da0f623ba	sql: redo and add more indexes to wcs_all_forms (#85108)	2024-01-26 08:45:38 +01:00
Frédéric Péters	e49a789201	sql: add more indexes (#85108)	2024-01-26 08:45:38 +01:00
Frédéric Péters	3395128ad6	sql: create indexes concurrently, after migrations (#85108)	2024-01-26 08:45:38 +01:00
Frédéric Péters	7863fa9186	sql: move all index creation to their own classmethods (#85108)	2024-01-26 08:45:38 +01:00
Frédéric Péters	71e53e6769	sql: redo formdata indexes with f-strings (#85108)	2024-01-26 08:45:38 +01:00
Frédéric Péters	e8f414abba	sql: move formdata fts index creation with others (#85108)	2024-01-26 08:45:38 +01:00
Frédéric Péters	bf180b0398	sql: consider instant transitions when computing resolution times (#86006)	2024-01-26 08:44:50 +01:00
Frédéric Péters	089d83d67e	misc: rewrite resolution time list comprehension for readability (#86006)	2024-01-26 08:44:50 +01:00
Frédéric Péters	0fa880a657	sql: check id are ascii digits (#85678)	2024-01-16 09:36:24 +01:00
Frédéric Péters	9ae6feb07e	fields: add support for numeric fields with decimal values in blocks (#84713)	2024-01-08 12:58:14 +01:00
Frédéric Péters	64871ff2b2	sql: run "add index on carddata/id_display" migration (#85348)	2024-01-08 12:56:12 +01:00
Frédéric Péters	a29effa254	sql: make cron status handling atomic (#84847)	2024-01-07 16:18:16 +01:00
Frédéric Péters	f8077830fa	sql: only update user in global forms table if name has changed (#85082)	2023-12-22 15:26:34 +01:00
Valentin Deniaud	78d64f0b04	statistics: aggregate resolution times with sql (#81734)	2023-11-30 16:14:11 +01:00
Frédéric Péters	0d33387f0f	misc: allow setting a custom id template on cards (#44604)	2023-11-28 08:59:36 +01:00