11 Commits (master)

Author	SHA1	Message	Date
Rene Krenn	42730fb359	TT#44404 datatables refactoring for large tables ... while limiting the count queries is sufficient for basic queries, a plethora of perfromance cosniderations arise when running compound queries (queries with set operations) against large tables. this is the particular case with the call history UI. + multi-column search must not hit any un-indexed column. when limit is providied, it seems ok for the optimizer even when no appropriate multi-col index is present. + 'col LIKE "%xyz%"' must be turned to 'col LIKE "xyz%"' - otherwise and idnex is useless. if fulltextsearch is desired, this needs to be done separately, including all the pain of maintaining the keyword/substring index etc. + each partial query of a compound query must have a LIMIT clause. if not, the db tends to try building an intermediate table (which gets large -> slow). this is the only option when sorting, but it must be prevent if only displaying unsorted or filtered rows. BIx::Class::Helper::ResultSet::SetOperations generates malformend SQL when limiting the partial queries. Therefore, the generated SQL will therefore be parsed and patched. + considering the LIMIT for the partial queries, it is also mandatory to inject the filter/joins to each. this is done properly by ReseultSet::SetOperations; but needs to be done explicitly when building compound queries. + aggregation footers must be prevented when clipped - it wont show useful data (sum, count, ..) anyway. + prevent page query when count gives 0 + prevent 'int_column = "12345678901"' search terms: literal must be numeric and not longer than the digits supported by the column (10) + implement * wildcard and strict_search Change-Id: Ie256877d368747ad6bfe74f5b6ac5dae88be9e58	7 years ago
Rene Krenn	f5117d3746	TT#44451 change e164 elements from PosInteger to Text ... Change-Id: I827c218a18ccb14b76fee1dfdce5ec562b47a82d	7 years ago
Gerhard Jungwirth	20a201581a	TT#37222 fix some perlcritic errors ValuesAndExpressions::ProhibitCommaSeparatedStatements ... this is to clean the Sipwise TAP tests for this repo Change-Id: I6761369e039070f9726a276f39792dae6e37138a	7 years ago
Andreas Granig	9b9a2ddb5b	TT#21050 Add length check to E164 number ... The DB has lengths of 4, 7 and 31 for cc, ac and sn, respectively. Instead of letting the DB fail and cause a 500, check the length properly upfront. Also make use of cc/ac/sn_regex from config.yml to allow narrowing down the format by the operator. Change-Id: Ie738177f7942454054c37bf8be66ab01cfe05ad5	7 years ago
Michael Prokop	12234e584d	TT#22411 Fix spelling mistakes/typos ... s/Diffrent/Different/ s/If it mathes/If it matches/ s/addreses/addresses/ s/altough/although/ s/autenticate/authenticate/ s/curently/currently/ s/dont't/don't/ s/dont/don't/ s/existance/existence/ s/explicitely/explicitly/ s/in in/in/ s/lenght/length/ s/neccessary/necessary/ s/occured/occurred/ s/occurence/occurrence/ s/packge/package/ s/paramters/parameters/ s/perfomed/performed/ s/propery/property/ s/recieve/receive/ s/reponse/response/ s/sematical/semantical/ s/serie /series / s/than than/than/ s/the the/the/ s/underun/underrun/ s/wether/whether/ s/wihout/without/ NOTE: Ignoring stuff in share/static + debian/changelog though Change-Id: I90fe718c92582eedf9325d2df3c3280f5f25afd7	8 years ago
Irina Peshinskaya	f1971bfcdd	TT#8680 Consider E164 empty fields ... Change-Id: I7accdbfc3421eb0fb94e3d9533a87c5489462bed	8 years ago
Gerhard Jungwirth	029765d8a5	MT#17473 allow single numbers in alias range field ... by setting the length to 0 or undef Change-Id: Ide65d6a0c6be635cdd51b569dd3f913fb52cf2bb	9 years ago
Andreas Granig	04a64e1493	MT#16465 partly remove namespace::sweep and others ... Remove namespace::sweep Remove MooseX stuff Remove perl5i Remove Moose where possible Change-Id: I4f873afb466f4e58a04c3304ff74df2185470b03	10 years ago
Andreas Granig	2f749a341a	MT#3933 API: add subscriber editing via PUT/PATCH	11 years ago
Andreas Granig	52ea49a1bc	MT#4967 Fix invalid "has label" statement. ... The label is in the form, not in the field. It leads to an exception at least.	12 years ago
Gerhard Jungwirth	d238758abc	MT#4967 Refactor Subscriber Forms ... Move Field e164 (Compound) and alias_number (Repeatable) to own Files because of multiple occurence.	12 years ago