Leo Hemsted 8ea09be1ff order the insert/update by created_at ...

you should always order by when doing a limit/offset, to guarantee that
the second time you run that query, the order hasn't changed and you
aren't just repeating the task with an overlap of notifications.
Luckily, in this case we haven't lost any data, because:

* we have an on conflict do update statement so when we returned
  duplicate rows it would just do an update
* when we delete, we cross-reference with the notification history so if
  a row always got missed, we won't delete it.

This resulted in, for example, govuk email still having a handful of
notifications in the table from 9th despite the task running succesfully
every day until the 18th of march.

order by created_at ascending so that we start with oldest notifications
first, in case it's interrupted part way through.

2020-03-20 19:11:24 +00:00

..

__init__.py

…

annual_billing_dao.py

add transactional wrapper

2019-12-04 15:26:26 +00:00

api_key_dao.py

…

complaint_dao.py

…

daily_sorted_letter_dao.py

…

dao_utils.py

remove error log from dao_utils

2020-02-20 12:09:18 +00:00

date_util.py

use dates rather than datetimes when comparing with bst_date

2019-09-02 11:56:56 +01:00

email_branding_dao.py

…

events_dao.py

…

fact_billing_dao.py

Fix bug on organisation-usage page.

2020-02-27 13:52:02 +00:00

fact_notification_status_dao.py

Add statsd annotations for the fact table queries.

2020-02-18 14:33:17 +00:00

inbound_numbers_dao.py

…

inbound_sms_dao.py

Do nothing on db conflict

2019-12-24 09:39:06 +00:00

invited_org_user_dao.py

…

invited_user_dao.py

…

jobs_dao.py

Update the dao_get_notification_outcomes_for_job to return the stats from either the notification table or the ft_notification_status table.

2019-12-30 16:17:00 +00:00

letter_branding_dao.py

…

notifications_dao.py

order the insert/update by created_at

2020-03-20 19:11:24 +00:00

organisation_dao.py

Only return the usage data for live services.

2020-02-24 14:23:05 +00:00

permissions_dao.py

…

provider_details_dao.py

refactor shared functionality from provider priority logic

2019-12-13 10:03:23 +00:00

provider_rates_dao.py

…

returned_letters_dao.py

Rename method to be clear it’s recent-only

2020-03-05 11:10:32 +00:00

service_callback_api_dao.py

…

service_contact_list_dao.py

Endpoint to return a ServiceContactList for a given id.

2020-03-13 17:21:59 +00:00

service_data_retention_dao.py

…

service_email_reply_to_dao.py

…

service_inbound_api_dao.py

…

service_letter_contact_dao.py

Let services have no default letter contact blocks

2019-07-22 10:40:18 +01:00

service_permissions_dao.py

…

service_sms_sender_dao.py

…

service_user_dao.py

…

service_whitelist_dao.py

…

services_dao.py

Give new services the upload letters permission

2020-02-25 14:03:43 +00:00

template_folder_dao.py

…

templates_dao.py

Add endpoint for getting / creating a hidden template

2019-09-12 09:56:10 +01:00

uploads_dao.py

Finding only jobs and letters within data retention works and tested

2020-03-10 15:53:56 +00:00

users_dao.py

Add email_access_valdiated_at field to user table, populate it

2020-01-30 14:51:54 +00:00