使用MongoDB驱动程序创建Java视图

<dependency>
    <groupId>org.mongodb</groupId>
    <artifactId>mongodb-driver-sync</artifactId>
    <version>4.4.0</version>
</dependency>

import com.mongodb.client.MongoClients;
import com.mongodb.client.MongoClient;
import com.mongodb.client.MongoDatabase;

// 创建MongoDB客户端
MongoClient mongoClient = MongoClients.create("mongodb://localhost:27017");

// 获取数据库实例
MongoDatabase database = mongoClient.getDatabase("mydb");

import com.mongodb.client.model.Aggregates;
import com.mongodb.client.model.CreateViewOptions;
import com.mongodb.client.model.Field;
import com.mongodb.client.model.Filters;
import com.mongodb.client.model.Variable;
import com.mongodb.client.model.VariableMap;
import com.mongodb.client.model.ViewPipeline;

// 定义视图管道
ViewPipeline pipeline = new ViewPipeline()
    .add(new Variable<>("filter", Filters.eq("status", "active")))
    .add(new Aggregates.match(Filters.expr("$filter", new Field<>("input", "$orders"), new Field<>("as", "o"), new Field<>("cond", Filters.eq("$$o.status", "completed")))))
    .add(new Aggregates.project(Filters.and(Filters.eq("_id", 0), Filters.eq("name", 1), Filters.eq("total", 1))));

// 创建视图选项
CreateViewOptions options = new CreateViewOptions()
    .viewOn("orders")
    .pipeline(pipeline);

// 创建视图
database.createView("active_completed_orders", "customers", options);