summary refs log tree commit diff
path: root/synapse/storage/event_push_actions.py (follow)
Commit message (Collapse)AuthorAgeFilesLines
* User Cursor.__iter__ instead of fetchallErik Johnston2017-03-231-1/+1
| | | | This prevents unnecessary construction of lists
* Remove lock from rotate notifsErik Johnston2017-02-221-3/+0
|
* Store looping callErik Johnston2017-02-211-1/+3
|
* Fix up notif rotationErik Johnston2017-02-181-14/+22
|
* CommentErik Johnston2017-02-161-1/+4
|
* CommentErik Johnston2017-02-161-7/+14
|
* Store the default push actions in a more efficient mannerErik Johnston2017-02-161-11/+40
|
* Less aggressive timersErik Johnston2017-02-141-2/+2
|
* Aggregate event push actionsErik Johnston2017-02-141-57/+210
|
* Be more agressive about purging old room event_push_actionsErik Johnston2017-02-011-3/+8
|
* CommentErik Johnston2016-11-231-1/+3
|
* More efficient notif count queriesErik Johnston2016-11-231-8/+31
|
* Remove where clauseErik Johnston2016-09-121-1/+0
|
* Add WHERE clause support to index creationErik Johnston2016-09-121-1/+2
|
* Change the index to be stream_ordering, highlightErik Johnston2016-09-121-1/+1
|
* Remove unused importErik Johnston2016-09-121-1/+0
|
* Use register_background_index_updateErik Johnston2016-09-121-24/+4
|
* Add back in query changeErik Johnston2016-09-121-1/+3
|
* Merge branch 'develop' of github.com:matrix-org/synapse into ↵Erik Johnston2016-09-121-3/+1
|\ | | | | | | erikj/make_notif_highlight_query_fast
| * Revert "Add index to event_push_actions"Erik Johnston2016-09-121-3/+1
| |
* | Make reindex happen in bgErik Johnston2016-09-121-0/+30
|/
* Merge remote-tracking branch 'origin/develop' into ↵David Baker2016-09-091-1/+1
|\ | | | | | | dbkr/make_notif_highlight_query_fast
| * Merge pull request #1081 from matrix-org/dbkr/notifications_only_highlightMatthew Hodgson2016-09-091-1/+8
| |\ | | | | | | Implement `only=highlight` on `/notifications`
| * | Fix /notifications API when used with `from` paramDavid Baker2016-09-081-1/+1
| | |
* | | Add index to event_push_actionsDavid Baker2016-09-091-1/+3
| |/ |/| | | | | | | | | and remove room_id caluse so it uses it Mostly from @negativemjark
* | Implement `only=highlight` on `/notifications`David Baker2016-09-081-1/+8
|/
* Merge branch 'develop' into dbkr/notifications_apiMatthew Hodgson2016-08-201-1/+1
|\
| * Remove lru optionErik Johnston2016-08-191-1/+1
| |
* | Merge remote-tracking branch 'origin/develop' into dbkr/notifications_apiDavid Baker2016-08-111-42/+188
|\|
| * Fix SQL to supply arguments in the same orderMark Haines2016-07-291-1/+1
| |
| * Create separate methods for getting messages to pushMark Haines2016-07-281-45/+154
| | | | | | | | | | | | | | | | | | | | | | for the email and http pushers rather than trying to make a single method that will work with their conflicting requirements. The http pusher needs to get the messages in ascending stream order, and doesn't want to miss a message. The email pusher needs to get the messages in descending timestamp order, and doesn't mind if it misses messages.
| * Comment get_unread_push_actions_for_user_in_range functionKegan Dougal2016-07-281-2/+26
| |
| * Use true/false for boolean parameter inclusive to avoid potential for sqli, ↵Mark Haines2016-07-051-1/+1
| | | | | | | | and possibly make the code clearer
| * Use different SQL for postgres and sqlite3 for when using multicolumn indexesMark Haines2016-07-041-9/+9
| |
| * Actually we need to order these properlyDavid Baker2016-06-221-2/+12
| | | | | | | | otherwise we'll end up returning the wrong 20
| * StyleDavid Baker2016-06-221-1/+1
| |
| * Put most recent 20 messages in notifDavid Baker2016-06-221-3/+4
| | | | | | | | Fixes https://github.com/vector-im/vector-web/issues/1648
| * Limit number of notifications in an email notificationDavid Baker2016-06-011-2/+4
| |
* | Include the ts the notif was received atDavid Baker2016-05-241-5/+7
| |
* | Add GET /notifications APIDavid Baker2016-05-231-0/+28
|/
* Remove debug loggingDavid Baker2016-05-231-1/+0
|
* Oops, missing commaDavid Baker2016-05-201-1/+1
|
* Remove stale lineDavid Baker2016-05-201-2/+0
|
* Handle empty events tableDavid Baker2016-05-201-0/+3
|
* Make deleting push actions more efficientDavid Baker2016-05-201-12/+59
| | | | There's no index on received_ts, so manually binary search using the stream_ordering index, and only update it once an hour.
* Only delete push actions after 30 daysDavid Baker2016-05-201-5/+37
|
* Merge pull request #769 from matrix-org/erikj/push_actions_deleteErik Johnston2016-05-131-0/+12
|\ | | | | Delete old pushers
| * Delete old pushersErik Johnston2016-05-031-0/+12
| |
* | Correct SQL statement for postgresDavid Baker2016-05-041-2/+3
| | | | | | | | In standard sql, join binds tighter than comma, so we were joining on the wrong table. Postgres follows the standard (apparently).
* | Remove unused functionDavid Baker2016-04-291-22/+0
| |
* | Use explicit joinDavid Baker2016-04-291-3/+3
| |
* | Oops, actually specify the user idDavid Baker2016-04-291-1/+3
| |
* | Remove unnecessary ifDavid Baker2016-04-291-1/+1
| |
* | Put spaces at start of lineDavid Baker2016-04-291-16/+16
| |
* | Send a rather basic email notifDavid Baker2016-04-201-1/+0
| | | | | | | | Also pep8 fixes
* | First bits of emailpusherDavid Baker2016-04-191-7/+50
|/ | | | Mostly logic of when to send an email
* Fix query for get_unread_push_actions_for_user_in_rangeErik Johnston2016-04-141-1/+2
|
* pep8David Baker2016-04-131-1/+1
|
* Only return unread notificationsDavid Baker2016-04-131-9/+50
| | | | Make get_unread_push_actions_for_user_in_range only return unread event actions, being more true to its name. Done in two separate sql queries to get actions after a read receipt and those in a room wiht no receipt at all. SQL queries by Erik.
* Oops, inequality failDavid Baker2016-04-071-1/+1
|
* pep8David Baker2016-04-061-1/+1
|
* Make pushers use the event_push_actions table instead of listening on an ↵David Baker2016-04-061-0/+48
| | | | | | | event stream & running the rules again. Sytest passes, but remaining to do: * Make badges work again * Remove old, unused code
* Use google style doc strings.Mark Haines2016-04-011-2/+3
| | | | | | | pycharm supports them so there is no need to use the other format. Might as well convert the existing strings to reduce the risk of people accidentally cargo culting the wrong doc string format.
* Bump get_unread_event_push_actions_by_room_for_user cacheErik Johnston2016-03-221-1/+1
|
* Remove dead code for setting device specific rules.Mark Haines2016-02-181-4/+3
| | | | | | It wasn't possible to hit the code from the API because of a typo in parsing the request path. Since no-one was using the feature we might as well remove the dead code.
* Rename functionsErik Johnston2016-02-101-2/+2
|
* Atomically persit push actions when we persist the eventErik Johnston2016-02-091-29/+16
|
* Actually return something sensibleErik Johnston2016-02-031-1/+1
|
* We return dicts now.Erik Johnston2016-02-031-1/+1
|
* Change event_push_actions_rm_tokens schemaErik Johnston2016-02-031-15/+32
|
* Make LRU cache not default to treecache & add options to use itDavid Baker2016-01-221-1/+1
|
* Use new invalidate_many cache invalidation to invalidate the ↵David Baker2016-01-221-4/+15
| | | | event_push_actions cache appropriately.
* Cache get_unread_event_push_actions_by_room_for_userErik Johnston2016-01-211-1/+2
|
* Return highlight_count in /syncErik Johnston2016-01-191-2/+3
|
* Remove the PushersTable and EventPushActionsTable objectsMark Haines2016-01-121-5/+1
|
* Delete notifications for redacted eventsDavid Baker2016-01-061-0/+12
|
* Add is_guest flag to users db to track whether a user is a guest user or ↵David Baker2016-01-061-2/+2
| | | | not. Use this so we can run _filter_events_for_client when calculating event_push_actions.
* = not == in sqlDavid Baker2016-01-041-1/+1
|
* Rename event-actions to event_push_actions as per PR requestDavid Baker2016-01-041-0/+98