{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":350637537,"defaultBranch":"main","name":"things.py","ownerLogin":"thingsapi","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-03-23T08:38:49.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/81222353?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1684784506.519216","currentOid":""},"activityList":{"items":[{"before":"30cfae9a7a673298332c6e9c040baf2b2c1f4f42","after":"854306777eda4802aaf56bf4452fad3bfb5242e4","ref":"refs/heads/main","pushedAt":"2024-01-12T15:07:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"e0218ca72a829fa623ca0d3ddbb5172b2709020c","after":"30cfae9a7a673298332c6e9c040baf2b2c1f4f42","ref":"refs/heads/main","pushedAt":"2024-01-12T15:07:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"Update README.md\n\nAdd things2md","shortMessageHtmlLink":"Update README.md"}},{"before":"ecabb9a22190665fbbd5aebcd229f6ffb426aa06","after":"e0218ca72a829fa623ca0d3ddbb5172b2709020c","ref":"refs/heads/main","pushedAt":"2023-08-12T10:35:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"b3fcedd5329c6c4072987fecfb06ea5f21596b7c","after":"ecabb9a22190665fbbd5aebcd229f6ffb426aa06","ref":"refs/heads/main","pushedAt":"2023-08-12T10:34:39.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"Add: Used by Things Review (#116)","shortMessageHtmlLink":"Add: Used by Things Review (#116)"}},{"before":"443dfada38212b1272b6302598c8bd30a22ef0a7","after":"b3fcedd5329c6c4072987fecfb06ea5f21596b7c","ref":"refs/heads/main","pushedAt":"2023-05-23T07:16:12.532Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"Update README.md\n\nAdd things-3-report to \"Used By\". Sort alphabetically.","shortMessageHtmlLink":"Update README.md"}},{"before":"f1b1a019ba2559fa43583caabb54abc139ac4931","after":"443dfada38212b1272b6302598c8bd30a22ef0a7","ref":"refs/heads/main","pushedAt":"2023-05-22T19:37:14.008Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"efb04939a52cc76a69d7570a4ec0d96aad57a21b","after":"f1b1a019ba2559fa43583caabb54abc139ac4931","ref":"refs/heads/main","pushedAt":"2023-05-22T19:36:20.565Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"minor cleanup (#114)\n\n* do not throw exception when DB does not exist\r\n* remove Scrutinizer\r\n* add ruff linter, add doctest coverage, remove lint\r\n* add pytest-cov","shortMessageHtmlLink":"minor cleanup (#114)"}},{"before":"dfba61b7d76c36637616fca95285967c287afaba","after":"efb04939a52cc76a69d7570a4ec0d96aad57a21b","ref":"refs/heads/main","pushedAt":"2023-05-22T15:39:45.993Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"5f4b94367aad7de8216f6b11f46711ab9a51c76c","after":"dfba61b7d76c36637616fca95285967c287afaba","ref":"refs/heads/main","pushedAt":"2023-05-22T15:38:58.335Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"fix typo in date validation; minor consistency fixes","shortMessageHtmlLink":"fix typo in date validation; minor consistency fixes"}},{"before":"9832b8ec99429513e92c7d3075d64fcbb74f35d7","after":"5f4b94367aad7de8216f6b11f46711ab9a51c76c","ref":"refs/heads/main","pushedAt":"2023-05-22T15:15:39.286Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"254937830c5dc0ca7c8030ad2051d3f8cb0991af","after":"9832b8ec99429513e92c7d3075d64fcbb74f35d7","ref":"refs/heads/main","pushedAt":"2023-05-22T15:14:44.333Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"Fix all tests (#112)\n\n* update DB to reflect test cases\r\n* add tests for new methods\r\n* fix (doc)test expectations\r\n* fix code style and lints\r\n* rename 'format' to 'printf' for backwards compatibility (see https://database.guide/sqlite-renames-printf-to-format/)\r\n* make tests less verbose\r\n* use CODECOV_TOKEN and do not fail if upload doesn't work","shortMessageHtmlLink":"Fix all tests (#112)"}},{"before":"13391c185e4fc0a9c3fb7ef2a70ebc5f31e4c910","after":"254937830c5dc0ca7c8030ad2051d3f8cb0991af","ref":"refs/heads/main","pushedAt":"2023-05-22T14:46:35.715Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"0296b3dd3a7812e76bbd17591d796f73ec6034a6","after":"13391c185e4fc0a9c3fb7ef2a70ebc5f31e4c910","ref":"refs/heads/main","pushedAt":"2023-05-22T14:45:41.418Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"Add support for exact date queries including optional operators.\n\nstart_date, stop_date, and deadline parameters now allow to pass\nISO 8601 dates with an optional operator. The input is converted\nto a \"Things date\" integer prior to running the SQL statement\nif it such a date column; otherwise regular UNIX Time is used.\n\nExamples:\n\n'2023-05-22'\n'<=2023-05-22'\n'>2023-05-22'\n\nIn SQL, depending on its column type, the parameter '<2023-05-22'\nis converted into\n\n deadline < 132602624\n\nor\n\n date(stopDate, 'unixepoch') < date('2023-05-22')\n\nSee also: #96 and https://github.com/thingsapi/things-cli/issues/9","shortMessageHtmlLink":"Add support for exact date queries including optional operators."}},{"before":"e64bea80c0b7c065dcc51c25744dbf5a9b7fcb60","after":"0296b3dd3a7812e76bbd17591d796f73ec6034a6","ref":"refs/heads/main","pushedAt":"2023-05-22T12:46:27.579Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"64ee9e1b1ab72adf69666a0195e76abb4d8b3267","after":"e64bea80c0b7c065dcc51c25744dbf5a9b7fcb60","ref":"refs/heads/main","pushedAt":"2023-05-22T12:45:31.759Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"Add support for the new Things integer dates. See #110 and #98.\n\nA _Things date_ is an integer where the binary digits are\nYYYYYYYYYYYMMMMDDDDD0000000; Y is year, M is month, and D is day.\n\nFor example, the ISO 8601 date '2021-03-28' corresponds to the Things\ndate 132464128 as integer; in binary that is:\n\n```\n111111001010011111000000000\nYYYYYYYYYYYMMMMDDDDD0000000\n 2021 3 28\n```","shortMessageHtmlLink":"Add support for the new Things integer dates. See #110 and #98."}},{"before":"c462dc1c283bafc26a1ca79b22e422ec1ff38bc3","after":"64ee9e1b1ab72adf69666a0195e76abb4d8b3267","ref":"refs/heads/main","pushedAt":"2023-05-21T23:25:06.105Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"e30d05db09991cdf50bf9c6dcbf923f48280e803","after":"c462dc1c283bafc26a1ca79b22e422ec1ff38bc3","ref":"refs/heads/main","pushedAt":"2023-05-21T23:24:21.901Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"code style (#109)","shortMessageHtmlLink":"code style (#109)"}},{"before":"3d18ff0972d20512f407518791d80075557c1180","after":"e30d05db09991cdf50bf9c6dcbf923f48280e803","ref":"refs/heads/main","pushedAt":"2023-05-21T23:18:17.691Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"7d8a7c6cbf2376a6ec6a98fee589149526e716e6","after":"3d18ff0972d20512f407518791d80075557c1180","ref":"refs/heads/main","pushedAt":"2023-05-21T23:17:10.978Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"find new database path - partly fixes #100 (#105)","shortMessageHtmlLink":"find new database path - partly fixes #100 (#105)"}},{"before":"66bb16f629b2c28b6c76cf71564fe802cb3c46b3","after":"7d8a7c6cbf2376a6ec6a98fee589149526e716e6","ref":"refs/heads/main","pushedAt":"2023-05-21T23:03:55.710Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"9ace142cdbbc95431fa5cd35bfe4fabc1a7e888d","after":"66bb16f629b2c28b6c76cf71564fe802cb3c46b3","ref":"refs/heads/main","pushedAt":"2023-05-21T23:03:11.923Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"Fix #94 (#108)","shortMessageHtmlLink":"Fix #94 (#108)"}},{"before":"3e78af29f12e0a789c20c46cf15de0e09733bb5e","after":"9ace142cdbbc95431fa5cd35bfe4fabc1a7e888d","ref":"refs/heads/main","pushedAt":"2023-05-21T22:55:59.591Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"6b12629d702c732cf29ca961c82c3e8389ae4583","after":"3e78af29f12e0a789c20c46cf15de0e09733bb5e","ref":"refs/heads/main","pushedAt":"2023-05-21T22:55:14.456Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"New DB since Things 3.15.16+ (#107)\n\n* copy from/to new DB location\r\n* test for new DB version\r\n* add assertion for old database\r\n* added new database, moved old database","shortMessageHtmlLink":"New DB since Things 3.15.16+ (#107)"}},{"before":"13e48c4277997314890ef6c73119eae2aef17aff","after":"6b12629d702c732cf29ca961c82c3e8389ae4583","ref":"refs/heads/main","pushedAt":"2023-05-21T21:59:29.045Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Updated docs","shortMessageHtmlLink":"Updated docs"}},{"before":"c0990a8faa78b5ebe276c8f1816b9cc7d159e95f","after":"13e48c4277997314890ef6c73119eae2aef17aff","ref":"refs/heads/main","pushedAt":"2023-05-21T21:58:27.489Z","pushType":"pr_merge","commitsCount":11,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"Merge pull request #96 from bkleinen/yesterday\n\nadd exact date query to enable logyesterday","shortMessageHtmlLink":"Merge pull request #96 from bkleinen/yesterday"}},{"before":"41f0112d3d1d9c5f67032a0be174c76542a0d598","after":"c0990a8faa78b5ebe276c8f1816b9cc7d159e95f","ref":"refs/heads/main","pushedAt":"2023-05-21T21:03:06.929Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"Rename columns that changed in a recent update","shortMessageHtmlLink":"Rename columns that changed in a recent update"}},{"before":"408c38a6509c23bd34031ee67affe33b0f946090","after":"41f0112d3d1d9c5f67032a0be174c76542a0d598","ref":"refs/heads/main","pushedAt":"2023-05-21T20:42:50.779Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"AlexanderWillner","name":"Alex","path":"/AlexanderWillner","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/307605?s=80&v=4"},"commit":{"message":"remove lint, add typing, modernize, cleanup (#104)\n\n* udpate pre-commit hooks\r\n* remove lint, add typing, modernize, cleanup\r\n* actually use different python versions in tests\r\n* different exceptions for different python versions","shortMessageHtmlLink":"remove lint, add typing, modernize, cleanup (#104)"}},{"before":"7e252f8de1e34d4981a806c788ff7ecc63a7dd2f","after":"408c38a6509c23bd34031ee67affe33b0f946090","ref":"refs/heads/main","pushedAt":"2023-05-11T10:20:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"Update README.md\n\nUsed-by: Add \"Things to CSV\"","shortMessageHtmlLink":"Update README.md"}},{"before":"411b2a6763508d6d3e1b821dc9512f1ccf4e1afe","after":"7e252f8de1e34d4981a806c788ff7ecc63a7dd2f","ref":"refs/heads/main","pushedAt":"2023-05-11T09:54:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"Update README.md\n\nAdd more details on the Things URL Scheme; point out that updates are possible.","shortMessageHtmlLink":"Update README.md"}},{"before":"3e8bc3560cfa01f303058fa2bd862b32374f7c05","after":"411b2a6763508d6d3e1b821dc9512f1ccf4e1afe","ref":"refs/heads/main","pushedAt":"2023-05-01T10:55:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mikez","name":"Michael","path":"/mikez","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/216956?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAD3lGtKQA","startCursor":null,"endCursor":null}},"title":"Activity ยท thingsapi/things.py"}