Goal: using the golang lib GORM.io, trying to generate a WHERE clause (programmatically) with (potentially multiple) 'OR' clauses grouped together.
Example:
Bad
SELECT * FROM ... WHERE (x = 'one') OR (y = 'two') OR (z = 'three')
Good
SELECT * FROM ... WHERE (x = 'one' AND (y = 'two' OR z = 'three'))
I've...
- read the GORM documentation end to end
- looked at the GORM source code; and tried doing this with Scopes(), SubQuery(), and Expr() to extract only the (what GORM internally refers to as the 'search' field) and generating the SQL string automatically
- scoured the depths of stack overflow for an answer to this
- considered giving up and going to be a shepherd in new zealand
Latest attempt and how I think something like this would be solved...ish.
q := gorm.DB
q.Where(`x=?`, `one`).Where(
gorm.<NewScopeMaybe?).Or(`y=?`, `two`).Or(`z=?`,`three`).Expr()
)
If anyone has some insight, I won't buy you a beer but I will upvote the hell out of your answer and tell my mom to register for stack overflow so she too can upvote your answer.