kobotoolbox / kpi / 13836959059

push

github

feat(attachments): add date_created and date_modified fields to Attachment model TASK-1533 (#5576)

### 🗒️ Checklist

1. [X] run linter locally
2. [X] update all related docs (API, README, inline, etc.), if any
3. [X] draft PR with a title `<type>(<scope>)<!>: <title> TASK-1234`
4. [X] tag PR: at least `frontend` or `backend` unless it's global
5. [X] fill in the template below and delete template comments
6. [X] review thyself: read the diff and repro the preview as written
7. [X] open PR & confirm that CI passes
8. [X] request reviewers, if needed
9. [ ] delete this section before merging

### 👀 Preview steps
1. Check out the kobocat database: `./manage.py dbshell --database
kobocat`
2. Look at the attachment table: `\d logger_attachment`
3. Verify that the Attachment table has the new fields:
```
                                     Table "public.logger_attachment"
       Column        |           Type           | Collation | Nullable |             Default              
---------------------+--------------------------+-----------+----------+----------------------------------
 id                  | integer                  |           | not null | generated by default as identity
 media_file          | character varying(380)   |           | not null | 
 mimetype            | character varying(100)   |           | not null | 
 instance_id         | integer                  |           | not null | 
 media_file_basename | character varying(260)   |           |          | 
 media_file_size     | integer                  |           |          | 
 deleted_at          | timestamp with time zone |           |          | 
 user_id             | integer                  |           |          | 
 xform_id            | integer                  |           |          | 
 date_created        | timestamp with time zone |           |          | 
 date_modified       | timestamp with time zone |           |          | 
Indexes:
    "logger_attachment_pkey" PRIMAR... (continued)

6002 of 9546 branches covered (62.87%)

4 of 4 new or added lines in 1 file covered. (100.0%)

22896 of 28325 relevant lines covered (80.83%)

0.81 hits per line