Quick ORM
Search…
hasOne

Usage

A hasOne relationship is a "one-to-one" relationship. For instance, a User entity might have an UserProfile entity attached to it.
1
// User.cfc
2
component extends="quick.models.BaseEntity" accessors="true" {
3
4
function profile() {
5
return hasOne( "UserProfile" );
6
}
7
8
}
Copied!
The first value passed to hasOne is a WireBox mapping to the related entity.
Quick determines the foreign key of the relationship based on the entity name and key values. In this case, the UserProfile entity is assumed to have a userId foreign key. You can override this by passing a foreign key in as the second argument:
1
return hasOne( "UserProfile", "FK_userID" );
Copied!
If your parent entity does not use id as its primary key, or you wish to join the child entity to a different column, you may pass a third argument to the hasOne method specifying your parent table's custom key.
1
return hasOne( "UserProfile", "FK_userID", "profile_id" );
Copied!
The inverse of hasOne is belongsTo. It is important to choose the right relationship for your database structure. hasOne assumes that the related model has the foreign key for the relationship.
1
// UserProfile.cfc
2
component extends="quick.models.BaseEntity" accessors="true" {
3
4
function user() {
5
return belongsTo( "User" );
6
}
7
8
}
Copied!

withDefault

HasOne relationships can be configured to return a default entity if no entity is found. This is done by calling withDefault on the relationship object.
1
// User.cfc
2
component extends="quick.models.BaseEntity" accessors="true" {
3
4
function profile() {
5
return hasOne( "UserProfile" ).withDefault();
6
}
7
8
}
Copied!
Called this way will return a new unloaded entity with no data. You can also specify any default attributes data by passing in a struct of data to withDefault.
1
// User.cfc
2
component extends="quick.models.BaseEntity" accessors="true" {
3
4
function profile() {
5
return hasOne( "UserProfile" ).withDefault( {
6
"showHints": true
7
} );
8
}
9
10
}
Copied!

Signature

Name
Type
Required
Default
Description
relationName
string
true
The WireBox mapping for the related entity.
foreignKey
String | [String]
false
entityName() & keyNames()
The foreign key on the parent entity.
localKey
String | [String]
false
keyNames()
The local primary key on the parent entity.
relationMethodName
String
false
The method name called on the entity to produce this relationship.
The method name called to retrieve this relationship. Uses a stack backtrace to determine by default.
<b></b>
DO NOT PASS A VALUE HERE UNLESS YOU KNOW WHAT YOU ARE DOING.
Returns a HasOne relationship between this entity and the entity defined by relationName.

Visualizer

Last modified 1yr ago
Copy link
Edit on GitHub