{"action":"created","issue":{"url":"https://api.github.com/repos/EMSL-MSC/pacifica-metadata/issues/44","repository_url":"https://api.github.com/repos/EMSL-MSC/pacifica-metadata","labels_url":"https://api.github.com/repos/EMSL-MSC/pacifica-metadata/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/EMSL-MSC/pacifica-metadata/issues/44/comments","events_url":"https://api.github.com/repos/EMSL-MSC/pacifica-metadata/issues/44/events","html_url":"https://github.com/EMSL-MSC/pacifica-metadata/issues/44","id":182403264,"number":44,"title":"'deleted' field not defaulting to NULL","user":{"login":"kauberry","id":10720978,"avatar_url":"https://avatars.githubusercontent.com/u/10720978?v=3","gravatar_id":"","url":"https://api.github.com/users/kauberry","html_url":"https://github.com/kauberry","followers_url":"https://api.github.com/users/kauberry/followers","following_url":"https://api.github.com/users/kauberry/following{/other_user}","gists_url":"https://api.github.com/users/kauberry/gists{/gist_id}","starred_url":"https://api.github.com/users/kauberry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kauberry/subscriptions","organizations_url":"https://api.github.com/users/kauberry/orgs","repos_url":"https://api.github.com/users/kauberry/repos","events_url":"https://api.github.com/users/kauberry/events{/privacy}","received_events_url":"https://api.github.com/users/kauberry/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-11T23:56:42Z","updated_at":"2016-10-12T21:14:16Z","closed_at":null,"body":"When inserting values through the REST interface, something is causing the 'deleted' value to be populated with a value that looks suspiciously like an epoch of 0 (zero, that is), instead of a NULL.\r\n\r\n    id      created              updated               deleted              first_name   last_name  network_id   encoding\r\n    43751\t2016-10-11 23:11:51  2016-10-11 23:11:51   1970-01-01 00:00:00\tKen          Auberry\td3k857       UTF8\r\n\r\nI looked around for something obvious, but I'm missing it. It's not the database proper, but rather in the actual query that is going across the wire.\r\n\r\n    INSERT INTO \"users\" (\r\n        \"id\", \"created\", \"updated\", \"deleted\", \"first_name\",\r\n        \"middle_initial\", \"last_name\", \"network_id\",\r\n        \"email_address\", \"encoding\") \r\n    VALUES (\r\n        43751, '2016-10-11T23:11:51'::timestamp,\r\n        '2016-10-11T23:11:51'::timestamp, '1970-01-01T00:00:00'::timestamp,\r\n        'Ken', '', 'Auberry', 'd3k857', '', 'UTF8') RETURNING \"id\"\r\n\r\nThoughts??"},"comment":{"url":"https://api.github.com/repos/EMSL-MSC/pacifica-metadata/issues/comments/253341282","html_url":"https://github.com/EMSL-MSC/pacifica-metadata/issues/44#issuecomment-253341282","issue_url":"https://api.github.com/repos/EMSL-MSC/pacifica-metadata/issues/44","id":253341282,"user":{"login":"dmlb2000","id":1504962,"avatar_url":"https://avatars.githubusercontent.com/u/1504962?v=3","gravatar_id":"","url":"https://api.github.com/users/dmlb2000","html_url":"https://github.com/dmlb2000","followers_url":"https://api.github.com/users/dmlb2000/followers","following_url":"https://api.github.com/users/dmlb2000/following{/other_user}","gists_url":"https://api.github.com/users/dmlb2000/gists{/gist_id}","starred_url":"https://api.github.com/users/dmlb2000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dmlb2000/subscriptions","organizations_url":"https://api.github.com/users/dmlb2000/orgs","repos_url":"https://api.github.com/users/dmlb2000/repos","events_url":"https://api.github.com/users/dmlb2000/events{/privacy}","received_events_url":"https://api.github.com/users/dmlb2000/received_events","type":"User","site_admin":false},"created_at":"2016-10-12T21:14:16Z","updated_at":"2016-10-12T21:14:16Z","body":"It seems like we need to change line 73 and line 94 that need to be changed to set deleted to None instead of datetime of 0 in the metadata.rest.orm. We should also add some testing to validate this behaviour... add query for stuff deleted and query for stuff not deleted and validate both sides..."}}
{"actor":{"display_login":"dmlb2000"}}