Invercargill-Sql/examples/projections/user-summary.vala

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

/**
 * Simple projection demonstrating basic field selection from a single entity.
 */
public class UserSummary : Object {
    public int64 user_id { get; set; }
    public string user_name { get; set; }
    public string email { get; set; }
    
    public UserSummary() {
        user_name = "";
        email = "";
    }
    
    public static void configure_projection(ProjectionBuilder<UserSummary> p) throws ProjectionError {
        p.source<User>("u")
            .select<int64?>("user_id", expr("u.id"), (x, v) => x.user_id = v)
            .select<string>("user_name", expr("u.name"), (x, v) => x.user_name = v)
            .select<string>("email", expr("u.email"), (x, v) => x.email = v);
    }
}