How to construct Subselects with v0.30.0?

[mpapenbr]

I am struggeling to compose a query with subselects.
Given two tables

CREATE TABLE event
(
   id                       serial,
   name                     varchar       NOT NULL,
   description              varchar,
   track_id                 integer       NOT NULL,
);

CREATE TABLE track
(
   id               serial,
   name             varchar   NOT NULL,
);

What I try to accomplish is to select all events where a searchArg is contained in event.name, event.description or trach.name
The SQL would look like this

select id from event 
WHERE name ilike $1
OR    description ilike $1
OR    track_id in (select id from track where name ilike $1)

with $1 beeing the searchArg

I used the code generation and this works fine.
The first two parts could be handled like this

partMain := psql.WhereOr(
		models.SelectWhere.Events.Name.ILike(searchArg),
		models.SelectWhere.Events.Description.ILike(searchArg),	
	)
query := models.Events.Query(partMain)
res, err := query.All(context.Background(), exec)

So far so good. A sub select could be this one

s := psql.Select(
		sm.Columns(models.TrackColumns.ID),
		models.SelectWhere.Tracks.Name.ILike(searchArg),
		sm.From(models.TrackColumns.Name).As("t"))

My problem is to combine this with the above query. Can someone give me a hint?

[stephenafamo]

Try this:

	searchArg := psql.Arg("%" + "search" + "%")
	query := models.Events.Query(
		psql.Or(
			models.SelectWhere.Events.Name.ILike(searchArg),
			models.SelectWhere.Events.Description.ILike(searchArg),
			models.EventColumns.TrackID.In(psql.Select(
				sm.Columns(models.TrackColumns.ID),
				models.SelectWhere.Tracks.Name.ILike(searchArg),
				sm.From(models.TrackColumns.Name).As("t"),
			)),
		),
	)
	res, err := query.All(context.Background(), exec)

[mpapenbr]

This works - thanks a lot