You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
83 lines
1.4 KiB
83 lines
1.4 KiB
db.getCollection('experiment_scopes').aggregate(
|
|
[
|
|
{
|
|
$match: {_id: "c42_v[5-42]_1"}
|
|
},
|
|
{
|
|
$unwind: "$instances"
|
|
},
|
|
{
|
|
$project: {"instance_id": "$instances"}
|
|
},
|
|
{
|
|
$lookup:
|
|
{
|
|
from: "wmis_qubos",
|
|
localField: "instance_id",
|
|
foreignField: "instance",
|
|
as: "wmis_qubo"
|
|
}
|
|
},
|
|
{
|
|
$unwind: "$wmis_qubo"
|
|
},
|
|
{
|
|
$project:
|
|
{
|
|
instance_id: true,
|
|
wmis_qubo_id: "$wmis_qubo._id"
|
|
}
|
|
},
|
|
{
|
|
$lookup:
|
|
{
|
|
from: "embeddings",
|
|
let:
|
|
{
|
|
qubo_id: "$wmis_qubo_id",
|
|
solver_graph_id: ObjectId("5c9e13168c6fe628c16eb361")
|
|
},
|
|
pipeline:
|
|
[
|
|
{
|
|
$project:
|
|
{
|
|
qubo: true,
|
|
solver_graph: true,
|
|
}
|
|
},
|
|
{
|
|
$match:
|
|
{
|
|
$expr:
|
|
{
|
|
$and:
|
|
[
|
|
{$eq: ["$qubo", "$$qubo_id"]},
|
|
{$eq: ["$solver_graph", "$$solver_graph_id"]}
|
|
]
|
|
}
|
|
}
|
|
},
|
|
{
|
|
$project:
|
|
{
|
|
_id: true
|
|
}
|
|
}
|
|
],
|
|
as: "embeddings_id"
|
|
}
|
|
},
|
|
{
|
|
$unwind: "$embeddings_id"
|
|
},
|
|
{
|
|
$project:
|
|
{
|
|
instance_id: true,
|
|
wmis_qubo_id: true,
|
|
embeddings_id: "$embeddings_id._id"
|
|
}
|
|
}
|
|
])
|