- Oct 02, 2018
-
- Sep 27, 2018
-
-
-
Jan Mach authored
(Redmine issue: #4307)
-
- Sep 26, 2018
-
- Sep 25, 2018
-
-
Jan Mach authored
Previously the enrichment plugin reload was hardcoded in a way, that during the reload a brand new instance of the plugin was created, which resulted in discarding of the internal state of the plugin. For some use cases this was not appropriate. The plugin reload event is now implemented differently, so the insternal state is kept. (Redmine issue: #4262)
- Sep 21, 2018
-
-
Jan Mach authored
I have added prototype periodical anomaly detection scripts created by Pavel Kácha into Mentat package. So far these are just simple shell scripts intended to be executed periodically via cron that will simply use the PSQL utility to query database and send the result via email. Possible improvements might be to envelope these into Mentat script to make use of common configurations. (Redmine issue: #4222)
-
- Sep 20, 2018
-
-
Jan Mach authored
Our database specialist pointed out, that currently the distinct value calculations for event table columns result in heavy paralel sequential scans. This is because the data model is optimized for efficiency and we are using as few relations and joins as possible for best performance. This means our event data model is flat and there are no tables containing common values like categories etc. The drawback if this approach is, that for retrieving column value enumerations the queries are very, very resource consuming. These results are used "only" for things like generating select boxes containing possible values in the web interface. These queries are executed periodically and they can load the database for tens of seconds, which is does not make sense in comparison with the use cases. Therefore we have decided to implement optimalization mechanism, that will cleverly precalculate the lists into separate tables and fetching it then will be a matter fraction of a second. (Redmine issue: #4252)
-
Jan Mach authored
It was possible for the reporter to attach files of any size to the report. The MTA then complained for the message being too big and refused to mail it. Now it is possible for each group co configure maximal attachment size limit (defaults to 10MB). Attachment files exceeding this limit will not be added to the report and user will be informed in the email text to download it from the server. (Redmine issue: #4232)
-
Jan Mach authored
With future improvements of database schema there must be a mechanism for performing database migrations. Problem is we have two databases, one accesed via SQLAlchemy and the second directly via Psycopg2. I have selected to use Flask-Migrate plugin built on top of Alembic to perform metadata database migrations. (Redmine issue: #4230)
-
- Sep 18, 2018
-
-
Jan Mach authored
Previous revision f3c669ae did not fully resolve the issue with incorrect pager links. It was necessary to implement generic mechanism for storing information about which fields can contain multiple values directly in the form object. I have used static class method to solve this issue. (Redmine issue: #4090)
-
Jan Mach authored
(Redmine issue: #3387)
- Sep 17, 2018
-
-
Jan Mach authored
-
- Sep 14, 2018
-
-
Jan Mach authored
* Divided dashboard panels into separate tabs (users, groups, filters, settings) * Added more hopefully usefull info panels for users and groups * Added panels for reporting settings * Added icon for reporting settings module * Translated newly added strings into czech language (Redmine issue: #4221)
-
- Sep 11, 2018
- Sep 07, 2018
-
-
Jan Mach authored
According to the recommendation of our database specialist the event table watchdog query was rewritten for better performance. New approach makes better use of database and results in better database query plan and procesing time. More detail on the issue in appropriate Redmine ticket. (Redmine issue: #4100)