Title: Support for custom models · Issue #755 · sqlc-dev/sqlc · GitHub
Open Graph Title: Support for custom models · Issue #755 · sqlc-dev/sqlc
X Title: Support for custom models · Issue #755 · sqlc-dev/sqlc
Description: Example: db/queries/roles.sql -- name: ListRolesWithPermissions :many -- model: Roles -- path: internal/domain/roles SELECT r.role_id, r.display_name, r.description, array_agg(permissions.method)::text[] AS permissions FROM roles r LEFT ...
Open Graph Description: Example: db/queries/roles.sql -- name: ListRolesWithPermissions :many -- model: Roles -- path: internal/domain/roles SELECT r.role_id, r.display_name, r.description, array_agg(permissions.method)::...
X Description: Example: db/queries/roles.sql -- name: ListRolesWithPermissions :many -- model: Roles -- path: internal/domain/roles SELECT r.role_id, r.display_name, r.description, array_agg(permissions.method)::...
Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/755
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Support for custom models","articleBody":"Example:\r\n\r\n`db/queries/roles.sql`\r\n```sql\r\n-- name: ListRolesWithPermissions :many\r\n-- model: Roles\r\n-- path: internal/domain/roles\r\nSELECT\r\n r.role_id,\r\n r.display_name,\r\n r.description,\r\n array_agg(permissions.method)::text[] AS permissions\r\n FROM roles r\r\n LEFT JOIN permissions USING (role_id)\r\nGROUP BY r.role_id;\r\n\r\n-- name ListRoles :many\r\n-- model: Roles\r\n-- path: internal/domain/roles\r\nSELECT role_id, display_name, description FROM roles; /* returned colums exists in the model so we can reuse it */\r\n```\r\n\r\nIt isn't generated file!\r\n`internal/domain/roles`\r\n```go\r\ntype Role struct {\r\n\tRoleID uuid.UUID // here we can add some custom struct tags and methods\r\n\tDisplayName string\r\n\tDescription string\r\n\tPermissions []sql.NullString // using []string throws an error if an array is empty \r\n}\r\n```\r\n\r\nGenerated method\r\n```go\r\nfunc (q *Queries) ListRoles(ctx context.Context) ([]roles.Role, error)\r\n```\r\n\r\nP.S. These features can be useful because with it we can both use sqlc and follow **Clean Architecture**. And reuse structs for tables for complex queries with joins.\r\n\r\nSo my question is if I'd correctly implement this functionality would you approve PR (I'm asking because this feature can be not in the spirit of the project)","author":{"url":"https://github.com/mlukasik-dev","@type":"Person","name":"mlukasik-dev"},"datePublished":"2020-10-29T13:20:54Z","url":"https://github.com/sqlc-dev/sqlc/issues/755"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:7190a766-69ce-6d0a-93a3-bef7acc6975b |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | EAFA:33D24F:1FB8DB8:28A9082:6B017682 |
| html-safe-nonce | 3fcbafe13e214aa3fc6fd628841afb3c9921964534a13de2c4f8c140d83c00f9 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFQUZBOjMzRDI0RjoxRkI4REI4OjI4QTkwODI6NkIwMTc2ODIiLCJ2aXNpdG9yX2lkIjoiNTQzNjk0MTY1MjMxOTEwNjY5MCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 0420d0b381125219670d7f65567aef6445ffef002bf4681d9ee4496a779dea7a |
| hovercard-subject-tag | issue:732308708 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/755/issue_layout |
| twitter:image | https://opengraph.githubassets.com/e9b15c68922cd6514be96432a81085c9aa216d489677a9374b18fa7935d61b3a/sqlc-dev/sqlc/issues/755 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/e9b15c68922cd6514be96432a81085c9aa216d489677a9374b18fa7935d61b3a/sqlc-dev/sqlc/issues/755 |
| og:image:alt | Example: db/queries/roles.sql -- name: ListRolesWithPermissions :many -- model: Roles -- path: internal/domain/roles SELECT r.role_id, r.display_name, r.description, array_agg(permissions.method)::... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | mlukasik-dev |
| hostname | github.com |
| expected-hostname | github.com |
| None | cc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git |
| octolytics-dimension-user_id | 136738596 |
| octolytics-dimension-user_login | sqlc-dev |
| octolytics-dimension-repository_id | 193160679 |
| octolytics-dimension-repository_nwo | sqlc-dev/sqlc |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 193160679 |
| octolytics-dimension-repository_network_root_nwo | sqlc-dev/sqlc |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 8c77c9e8439031ad54c75a250694842892f693e1 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width