|  | Commit message (Collapse) | Author | Age | Lines | 
|---|
| | 
| 
| 
| 
| 
| | Previously we were using some sort of borrowed token, but it
seems to not be working anymore for local sessions, so let's
just get rid of it. | 
| | |  | 
| | 
| 
| 
| 
| | Here we're getting rid of all filtering and search functionality
on the backend. We'll be handling this on the client-side from now on. | 
| | |  | 
| |\ |  | 
| | |\ |  | 
| | | | |  | 
| | | | |  | 
| | | | |  | 
| | | | |  | 
| | | | |  | 
| | | | |  | 
| | |/ |  | 
| | | 
| | 
| | | Migration 59 populated the filters table with regex filters, some of which were faulty because the `\b` character wasn't escaped. This is fixed in this PR by making all patterns raw strings. | 
| | |\ |  | 
| | | | 
| | | 
| | | 
| | | | Thanks to a recent database maintenance (https://pythondiscord.freshstatus.io/incident/139811) querying out metricity message data is far cheaper. So there is no longer a reason to only fetch blocks if the member has a low message count. | 
| | | | 
| | | 
| | | 
| | | 
| | | 
| | | | This was changed due to performance reasons, but after some tweaking in the database, such as increasing work memory and adding an index, this query runs much faster now.
To test this, I want to revert this change, so that we can stop the materialised view from refreshing, to see if the act of refreshing is what's causing this query to seem faster when runing against the database. | 
| | | | |  | 
| | |\| |  | 
| | | |\ |  | 
| | | | | |  | 
| | | |/  
| | |   
| | |   
| | |   
| | |   
| | | | We have added a new view to metricity that will keep track of an approximate message count, updating every 10 seconds.
By doing this, we avoid running a query against the whole message table every time we want to get a user's messages. | 
| | | | 
| | | 
| | | 
| | | 
| | | | From now on the signal will only get executed after the Role has been deleted
The commit also introduces minor changes in the tests of roles | 
| | | | |  | 
| | | | 
| | | 
| | | 
| | | | Create a test that checks if a role gets deleted it will also get unassigned from the user | 
| | | | 
| | | 
| | | 
| | | 
| | | | Add a signal to the api app that automatically unassigns
deleted roles from users that have them | 
| | | |\ |  | 
| | | | |\ |  | 
| | | | | | |  | 
| | | | | | |  | 
| | | | | | |  | 
| | | | | | |  | 
| | | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | | Previously this query would convert each row to an array just to check if it matched or not. By changing EXCLUDE_CHANNELS to a tuple instead of a list, it doesn't get passed as an array, so we can do a simple NOT IN check.
This will also allow us to add an index with this condition to speed it up further. | 
| | | | | | |  | 
| | | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | | We only actually care that thee key:value pairs are equal, the order of them isn't actually important.
The naming of `assertCountEqual` is a little misleading, since it actually tests that the first sequence contains the same elements as second, regardless of their order. See https://docs.python.org/3/library/unittest.html#unittest.TestCase.assertCountEqual | 
| | | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | | We only truly care about how many activity blocks a user has when they have a small number of messages, as we only use this for the voice gate.
If a user has more than say 1k messages, then we really don't need to calculate their activity blocks, as it's quite an expensive query with many messages. | 
| | | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | | Adds a new filter list for URLs which should be treated as
redirects and unfurled.
Signed-off-by: Hassan Abouelela <[email protected]> | 
| | | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | | Adds an integer field to reminders, to keep track of how many failed
attempts at delivering the reminder were made.
Updates documentation and serialization.
Signed-off-by: Hassan Abouelela <[email protected]> | 
| | | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | | Dynamically adds static HTML redirects for static builds.
Signed-off-by: Hassan Abouelela <[email protected]> | 
| | | | | | |  | 
| | | | |/  
| | |/|   
| | | |   
| | | |   
| | | |   
| | | |   
| | | | | - Add newlines so it's not a big unfriendly paragraph
- Fix gitpod workspace link
- Clarification on terminal commands
- Clarification on test server and bot
- Add links for that ^ and for environment variables | 
| | | | | |  | 
| | | | | |  | 
| | | | | |  | 
| | | | | |  | 
| | | | | |  | 
| | |\| | |  | 
| | | | | |  | 
| | | |\ \ |  | 
| | | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | 
| | | | | | Fixes a test that fails on Windows due to differing path separators.
This is currently the only failing test.
Signed-off-by: Hassan Abouelela <[email protected]> |