Using the same field operation multiple times does not work

[steebchen]

The following does not work:

user, err := client.Post.FindUnique(
	db.Post.Or(
		db.Post.Status.Equals(PostStatusUnpublished),
		db.Post.Status.Equals(PostStatusFlagged),
	),
).Exec(ctx)

This works:

user, err := client.Post.FindUnique(
	db.Post.Or(
		db.Post.And(
			db.Post.Status.Equals(PostStatusUnpublished),
		),
		db.Post.And(
			db.Post.Status.Equals(PostStatusFlagged),
		),
	),
).Exec(ctx)

For the above example, you can consider using .In() instead:

user, err := client.Post.FindUnique(
	db.Post.In([]PostStatus{PostStatusUnpublished, PostStatusFlagged}),
).Exec(ctx)

Alternatively, wrap your queries using the same field in an .And() like above.

For linking many items, you can do the following:

user, err := client.User.FindUnique(
	User.ID.Equals("new"),
).Update(
	User.Posts.Link(
		Post.ID.Equals("a"),
		Post.ID.Equals("b"),
		Post.ID.Equals("c"),
	),
).Exec(ctx)

// or

worker, err := client.Worker.FindUnique(
	Worker.ID.Equals("new"),
).Update(
	db.Worker.Actions.Link(
		db.Action.TenantIDID(
			db.Action.TenantID.Equals(tenantId),
			db.Action.ID.Equals("action:one"),
		),
	),
	db.Worker.Actions.Link(
		db.Action.TenantIDID(
			db.Action.TenantID.Equals(tenantId),
			db.Action.ID.Equals("action:two"),
		),
	),
).Exec(ctx)

TODO @steebchen: explain why this does not work (AST reasons)

This results in unexpected behaviour. #1094 disallows the use of this and fails on runtime.