How to join array of strings?

Question

I have an API where I send a parameter currentList: ["hey", "cool"]

type sentenceCreateReq struct {
    CurrentList []string `json:"currentList"`
}

func (usr *SentenceResource) Create(c buffalo.Context) error {
    req := sentenceCreateReq{}
    parseReqBody(c.Request(), &req)

    ...

    sentence := models.Sentence{}
    err := tx.Limit(1).Where("word NOT IN (?)", c.Params("currentList")).First(&sentence)

    ...
}

How would I be able to join the array of strings to fit my requirement?

The SQL statement I want to run is

SELECT * FROM sentences WHERE word NOT IN ('hey', 'cool');

Possible duplicates: Go and IN clause in Postgres; and Golang MySQL querying undefined amount of args using IN operator. — icza
– icza, Commented Apr 6, 2018 at 15:03

Slabgorb · Accepted Answer · 2018-04-06 15:31:39Z

1

Generally you will need a number of placeholders equal to the length of the slice you are passing in

like this, for example: https://play.golang.org/p/AZRTUsfKyH7

then something like

tx.Where(query, sentence...)

which will pass in the slice as separate arguments to fill in the placeholders.

answered Apr 6, 2018 at 15:31

Slabgorb

8167 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to join array of strings?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related