{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":633508310,"defaultBranch":"master","name":"sqldelight","ownerLogin":"griffio","currentUserCanPush":false,"isFork":true,"isEmpty":false,"createdAt":"2023-04-27T16:46:40.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/346896?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1721223221.0","currentOid":""},"activityList":{"items":[{"before":"10405b26070590be8dc3f92a5cc626a535e42687","after":"6bb8711dd3b5cfc671931081bf850f7d7aa1888a","ref":"refs/heads/master","pushedAt":"2024-07-17T14:28:01.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Add  5273 Postrgesql extract from temporal types (#5274)\n\n* Add Postgresql EXTRACT function\r\n\r\nextract temporal fields\r\n\r\n* Add tests\r\n\r\nfixture test\r\nintegration test\r\n\r\n* Integration Test\r\n\r\ntodo - bind arg test \"?\" needs cast e.g `?::TIMESTAMP`\r\n\r\n* Add TIME and DATE literals\r\n\r\nAdd Support for:\r\n\r\nSELECT EXTRACT(MONTH FROM DATE '2023-05-15');\r\n\r\nSELECT EXTRACT(HOUR FROM TIME '10:30:45');\r\n\r\n* Update Test.s\r\n\r\nSELECT EXTRACT(MONTH FROM DATE '2023-05-15');\r\n\r\nSELECT EXTRACT(HOUR FROM TIME '10:30:45');\r\n\r\n* Add date and time literals\r\n\r\nTo support Extract\r\n\r\n* Date and Time tests\r\n\r\nLiteral Date and Time tests\r\n\r\n* Add Date and Time test\r\n\r\nIntegration Test for Extract\r\n\r\n* Update PostgreSqlTypeResolver.kt\r\n\r\nAdd error to validate temporal types\r\n\r\n* Add Interval test\r\n\r\nIntegration test for INTERVAL returns double(3)\r\n\r\n* Update PostgreSql.bnf\r\n\r\nAdd latest temporal fields (22)","shortMessageHtmlLink":"Add 5273 Postrgesql extract from temporal types (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2315934408\" data-permission-text=\"Title is private\" data-url=\"https://github.com/cashapp/sqldelight/issues/5274\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/cashapp/sqldelight/pull/5274/hovercard\" href=\"https://github.com/cashapp/sqldelight/pull/5274\">cashapp#5274</a>)"}},{"before":"aa97acb64afec8edf2848a58586641f06b83595d","after":null,"ref":"refs/heads/add-postrgesql-extract-from","pushedAt":"2024-07-17T13:33:41.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"06c9cf221c9dcfdc504ba53ac854a56d054ad8ce","after":"aa97acb64afec8edf2848a58586641f06b83595d","ref":"refs/heads/add-postrgesql-extract-from","pushedAt":"2024-07-16T18:22:48.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Update PostgreSql.bnf\n\nAdd latest temporal fields (22)","shortMessageHtmlLink":"Update PostgreSql.bnf"}},{"before":"7550327681585f17f452d94ee2307563cf73fbb9","after":null,"ref":"refs/heads/fix-5345-postgresql-distinct-on","pushedAt":"2024-07-16T16:16:40.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"e182037e2c46c1ea0d85b437b2ce2daa045fa547","after":"7550327681585f17f452d94ee2307563cf73fbb9","ref":"refs/heads/fix-5345-postgresql-distinct-on","pushedAt":"2024-07-16T15:37:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Remove unnecessary nullability\n\nAs the code is was using mapNotNull\nRemove unnecessary null type parameter and not-null assertion operator","shortMessageHtmlLink":"Remove unnecessary nullability"}},{"before":"659a30d71a39a674edd06bbe02dc2466a7cb9d0c","after":"e182037e2c46c1ea0d85b437b2ce2daa045fa547","ref":"refs/heads/fix-5345-postgresql-distinct-on","pushedAt":"2024-07-15T07:54:56.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Add tests\n\nfixture tests - multiple tables and columns in DISTINCT ON\nintegration test - valid sql is generated and helps prevent regressions","shortMessageHtmlLink":"Add tests"}},{"before":"32e5f02b2c2ad12ce10cc59efb73d99708d045d3","after":"659a30d71a39a674edd06bbe02dc2466a7cb9d0c","ref":"refs/heads/fix-5345-postgresql-distinct-on","pushedAt":"2024-07-13T15:07:29.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Add tests\n\nfixture tests - multiple tables and columns in DISTINCT ON\nintegration test - valid sql is generated and helps prevent regressions","shortMessageHtmlLink":"Add tests"}},{"before":"a407d5c462824886bac504e9c3fb4526f3f3b21b","after":"10405b26070590be8dc3f92a5cc626a535e42687","ref":"refs/heads/master","pushedAt":"2024-07-13T14:49:33.000Z","pushType":"push","commitsCount":8,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Update dependency com.google.truth:truth to v1.4.4 (#5352)\n\nCo-authored-by: renovate[bot] <29139614+renovate[bot]@users.noreply.github.com>","shortMessageHtmlLink":"Update dependency com.google.truth:truth to v1.4.4 (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2406639280\" data-permission-text=\"Title is private\" data-url=\"https://github.com/cashapp/sqldelight/issues/5352\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/cashapp/sqldelight/pull/5352/hovercard\" href=\"https://github.com/cashapp/sqldelight/pull/5352\">cashapp#5352</a>)"}},{"before":null,"after":"32e5f02b2c2ad12ce10cc59efb73d99708d045d3","ref":"refs/heads/fix-5345-postgresql-distinct-on","pushedAt":"2024-07-13T14:45:32.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Add tests\n\nfixture tests - multiple tables and columns in DISTINCT ON\nintegration test - valid sql is generated and helps prevent regressions","shortMessageHtmlLink":"Add tests"}},{"before":"560a7fb5fafeedda842eba1756f69381737f3ccb","after":null,"ref":"refs/heads/add-5199-support-postgresql-order-by-nulls","pushedAt":"2024-07-10T17:33:23.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"0d7ba6b16db4c9039675f31c74021cfdef71db0e","after":null,"ref":"refs/heads/fixes-5059-add-brin-gist","pushedAt":"2024-07-10T17:17:50.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"cc7bec7b30e2b7ca041b8df8e20816b39e57c666","after":null,"ref":"refs/heads/fix-5330-add-postgresql-ilike","pushedAt":"2024-07-10T17:12:46.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"bf5155af9a2fb39c531f7801f9ad30dc9ace0790","after":"c27103ef8a87642b2e122570ebd686de71fa29a5","ref":"refs/heads/fix-5122-add-postgresql-lateral-subquery","pushedAt":"2024-07-10T15:35:38.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Tests\n\nFixture tests","shortMessageHtmlLink":"Tests"}},{"before":"9f3939623d5eef1bc71233456bcfc001633abb49","after":"06c9cf221c9dcfdc504ba53ac854a56d054ad8ce","ref":"refs/heads/add-postrgesql-extract-from","pushedAt":"2024-07-09T16:25:59.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Update PostgreSql.bnf\n\nAdd latest temporal fields (22)","shortMessageHtmlLink":"Update PostgreSql.bnf"}},{"before":"8e34da2a7c4df48253d6631a13b85c8ae4e403da","after":null,"ref":"refs/heads/add-4933-postgresql-array-operator","pushedAt":"2024-07-09T16:25:08.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"22bf6feabe54dafcae992d7e40735ad091770e7a","after":null,"ref":"refs/heads/fix-5309-alter-column-if-not-exists","pushedAt":"2024-07-09T15:21:26.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"941a2406e3daa31c272c7a71a530649b83143ab4","after":null,"ref":"refs/heads/fix-5089-add-postgresql-type-casting","pushedAt":"2024-07-09T15:06:31.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"3e3bc62229401c77bb41c9a698f66e4475d963a2","after":null,"ref":"refs/heads/fix-5288-postgresql-drop-constraint","pushedAt":"2024-07-09T15:04:03.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"a2e5d0e00c39d3bc27f9c5619e3cea442d358075","after":"8e34da2a7c4df48253d6631a13b85c8ae4e403da","ref":"refs/heads/add-4933-postgresql-array-operator","pushedAt":"2024-07-09T14:53:49.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"JakeWharton","name":"Jake Wharton","path":"/JakeWharton","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66577?s=80&v=4"},"commit":{"message":"Merge branch 'master' into add-4933-postgresql-array-operator","shortMessageHtmlLink":"Merge branch 'master' into add-4933-postgresql-array-operator"}},{"before":"9db34d6c24c58c61565defee01916ce41ebabe93","after":"22bf6feabe54dafcae992d7e40735ad091770e7a","ref":"refs/heads/fix-5309-alter-column-if-not-exists","pushedAt":"2024-07-09T13:35:07.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Add integration test\n\nmigration file test","shortMessageHtmlLink":"Add integration test"}},{"before":"fff56703fb58de72ff2755c33a392438ffaf515b","after":"a2e5d0e00c39d3bc27f9c5619e3cea442d358075","ref":"refs/heads/add-4933-postgresql-array-operator","pushedAt":"2024-07-09T12:40:43.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"fix merge conflict","shortMessageHtmlLink":"fix merge conflict"}},{"before":"004db6a22048279ff666d9bde1fdd6c2d9b6ca4b","after":"3e3bc62229401c77bb41c9a698f66e4475d963a2","ref":"refs/heads/fix-5288-postgresql-drop-constraint","pushedAt":"2024-07-09T12:04:48.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Fixture test\n\nconsider constraint doesn't exist in table schema","shortMessageHtmlLink":"Fixture test"}},{"before":"0ff280b2aa408ee56277c63fb398bea95e33fb05","after":"941a2406e3daa31c272c7a71a530649b83143ab4","ref":"refs/heads/fix-5089-add-postgresql-type-casting","pushedAt":"2024-07-09T11:36:09.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Tests","shortMessageHtmlLink":"Tests"}},{"before":"19e393a3fa13b4a1282ab448e355dadaa33cc92d","after":"a407d5c462824886bac504e9c3fb4526f3f3b21b","ref":"refs/heads/master","pushedAt":"2024-07-09T07:51:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Fix 5330 add Postgresql ILIKE operator (#5333)\n\n* override binary_like_operator\r\n\r\nAdd `ILIKE` to `binary_like_operator`\r\n\r\nPostgresql doesn't use `GLOB | REGEXP | MATCH` keywords\r\nIt would require rewriting the mixin just to add `ILIKE`\r\n\r\nAdd like and ilike patterns to regex_match_operator\r\nregex_match_operator is ordered by shortest matching characters first as the parser gets confused\r\n\r\n* Add tests\r\n\r\nfixture test\r\nintegration tests","shortMessageHtmlLink":"Fix 5330 add Postgresql ILIKE operator (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2394102433\" data-permission-text=\"Title is private\" data-url=\"https://github.com/cashapp/sqldelight/issues/5333\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/cashapp/sqldelight/pull/5333/hovercard\" href=\"https://github.com/cashapp/sqldelight/pull/5333\">cashapp#5333</a>)"}},{"before":"1184be7f339f6edd0f9e7bd42bcca546bd15dfba","after":"9db34d6c24c58c61565defee01916ce41ebabe93","ref":"refs/heads/fix-5309-alter-column-if-not-exists","pushedAt":"2024-07-09T06:29:22.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Add integration test\n\nmigration file test","shortMessageHtmlLink":"Add integration test"}},{"before":"c2225b54674c33fafef1912bb9b03a72ca302a70","after":null,"ref":"refs/heads/add-postgresql-regex-operators","pushedAt":"2024-07-08T17:51:08.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"47761ec2b96edcaee6effd85b555ce5d94019324","after":"bf5155af9a2fb39c531f7801f9ad30dc9ace0790","ref":"refs/heads/fix-5122-add-postgresql-lateral-subquery","pushedAt":"2024-07-08T17:45:53.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Tests\n\nFixture tests","shortMessageHtmlLink":"Tests"}},{"before":null,"after":"47761ec2b96edcaee6effd85b555ce5d94019324","ref":"refs/heads/fix-5122-add-postgresql-lateral-subquery","pushedAt":"2024-07-08T17:32:29.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Tests\n\nFixture tests","shortMessageHtmlLink":"Tests"}},{"before":"225ff59ab56aeacf36dfe18e657225517b85e778","after":null,"ref":"refs/heads/fix-5331-add-postgresql-xml-type","pushedAt":"2024-07-08T16:00:00.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"}},{"before":"6ae0693a5627bd37f9df5e292117a0337f228888","after":"19e393a3fa13b4a1282ab448e355dadaa33cc92d","ref":"refs/heads/master","pushedAt":"2024-07-08T15:39:28.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"griffio","name":"griff і⊙","path":"/griffio","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/346896?s=80&v=4"},"commit":{"message":"Fix 5331 add PostgreSql XML type (#5334)\n\n* add XML data type\r\n\r\nMap to SQLXML type on bind and String for results\r\n\r\n* Add tests\r\n\r\nfixture test\r\nintegration test","shortMessageHtmlLink":"Fix 5331 add PostgreSql XML type (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2394118077\" data-permission-text=\"Title is private\" data-url=\"https://github.com/cashapp/sqldelight/issues/5334\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/cashapp/sqldelight/pull/5334/hovercard\" href=\"https://github.com/cashapp/sqldelight/pull/5334\">cashapp#5334</a>)"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEgfCmJgA","startCursor":null,"endCursor":null}},"title":"Activity · griffio/sqldelight"}