{"url":"https://api.github.com/repos/simonw/sqlite-utils/issues/596","repository_url":"https://api.github.com/repos/simonw/sqlite-utils","labels_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/596/labels{/name}","comments_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/596/comments","events_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/596/events","html_url":"https://github.com/simonw/sqlite-utils/pull/596","id":1919296686,"node_id":"PR_kwDOCGYnMM5bifPC","number":596,"title":"Fixes mapping for time fields related to mysql, closes #522","user":{"login":"nezhar","id":4420927,"node_id":"MDQ6VXNlcjQ0MjA5Mjc=","avatar_url":"https://avatars.githubusercontent.com/u/4420927?v=4","gravatar_id":"","url":"https://api.github.com/users/nezhar","html_url":"https://github.com/nezhar","followers_url":"https://api.github.com/users/nezhar/followers","following_url":"https://api.github.com/users/nezhar/following{/other_user}","gists_url":"https://api.github.com/users/nezhar/gists{/gist_id}","starred_url":"https://api.github.com/users/nezhar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nezhar/subscriptions","organizations_url":"https://api.github.com/users/nezhar/orgs","repos_url":"https://api.github.com/users/nezhar/repos","events_url":"https://api.github.com/users/nezhar/events{/privacy}","received_events_url":"https://api.github.com/users/nezhar/received_events","type":"User","user_view_type":"public","site_admin":false},"labels":[],"state":"closed","locked":false,"assignees":[],"milestone":null,"comments":1,"created_at":"2023-09-29T13:41:48Z","updated_at":"2023-11-04T00:49:50Z","closed_at":"2023-11-04T00:49:50Z","assignee":null,"author_association":"CONTRIBUTOR","active_lock_reason":null,"draft":false,"pull_request":{"url":"https://api.github.com/repos/simonw/sqlite-utils/pulls/596","html_url":"https://github.com/simonw/sqlite-utils/pull/596","diff_url":"https://github.com/simonw/sqlite-utils/pull/596.diff","patch_url":"https://github.com/simonw/sqlite-utils/pull/596.patch","merged_at":"2023-11-04T00:49:50Z"},"body":"Adds `COLUMN_TYPE_MAPPING` for `TIME` fields that are mapped as `datetime.timedelta` for MySQL and json represantation for `datetime.timedelta` in order to fix #522\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation preview :books:: https://sqlite-utils--596.org.readthedocs.build/en/596/\n\r\n<!-- readthedocs-preview sqlite-utils end -->","closed_by":{"login":"simonw","id":9599,"node_id":"MDQ6VXNlcjk1OTk=","avatar_url":"https://avatars.githubusercontent.com/u/9599?v=4","gravatar_id":"","url":"https://api.github.com/users/simonw","html_url":"https://github.com/simonw","followers_url":"https://api.github.com/users/simonw/followers","following_url":"https://api.github.com/users/simonw/following{/other_user}","gists_url":"https://api.github.com/users/simonw/gists{/gist_id}","starred_url":"https://api.github.com/users/simonw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simonw/subscriptions","organizations_url":"https://api.github.com/users/simonw/orgs","repos_url":"https://api.github.com/users/simonw/repos","events_url":"https://api.github.com/users/simonw/events{/privacy}","received_events_url":"https://api.github.com/users/simonw/received_events","type":"User","user_view_type":"public","site_admin":false},"reactions":{"url":"https://api.github.com/repos/simonw/sqlite-utils/issues/596/reactions","total_count":0,"+1":0,"-1":0,"laugh":0,"hooray":0,"confused":0,"heart":0,"rocket":0,"eyes":0},"timeline_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/596/timeline","performed_via_github_app":null,"state_reason":null}