Title: Embedding struct? · sqlc-dev/sqlc · Discussion #363 · GitHub
Open Graph Title: Embedding struct? · sqlc-dev/sqlc · Discussion #363
X Title: Embedding struct? · sqlc-dev/sqlc · Discussion #363
Description: Embedding struct?
Open Graph Description: Hello! Input: (PostgreSQL) -- name: PreFetchContentsByGroup :many SELECT c.*, array_agg(g.id)::INT[] AS Ids FROM contents c INNER JOIN content_group_links cgl ON c.id = cgl.content_id INNER JOIN gr...
X Description: Hello! Input: (PostgreSQL) -- name: PreFetchContentsByGroup :many SELECT c.*, array_agg(g.id)::INT[] AS Ids FROM contents c INNER JOIN content_group_links cgl ON c.id = cgl.content_id INNER JOIN gr...
Opengraph URL: https://github.com/sqlc-dev/sqlc/discussions/363
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"QAPage","mainEntity":{"@type":"Question","name":"Embedding struct?","text":"\u003cp dir=\"auto\"\u003eHello!\u003c/p\u003e\n\u003cp dir=\"auto\"\u003eInput: (PostgreSQL)\u003c/p\u003e\n\u003cdiv class=\"highlight highlight-source-sql notranslate position-relative overflow-auto\" dir=\"auto\" data-snippet-clipboard-copy-content=\"-- name: PreFetchContentsByGroup :many\nSELECT c.*, array_agg(g.id)::INT[] AS Ids\nFROM contents c\n INNER JOIN content_group_links cgl ON c.id = cgl.content_id\n INNER JOIN groups g ON cgl.group_id = g.id\nWHERE g.id = ANY ($1::INT[])\nGROUP BY c.id;\"\u003e\u003cpre class=\"notranslate\"\u003e\u003cspan class=\"pl-c\"\u003e\u003cspan class=\"pl-c\"\u003e--\u003c/span\u003e name: PreFetchContentsByGroup :many\u003c/span\u003e\n\u003cspan class=\"pl-k\"\u003eSELECT\u003c/span\u003e c.\u003cspan class=\"pl-k\"\u003e*\u003c/span\u003e, array_agg(\u003cspan class=\"pl-c1\"\u003eg\u003c/span\u003e.\u003cspan class=\"pl-c1\"\u003eid\u003c/span\u003e)::\u003cspan class=\"pl-k\"\u003eINT\u003c/span\u003e[] \u003cspan class=\"pl-k\"\u003eAS\u003c/span\u003e Ids\n\u003cspan class=\"pl-k\"\u003eFROM\u003c/span\u003e contents c\n \u003cspan class=\"pl-k\"\u003eINNER JOIN\u003c/span\u003e content_group_links cgl \u003cspan class=\"pl-k\"\u003eON\u003c/span\u003e \u003cspan class=\"pl-c1\"\u003ec\u003c/span\u003e.\u003cspan class=\"pl-c1\"\u003eid\u003c/span\u003e \u003cspan class=\"pl-k\"\u003e=\u003c/span\u003e \u003cspan class=\"pl-c1\"\u003ecgl\u003c/span\u003e.\u003cspan class=\"pl-c1\"\u003econtent_id\u003c/span\u003e\n \u003cspan class=\"pl-k\"\u003eINNER JOIN\u003c/span\u003e groups g \u003cspan class=\"pl-k\"\u003eON\u003c/span\u003e \u003cspan class=\"pl-c1\"\u003ecgl\u003c/span\u003e.\u003cspan class=\"pl-c1\"\u003egroup_id\u003c/span\u003e \u003cspan class=\"pl-k\"\u003e=\u003c/span\u003e \u003cspan class=\"pl-c1\"\u003eg\u003c/span\u003e.\u003cspan class=\"pl-c1\"\u003eid\u003c/span\u003e\n\u003cspan class=\"pl-k\"\u003eWHERE\u003c/span\u003e \u003cspan class=\"pl-c1\"\u003eg\u003c/span\u003e.\u003cspan class=\"pl-c1\"\u003eid\u003c/span\u003e \u003cspan class=\"pl-k\"\u003e=\u003c/span\u003e ANY ($\u003cspan class=\"pl-c1\"\u003e1\u003c/span\u003e::\u003cspan class=\"pl-k\"\u003eINT\u003c/span\u003e[])\n\u003cspan class=\"pl-k\"\u003eGROUP BY\u003c/span\u003e \u003cspan class=\"pl-c1\"\u003ec\u003c/span\u003e.\u003cspan class=\"pl-c1\"\u003eid\u003c/span\u003e;\u003c/pre\u003e\u003c/div\u003e\n\u003cdiv class=\"highlight highlight-source-go notranslate position-relative overflow-auto\" dir=\"auto\" data-snippet-clipboard-copy-content=\"const preFetchContentsByGroup = `-- name: PreFetchContentsByGroup :many\nSELECT c.id, c.name, c.type, c.file, c.category, c.description, c.priority, c.enable, c.sys_1, c.sys_2, c.text_field_1, c.text_field_2, c.text_field_3, c.text_field_4, c.name_i18n, c.protected, c.uidx, c.name_i, c.description_i, c.text_field_1_i, c.text_field_2_i, c.text_field_3_i, c.text_field_4_i, c.file_i, array_agg(g.id)::INT[] AS Ids\nFROM contents c\n INNER JOIN content_group_links cgl ON c.id = cgl.content_id\n INNER JOIN groups g ON cgl.group_id = g.id\nWHERE g.id = ANY ($1::INT[])\nGROUP BY c.id\n`\"\u003e\u003cpre class=\"notranslate\"\u003e\u003cspan class=\"pl-k\"\u003econst\u003c/span\u003e \u003cspan class=\"pl-s1\"\u003epreFetchContentsByGroup\u003c/span\u003e \u003cspan class=\"pl-c1\"\u003e=\u003c/span\u003e \u003cspan class=\"pl-s\"\u003e`-- name: PreFetchContentsByGroup :many\u003c/span\u003e\n\u003cspan class=\"pl-s\"\u003eSELECT c.id, c.name, c.type, c.file, c.category, c.description, c.priority, c.enable, c.sys_1, c.sys_2, c.text_field_1, c.text_field_2, c.text_field_3, c.text_field_4, c.name_i18n, c.protected, c.uidx, c.name_i, c.description_i, c.text_field_1_i, c.text_field_2_i, c.text_field_3_i, c.text_field_4_i, c.file_i, array_agg(g.id)::INT[] AS Ids\u003c/span\u003e\n\u003cspan class=\"pl-s\"\u003eFROM contents c\u003c/span\u003e\n\u003cspan class=\"pl-s\"\u003e INNER JOIN content_group_links cgl ON c.id = cgl.content_id\u003c/span\u003e\n\u003cspan class=\"pl-s\"\u003e INNER JOIN groups g ON cgl.group_id = g.id\u003c/span\u003e\n\u003cspan class=\"pl-s\"\u003eWHERE g.id = ANY ($1::INT[])\u003c/span\u003e\n\u003cspan class=\"pl-s\"\u003eGROUP BY c.id\u003c/span\u003e\n\u003cspan class=\"pl-s\"\u003e`\u003c/span\u003e\u003c/pre\u003e\u003c/div\u003e\n\u003cp dir=\"auto\"\u003eOutput:\u003c/p\u003e\n\u003cdiv class=\"highlight highlight-source-go notranslate position-relative overflow-auto\" dir=\"auto\" data-snippet-clipboard-copy-content=\"type PreFetchContentsByGroupRow struct {\n\tID int32\n\tName sql.NullString\n\tType string\n\tFile uuid.UUID\n\tCategory sql.NullInt32\n\tDescription sql.NullString\n\tPriority int16\n\tEnable bool\n\tSys1 sql.NullString\n\tSys2 sql.NullString\n\tTextField1 sql.NullString\n\tTextField2 sql.NullString\n\tTextField3 sql.NullString\n\tTextField4 sql.NullString\n\tNameI18n sql.NullInt32\n\tProtected bool\n\tUidx uuid.UUID\n\tNameI sql.NullString\n\tDescriptionI sql.NullString\n\tTextField1I sql.NullString\n\tTextField2I sql.NullString\n\tTextField3I sql.NullString\n\tTextField4I sql.NullString\n\tFileI sql.NullString\n\tIds []int32\n}\"\u003e\u003cpre class=\"notranslate\"\u003e\u003cspan class=\"pl-k\"\u003etype\u003c/span\u003e \u003cspan class=\"pl-smi\"\u003ePreFetchContentsByGroupRow\u003c/span\u003e \u003cspan class=\"pl-k\"\u003estruct\u003c/span\u003e {\n\t\u003cspan class=\"pl-c1\"\u003eID\u003c/span\u003e \u003cspan class=\"pl-smi\"\u003eint32\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eName\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eType\u003c/span\u003e \u003cspan class=\"pl-smi\"\u003estring\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eFile\u003c/span\u003e uuid.\u003cspan class=\"pl-smi\"\u003eUUID\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eCategory\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullInt32\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eDescription\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003ePriority\u003c/span\u003e \u003cspan class=\"pl-smi\"\u003eint16\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eEnable\u003c/span\u003e \u003cspan class=\"pl-smi\"\u003ebool\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eSys1\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eSys2\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField1\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField2\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField3\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField4\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eNameI18n\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullInt32\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eProtected\u003c/span\u003e \u003cspan class=\"pl-smi\"\u003ebool\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eUidx\u003c/span\u003e uuid.\u003cspan class=\"pl-smi\"\u003eUUID\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eNameI\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eDescriptionI\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField1I\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField2I\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField3I\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eTextField4I\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eFileI\u003c/span\u003e sql.\u003cspan class=\"pl-smi\"\u003eNullString\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eIds\u003c/span\u003e []\u003cspan class=\"pl-smi\"\u003eint32\u003c/span\u003e\n}\u003c/pre\u003e\u003c/div\u003e\n\u003cp dir=\"auto\"\u003eIs it possible to do so ...\u003c/p\u003e\n\u003cdiv class=\"highlight highlight-source-go notranslate position-relative overflow-auto\" dir=\"auto\" data-snippet-clipboard-copy-content=\"type PreFetchContentsByGroupRow struct {\n\tContent\n\tIds []int32\n}\"\u003e\u003cpre class=\"notranslate\"\u003e\u003cspan class=\"pl-k\"\u003etype\u003c/span\u003e \u003cspan class=\"pl-smi\"\u003ePreFetchContentsByGroupRow\u003c/span\u003e \u003cspan class=\"pl-k\"\u003estruct\u003c/span\u003e {\n\t\u003cspan class=\"pl-smi\"\u003eContent\u003c/span\u003e\n\t\u003cspan class=\"pl-c1\"\u003eIds\u003c/span\u003e []\u003cspan class=\"pl-smi\"\u003eint32\u003c/span\u003e\n}\u003c/pre\u003e\u003c/div\u003e\n\u003cp dir=\"auto\"\u003eCan this be?\u003c/p\u003e","upvoteCount":7,"answerCount":10,"acceptedAnswer":{"@type":"Answer","text":"\u003cp dir=\"auto\"\u003eAs of \u003ccode class=\"notranslate\"\u003ev1.18.0\u003c/code\u003e you can use \u003ccode class=\"notranslate\"\u003esqlc.embed()\u003c/code\u003e for this: \u003ca href=\"https://docs.sqlc.dev/en/stable/reference/changelog.html#sqlc-embed\" rel=\"nofollow\"\u003ehttps://docs.sqlc.dev/en/stable/reference/changelog.html#sqlc-embed\u003c/a\u003e\u003c/p\u003e","upvoteCount":6,"url":"https://github.com/sqlc-dev/sqlc/discussions/363#discussioncomment-6703684"}}}
| 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/Voltron::DiscussionsFragmentsController/show/:user_id/:repository/:discussion_number/discussion_layout(.:format) |
| route-controller | voltron_discussions_fragments |
| route-action | discussion_layout |
| fetch-nonce | v2:4c6007a4-bd0a-12f8-d36b-9e6713a42c32 |
| current-catalog-service-hash | 9f0abe34da433c9b6db74bffa2466494a717b579a96b30a5d252e5090baea7be |
| request-id | A3B6:136CDA:1E23EC:2805CD:6B018A18 |
| html-safe-nonce | ade7298e842132618f086980919c8c2b7464d6cde3168e58a685a533fe2a80a2 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBM0I2OjEzNkNEQToxRTIzRUM6MjgwNUNEOjZCMDE4QTE4IiwidmlzaXRvcl9pZCI6Ijg4MTEzODM4NTM4Nzg4MzAzMiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 31f3f65ad5409c66e4562ea49f7bdadd7febb83b8c481c21ddd045995f836b0c |
| hovercard-subject-tag | discussion:14979 |
| github-keyboard-shortcuts | repository,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/Voltron::DiscussionsFragmentsController/show/sqlc-dev/sqlc/363/discussion_layout |
| twitter:image | https://opengraph.githubassets.com/5eaa95ade495db98d0d25e969a8ef2708f5b4174492f5c4a7182316ca057e4ff/sqlc-dev/sqlc/discussions/363 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/5eaa95ade495db98d0d25e969a8ef2708f5b4174492f5c4a7182316ca057e4ff/sqlc-dev/sqlc/discussions/363 |
| og:image:alt | Hello! Input: (PostgreSQL) -- name: PreFetchContentsByGroup :many SELECT c.*, array_agg(g.id)::INT[] AS Ids FROM contents c INNER JOIN content_group_links cgl ON c.id = cgl.content_id INNER JOIN gr... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| 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 |
Links:
Viewport: width=device-width