Invercargill-Sql/examples/projections/order-detail.vala

using Invercargill.Expressions;
using InvercargillSql.Orm;
using InvercargillSql.Orm.Projections;

/**
 * Join projection demonstrating entity relationships across User, Order, and Product.
 */
public class OrderDetail : Object {
    public int64 order_id { get; set; }
    public string user_name { get; set; }
    public string product_name { get; set; }
    public int64 quantity { get; set; }
    public double total { get; set; }
    public string status { get; set; }
    
    public OrderDetail() {
        user_name = "";
        product_name = "";
        status = "";
    }
    
    public static void configure_projection(ProjectionBuilder<OrderDetail> p) throws ProjectionError {
        p.source<User>("u")
            .join<Order>("o", expr("u.id == o.user_id"))
            .join<Product>("p", expr("o.product_id == p.id"))
            .select<int64?>("order_id", expr("o.id"), (x, v) => x.order_id = v)
            .select<string>("user_name", expr("u.name"), (x, v) => x.user_name = v)
            .select<string>("product_name", expr("p.name"), (x, v) => x.product_name = v)
            .select<int64?>("quantity", expr("o.quantity"), (x, v) => x.quantity = v)
            .select<double?>("total", expr("o.total"), (x, v) => x.total = v)
            .select<string>("status", expr("o.status"), (x, v) => x.status = v);
    }
}