summary refs log tree commit diff
path: root/synapse/storage (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Cache check_host_in_roomErik Johnston2016-08-261-0/+35
|
* Make sync not pull out full stateErik Johnston2016-08-251-0/+33
|
* Add descErik Johnston2016-08-251-1/+2
|
* Replace context.current_state with context.current_state_idsErik Johnston2016-08-253-16/+66
|
* Pull out event ids rather than full events for stateErik Johnston2016-08-251-17/+38
|
* Preserve some logcontextsErik Johnston2016-08-242-9/+13
|
* Merge pull request #1038 from matrix-org/erikj/receved_txn_purgeErik Johnston2016-08-232-4/+45
|\ | | | | Delete old received_transactions rows
| * Delete old received_transactionsErik Johnston2016-08-222-4/+45
| |
* | Merge pull request #1028 from matrix-org/dbkr/notifications_apiErik Johnston2016-08-222-0/+55
|\ \ | |/ |/| Add the Notifications API
| * Merge branch 'develop' into dbkr/notifications_apiMatthew Hodgson2016-08-208-11/+70
| |\
| * | Explicit joinDavid Baker2016-08-181-2/+2
| | |
| * | Merge remote-tracking branch 'origin/develop' into dbkr/notifications_apiDavid Baker2016-08-1812-164/+382
| |\ \
| * \ \ Merge remote-tracking branch 'origin/develop' into dbkr/notifications_apiDavid Baker2016-08-1138-657/+1984
| |\ \ \
| * | | | Include the ts the notif was received atDavid Baker2016-05-241-5/+7
| | | | |
| * | | | Add GET /notifications APIDavid Baker2016-05-232-0/+53
| | | | |
* | | | | Merge pull request #1031 from matrix-org/erikj/measure_notifierErik Johnston2016-08-221-40/+42
|\ \ \ \ \ | |_|_|_|/ |/| | | | Add more Measure blocks
| * | | | Move defer.returnValue out of MeasureErik Johnston2016-08-191-1/+1
| | | | |
| * | | | Measure _get_event_from_rowErik Johnston2016-08-191-41/+43
| | | | |
* | | | | Merge pull request #1030 from matrix-org/erikj/cache_contextsErik Johnston2016-08-197-9/+65
|\ \ \ \ \ | |/ / / / |/| | | | Add concept of cache contexts
| * | | | Rename to on_invalidateErik Johnston2016-08-191-3/+3
| | | | |
| * | | | Make cache_context an explicit optionErik Johnston2016-08-191-1/+1
| | | | |
| * | | | Move _bulk_get_push_rules_for_room to storage layerErik Johnston2016-08-191-0/+56
| | | | |
| * | | | Remove lru optionErik Johnston2016-08-197-9/+9
| | |_|/ | |/| |
* / | | Make get_new_events_for_appservice use indicesErik Johnston2016-08-191-2/+5
|/ / /
* | | Add appservice workerErik Johnston2016-08-182-85/+93
| | |
* | | Make AppserviceHandler stream events from databaseErik Johnston2016-08-182-0/+62
| | | | | | | | | | | | | | | | | | | | | | | | | | | This is for two reasons: 1. Suppresses duplicates correctly, as the notifier doesn't do any duplicate suppression. 2. Makes it easier to connect the AppserviceHandler to the replication stream.
* | | Fix push_display_name_rename schema updateErik Johnston2016-08-171-0/+3
| | |
* | | Merge pull request #1011 from matrix-org/dbkr/contains_display_name_overrideDavid Baker2016-08-171-0/+17
|\ \ \ | | | | | | | | Move display name rule
| * | | Add migration scriptDavid Baker2016-08-161-0/+17
| | | | | | | | | | | | | | | | To port existing rule actions & enable entries to the new name
* | | | Do it in storage functionErik Johnston2016-08-161-0/+3
|/ / /
* | | Merge pull request #1010 from matrix-org/erikj/refactor_deletionsErik Johnston2016-08-162-38/+33
|\ \ \ | | | | | | | | Refactor user_delete_access_tokens. Invalidate get_user_by_access_token to slaves.
| * | | Use cached get_user_by_access_token in slavesErik Johnston2016-08-161-0/+1
| | | |
| * | | Refactor user_delete_access_tokens. Invalidate get_user_by_access_token to ↵Erik Johnston2016-08-151-38/+32
| | | | | | | | | | | | | | | | slaves.
* | | | Merge branch 'fix_integrity_retry' of https://github.com/Ralith/synapse into ↵Erik Johnston2016-08-161-1/+2
|\ \ \ \ | |/ / / |/| | | | | | | Ralith-fix_integrity_retry
| * | | Add missing database corruption recovery caseBenjamin Saunders2016-08-141-1/+2
| | |/ | |/| | | | | | | Signed-off-by: Benjamin Saunders <ben.e.saunders@gmail.com>
* | | Doc get_next() context manager usageErik Johnston2016-08-151-0/+4
| | |
* | | Rename table. Add docs.Erik Johnston2016-08-153-5/+15
| | |
* | | Implement cache replication streamErik Johnston2016-08-152-15/+43
| | |
* | | Add some invalidations to a cache_streamErik Johnston2016-08-157-31/+117
| | |
* | | Always run txn.after_callbacksErik Johnston2016-08-151-7/+8
|/ /
* | Raise 404 when couldn't find eventErik Johnston2016-08-051-1/+1
| |
* | Delete more tablesErik Johnston2016-08-051-0/+5
| |
* | Tweak integrity error recovery to work as intendedBenjamin Saunders2016-08-041-0/+3
| |
* | Fix typoErik Johnston2016-08-041-3/+4
| |
* | Retry event persistence on IntegrityErrorErik Johnston2016-08-041-4/+65
| | | | | | | | | | | | | | | | | | | | Due to a bug in the porting script some backfilled events were not correctly persisted, causing irrecoverable IntegrityErrors on future attempts to persist those events. This commit adds a retry mechanism invoked upon IntegrityError, where when retried the tables are purged for all references to the events being persisted.
* | PEP8Richard van der Hoff2016-08-031-10/+10
| |
* | Include device name in /keys/query responseRichard van der Hoff2016-08-031-17/+43
| | | | | | | | Add an 'unsigned' section which includes the device display name.
* | Merge branch 'rav/null_default_device_displayname' into developRichard van der Hoff2016-08-032-1/+21
|\ \
| * | Default device_display_name to nullRichard van der Hoff2016-08-032-1/+21
| | | | | | | | | | | | | | | | | | It turns out that it's more useful to return a null device display name (and let clients decide how to handle it: eg, falling back to device_id) than using a constant string like "unknown device".
* | | Remove other bit of deduplicationErik Johnston2016-08-031-19/+0
| | |
* | | Ensure we only persist an event once at a timeErik Johnston2016-08-031-1/+18
|/ /
* | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/fed_readerErik Johnston2016-07-2912-120/+552
|\ \
| * | 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
| | |
| * | Merge pull request #956 from matrix-org/rav/check_device_id_on_key_uploadRichard van der Hoff2016-07-272-0/+34
| |\ \ | | | | | | | | Make the device id on e2e key upload optional
| | * | SQL syntax fixRichard van der Hoff2016-07-271-1/+1
| | | |
| | * | Delete e2e keys on device deleteRichard van der Hoff2016-07-271-0/+15
| | | |
| | * | Make the device id on e2e key upload optionalRichard van der Hoff2016-07-261-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | We should now be able to get our device_id from the access_token, so the device_id on the upload request is optional. Where it is supplied, we should check that it matches. For active access_tokens without an associated device_id, we ought to register the device in the devices table. Also update the table on upgrade so that all of the existing e2e keys are associated with real devices.
| * | | Fix a couple of bugs in the transaction and keyring codeMark Haines2016-07-261-1/+2
| |/ /
| * | Fix typoRichard van der Hoff2016-07-261-1/+1
| | |
| * | Merge branch 'develop' into rav/delete_refreshtoken_on_delete_deviceRichard van der Hoff2016-07-261-50/+110
| |\ \
| | * \ Merge pull request #948 from matrix-org/markjh/auth_fixesMark Haines2016-07-261-50/+110
| | |\ \ | | | | | | | | | | Don't add rejections to the state_group, persist all rejections
| | | * | Fix how push_actions are redacted.Mark Haines2016-07-261-8/+10
| | | | |
| | | * | Don't add rejected events if we've seen them befrore. Add some comments to ↵Mark Haines2016-07-261-5/+48
| | | | | | | | | | | | | | | | | | | | explain what the code is doing mechanically
| | | * | Only update the events and event_json tables for rejected eventsMark Haines2016-07-252-52/+63
| | | | |
| | | * | Don't add the events to forward extremities if the event is rejectedMark Haines2016-07-251-3/+6
| | | | |
| | | * | Don't add rejections to the state_group, persist all rejectionsMark Haines2016-07-252-5/+6
| | | | |
| * | | | Delete refresh tokens when deleting devicesRichard van der Hoff2016-07-261-13/+45
| |/ / /
| * | | Implement updating devicesRichard van der Hoff2016-07-261-1/+26
| | | | | | | | | | | | | | | | You can update the displayname of devices now.
| * | | Implement deleting devicesRichard van der Hoff2016-07-264-4/+71
| |/ /
| * | fix: defer.returnValue takes one argumentMark Haines2016-07-251-1/+1
| | |
| * | background updates: fix assert againRichard van der Hoff2016-07-251-1/+1
| | |
| * | background updates: Fix assertion to do somethingRichard van der Hoff2016-07-251-2/+2
| | |
| * | Fix background_update testsRichard van der Hoff2016-07-251-7/+20
| | | | | | | | | | | | | | | | | | A bit of a cleanup for background_updates, and make sure that the real background updates have run before we start the unit tests, so that they don't interfere with the tests.
| * | PEP8Richard van der Hoff2016-07-221-1/+0
| | |
| * | Create index on user_ips in the backgroundRichard van der Hoff2016-07-223-12/+80
| | | | | | | | | | | | | | | | | | | | | | | | user_ips is kinda big, so really we want to add the index in the background once we're running. Replace the schema delta with one which will do that. I've done this in a way that's reasonably easy to reuse as there a few other indexes I need, and I don't suppose they will be the last.
* | | Add more key storage funcs into slave storeErik Johnston2016-07-281-18/+16
| | |
* | | Split out a FederationReader processErik Johnston2016-07-211-0/+4
|/ /
* | storage/client_ips: remove some dead codeRichard van der Hoff2016-07-211-3/+0
| |
* | Merge branch 'develop' into rav/get_devices_apiRichard van der Hoff2016-07-201-1/+2
|\ \ | | | | | | | | | (pick up PR #938 in the hope of fixing the UTs)
| * | Record device_id in client_ipsRichard van der Hoff2016-07-201-1/+2
| | | | | | | | | | | | | | | Record the device_id when we add a client ip; it's somewhat redundant as we could get it via the access_token, but it will make querying rather easier.
* | | GET /devices endpointRichard van der Hoff2016-07-203-1/+109
|/ / | | | | | | | | | | | | implement a GET /devices endpoint which lists all of the user's devices. It also returns the last IP where we saw that device, so there is some dancing to fish that out of the user_ips table.
* | More doc-commentsRichard van der Hoff2016-07-201-7/+12
| | | | | | | | Fix some more comments on some things
* | Merge pull request #932 from matrix-org/rav/register_refactorDavid Baker2016-07-201-2/+4
|\ \ | | | | | | Further registration refactoring
| * | Further registration refactoringRichard van der Hoff2016-07-191-2/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * `RegistrationHandler.appservice_register` no longer issues an access token: instead it is left for the caller to do it. (There are two of these, one in `synapse/rest/client/v1/register.py`, which now simply calls `AuthHandler.issue_access_token`, and the other in `synapse/rest/client/v2_alpha/register.py`, which is covered below). * In `synapse/rest/client/v2_alpha/register.py`, move the generation of access_tokens into `_create_registration_details`. This means that the normal flow no longer needs to call `AuthHandler.issue_access_token`; the shared-secret flow can tell `RegistrationHandler.register` not to generate a token; and the appservice flow continues to work despite the above change.
* | | Merge pull request #922 from matrix-org/erikj/file_api2Erik Johnston2016-07-203-1/+197
|\ \ \ | |/ / |/| | Feature: Add filter to /messages. Add 'contains_url' to filter.
| * | CommentErik Johnston2016-07-201-0/+4
| | |
| * | Add support for filters in paginate_room_eventsErik Johnston2016-07-141-1/+51
| | |
| * | Add sender and contains_url field to events tableErik Johnston2016-07-142-0/+142
| | |
* | | schema fixRichard van der Hoff2016-07-191-1/+1
| | | | | | | | | | | | device_id should be text, not bigint.
* | | Add device_id support to /loginRichard van der Hoff2016-07-185-10/+135
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add a 'devices' table to the storage, as well as a 'device_id' column to refresh_tokens. Allow the client to pass a device_id, and initial_device_display_name, to /login. If login is successful, then register the device in the devices table if it wasn't known already. If no device_id was supplied, make one up. Associate the device_id with the access token and refresh token, so that we can get at it again later. Ensure that the device_id is copied from the refresh token to the access_token when the token is refreshed.
* | | Fix /purge_history bugErik Johnston2016-07-151-19/+15
| | | | | | | | | | | | This was caused by trying to insert duplicate backward extremeties
* | | Pull out min stream_ordering from ex_outlier_streamErik Johnston2016-07-151-1/+2
| | |
* | | event_backwards_extremeties may not be emptyErik Johnston2016-07-151-1/+11
|/ /
* | Add a comment explaining allow_noneMark Haines2016-07-081-0/+2
| |
* | Ensure that the guest user is in the database when upgrading accountsMark Haines2016-07-081-0/+13
| |
* | Merge branch 'master' of github.com:matrix-org/synapse into developErik Johnston2016-07-083-3/+14
|\ \
| * \ Merge pull request #886 from matrix-org/markjh/async_commitMark Haines2016-06-293-3/+14
| |\ \ | | | | | | | | Optionally make committing to postgres asynchronous.
| | * | Optionally make committing to postgres asynchronous.Mark Haines2016-06-203-3/+14
| | | | | | | | | | | | | | | | | | | | Useful when running tests when you don't care whether the server will lose data that it claims that it has committed.
* | | | CommentErik Johnston2016-07-071-0/+3
| | | |
* | | | Return 400 rather than 500Erik Johnston2016-07-071-1/+4
| | | |
* | | | Add rest servlet. Fix SQL.Erik Johnston2016-07-061-5/+4
| | | |
* | | | Merge branch 'erikj/shared_secret' into erikj/test2Erik Johnston2016-07-063-83/+131
|\ \ \ \
| * | | | Remove spurious txnErik Johnston2016-07-051-9/+0
| | | | |
| * | | | Fix for postgresErik Johnston2016-07-051-2/+2
| | | | |
| * | | | Add an admin option to shared secret registrationErik Johnston2016-07-051-23/+38
| | | | |
| * | | | Fix typoMark Haines2016-07-051-1/+1
| | | | |
| * | | | Make get_events_around more efficient on sqlite3Mark Haines2016-07-051-13/+49
| | | | |
| * | | | Use true/false for boolean parameter inclusive to avoid potential for sqli, ↵Mark Haines2016-07-052-5/+7
| | | | | | | | | | | | | | | | | | | | and possibly make the code clearer
| * | | | Use different SQL for postgres and sqlite3 for when using multicolumn indexesMark Haines2016-07-042-59/+59
| | | | |
| * | | | Use a query that postgresql optimises better for get_events_aroundMark Haines2016-07-041-12/+16
| | | | |
* | | | | Add ReadWriteLock for pagination and history pruneErik Johnston2016-07-051-2/+2
| | | | |
* | | | | Add purge_history APIErik Johnston2016-07-051-0/+6
| | | | |
* | | | | Add storage function to purge history for a roomErik Johnston2016-07-041-0/+140
|/ / / /
* | | | Feature: Add deactivate account admin APIErik Johnston2016-06-302-0/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Allows server admins to "deactivate" accounts, which: - Revokes all access tokens - Removes all threepids - Removes password The API is a POST to `/admin/deactivate/<user_id>`
* | | | Implement purge_media_cache admin APIErik Johnston2016-06-291-0/+29
| | | |
* | | | Track approximate last access time for remote mediaErik Johnston2016-06-293-1/+47
| | | |
* | | | more pep8David Baker2016-06-241-1/+0
| | | |
* | | | Use similar naming we use in email notifs for pushDavid Baker2016-06-242-50/+0
| | | | | | | | | | | | | | | | Fixes https://github.com/vector-im/vector-web/issues/1654
* | | | 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
* | | Add the create_profile method back since the tests use itMark Haines2016-06-171-0/+6
| | |
* | | Remove registered_users from the distributor.Mark Haines2016-06-172-9/+14
|/ / | | | | | | | | | | | | | | | | | | The only place that was observed was to set the profile. I've made it so that the profile is set within store.register in the same transaction that creates the user. This required some slight changes to the registration code for upgrading guest users, since it previously relied on the distributor swallowing errors if the profile already existed.
* | Don't hit DB for noop replications queriesErik Johnston2016-06-084-0/+12
| |
* | Remove dead code.Mark Haines2016-06-071-7/+0
| | | | | | | | | | | | | | | | | | | | | | Loading push rules now happens in the datastore, so we can remove the methods that loaded them outside the datastore. The ``waiting_for_join_list`` in federation handler is populated by anything, so can be removed. The ``_get_members_events_txn`` method isn't called from anywhere so can be removed.
* | Fix AS retries, but with correct orderingErik Johnston2016-06-071-2/+2
| |
* | Fix AS retriesErik Johnston2016-06-071-2/+2
| |
* | Merge pull request #841 from matrix-org/erikj/event_counterErik Johnston2016-06-061-0/+9
|\ \ | | | | | | Add metric counter for number of persisted events
| * | Add metric counter for number of persisted eventsErik Johnston2016-06-061-0/+9
| | |
* | | Add events to cache when we persist themErik Johnston2016-06-061-0/+41
|/ /
* | Don't rely on options when inserting event into cacheErik Johnston2016-06-031-40/+43
| |
* | Change the way we cache eventsErik Johnston2016-06-031-39/+41
| |
* | Remove event fetching from DB threadsErik Johnston2016-06-035-194/+74
| |
* | Move insert_client_ip to a separate classMark Haines2016-06-032-45/+71
| |
* | Merge pull request #828 from matrix-org/erikj/joined_hosts_for_roomErik Johnston2016-06-031-16/+3
|\ \ | | | | | | Make get_joined_hosts_for_room use get_users_in_room
| * | Make get_joined_hosts_for_room use get_users_in_roomErik Johnston2016-06-031-16/+3
| | |
* | | Merge pull request #825 from matrix-org/erikj/cache_push_rulesErik Johnston2016-06-032-2/+38
|\ \ \ | | | | | | | | Load push rules in storage layer so that they get cached
| * | | Load push rules in storage layer, so that they get cachedErik Johnston2016-06-031-1/+37
| | | |
| * | | Only get local usersErik Johnston2016-06-031-1/+1
| |/ /
* | | Merge pull request #824 from matrix-org/markjh/slaved_presence_storeMark Haines2016-06-031-3/+3
|\ \ \ | |/ / |/| | Add a slaved store for presence
| * | Add a slaved store for presenceMark Haines2016-06-031-3/+3
| | |
* | | Merge pull request #811 from matrix-org/erikj/state_users_in_roomErik Johnston2016-06-033-17/+27
|\ \ \ | | | | | | | | Use state to calculate get_users_in_room
| * | | Use state to calculate get_users_in_roomErik Johnston2016-06-013-17/+27
| | | |
* | | | Merge pull request #809 from matrix-org/erikj/cache_receipts_in_roomErik Johnston2016-06-031-0/+28
|\| | | | |/ / |/| | Add get_users_with_read_receipts_in_room cache
| * | Add get_users_with_read_receipts_in_room cacheErik Johnston2016-06-011-0/+28
| | |
* | | Fix setting the _clock in SQLBaseStoreMark Haines2016-06-021-0/+1
| | |
* | | Merge pull request #807 from matrix-org/erikj/push_rules_cacheErik Johnston2016-06-011-1/+2
|\ \ \ | | | | | | | | Ensure we always return boolean in push rules
| * | | Force booleanErik Johnston2016-05-311-1/+2
| | | |
* | | | Merge pull request #806 from matrix-org/erikj/hash_cacheErik Johnston2016-06-011-9/+16
|\ \ \ \ | | | | | | | | | | Cache get_event_reference_hashes
| * | | | Cache get_event_reference_hashesErik Johnston2016-05-311-9/+16
| | |/ / | |/| |
* | | | Limit number of notifications in an email notificationDavid Baker2016-06-011-2/+4
| | | |
* | | | Fix synapse/storage/schema/delta/30/as_users.pyMark Haines2016-05-311-2/+2
| | | |
* | | | Merge pull request #805 from matrix-org/erikj/push_rules_cacheErik Johnston2016-05-311-2/+8
|\ \ \ \ | | |/ / | |/| | Fix GET /push_rules
| * | | Fix typoErik Johnston2016-05-311-1/+1
| | | |
| * | | Change fixErik Johnston2016-05-311-2/+8
| |/ /
* | | Merge pull request #804 from matrix-org/erikj/push_rules_cacheErik Johnston2016-05-311-6/+10
|\| | | | | | | | Add caches to bulk_get_push_rules*
| * | Add caches to bulk_get_push_rules*Erik Johnston2016-05-311-6/+10
| | |
* | | Fix to allow start with postgresErik Johnston2016-05-271-2/+7
| |/ |/|
* | 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-203-13/+68
| | | | | | | | 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-202-6/+38
|/
* Add desc to get_presence_for_usersErik Johnston2016-05-181-0/+1
|
* Move the functions for parsing app service configMark Haines2016-05-171-102/+3
|
* get_room_members is unused nowMark Haines2016-05-161-18/+0
|
* Spell "domain" correctlyMark Haines2016-05-161-2/+2
| | | | s/domian/domain/g
* Allow receipts for events we haven't seen in the dbMark Haines2016-05-131-4/+6
|
* Merge pull request #778 from matrix-org/erikj/add_pusherErik Johnston2016-05-132-4/+17
|\ | | | | Fixup add_pusher
| * SpellingErik Johnston2016-05-131-1/+1
| |
| * Fixup add_pusherErik Johnston2016-05-132-4/+17
| |
* | Merge pull request #769 from matrix-org/erikj/push_actions_deleteErik Johnston2016-05-132-9/+29
|\ \ | | | | | | Delete old pushers
| * \ Merge branch 'develop' of github.com:matrix-org/synapse into ↵Erik Johnston2016-05-067-46/+210
| |\ \ | | | | | | | | | | | | erikj/push_actions_delete
| * | | Delete old pushersErik Johnston2016-05-032-9/+29
| | | |
* | | | Merge pull request #779 from matrix-org/erikj/receiptsErik Johnston2016-05-131-3/+3
|\ \ \ \ | | | | | | | | | | Use tree cache for get_linearized_receipts_for_room
| * | | | Use tree cache for get_linearized_receipts_for_roomErik Johnston2016-05-131-3/+3
| | |_|/ | |/| |
* | | | Remove topics tableErik Johnston2016-05-131-1/+0
| | | |
* | | | Annotate the removed indicies with why they were removed.Mark Haines2016-05-131-18/+15
| | | |
* | | | Remove unused indicesErik Johnston2016-05-131-0/+42
|/ / / | | | | | | | | | | | | This includes removing both unused indices and indices that are subsets of other indices.
* | | unbreak schemaMatrix2016-05-102-0/+0
| | |
* | | Merge pull request #759 from matrix-org/dbkr/email_notifsMatthew Hodgson2016-05-105-13/+104
|\ \ \ | | | | | | | | Send email notifications for missed messages
| * \ \ Merge remote-tracking branch 'origin/develop' into dbkr/email_notifsDavid Baker2016-05-1010-62/+364
| |\ \ \
| * | | | 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
| | | | |
| * | | | Merge remote-tracking branch 'origin/develop' into dbkr/email_notifsDavid Baker2016-04-298-12/+199
| |\ \ \ \ | | | |/ / | | |/| |
| * | | | Send a rather basic email notifDavid Baker2016-04-202-2/+1
| | | | | | | | | | | | | | | | | | | | Also pep8 fixes
| * | | | First bits of emailpusherDavid Baker2016-04-195-7/+118
| | | | | | | | | | | | | | | | | | | | Mostly logic of when to send an email
* | | | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/ignore_userErik Johnston2016-05-091-5/+2
|\ \ \ \ \ | | |_|/ / | |/| | |
| * | | | Merge pull request #773 from matrix-org/erikj/get_domian_from_idErik Johnston2016-05-091-5/+2
| |\ \ \ \ | | | | | | | | | | | | Add and use get_domain_from_id
| | * | | | Add and use get_domian_from_idErik Johnston2016-05-091-5/+2
| | | |_|/ | | |/| |
* | | | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/ignore_userErik Johnston2016-05-096-56/+317
|\| | | |
| * | | | Merge pull request #772 from matrix-org/erikj/get_user_cacheErik Johnston2016-05-091-0/+3
| |\ \ \ \ | | | | | | | | | | | | Add cache to get_user_by_id
| | * | | | Add cache to get_user_by_idErik Johnston2016-05-091-0/+3
| | |/ / /
| * | | | Remove unused importErik Johnston2016-05-061-1/+1
| | | | |
| * | | | Pull loop one level upErik Johnston2016-05-061-36/+41
| | | | |
| * | | | Queue events for persistenceErik Johnston2016-05-061-11/+144
| |/ / /
| * | | Pull prev txn from in memoryErik Johnston2016-05-061-5/+13
| | | |
| * | | Don't needlessly enter transactionErik Johnston2016-05-061-9/+9
| | | |
| * | | Reduce database inserts when sending transactionsErik Johnston2016-05-061-44/+113
| | | |
| * | | Add an openidish mechanism for proving to third parties that you own a given ↵Mark Haines2016-05-053-1/+44
| | | | | | | | | | | | | | | | user_id
* | | | Add bulk fetch storage APIErik Johnston2016-05-051-3/+22
| | | |
* | | | Merge branch 'develop' of github.com:matrix-org/synapse into erikj/ignore_userErik Johnston2016-05-044-1/+45
|\| | |
| * | | Add primary keyErik Johnston2016-05-041-1/+1
| | | |
| * | | Add timestamp and auto incrementing IDErik Johnston2016-05-043-1/+8
| | | |
| * | | Add /report endpointErik Johnston2016-05-043-1/+38
| | |/ | |/|
* / | Implement basic ignore userErik Johnston2016-05-041-0/+31
|/ /
* | Check that somethign has happend before running the selectsMark Haines2016-04-273-2/+14
| |
* | Simplify query and handle finishing correctlyErik Johnston2016-04-222-17/+16
| |
* | Order NULLs firstErik Johnston2016-04-212-5/+16
| |
* | Fix queryErik Johnston2016-04-211-2/+2
| |
* | Use special UPDATE syntaxErik Johnston2016-04-212-22/+14
| |
* | TypoErik Johnston2016-04-211-1/+1
| |
* | Need to do _background_update_progress_txn in actual transactionErik Johnston2016-04-211-6/+8
| |
* | Update progress when creating indexErik Johnston2016-04-211-0/+7
| |
* | Fix SQL statementErik Johnston2016-04-211-3/+3
| |
* | Create index must be on a connErik Johnston2016-04-211-6/+13
| |
* | Create index concurrentlyErik Johnston2016-04-212-6/+14
| |
* | Add missing run_upgradeErik Johnston2016-04-211-0/+4
| |
* | Optimise event_search in postgresErik Johnston2016-04-213-5/+137
| |
* | Add cache to _get_state_groups_from_groupsErik Johnston2016-04-191-3/+16
|/
* Add desc argErik Johnston2016-04-141-1/+5
|
* Add indexErik Johnston2016-04-141-0/+18
|
* 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.
* Merge pull request #716 from matrix-org/dbkr/get_pushersDavid Baker2016-04-121-14/+30
|\ | | | | Add get endpoint for pushers
| * UnneccessarywhitespaceisunnecessaryDavid Baker2016-04-121-1/+0
| |
| * Oops, forgot the desc.David Baker2016-04-121-1/+1
| |
| * Tidy up get_pusher functionsDavid Baker2016-04-121-32/+30
| | | | | | | | Decodes pushers rows on the main thread rather than the db thread and uses _simple_select_list. Also do the same to the function I copied and factor out the duplication into a helper function.
| * Mis-named functionDavid Baker2016-04-121-1/+1
| |
| * Add get endpoint for pushersDavid Baker2016-04-111-0/+19
| | | | | | | | As per https://github.com/matrix-org/matrix-doc/pull/308
* | Add back backfilled parameter that was removedErik Johnston2016-04-121-3/+4
| |
* | Check if we've already backfilled eventsErik Johnston2016-04-121-0/+16
|/
* Merge pull request #705 from matrix-org/dbkr/pushers_use_event_actionsDavid Baker2016-04-117-52/+209
|\ | | | | Change pushers to use the event_actions table
| * Fix invite pushesDavid Baker2016-04-081-0/+7
| | | | | | | | | | | | * If the event is an invite event, add the invitee to list of user we run push rules for (if they have a pusher etc) * Move invite_for_me to be higher prio than member events otherwise member events matches them * Spell override right
| * Literally a dictionaryDavid Baker2016-04-071-17/+17
| |
| * generate id in the main threadDavid Baker2016-04-071-3/+3
| |
| * Oops, inequality failDavid Baker2016-04-071-1/+1
| |
| * pep8David Baker2016-04-071-0/+1
| |
| * Fix port script for changes merged from developDavid Baker2016-04-071-1/+4
| |
| * Merge remote-tracking branch 'origin/develop' into ↵David Baker2016-04-0714-107/+91
| |\ | | | | | | | | | dbkr/pushers_use_event_actions
| * | Send badge count pushes.David Baker2016-04-071-3/+6
| | | | | | | | | | | | Also fix bugs with retrying.
| * | pep8David Baker2016-04-064-4/+8
| | |