python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - sqlc

How to use gomock with sqlc

I'd like to write unit tests for functions generated by sqlc but I don't understand how to use gomock. I'm new to mocking. Below I'll describe a bit how sqlc generation works. So, sqlc generates an in...
test-img

Vsevolod Molchanov

go

mocking

gomock

sqlc

Votes: 0

Answers: 0

inserting json to db

I use https://github.com/kyleconroy/sqlc This is a library for generating code. My query -- name: SetAssignmentsResult :exec UPDATE assignments SET status = 'ACCEPTED', result = $1 WHERE task_id =...
test-img

Nakem1

sql

json

database

go

sqlc

Votes: 0

Answers: 0

Return values consisting of the set in Posgresql

I use https://github.com/kyleconroy/sqlc to generate code. I want to return human_id using the group_id array. -- name: HumansByGroupID :many SELECT human_id FROM groups WHERE group_id IN (UNNEST($1::...
test-img

Nakem1

sql

postgresql

go

sqlc

Votes: 0

Answers: 1

Latest Answer

You can do the following: WHERE group_id IN (SELECT col FROM UNNEST($1::uuid[]) AS col); or, alternatively, you can also do: WHERE group_id = ANY ($1::uuid[]);
test-img

mkopriva

Posts

Questions

Blogs

Jobs