{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":179587638,"defaultBranch":"master","name":"id3c","ownerLogin":"seattleflu","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2019-04-04T22:43:20.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/46054854?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1701900836.0","currentOid":""},"activityList":{"items":[{"before":"968ee3de186fcfcdd093cf3d7fc0e4bb23e38003","after":null,"ref":"refs/heads/process_tract_only","pushedAt":"2023-12-06T22:13:56.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"}},{"before":"5dc30237189ec4682a2204580114ab245008ca66","after":"6c3c1a940264a0ff87bd47ee243c6099056900b1","ref":"refs/heads/master","pushedAt":"2023-12-04T20:04:30.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"},"commit":{"message":"Merge pull request #331 from seattleflu/process_tract_only\n\nAdd option to process tract without address in FHIR ETL","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2015405166\" data-permission-text=\"Title is private\" data-url=\"https://github.com/seattleflu/id3c/issues/331\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/seattleflu/id3c/pull/331/hovercard\" href=\"https://github.com/seattleflu/id3c/pull/331\">#331</a> from seattleflu/process_tract_only"}},{"before":"90366b0375b71e5272ca95659fdfc66e029c5b6d","after":"968ee3de186fcfcdd093cf3d7fc0e4bb23e38003","ref":"refs/heads/process_tract_only","pushedAt":"2023-12-04T19:45:49.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"},"commit":{"message":"Add option to process tract without address in FHIR ETL","shortMessageHtmlLink":"Add option to process tract without address in FHIR ETL"}},{"before":null,"after":"90366b0375b71e5272ca95659fdfc66e029c5b6d","ref":"refs/heads/process_tract_only","pushedAt":"2023-11-28T21:58:44.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"},"commit":{"message":"Add option to process tract without address in FHIR ETL","shortMessageHtmlLink":"Add option to process tract without address in FHIR ETL"}},{"before":"f1de9c08ca504cca46982b187454ac8fcb422398","after":"2f95b1a1184a9621d7064d127f6b254e1e2b871a","ref":"refs/heads/genomic-seq-etl-access-role","pushedAt":"2023-11-27T23:34:17.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Include `access_role` value in genomic sequencing ETL\n\nAn `access_role` column was recently added to the `sample`, `sequencing_read_set`, `genomic_sequence`, and `consensus_genome` tables of the `warehouse` schema to allow data with restricted access to be included in these tables. These changes include `access_role` in the appropriate class definitions, and updates ETLs to propagate the `access_role` value from a `sample` record to the related sequencing records.\n\nThe sample record will continue server as the primary `access_role` value, but must also be stored in each table that uses row level security.","shortMessageHtmlLink":"Include <code>access_role</code> value in genomic sequencing ETL"}},{"before":"c97903f730cb781b0ebfe909720894f84a174f70","after":"f1de9c08ca504cca46982b187454ac8fcb422398","ref":"refs/heads/genomic-seq-etl-access-role","pushedAt":"2023-11-27T23:31:16.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Include `access_role` value in genomic sequencing ETL\n\nAn `access_role` column was recently added to the `sample`, `sequencing_read_set`, `genomic_sequence`, and `consensus_genome` tables of the `warehouse` schema to allow data with restricted access to be included in these tables. These changes include `access_role` in the appropriate class definitions, and updates ETLs to propogate the `access_role` value found in the `sample` record to the related records.\n\nThe sample record will continue server as the primary `access_role` value, but must also be stored in each table that uses row level security.","shortMessageHtmlLink":"Include <code>access_role</code> value in genomic sequencing ETL"}},{"before":"8e2af28b59bd59b5d0138ed3c827aa067f2237ea","after":"c97903f730cb781b0ebfe909720894f84a174f70","ref":"refs/heads/genomic-seq-etl-access-role","pushedAt":"2023-11-27T23:24:15.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Include `access_role` value in genomic sequencing ETL\n\nAn `access_role` column was recently added to the `sample`, `sequencing_read_set`, `genomic_sequence`, and `consensus_genome` tables of the `warehouse` schema to allow data with restricted access to be included in these tables. These changes include `access_role` in the appropriate class definitions, and updates ETLs to propogate the `access_role` value found in the `sample` record to the related records.\n\nThe sample record will continue server as the primary `access_role` value, but must also be stored in each table that uses row level security.","shortMessageHtmlLink":"Include <code>access_role</code> value in genomic sequencing ETL"}},{"before":null,"after":"8e2af28b59bd59b5d0138ed3c827aa067f2237ea","ref":"refs/heads/genomic-seq-etl-access-role","pushedAt":"2023-11-27T23:21:18.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Include `access_role` value in genomic sequencing ETL\n\nAn `access_role` column was recently added to the `sample`, `sequencing_read_set`, `genomic_sequence`, and `consensus_genome` tables of the `warehouse` schema to allow data with restricted access to be included in these tables. These changes include `access_role` in the appropriate class definitions, and updates ETLs to propogate the `access_role` value found in the `sample` record to the related records.\n\nThe sample record will continue server as the primary `access_role` value, but must also be stored in each table that uses row level security.","shortMessageHtmlLink":"Include <code>access_role</code> value in genomic sequencing ETL"}},{"before":"7b1b4ac30d1969e30fc36da7f1433c55d0061502","after":"5dc30237189ec4682a2204580114ab245008ca66","ref":"refs/heads/master","pushedAt":"2023-09-01T18:37:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"c2126ad1bcc3aa37f6bfead651ad72b5685a8652","after":null,"ref":"refs/heads/sample-api-update","pushedAt":"2023-09-01T17:16:53.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"}},{"before":"76a7f7e68f86e893fefdaf8deb047dd4407a63b4","after":"7b1b4ac30d1969e30fc36da7f1433c55d0061502","ref":"refs/heads/master","pushedAt":"2023-09-01T17:16:44.000Z","pushType":"pr_merge","commitsCount":4,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Merge pull request #329 from seattleflu/sample-api-update\n\nSample API update","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1865932016\" data-permission-text=\"Title is private\" data-url=\"https://github.com/seattleflu/id3c/issues/329\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/seattleflu/id3c/pull/329/hovercard\" href=\"https://github.com/seattleflu/id3c/pull/329\">#329</a> from seattleflu/sample-api-update"}},{"before":"7bb614790eccdb94065c23f811be8673a7b8fa42","after":"c2126ad1bcc3aa37f6bfead651ad72b5685a8652","ref":"refs/heads/sample-api-update","pushedAt":"2023-08-30T17:49:56.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Update API doc page","shortMessageHtmlLink":"Update API doc page"}},{"before":"51a4b8509a1a255923798bfc65b2b1b30ef7321c","after":"7bb614790eccdb94065c23f811be8673a7b8fa42","ref":"refs/heads/sample-api-update","pushedAt":"2023-08-25T21:55:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Update API doc page","shortMessageHtmlLink":"Update API doc page"}},{"before":"04224377d766a8596476bf502f95da8664ac03fa","after":"51a4b8509a1a255923798bfc65b2b1b30ef7321c","ref":"refs/heads/sample-api-update","pushedAt":"2023-08-24T21:57:11.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Remove `_provenance` from sample.details for comparison purposes\n\nWhen detecting data changes in sample upsert function, timestamp changes in the `_provenance` were causing otherwise unchanged records to be updated. Removing this value for comparison purposes in a copy of the dict, and retaining the original for insert and update.","shortMessageHtmlLink":"Remove <code>_provenance</code> from sample.details for comparison purposes"}},{"before":null,"after":"04224377d766a8596476bf502f95da8664ac03fa","ref":"refs/heads/sample-api-update","pushedAt":"2023-08-24T21:36:36.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Remove `_provenance` from sample.details for comparison purposes\n\nWhen detecting data changes in sample upsert function, timestamp changes in the `_provenance` were causing otherwise unchanged records to be updated. Removing this value for comparison purposes in a copy of the dict, and retaining the original for insert and update.","shortMessageHtmlLink":"Remove <code>_provenance</code> from sample.details for comparison purposes"}},{"before":"04f537ed995cf66412b11869674d840aca103fcd","after":"76a7f7e68f86e893fefdaf8deb047dd4407a63b4","ref":"refs/heads/master","pushedAt":"2023-08-23T15:21:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Update Pipfile.lock","shortMessageHtmlLink":"Update Pipfile.lock"}},{"before":"05bb2353f958f226e2381f83f31ec7275d7ce960","after":null,"ref":"refs/heads/add-row-level-security","pushedAt":"2023-08-22T21:26:44.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"}},{"before":"f2b8a161eea7ce241e8e1039dae605150e11c8f9","after":"04f537ed995cf66412b11869674d840aca103fcd","ref":"refs/heads/master","pushedAt":"2023-08-22T21:26:40.000Z","pushType":"pr_merge","commitsCount":5,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Merge pull request #328 from seattleflu/add-row-level-security\n\nAdding row level security to sample and genomics tables","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1825286976\" data-permission-text=\"Title is private\" data-url=\"https://github.com/seattleflu/id3c/issues/328\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/seattleflu/id3c/pull/328/hovercard\" href=\"https://github.com/seattleflu/id3c/pull/328\">#328</a> from seattleflu/add-row-level-security"}},{"before":"0d1423abc67cc90b966de371d74a1c1098a56fec","after":"05bb2353f958f226e2381f83f31ec7275d7ce960","ref":"refs/heads/add-row-level-security","pushedAt":"2023-08-21T18:00:55.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Revoke select permissions from reporter on receiving.consensus_genome and receiving.sequence_read_set","shortMessageHtmlLink":"Revoke select permissions from reporter on receiving.consensus_genome…"}},{"before":"fdaa5dac74a3561d02101d0aba1a76767f68ac95","after":"0d1423abc67cc90b966de371d74a1c1098a56fec","ref":"refs/heads/add-row-level-security","pushedAt":"2023-08-18T23:56:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Revoke select permissions from reporter on receiving.consensus_genome","shortMessageHtmlLink":"Revoke select permissions from reporter on receiving.consensus_genome"}},{"before":"cb52e76661d4faf2045c293072a17615877f1ed3","after":"fdaa5dac74a3561d02101d0aba1a76767f68ac95","ref":"refs/heads/add-row-level-security","pushedAt":"2023-08-18T23:35:19.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Replace sqitch.conf with a template with customizable database URIs\n\nDatabases are no longer directly accessible, and each environment may have connections to ID3C configured differently, so replacing hard coded URIs with placeholders. `sqitch.template.conf` should be copied to `sqitch.conf` and the database connection URIs should updated in that file prior to running sqitch commands.","shortMessageHtmlLink":"Replace sqitch.conf with a template with customizable database URIs"}},{"before":"fdaa5dac74a3561d02101d0aba1a76767f68ac95","after":"cb52e76661d4faf2045c293072a17615877f1ed3","ref":"refs/heads/add-row-level-security","pushedAt":"2023-08-18T22:00:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Add row-level security to  table","shortMessageHtmlLink":"Add row-level security to table"}},{"before":"68b0ec100a58c4e9f6bc65e33f7c0812a1dc3fa1","after":"fdaa5dac74a3561d02101d0aba1a76767f68ac95","ref":"refs/heads/add-row-level-security","pushedAt":"2023-08-14T21:11:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Replace sqitch.conf with a template with customizable database URIs\n\nDatabases are no longer directly accessible, and each environment may have connections to ID3C configured differently, so replacing hard coded URIs with placeholders. `sqitch.template.conf` should be copied to `sqitch.conf` and the database connection URIs should updated in that file prior to running sqitch commands.","shortMessageHtmlLink":"Replace sqitch.conf with a template with customizable database URIs"}},{"before":"c1f22985d482fc08e2be68e97f67f9242673ad4c","after":"68b0ec100a58c4e9f6bc65e33f7c0812a1dc3fa1","ref":"refs/heads/add-row-level-security","pushedAt":"2023-07-27T22:53:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Add security invoker to shipping views\n\nAdding security invoker to shipping views to enforce row-level security policies on the underlying tables. By specifying this option, the current user's permissions are applied rather than the default (view owner's) permissions.","shortMessageHtmlLink":"Add security invoker to shipping views"}},{"before":null,"after":"c1f22985d482fc08e2be68e97f67f9242673ad4c","ref":"refs/heads/add-row-level-security","pushedAt":"2023-07-27T21:48:50.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"davereinhart","name":"Dave Reinhart","path":"/davereinhart","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/11579388?s=80&v=4"},"commit":{"message":"Adding row level security policies","shortMessageHtmlLink":"Adding row level security policies"}},{"before":null,"after":"ad040a59b2bf76a01417df3bd3b3e06584a54f6b","ref":"refs/heads/feature/bencap/83/viral-evolution-identifiers","pushedAt":"2023-07-25T22:26:07.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"bencap","name":"Benjamin Capodanno","path":"/bencap","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/31941502?s=80&v=4"},"commit":{"message":"Create New Viral Evolution Identifier Set\n\nCreates a new identifier set for the upcoming viral evolution study\nmodeled after the Cascadia identifier set layout.","shortMessageHtmlLink":"Create New Viral Evolution Identifier Set"}},{"before":"c6608cf8be09d6236acccb152af46440eff2bd71","after":null,"ref":"refs/heads/macbook-m2-setup","pushedAt":"2023-07-13T23:24:40.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"}},{"before":"ca40a302fa34b9484a544d34b221c69e508c2393","after":"f2b8a161eea7ce241e8e1039dae605150e11c8f9","ref":"refs/heads/master","pushedAt":"2023-07-13T21:34:39.000Z","pushType":"pr_merge","commitsCount":4,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"},"commit":{"message":"Merge pull request #325 from seattleflu/macbook-m2-setup\n\nUse psycopg2-binary, upgrade click to 8.x, pin click to <8.1.4. Pin s3fs, openpyxl, and smartystreets-python-sdk. Require Python >=3.8.","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1801313461\" data-permission-text=\"Title is private\" data-url=\"https://github.com/seattleflu/id3c/issues/325\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/seattleflu/id3c/pull/325/hovercard\" href=\"https://github.com/seattleflu/id3c/pull/325\">#325</a> from seattleflu/macbook-m2-setup"}},{"before":"06b33b9609f1fb3083cddefdfd37442964166185","after":"c6608cf8be09d6236acccb152af46440eff2bd71","ref":"refs/heads/macbook-m2-setup","pushedAt":"2023-07-13T20:35:19.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"},"commit":{"message":"Require Python >=3.8\n\nNo longer running CI checks for Python 3.6 and 3.7 due to compatibility issues\n(6fcafc49514db4e70d1cf6a2ed25326f7ff243bb).","shortMessageHtmlLink":"Require Python &gt;=3.8"}},{"before":"d1f1c1dd8f827807ca3ace223d4c5d69a7710fa4","after":"06b33b9609f1fb3083cddefdfd37442964166185","ref":"refs/heads/macbook-m2-setup","pushedAt":"2023-07-13T16:19:31.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"sallybg","name":null,"path":"/sallybg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/136365880?s=80&v=4"},"commit":{"message":"Use psycopg2-binary, upgrade click to 8.x for compatibility with M2-compatible Fiona, temporarily pin click to <8.1.4 to avoid mypy type check failures (pallets/click#2558), and pin pandas to 1.5.3 until pandas 2.0 is more thoroughly tested.","shortMessageHtmlLink":"Use psycopg2-binary, upgrade click to 8.x for compatibility with M2-c…"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAADwzz6hwA","startCursor":null,"endCursor":null}},"title":"Activity · seattleflu/id3c"}