Download the PHP package lorenzo/linkable without Composer
On this page you can find all versions of the php package lorenzo/linkable. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package linkable
CakePHP Linkable Behavior
Linkable behavior is a companion for the CakePHP built-in containable behavior. It helps fill the gaps that are not covered by containable: You will be able to contain association that are not directly associated with your model and to generate queries joining all specified models.
This is particularly useful when you want to filter results by conditions in a hasMany or hasAndBelongsToMany relationship.
Original behavior by rafaelbandeira3 on GitHub.
Licensed under The MIT License Redistributions of files must retain the above copyright notice.
Requirements
- CakePHP 2.x
- PHP 5.2+
Installation
If you are using composer, add this to your composer.json file:
Otherwise just clone this repository inside your app/Plugin folder:
git clone git://github.com/lorenzo/linkable.git Plugin/Linkable
Enable plugin
You need to enable the plugin your app/Config/bootstrap.php file:
CakePlugin::load('Linkable');
Configuration
To use this behavior, add it to your AppModel:
Usage
Here's an example using both linkable and containable:
Relationships:
- CasesRun is the HABTM table of TestRun <-> TestCases
- CasesRun belongsTo TestRun
- CasesRun belongsTo User
- CasesRun belongsTo TestCase
- TestCase belongsTo TestSuite
- TestSuite belongsTo TestHarness
- CasesRun HABTM Tags
Output SQL:
If you were to try this example with containable, you would find that it generates a lot of queries to fetch all of the data records. Linkable produces a single query with joins instead.
Filtering a parent model by records in a child model:
The previous example will bring all articles having a comment done by user 1. Please note that if there is more than one comment per article from a user, this query will actually return an Article record per each comment made. This is because Linkable will use a single query using joins.
version 1.1.1
- Using inner joins for filtering queries
- Bug fixes
version 1.1:
- Brought in improvements and test cases from Terr. However, THIS VERSION OF LINKABLE IS NOT DROP-IN COMPATIBLE WITH Terr's VERSION!
- If fields aren't specified, will now return all columns of that model
- No need to specify the foreign key condition if a custom condition is given. Linkable will automatically include the foreign key relationship.
-
Ability to specify the exact condition Linkable should use. This is usually required when doing on-the-fly joins since Linkable generally assumes a belongsTo relationship when no specific relationship is found and may produce invalid foreign key conditions. Example:
$this->Post->find('first', array('link' => array('User' => array('conditions' => array('exactly' => 'User.last_post_id = Post.id')))))
- Linkable will no longer break queries that use SQL COUNTs
More examples
Look into the unit tests for some more ways of using Linkable
