aggregations

var BanRelationActor = []bson.D{
	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         mongo.CollectionNameUsers,
			LocalField:   "actor_id",
			ForeignField: "_id",
			As:           "actors",
		},
	}},
	{{
		Key: "$set",
		Value: bson.M{
			"actor": bson.M{"$first": "$actors"},
		},
	}},
}

var BanRelationVictim = []bson.D{
	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         mongo.CollectionNameUsers,
			LocalField:   "victim_id",
			ForeignField: "_id",
			As:           "victims",
		},
	}},
	{{
		Key: "$set",
		Value: bson.M{
			"victim": bson.M{"$first": "$victims"},
		},
	}},
}

var EmoteSetRelationActiveEmotes = mongo.Pipeline{

	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         mongo.CollectionNameEmotes,
			LocalField:   "emotes.id",
			ForeignField: "versions.id",
			As:           "_emotes",
		},
	}},

	{{
		Key: "$set",
		Value: bson.M{
			"emotes": bson.M{
				"$map": bson.M{
					"input": "$emotes",
					"in": bson.M{
						"$mergeObjects": bson.A{
							"$$this",
							bson.M{
								"emote": bson.M{
									"$arrayElemAt": bson.A{
										"$_emotes",
										bson.M{"$indexOfArray": bson.A{"$_emotes._id", "$$this.id"}},
									},
								},
							},
						},
					},
				},
			},
		},
	}},
}

var ReportRelationReporter = []bson.D{
	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         mongo.CollectionNameUsers,
			LocalField:   "reporter_id",
			ForeignField: "_id",
			As:           "reporters",
		},
	}},
	{{
		Key: "$set",
		Value: bson.M{
			"reporter": bson.M{"$first": "$reporters"},
		},
	}},
	{{Key: "$unset", Value: bson.A{"reporters"}}},
}

var UserRelationBans = []bson.D{
	{{
		Key: "$lookup",
		Value: mongo.LookupWithPipeline{
			From: mongo.CollectionNameBans,
			Let:  bson.M{"user_id": "$_id"},
			Pipeline: &mongo.Pipeline{
				{{
					Key: "$match",
					Value: bson.M{
						"$expr": bson.M{
							"$eq": bson.A{"$victim_id", "$$user_id"},
						},
						"$or": bson.A{
							bson.M{"expire_at": time.Time{}},
							bson.M{
								"expire_at": bson.M{"$gt": time.Now()},
							},
						},
					},
				}},
			},
			As: "bans",
		},
	}},
}

var UserRelationConnections = []bson.D{
	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         "user_connections",
			LocalField:   "connection_ids",
			ForeignField: "_id",
			As:           "connections",
		},
	}},
}

var UserRelationEditorOf = []bson.D{
	{{
		Key: "$lookup",
		Value: mongo.LookupWithPipeline{
			From: mongo.CollectionNameUsers,
			Let:  bson.M{"user_id": "$_id"},
			Pipeline: &mongo.Pipeline{
				{{
					Key: "$match",
					Value: bson.M{
						"$expr": bson.M{"$in": bson.A{"$$user_id", "$editors.id"}},
					},
				}},
				{{
					Key: "$project",
					Value: bson.M{
						"user": "$$ROOT",
						"as_editor": bson.M{
							"$mergeObjects": bson.M{
								"$filter": bson.M{
									"input": "$editors",
									"as":    "u_editor_of",
									"cond":  bson.M{"$eq": bson.A{"$$u_editor_of.id", "$$user_id"}},
								},
							},
						},
					},
				}},
				{{
					Key: "$project",
					Value: bson.M{
						"id":          "$_id",
						"permissions": "$as_editor.permissions",
						"connections": "$as_editor.connections",
						"visible":     "$as_editor.visible",
						"user":        "$user",
					},
				}},
				{{Key: "$unset", Value: bson.A{"_id"}}},
			},
			As: "editor_of",
		},
	}},
}

var UserRelationEditors = []bson.D{

	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         mongo.CollectionNameUsers,
			LocalField:   "editors.id",
			ForeignField: "_id",
			As:           "_ed",
		},
	}},
	{{
		Key: "$set",
		Value: bson.M{
			"editors": bson.M{
				"$map": bson.M{
					"input": "$editors",
					"in": bson.M{
						"$mergeObjects": bson.A{
							"$$this",
							bson.M{
								"user": bson.M{
									"$arrayElemAt": bson.A{
										"$_ed",
										bson.M{"$indexOfArray": bson.A{"$_ed._id", "$$this.id"}},
									},
								},
							},
						},
					},
				},
			},
		},
	}},
}

var UserRelationOwnedEmotes = []bson.D{
	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         mongo.CollectionNameEmotes,
			LocalField:   "_id",
			ForeignField: "owner_id",
			As:           "owned_emotes",
		},
	}},
}

var UserRelationRoles = []bson.D{

	{{
		Key: "$lookup",
		Value: mongo.LookupWithPipeline{
			From: mongo.CollectionNameEntitlements,
			Let:  bson.M{"user_id": "$_id"},
			Pipeline: &mongo.Pipeline{
				bson.D{{
					Key: "$match",
					Value: bson.M{
						"disabled": bson.M{"$not": bson.M{"$eq": true}},
						"kind":     "ROLE",
						"$expr": bson.M{
							"$eq": bson.A{"$user_id", "$$user_id"},
						},
					},
				}},
			},
			As: "role_entitlements",
		},
	}},

	{{
		Key: "$set",
		Value: bson.M{
			"role_ids": bson.M{
				"$concatArrays": bson.A{
					bson.M{"$ifNull": bson.A{"$role_ids", bson.A{}}},
					"$role_entitlements.data.ref",
				},
			},
		},
	}},

	{{Key: "$unset", Value: bson.A{"role_entitlements"}}},

	{{
		Key: "$lookup",
		Value: mongo.Lookup{
			From:         mongo.CollectionNameRoles,
			LocalField:   "role_ids",
			ForeignField: "_id",
			As:           "roles",
		},
	}},
}