{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":686932121,"defaultBranch":"main","name":"pos365-analysis","ownerLogin":"JCharante","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-09-04T08:53:18.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/13973198?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1693817599.0","currentOid":""},"activityList":{"items":[{"before":"2d78b97b5efe3ef34704b6b8224c8045e2f7a611","after":"808be3e3ec142b774721f0ba9e04de7ec2d50fc3","ref":"refs/heads/main","pushedAt":"2023-09-23T16:06:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"patch update-prices.sql and create the sales-by-day.sql script","shortMessageHtmlLink":"patch update-prices.sql and create the sales-by-day.sql script"}},{"before":"38c8cb49491568aac47502f6320fa2b0e6c27142","after":"2d78b97b5efe3ef34704b6b8224c8045e2f7a611","ref":"refs/heads/main","pushedAt":"2023-09-23T15:30:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add two useful sql scripts","shortMessageHtmlLink":"add two useful sql scripts"}},{"before":"3612eb78f1dc304eaef21d01cb570000849ed12e","after":"38c8cb49491568aac47502f6320fa2b0e6c27142","ref":"refs/heads/main","pushedAt":"2023-09-15T13:56:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add day of week information to item_cat_sales table and switch to YYYY-MM-DD format","shortMessageHtmlLink":"add day of week information to item_cat_sales table and switch to YYY…"}},{"before":"db9f6dbd4ee3e6f962b8e62b6246d8444dd56525","after":"3612eb78f1dc304eaef21d01cb570000849ed12e","ref":"refs/heads/main","pushedAt":"2023-09-14T11:46:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"update readme","shortMessageHtmlLink":"update readme"}},{"before":"35af7ca81e687b76d0e2d16fbd380f5e53c10f28","after":"db9f6dbd4ee3e6f962b8e62b6246d8444dd56525","ref":"refs/heads/main","pushedAt":"2023-09-14T11:44:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"save category summaries into DB","shortMessageHtmlLink":"save category summaries into DB"}},{"before":"281247dc631d691265d3f248c79c765515bdf5f6","after":"35af7ca81e687b76d0e2d16fbd380f5e53c10f28","ref":"refs/heads/main","pushedAt":"2023-09-09T06:32:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"start moving category data into sqlite","shortMessageHtmlLink":"start moving category data into sqlite"}},{"before":"9837d484b6cd5bf5a60ab1e0181f43d775bc2f5b","after":"281247dc631d691265d3f248c79c765515bdf5f6","ref":"refs/heads/main","pushedAt":"2023-09-07T01:29:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add remaining_items.py script","shortMessageHtmlLink":"add remaining_items.py script"}},{"before":"ff9646a055208fa2662669b4a2b707d57da96dfb","after":"9837d484b6cd5bf5a60ab1e0181f43d775bc2f5b","ref":"refs/heads/main","pushedAt":"2023-09-06T15:59:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"finish implementing gen_report_cats","shortMessageHtmlLink":"finish implementing gen_report_cats"}},{"before":"9ad6cb18ed05eff7d3c5c9ad27312f7961a1b945","after":"ff9646a055208fa2662669b4a2b707d57da96dfb","ref":"refs/heads/main","pushedAt":"2023-09-06T10:37:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"progress on generating new data reports","shortMessageHtmlLink":"progress on generating new data reports"}},{"before":"c2c30a9fb937bb1fe9b1d113fa60045fca8e6434","after":"9ad6cb18ed05eff7d3c5c9ad27312f7961a1b945","ref":"refs/heads/main","pushedAt":"2023-09-06T09:48:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"generate categories file","shortMessageHtmlLink":"generate categories file"}},{"before":"865dc7ad0f173a882782bc6d1a8f4646bbf8e0c5","after":"c2c30a9fb937bb1fe9b1d113fa60045fca8e6434","ref":"refs/heads/main","pushedAt":"2023-09-06T04:38:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add case study to readme","shortMessageHtmlLink":"add case study to readme"}},{"before":"c6919c3912ad08fbaccb41d0463555aa9509e2e0","after":"865dc7ad0f173a882782bc6d1a8f4646bbf8e0c5","ref":"refs/heads/main","pushedAt":"2023-09-06T04:33:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add gen_report_time script","shortMessageHtmlLink":"add gen_report_time script"}},{"before":"26d4efa427def72ebaee4647e413ef9e7925d2db","after":"c6919c3912ad08fbaccb41d0463555aa9509e2e0","ref":"refs/heads/main","pushedAt":"2023-09-05T15:31:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"change to json5 for items mapping","shortMessageHtmlLink":"change to json5 for items mapping"}},{"before":"698c88fcc5d579d3abb71338a048ec8d13562669","after":"26d4efa427def72ebaee4647e413ef9e7925d2db","ref":"refs/heads/main","pushedAt":"2023-09-05T06:06:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add sum_product_sales script","shortMessageHtmlLink":"add sum_product_sales script"}},{"before":"72459ef607b7672e88fd8fae334f7fbeb633a0c4","after":"698c88fcc5d579d3abb71338a048ec8d13562669","ref":"refs/heads/main","pushedAt":"2023-09-05T06:06:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add support for floats in transaction_total_discount (should not exist but is present in data)","shortMessageHtmlLink":"add support for floats in transaction_total_discount (should not exis…"}},{"before":"c30873c36a9d85cacc3bf1ee0b3d537ecd6cde66","after":"72459ef607b7672e88fd8fae334f7fbeb633a0c4","ref":"refs/heads/main","pushedAt":"2023-09-04T15:39:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"test updating readme","shortMessageHtmlLink":"test updating readme"}},{"before":"3010ef181eb0ec88c8c70b07005b2ae20368fbd7","after":"c30873c36a9d85cacc3bf1ee0b3d537ecd6cde66","ref":"refs/heads/main","pushedAt":"2023-09-04T15:37:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add support for fractional quantities","shortMessageHtmlLink":"add support for fractional quantities"}},{"before":"cb2fb6c220f75da88fa05ea70dd8cb598423ccd4","after":"3010ef181eb0ec88c8c70b07005b2ae20368fbd7","ref":"refs/heads/main","pushedAt":"2023-09-04T15:37:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add support for fractional quantities and fix product_prices index; add parsed files into table;","shortMessageHtmlLink":"add support for fractional quantities and fix product_prices index; a…"}},{"before":"0ff32fbeaa4e59cd5a78262aa53498f88f6c4442","after":"cb2fb6c220f75da88fa05ea70dd8cb598423ccd4","ref":"refs/heads/main","pushedAt":"2023-09-04T15:00:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"implement add_transaction_to_db","shortMessageHtmlLink":"implement add_transaction_to_db"}},{"before":"e84ed86c0b26ec5f661a109571f0b4145fea0a66","after":"0ff32fbeaa4e59cd5a78262aa53498f88f6c4442","ref":"refs/heads/main","pushedAt":"2023-09-04T14:33:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"clarify wording in readme","shortMessageHtmlLink":"clarify wording in readme"}},{"before":"9966a419d071d7dedc2e77dd0e220596ec43ec2c","after":"e84ed86c0b26ec5f661a109571f0b4145fea0a66","ref":"refs/heads/main","pushedAt":"2023-09-04T14:32:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"make progress parsing csv file; add raw_sales table and index","shortMessageHtmlLink":"make progress parsing csv file; add raw_sales table and index"}},{"before":"a31f018045bc29325b9ef747a4cd9b9fe623132d","after":"9966a419d071d7dedc2e77dd0e220596ec43ec2c","ref":"refs/heads/main","pushedAt":"2023-09-04T13:22:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"add init and add_store scripts, also add gitignore","shortMessageHtmlLink":"add init and add_store scripts, also add gitignore"}},{"before":"eef53e65062362f325009e6cd30a826bcd3cd062","after":"a31f018045bc29325b9ef747a4cd9b9fe623132d","ref":"refs/heads/main","pushedAt":"2023-09-04T09:24:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"update readme","shortMessageHtmlLink":"update readme"}},{"before":"863ae502dd829f5889f7ea511c1179c31cb0aea0","after":"eef53e65062362f325009e6cd30a826bcd3cd062","ref":"refs/heads/main","pushedAt":"2023-09-04T08:58:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"1523aa119a7bfd98b0c4355a89206c400b1af1bb","after":"863ae502dd829f5889f7ea511c1179c31cb0aea0","ref":"refs/heads/main","pushedAt":"2023-09-04T08:57:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":null,"after":"1523aa119a7bfd98b0c4355a89206c400b1af1bb","ref":"refs/heads/main","pushedAt":"2023-09-04T08:53:19.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"JCharante","name":"Jyan Zarate","path":"/JCharante","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/13973198?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyMy0wOS0yM1QxNjowNjo0Ni4wMDAwMDBazwAAAAOHQ92x","startCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wOS0yM1QxNjowNjo0Ni4wMDAwMDBazwAAAAOHQ92x","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wOS0wNFQwODo1MzoxOS4wMDAwMDBazwAAAAN4v2E2"}},"title":"Activity · JCharante/pos365-analysis"}