Dr. Quadragon ❌

All posts Dr. Quadragon ❌'s posts Post Back to profile

Golang question

So I have this huge MySQL query, which takes 12 input parameters, but all of them are 8 instances of value X and 4 instances of value Y. They're all in different places of the huge query.

How do I bind variables to that in Go in an SQL-safe way?

I see the syntax of "?" but it's not really named, so it works if you have one or two unique parameters, not 12 recurring ones.

Like 18 Aug 2022 at 0:40 | Open on mastodon.ml

5 comments | Expand all CWs

Кира 🌺

Golang question

@drq прочитала gulag

18 Aug 2022 at 1:02 | Open on mastodon.ml

D:\side\

Golang question

@drq я не уверен, насколько это хорошая идея, но в голову приходит CTE с селектом констант:
https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions

Так можно дать им в рамках запроса локальные имена, но снаружи передать всего единожды.

Наверное. У меня в голове это вроде имеет смысл, начал что-то может иметь смысл в 5 часов утра :blobcatgooglyholdingitsheadinitshands:

Или вот такого рода хохма:
> SELECT … FROM …
> INNER JOIN (SELECT ? AS l1, ? AS l2) locals
> ON true
> WHERE c1 = l1 AND c2 IN (l1, l2)

Так можно дать им в рамках запроса локальные имена, но снаружи передать всего единожды.

Expand text...

18 Aug 2022 at 2:03 | Open on mastodon.ml

Golang question

@drq IIRC, instead of `?` you can use `$1`, `$2` and so on.

If you're tired of writing SQL strings by hand, we maintain the sqrl project at my current job:
https://github.com/SharperShape/sqrl

It's a bit nicer than concatenating strings with possible typos all the time :)

18 Aug 2022 at 4:25 | Open on lor.sh

Dr. Quadragon ❌

@bemyak
I tried $1 and $2, doesn't work.

18 Aug 2022 at 10:50 | Open on mastodon.ml

Golang question

@drq yep, sorry, it works in Postgres, not in MySQL. Have you tried `?1` ?

19 Aug 2022 at 8:12 | Open on lor.sh