Hi all - playing around with the golang client. I'm trying to grab a list of users with a few related records. A user has many databases. I've queried them with

db.User.Database.Some()

A user has many alerts. I've queried them with

db.User.Alert.Some()

An alert has one notification. I've tried querying it with

db.Alert.Notification.Some()

, but

Some

isn't available here. If it's a "has one" relationship, should I be using another function instead?

users, err := prisma.User.FindMany(
		db.User.Alert.Some(
			db.Alert.Notification.Some(),
		),
		db.User.Database.Some(),
	).Exec(ctx)

cc @Luca

For ‘has one’ it should be called

Where

instead of

Some

ok - so this should work?

users, err := prisma.User.FindMany(
		db.User.Alert.Some(
			db.Alert.Notification.Where(),
		),
		db.User.Database.Some(),
	).Exec(ctx)

yep

ok that appears to typecheck. Thanks!

I’m not sure if I understand. This will result in one database call, i.e. one big query, but the query itself may contain many subqueries (a sub SELECT etc.) or many joins

ok that makes sense. I guess I'm curious whether this query would omit users without databases, or users with alerts without notifications? With

.Some()

and

.Where()

, is it required that all relations have records?

Well it will query for whatever you specify in the Some(), if you leave it empty I believe it should return users which have at least one database or have an alert->notification