Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQLboiler not in clause

I am trying to follow the examples in sqlboiler (https://github.com/volatiletech/sqlboiler). But, I can't find a way to get equivalent of NOT IN query.

users, err := models.Users(
  Select("id", "name"),
  Where("age > ?", 30),
  AndIn("c.kind in ?", "visa", "mastercard"),
).All(ctx, db)

In this example, if, we could get an operation AndNotIn, it'd be great.

Thanks!

like image 968
Vikas Goel Avatar asked Oct 15 '22 14:10

Vikas Goel


1 Answers

I'm seeing AndNotIn in current versions of SQLBoiler generated code.

Looks like it was added on July 3rd, 2020.

like image 149
Matt Mc Avatar answered Oct 21 '22 03:10

Matt Mc



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!