{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":1318764,"defaultBranch":"master","name":"sql-translator","ownerLogin":"dbsrgits","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2011-02-02T01:25:35.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/247741?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1705306283.0","currentOid":""},"activityList":{"items":[{"before":"b5d88d049ce7c104d83ab29968535ba6e288dd86","after":"682f21a87316d6276eb6fb0b5662d869e39eaeec","ref":"refs/heads/master","pushedAt":"2024-01-15T08:11:23.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"Release commit for 1.65\n\n  FIXES\n  * support for older perls","shortMessageHtmlLink":"Release commit for 1.65"}},{"before":"f8728221513e95fe02f1c49c676d3b219a6d1b84","after":"b5d88d049ce7c104d83ab29968535ba6e288dd86","ref":"refs/heads/master","pushedAt":"2023-12-22T11:51:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"chore: perltidy all the tings","shortMessageHtmlLink":"chore: perltidy all the tings"}},{"before":"d8415f9c59da78665bb04acdab8e069d646b1752","after":"f8728221513e95fe02f1c49c676d3b219a6d1b84","ref":"refs/heads/master","pushedAt":"2023-12-22T09:55:08.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"Release commit for 1.64\n\n * support EXCLUDE constraints in Postgres (thansk @KES777)\n * Improve enums in the PostgrSQL family (thanks @nrdvana)\n * Add index length options for MySQL (thanks @abeverley)\n   * you can pass fields for an index now as { name => $name, prefix_length => 9001 }\n\n FIXES\n * fix spurious on_update/on_delete in diffs (thanks @nrdvana)\n * CI improvements (thanks @eserte)\n * AUTOINCREMENT is now correctly parsed for SQLite (thanks @nrdvana)","shortMessageHtmlLink":"Release commit for 1.64"}},{"before":"7db8c698b7aff1bdc8c39893713772a995a180a7","after":"d8415f9c59da78665bb04acdab8e069d646b1752","ref":"refs/heads/master","pushedAt":"2023-12-22T09:46:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"chore: switch tracker from RT to GH (closes #140)","shortMessageHtmlLink":"chore: switch tracker from RT to GH (<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #140.\">closes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1325609790\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/140\" data-hovercard-type=\"issue\" data-hovercard-url=\"/dbsrgits/sql-translator/issues/140/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/issues/140\">#140</a>)"}},{"before":"dee6a8db1441b11beb3354cb21df4f54ec520938","after":"7db8c698b7aff1bdc8c39893713772a995a180a7","ref":"refs/heads/master","pushedAt":"2023-12-22T09:44:25.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"Support EXCLUDE constraints in Postgres (#168)\n\n* Implement EXCLUDE constraint for PostgreSQL\r\n\r\n* finish support + test EXCLUDE on PG\r\n\r\n* feat: add parser support for EXCLUDE, with WHERE INCLUDE and USING support\r\n\r\n---------\r\n\r\nCo-authored-by: Eugen Konkov <kes-kes@yandex.ru>","shortMessageHtmlLink":"Support EXCLUDE constraints in Postgres (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2053650840\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/168\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/dbsrgits/sql-translator/pull/168/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/pull/168\">#168</a>)"}},{"before":null,"after":"95e460c7ebff549cd3d7e1146a1c258dc0da6a32","ref":"refs/heads/veesh/finish-up-exclude","pushedAt":"2023-12-22T09:38:37.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"feat: add parser support for EXCLUDE, with WHERE INCLUDE and USING support","shortMessageHtmlLink":"feat: add parser support for EXCLUDE, with WHERE INCLUDE and USING su…"}},{"before":"d5367ac3d1ef628a438b69d475d9e2b0b9ae3795","after":"dee6a8db1441b11beb3354cb21df4f54ec520938","ref":"refs/heads/master","pushedAt":"2023-12-19T18:30:38.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"More improvements for PostgreSQL parse / diff (#161)\n\n* Fix ::Parser::DBI::PostgreSQL bug that swapped on_update and on_delete\r\n\r\nThe parser was storing the ON UPDATE value into the constraint's\r\non_delete attribute, and vice versa.  This caused foreign keys to\r\nalways show as diffs in SQL::Translator::Diff if the on_update\r\ndiffered from on_delete.\r\n\r\n* Add option to run t/66-postgres-dbi-parser.t with Test::PostgreSQL\r\n\r\nTest::PostgreSQL requires the postgres server binaries to be installed\r\non the host, which is a steep requirement.  So, eval{} both the\r\npresence of the module and whether the module is successfully able to\r\ncreate a postgres instance.  If so, use that.  (but only if none of\r\nthe env variables were set)\r\n\r\n* New ::Parser::DBI::PostgreSQL option deconstruct_enum_types\r\n\r\nThe ::Producer::PostgreSQL will take a column definition of\r\ndata_type 'enum' and convert it to a postgres custom data type,\r\nand then declare the column of that type.  When parsed, the column\r\nno longer shows the values of the enum and the data_type is the\r\ncustom name rather than 'enum'.  This new option reaches into the\r\npostgres type to find the enum values, and reverts the data_type\r\nto 'enum', like it was originally.\r\n\r\n* Handle addition of enum values in ::Producer::PostgreSQL->alter_field\r\n\r\nNow, when producing a diff between two enum columns where the list\r\nof values are known, and when the postgres version is greater than\r\n9.001, the producer will generate an ALTER TYPE ... ADD VALUE\r\nstatments if the new enum includes values that the old one did not.\r\nThis is an easy case to support because it does not involve\r\nre-creating the type.\r\n\r\nThe harder case of removing an enum value is not supported, yet.\r\nThe output includes a SQL comment to that effect, giving the\r\nuser a note that they need to perform that step on their own.","shortMessageHtmlLink":"More improvements for PostgreSQL parse / diff (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1973744479\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/161\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/dbsrgits/sql-translator/pull/161/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/pull/161\">#161</a>)"}},{"before":"13649ce32eece9774bfa83c39c4f7f3437f0f817","after":"d5367ac3d1ef628a438b69d475d9e2b0b9ae3795","ref":"refs/heads/master","pushedAt":"2023-11-26T19:08:43.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"Add index length option for MySQL (#68)\n\n* Add index length option for MySQL Producer (parser to come!)\r\n* Add IndexField objects to handle fancy index fields (like our new length option)\r\n* YAML + JSON producers now dump the extras for index fields\r\n\r\n---------\r\n\r\nCo-authored-by: Andrew Beverley <a.beverley@ctrlo.com>\r\nCo-authored-by: Jess Robinson <j.robinson@shadowcat.co.uk>\r\nCo-authored-by: Veesh Goldman <rabbiveesh@gmail.com>","shortMessageHtmlLink":"Add index length option for MySQL (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"104474801\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/68\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/dbsrgits/sql-translator/pull/68/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/pull/68\">#68</a>)"}},{"before":null,"after":"a2d2e6c17abe4af0591d4822162aacdf54ae123c","ref":"refs/heads/index-length","pushedAt":"2023-11-25T21:56:49.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"Merge branch 'master' into index-length","shortMessageHtmlLink":"Merge branch 'master' into index-length"}},{"before":"76cfd1f202f771a7c73653f4a6c9f5c263972974","after":"13649ce32eece9774bfa83c39c4f7f3437f0f817","ref":"refs/heads/master","pushedAt":"2023-11-25T21:24:58.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"test also xt in github workflows (#165)\n\nCo-authored-by: Veesh Goldman <rabbiveesh@gmail.com>","shortMessageHtmlLink":"test also xt in github workflows (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2008309931\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/165\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/dbsrgits/sql-translator/pull/165/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/pull/165\">#165</a>)"}},{"before":"31086ad800b2e2e09dbc22e87d1a052370b78956","after":"76cfd1f202f771a7c73653f4a6c9f5c263972974","ref":"refs/heads/master","pushedAt":"2023-11-25T21:13:58.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"untabify lib/SQL/Translator/Parser/SQLite.pm (#164)","shortMessageHtmlLink":"untabify lib/SQL/Translator/Parser/SQLite.pm (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2008301086\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/164\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/dbsrgits/sql-translator/pull/164/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/pull/164\">#164</a>)"}},{"before":"39e00abbda182594a0e6e9c152f317f147485022","after":"31086ad800b2e2e09dbc22e87d1a052370b78956","ref":"refs/heads/master","pushedAt":"2023-11-25T21:13:48.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"producer Dumper: fix NULL handling for strings (#163)","shortMessageHtmlLink":"producer Dumper: fix NULL handling for strings (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2008294235\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/163\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/dbsrgits/sql-translator/pull/163/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/pull/163\">#163</a>)"}},{"before":null,"after":"a26cff073c53d23170201bcfe0437d04bfbce24e","ref":"refs/heads/veesh/index-length-and-other-ops","pushedAt":"2023-06-21T21:05:56.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"fix: handle weird YAML double objecting","shortMessageHtmlLink":"fix: handle weird YAML double objecting"}},{"before":"c74aaebd94a67712194d818926a341aff6a98425","after":"39e00abbda182594a0e6e9c152f317f147485022","ref":"refs/heads/master","pushedAt":"2023-05-21T10:55:17.263Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"rabbiveesh","name":"Veesh Goldman","path":"/rabbiveesh","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23664554?s=80&v=4"},"commit":{"message":"Round-trip AUTOINCREMENT in SQLite parser (#158)\n\nCurrently, the SQLite parser sees the AUTOINCREMENT keyword and sets\r\nthe column flag is_auto_increment, but the SQLite Producer will not\r\nwrite the AUTOINCREMENT keyword unless extra.auto_increment_type is\r\n'monotonic'.  This breaks round-trip by the AUTOINCREMENT keyword\r\ngetting lost.","shortMessageHtmlLink":"Round-trip AUTOINCREMENT in SQLite parser (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1699645316\" data-permission-text=\"Title is private\" data-url=\"https://github.com/dbsrgits/sql-translator/issues/158\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/dbsrgits/sql-translator/pull/158/hovercard\" href=\"https://github.com/dbsrgits/sql-translator/pull/158\">#158</a>)"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAD384P2wA","startCursor":null,"endCursor":null}},"title":"Activity · dbsrgits/sql-translator"}