{"action":"created","issue":{"url":"https://api.github.com/repos/rr-/szurubooru/issues/202","repository_url":"https://api.github.com/repos/rr-/szurubooru","labels_url":"https://api.github.com/repos/rr-/szurubooru/issues/202/labels{/name}","comments_url":"https://api.github.com/repos/rr-/szurubooru/issues/202/comments","events_url":"https://api.github.com/repos/rr-/szurubooru/issues/202/events","html_url":"https://github.com/rr-/szurubooru/pull/202","id":362829707,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE3NDQxMjUw","number":202,"title":"New flag: check sound","user":{"login":"sgsunder","id":16943235,"node_id":"MDQ6VXNlcjE2OTQzMjM1","avatar_url":"https://avatars2.githubusercontent.com/u/16943235?v=4","gravatar_id":"","url":"https://api.github.com/users/sgsunder","html_url":"https://github.com/sgsunder","followers_url":"https://api.github.com/users/sgsunder/followers","following_url":"https://api.github.com/users/sgsunder/following{/other_user}","gists_url":"https://api.github.com/users/sgsunder/gists{/gist_id}","starred_url":"https://api.github.com/users/sgsunder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgsunder/subscriptions","organizations_url":"https://api.github.com/users/sgsunder/orgs","repos_url":"https://api.github.com/users/sgsunder/repos","events_url":"https://api.github.com/users/sgsunder/events{/privacy}","received_events_url":"https://api.github.com/users/sgsunder/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-09-22T05:58:51Z","updated_at":"2018-09-22T14:43:36Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/rr-/szurubooru/pulls/202","html_url":"https://github.com/rr-/szurubooru/pull/202","diff_url":"https://github.com/rr-/szurubooru/pull/202.diff","patch_url":"https://github.com/rr-/szurubooru/pull/202.patch"},"body":"A lot GIF-like video loops (GFYs or whatever people usually call them) on the internet nowadays come with sound. This allows users to add a sound flag to video posts so that others can know if a post has sound before playing a clip.\r\n\r\nFirst commit enables a sound flag on the backend, shows if it's present in the post view, and allows for setting during upload and post edit.\r\n\r\nSecond commit allows for flags to be searched, with `flag:sound` and `flag:loop`. The best way to do this was to migrate the flags column in the post table from PickleType/binary to varchar, stored as a comma delimited list. This allows for the column to be queried easily (I'm not sure if it's even possible to query a PickleType in SQLAlchemy, as I can't find any documentation or examples) and also has the side benefit of being human-readable.\r\n\r\nLooking through the commit history, I'm not exactly sure why PickleType was used in the first place, so I'm not sure if I'm losing any capabilities with this change."},"comment":{"url":"https://api.github.com/repos/rr-/szurubooru/issues/comments/423748897","html_url":"https://github.com/rr-/szurubooru/pull/202#issuecomment-423748897","issue_url":"https://api.github.com/repos/rr-/szurubooru/issues/202","id":423748897,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMzc0ODg5Nw==","user":{"login":"sgsunder","id":16943235,"node_id":"MDQ6VXNlcjE2OTQzMjM1","avatar_url":"https://avatars2.githubusercontent.com/u/16943235?v=4","gravatar_id":"","url":"https://api.github.com/users/sgsunder","html_url":"https://github.com/sgsunder","followers_url":"https://api.github.com/users/sgsunder/followers","following_url":"https://api.github.com/users/sgsunder/following{/other_user}","gists_url":"https://api.github.com/users/sgsunder/gists{/gist_id}","starred_url":"https://api.github.com/users/sgsunder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgsunder/subscriptions","organizations_url":"https://api.github.com/users/sgsunder/orgs","repos_url":"https://api.github.com/users/sgsunder/repos","events_url":"https://api.github.com/users/sgsunder/events{/privacy}","received_events_url":"https://api.github.com/users/sgsunder/received_events","type":"User","site_admin":false},"created_at":"2018-09-22T14:43:36Z","updated_at":"2018-09-22T14:43:36Z","author_association":"CONTRIBUTOR","body":"Post edit view:\r\n<img width=\"1212\" alt=\"edit\" src=\"https://user-images.githubusercontent.com/16943235/45918379-31647e80-be54-11e8-9128-5fb5278acc78.png\">\r\nPost upload view:\r\n<img width=\"1212\" alt=\"upload\" src=\"https://user-images.githubusercontent.com/16943235/45918380-31647e80-be54-11e8-874e-6e40fcb93b55.png\">\r\nPost view:\r\n<img width=\"1212\" alt=\"view\" src=\"https://user-images.githubusercontent.com/16943235/45918381-31647e80-be54-11e8-94eb-baadbeb9103e.png\">\r\n"}}
{"actor":{"display_login":"sgsunder"}}