René's URL Explorer Experiment


Title: Add custom struct tags to params structs · Issue #2039 · sqlc-dev/sqlc · GitHub

Open Graph Title: Add custom struct tags to params structs · Issue #2039 · sqlc-dev/sqlc

X Title: Add custom struct tags to params structs · Issue #2039 · sqlc-dev/sqlc

Description: What do you want to change? Hello, first of all thank you for the brilliant library. As already mentioned in Issue #534, the feature of custom struct tags was implemented with PR #1569. However, I noticed that the custom struct tags are ...

Open Graph Description: What do you want to change? Hello, first of all thank you for the brilliant library. As already mentioned in Issue #534, the feature of custom struct tags was implemented with PR #1569. However, I ...

X Description: What do you want to change? Hello, first of all thank you for the brilliant library. As already mentioned in Issue #534, the feature of custom struct tags was implemented with PR #1569. However, I ...

Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/2039

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Add custom struct tags to params structs ","articleBody":"### What do you want to change?\n\nHello,\r\nfirst of all thank you for the brilliant library.\r\n\r\nAs already mentioned in Issue #534, the feature of custom struct tags was implemented with PR #1569.\r\nHowever, I noticed that the custom struct tags are only added to the database table structs. But not to the their corresponding parameter structs.\r\n\r\nIn my opinion, this would also be quite helpful and should not cause more problems than the struct tags of the database types, or tables, at least in terms of compatibility.\r\n\r\nCurrently I am facing the problem to validate user payloads of a REST API in GoLang.  \r\nFor this I use among others the libraries: sqlc, gofiber, go-playground/validator/v10.\r\n\r\nI noticed the whole thing after I wanted to validate payload data to create a user.\r\nSome project snippets for reference:\r\n\r\n```yaml\r\nversion: \"2\"\r\n\r\nsql:\r\n  - engine: \"postgresql\"\r\n    queries: \"db/sqlc/\"\r\n    schema: \"db/migrations/\"\r\n    gen:\r\n      go:\r\n        package: \"db\"\r\n        out: \"internal/db\"\r\n        emit_json_tags: true\r\n        emit_empty_slices: true\r\n        emit_db_tags: true\r\n        overrides:\r\n          - column: users.first_name\r\n            go_struct_tag: 'validate:\"required\"'\r\n          - column: users.flast_name\r\n            go_struct_tag: 'validate:\"required\"'\r\n          - column: users.email\r\n            go_struct_tag: 'validate:\"required,email\"'\r\n          - column: users.organizational_unit\r\n            go_struct_tag: 'validate:\"required\"'\r\n          - column: users.name\r\n            go_struct_tag: 'validate:\"required\"'\r\n```\r\n\r\n```sql\r\n// db.go\r\n// Code generated by sqlc. DO NOT EDIT.\r\n// versions:\r\n//   sqlc v1.16.0\r\ntype User struct {\r\n\tID                 int32     `db:\"id\" json:\"id\"`\r\n\tFirstName          string    `db:\"first_name\" json:\"first_name\" validate:\"required\"`\r\n\tLastName           string    `db:\"last_name\" json:\"last_name\"`\r\n\tOrganizationalUnit string    `db:\"organizational_unit\" json:\"organizational_unit\" validate:\"required\"`\r\n\tName               string    `db:\"name\" json:\"name\" validate:\"required\"`\r\n\tEmail              string    `db:\"email\" json:\"email\" validate:\"required,email\"`\r\n\tCreatedAt          time.Time `db:\"created_at\" json:\"created_at\"`\r\n\tChangedAt          time.Time `db:\"changed_at\" json:\"changed_at\"`\r\n}\r\n```\r\n\r\n```sql\r\n// query.sql.go\r\n// Code generated by sqlc. DO NOT EDIT.\r\n// versions:\r\n//   sqlc v1.16.0\r\n// source: query.sql\r\ntype UpdateUserParams struct {\r\n\tID                 int32  `db:\"id\" json:\"id\"`\r\n\tFirstName          string `db:\"first_name\" json:\"first_name\"`\r\n\tLastName           string `db:\"last_name\" json:\"last_name\"`\r\n\tOrganizationalUnit string `db:\"organizational_unit\" json:\"organizational_unit\"`\r\n\tName               string `db:\"name\" json:\"name\"`\r\n\tEmail              string `db:\"email\" json:\"email\"`\r\n}\r\n```\r\n\r\n```go\r\nimport (\r\n    \"github.com/gofiber/fiber/v2\"\r\n    \"github.com/go-playground/validator/v10\"\r\n    \"example.org/internal/database\"\r\n    \"example.org/internal/db\" // sqlc generated package\r\n)\r\n\r\nvar (\r\n    validate = validator.New()\r\n)\r\n\r\nfunc ValidateStruct(model interface{}) []*ErrorResponse {\r\n\r\n\tvar errors []*ErrorResponse\r\n\terr := validate.Struct(model)\r\n\tif err != nil {\r\n\t\tfor _, err := range err.(validator.ValidationErrors) {\r\n\t\t\tvar element ErrorResponse\r\n\t\t\telement.FailedField = err.StructNamespace()\r\n\t\t\telement.Tag = err.Tag()\r\n\t\t\telement.Value = err.Param()\r\n\t\t\terrors = append(errors, &element)\r\n\t\t}\r\n\t}\r\n\treturn errors\r\n}\r\n\r\nfunc CreateUser(c *fiber.Ctx) error {\r\n\t// user struct contains struct tags for \"github.com/go-playground/validator/v10\" defined in sqlc.yaml\r\n\tuserPayload := &db.User{}\r\n\r\n\terr := c.BodyParser(&userPayload)\r\n\tif err != nil {\r\n\t\treturn MessageBadRequest(c, \"failure while binding payload data to structured data\")\r\n\t}\r\n\r\n\terrors := ValidateStruct(*userPayload)\r\n\tif errors != nil {\r\n\t\treturn MessageBadRequest(c, errors)\r\n\t}\r\n\r\n\tqueries := database.GetQueries()\r\n\tctx, cancel := database.NewContext()\r\n\r\n\tdefer cancel()\r\n\r\n\t// CreateUserParams is missing custom struct tags for \"github.com/go-playground/validator/v10\" defined in sqlc.yaml\r\n\tinsertedUser, err := queries.CreateUser(ctx, db.CreateUserParams{\r\n\t\t// ...\r\n\t})\r\n\tif err != nil {\r\n\t\treturn err\r\n\t}\r\n\r\n\treturn MessageOK(c, insertedUser)\r\n}\r\n\r\n```\r\n \n\n### What database engines need to be changed?\n\nPostgreSQL, MySQL\n\n### What programming language backends need to be changed?\n\nGo, Python, Kotlin","author":{"url":"https://github.com/timrabl","@type":"Person","name":"timrabl"},"datePublished":"2023-01-27T20:32:27Z","url":"https://github.com/sqlc-dev/sqlc/issues/2039"}

