Skip to main content

Castle ActiveRecord with Criteria and Alias

Update May 25, 2007: ActiveRecord now supports DetachedCriteria, which eliminates the need for the SlicedFindAll that I wrote below. It is nice when a library moves to add support for such commonly needed functions. So in summary, use Detached criteria instead of the code below. It is still a nice example of using NHibernate sessions.

I have a history log, where each history record "belongs to" a service record. I have to treat this as a child-to-parent join, since some children are orphans. I wanted to use the FindAll(Criteria), but I wanted the option to have optional criteria, orders and aliases. My solution was to create an ARAlias class to represent an Associated Entity and an alias, and then build an ARBusinessBase class with the following method:

public static T[] SlicedFindAll(int firstResult, int maxResults,
Order[] orders, ARAlias[] aliases, params ICriterion[] criteria)
{
IList list = null;
ISessionFactoryHolder holder = ActiveRecordMediator.GetSessionFactoryHolder();
ISession session = holder.CreateSession(typeof(T));

try
{
ICriteria sessionCriteria = session.CreateCriteria(typeof(T));

if (aliases != null)
{
foreach (ARAlias alias in aliases)
{
alias.AttachTo(sessionCriteria);
}
}

if (criteria != null)
{
foreach (ICriterion cond in criteria)
{
sessionCriteria.Add(cond);
}
}

if (orders != null)
{
foreach (Order order in orders)
{
sessionCriteria.AddOrder(order);
}
}

sessionCriteria.SetFirstResult(firstResult);
sessionCriteria.SetMaxResults(maxResults);

list = SupportingUtils.BuildArray(typeof(T), sessionCriteria.List());
}
catch (ValidationException)
{
throw;
}
catch (Exception ex)
{
throw new ActiveRecordException("Could not perform SlicedFindAll for "
+ typeof(T).Name, ex);
}
finally
{
holder.ReleaseSession(session);
}
return (T[])list;
}


The ActiveRecordBase methods in svn trunk allow you to supply a null for the Order[] array, but not for Criteria (in that case, they require an empty placeholder array. My method is more consistent, and allows null for any array. So if I do not need to do an "ORDER BY", I can do ...

IList list = History.SlicedFindAll(0, 10, null, null, myCriterionList);

rather than ...

IList list = History.SlicedFindAll(0, 10, new ARAlias[] {}, new Order[] {}, myCriterionList);

Either way works. My ARAlias class just attaches itself to the query's criteria by calling sessionCriteria.CreateAlias(associatedEntityName, aliasName). Here is the code for the ARAlias class:

using System;
using System.Collections.Generic;
using System.Text;

using NHibernate;
using NHibernate.SqlCommand;

namespace LearningByDoing.ActiveRecord.Support
{
// represents an alias to be added to a Criteria search
public class ARAlias
{
private string _associationPath;
private string _alias;
private JoinType _joinType;

public ARAlias(string associationPath, string alias)
{
_associationPath = associationPath;
_alias = alias;
_joinType = JoinType.InnerJoin;
}

public ARAlias(string associationPath, string alias, JoinType joinType)
{
_associationPath = associationPath;
_alias = alias;
_joinType = joinType;
}

public ICriteria AttachTo(ICriteria criteria)
{
// apparently, this creates and attaches the alias to the supplied criteria
criteria.CreateAlias(_associationPath, _alias, _joinType);
return criteria;
}
}
}



I might make contact with the ActiveRecord maintainer, and see if there is any interest in adding something like this to the mainline. I would have to build a patch for ActiveRecordBase, adding the non-generic base methods and calling them from the generic child type. In my code, I have ARSortOrder, ARAlias and ARCriterion. My ARCriterion class is very weak, but the ARSortOrder and ARAlias classes seem to work nicely in my application. My current ARCriterion is more of a "Builder" class that allows the user of my application to select a property, an equality condition like LESS_THAN or EQUALS, and a value or entity, and create a Criterion from that. I will not pretend that my augmentation of ActiveRecord's Criteria support eliminates the need for HQL, but it dramatically reduces it.

Comments

Popular posts from this blog

How does Rails scaffolding select HTML input tags?

Recently, a reader saw my fix for SQL Server booleans, and asked me a followup question: why does Rails display a yes/no selection instead of a checkbox? The short answer is look in {RUBY_HOME} /lib/ruby/gems/1.8 /gems/actionpack-1.10.2 /lib/action_view/helpers, but your path may vary depending on whether you are using gem, "edge rails", etc. Anyway, look in the file "active_record_helper.rb" for a method called "all_input_tags", and notice that it calls "default_input_block" if you don't supply an input_block. Now notice that "default_input_block" creates a label and calls "input(record, column.name)" which in turn calls "InstanceTag#to_tag" which finally looks at the datatype and maps boolean to a select tag. Perhaps a wiser Rails explorer can provide us with the rationale for this, but I guess we could add a MixIn for InstanceTag that redefines the to_tag() method, or just do a dirty and unmaintainable hack l...

Destiny 2 - The Corrupted Nightfall

 == Overview == This Dreaming City Nightfall is already considered one of the most irritating strikes, in part because of bugs that sometimes prevent players from proceeding to the next encounter.  Notable bugged areas are the transition from the Elevator to the Knights Steps, and after the passage, the temple sometimes doesn't reveal a way to the shadow realm where you will take your leap. Important Note: After a "de-buff" from Particle Deconstruction, shoot the boss in the head!  It is quite effective, and can melt her with some coordination. Champions: Unstoppable and Overload Shields: Arc, Solar and Void (many shields!) Don't place your well in the open where boss can snipe the sword!  She will break your super. Pass the "Relic" (Orb) twice to maximize damage. == Loadouts == General: * Add Taken spec to every weapon Titans: * Bottom Tree Solar + Path of the Burning Steps or Phoenix Cradle * Sentinal Shield + Ursa, Aeon Gauntlets Warlocks: * Stasis + Blea...

Updated ActiveRecord Code Generator

Today, I updated the ActiveRecord Code Generator a bit. I checked in changes to use primary and foreign key details from INFORMATION_SCHEMA. The original code used naming conventions to decide what various fields were used for - ID = Primary Key, Field_ID = Foreign Key to table Fields. If you want to use naming conventions, let me know and I can add a setting in App.Config to allow this (along with any "real" key constraints).