Quick ORM
Search…
4.2.0
Guide
Cookbook
External Links
Subclass Entities
By default, Quick supports basic component-level inheritance of entities, meaning that a child component inherits the properties ( and ability to overload ) its parent. A common, object-oriented relational database pattern, however is to provide additional definition on parent tables ( and classes ) within child tables which contain a foreign key.
Quick supports two types of child classes: Discriminated and Subclassed child entities. In both cases, loading any child class will also deliver the data of its parent class.
Subclass Entities
Let's say, for example, that I have a
Media entity, which is used to catalog and organize all media items loaded in to my application.1
component
2
table="media"
3
extends="quick.models.BaseEntity"
4
accessors="true"
5
{
6
​
7
property name="id";
8
property name="uploadFileName";
9
property name="fileLocation";
10
property name="fileSizeBytes";
11
​
12
}
Copied!
My
Media entity contains all of the properties which are common to every media item uploaded in to my application. Let's say, however, that I need to have specific attributes that are available on only media for my Book entity ( e.g. whether the image is the cover photo, for example ). I can create a child class of BookMedia which extends my Media entity. When loaded, all of the properties of Media will be loaded along with the custom attributes which apply to my BookMedia object:1
component
2
extends="Media"
3
table="book_media"
4
joinColumn="FK_media"
5
accessors="true"
6
{
7
property name="displayOrder";
8
property name="designation";
9
​
10
function approvalStatus(){
11
return belongsTo( "Book", "FK_book" );
12
}
13
​
14
}
Copied!
Note the additional component attribute
joincolumn. The presence of this attribute on a child class signifies that it is a child entity of the parent and that the parent's properties should be loaded whenever the BookMedia entity is loaded. In addition, the primary key of the entity is that of the parent.Note that a
table attribute is required on a child entity if the parent entity has one. This is because ColdBox will perform a deep merge on the entire inheritance chain for metadata properties. If a parent class has a table attribute, it will show up as the child's table attribute.Child entities can be retrieved by queries specific to their own properties:
1
var coverPhotos = getInstance( "BookMedia" )
2
.where( "designation", "cover" )
3
.orderBy( "displayOrder", "ASC" );
Copied!
Or properties on the parent class can be used as first-class properties within the query:
1
var smallCoverPhotos = getInstance( "BookMedia" )
2
.where( "designation", "cover" )
3
.where( "fileSizeBytes", "<", 40000 )
4
.orderBy( "displayOrder", "ASC" )
5
.orderBy( "uploadFileName", "ASC" );
Copied!
Child entities can be retrieved, individually, using the value of the
joinColumn, which should be a foreign key to the parent identifier column:1
var myBookMediaItem = getInstance( "BookMedia" ).get( myId );
Copied!
Now my
Book entity can use its extended media class to retrieve media items which are specific to its own purpose:1
function media(){
2
return hasMany( "BookMedia", "FK_book" ).orderBy( "displayOrder", "ASC" );
3
}
Copied!
Discriminated Entities
A discriminated child class functions, basically, in the same way as a subclassed entity, with one exception: The parent entity is aware of the discriminated child, due to a
discriminatorValue attribute and will return that specific class when a retrieval is performed through the parent Entity. Let's take our BookMedia class, again, but this time defining it as a discriminated entity.The first step is to add the
discriminatorColumn attribute to the Media entity:1
component
2
table="media"
3
extends="quick.models.BaseEntity"
4
accessors="true"
5
discriminatorColumn="type"
6
{
7
​
8
property name="id";
9
property name="uploadFileName";
10
property name="fileLocation";
11
property name="fileSizeBytes";
12
​
13
}
Copied!
Then we set a
discriminatorValue property on the child class, the value of which is stored in the parent entity table:1
component
2
extends="Media"
3
table="book_media"
4
joinColumn="FK_media"
5
discriminatorValue="book"
6
accessors="true"
7
{
8
property name="displayOrder";
9
property name="designation";
10
​
11
function approvalStatus(){
12
return belongsTo( "Book", "FK_book" );
13
}
14
​
15
}
Copied!
Finally, we define an array of possible discriminated entities for the parent. This is so we don't have to scan all Quick components just to determine if there are any discriminated entities.
1
component
2
extends="Media"
3
table="book_media"
4
joinColumn="FK_media"
5
discriminatorValue="book"
6
accessors="true"
7
{
8
property name="displayOrder";
9
property name="designation";
10
11
variables._discriminators = [
12
"BookMedia"
13
];
14
​
15
function approvalStatus(){
16
return belongsTo( "Book", "FK_book" );
17
}
18
​
19
}
Copied!
Once this is defined, any new
BookMedia entity will be saved with a type value of book in the media table. As such, the following query will result in only entities of BookMedia being returned:1
var bookMedia = getInstance( "Media" ).where( "type", "book" ).get();
Copied!
If our
Media table contains a combination of non-book and book media, then the collection returned when querying all records will contain a mix of BookMedia and Media entities.Loading a collection of
BookMedia entities, however, will always return a collection of BookMedia entities, because the type column value on the media must be equal to book.Summary
Discriminated and child class entities, allow for a more Object oriented approach to entity-specific relationships by allowing you to eliminate pivot/join tables and extend the attributes of the base class.
Last modified 1yr ago
Copy link
Edit on GitHub