react-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:de15a5eb-ded1-a710-4f17-efcfa90d9693
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idB590:2E7A8:3FDA9:53EF6:6B01805E
html-safe-nonce73f15ad1becdeb5bee5cce369d8db9df2962c0e8ba2399936c33f9615322f442
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCNTkwOjJFN0E4OjNGREE5OjUzRUY2OjZCMDE4MDVFIiwidmlzaXRvcl9pZCI6IjQ3MTcxMTA2NTY4Mzc0NTE4NzAiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacf58a60b51fb97016ca2c6613c88b9c05206b84a669596430b38ce3095d6f1451
hovercard-subject-tagissue:1560396755
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/2039/issue_layout
twitter:imagehttps://opengraph.githubassets.com/0f29f5185a5d3167e3fafbb6febc2fb8c498223537c438ee11886bdff63886eb/sqlc-dev/sqlc/issues/2039
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/0f29f5185a5d3167e3fafbb6febc2fb8c498223537c438ee11886bdff63886eb/sqlc-dev/sqlc/issues/2039
og:image:altWhat do you want to change? Hello, first of all thank you for the brilliant library. As already mentioned in Issue #534, the feature of custom struct tags was implemented with PR #1569. However, I ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernametimrabl
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
go-importgithub.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git
octolytics-dimension-user_id136738596
octolytics-dimension-user_loginsqlc-dev
octolytics-dimension-repository_id193160679
octolytics-dimension-repository_nwosqlc-dev/sqlc
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id193160679
octolytics-dimension-repository_network_root_nwosqlc-dev/sqlc
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlc-dev/sqlc/issues/2039#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F2039
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F2039
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlc-dev%2Fsqlc
Reloadhttps://github.com/sqlc-dev/sqlc/issues/2039
Reloadhttps://github.com/sqlc-dev/sqlc/issues/2039
Reloadhttps://github.com/sqlc-dev/sqlc/issues/2039
sqlc-devhttps://github.com/sqlc-dev
sqlchttps://github.com/sqlc-dev/sqlc
Codehttps://github.com/sqlc-dev/sqlc
Issues600 (600)https://github.com/sqlc-dev/sqlc/issues
Pull requests132 (132)https://github.com/sqlc-dev/sqlc/pulls
Discussionshttps://github.com/sqlc-dev/sqlc/discussions
Actionshttps://github.com/sqlc-dev/sqlc/actions
Projectshttps://github.com/sqlc-dev/sqlc/projects
Security and qualityhttps://github.com/sqlc-dev/sqlc/security
Insightshttps://github.com/sqlc-dev/sqlc/insights
https://github.com/sqlc-dev/sqlc
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/2039
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/2039
Add custom struct tags to params structs https://github.com/sqlc-dev/sqlc/issues/2039#top
📚 mysqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20mysql%22
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
enhancementNew feature or requesthttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22enhancement%22
https://github.com/timrabl
timrablhttps://github.com/timrabl
on Jan 27, 2023https://github.com/sqlc-dev/sqlc/issues/2039#issue-1560396755
#534https://github.com/sqlc-dev/sqlc/issues/534
#1569https://github.com/sqlc-dev/sqlc/pull/1569
timrablhttps://github.com/timrabl
enhancementNew feature or requesthttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22enhancement%22
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
on Jan 27, 2023https://github.com/sqlc-dev/sqlc/issues/2039#event-8376912118
kyleconroyhttps://github.com/kyleconroy
📚 mysqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20mysql%22
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
triageNew issues that hasn't been reviewedhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22triage%22
on Jun 7, 2023https://github.com/sqlc-dev/sqlc/issues/2039#event-9452239950
https://github.com/WiRight
WiRighthttps://github.com/WiRight
on Mar 5, 2025https://github.com/sqlc-dev/sqlc/issues/2039#issuecomment-2701522693
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/2039
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/2039
📚 mysqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20mysql%22
📚 postgresqlhttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Abooks%3A%20postgresql%22
🔧 golanghttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22%3Awrench%3A%20golang%22
enhancementNew feature or requesthttps://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22enhancement%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.