arif-rh/ci4-dynamic-model

Creating CodeIgniter 4 Model on-the-fly with Relationship Built-in Feature.

0.3.7 2021-06-08 20:27 UTC

Requires

• php: >=7.2

Requires (Dev)

• codeigniter4/codeigniter4-standard: ^1.0
• codeigniter4/framework: ^4.0
• php-coveralls/php-coveralls: ^2.2
• phpstan/extension-installer: 1.0.4
• phpstan/phpstan: 0.12.34
• phpstan/phpstan-phpunit: ^0.12.8
• phpunit/phpunit: ^8.5
• squizlabs/php_codesniffer: ^3.3

MIT

• Arif Rahman Hakim

• model
• ci4 model
• codeigniter model
• codeigniter4 model
• codeigniter4 relationship
• ci4 relationship model

README

Dynamic Model for CodeIgniter 4

Feature

• Dynamically Creating the Model on-the-fly
• Support One-to-One / Many-to-One relationship
• Support One-to-Many relationship
• Can Filter data based on child/related criteria
• Can set the order of One-to-Many relationship result based on child criteria

Installation

composer require arif-rh/ci4-dynamic-model

Usage

Simple

    // creating postModel on-the-fly, just pass a table name
    $postModel = \Arifrh\DynaModel\DB::table('posts');

    // then you can use it, to get all posts
    $postModel->findAll();

Many-to-One Relationship

    // assume that posts always belongs to one author using author_id 
    $postModel->belongsTo('authors);

    // then you can grab author info along with posts
    $postModel->with('authors')->findAll();

    /**
    * by default, primary key of authors will be omit in the column result
    * because its value already exist in the foregin key of relationship
    * 
    * if authors has same column name with posts, then it will be aliased with prefix "author_"
    * for example, both posts and authors has "rating" column, then it will become author_rating
    */

    // you can call only spesific column if you need, pass it on the second parameters in array
    $postModel->with('authors', ['name', 'rating'])->findAll(); 
    // will display all posts column, plus author name and author rating

    // you can filter posts based on author criteria
    $postModel->with('authors')->whereRelation('authors', ['status' => 'active'])->findAll();
    // will display all posts only from active authors

One-to-Many Relationship

    $postModel->hasMany('comments');

    // this will return posts with all related comments
    $postModel->with('comments')->findAll();

    // you can also filter posts based on comments criteria
    $postModel->with('comments')->whereRelation('comments', ['status' => 'approved'])->findAll();
    // will display all posts with approved comments only

Testing

    composer test

    // or

    composer testdox

    // analyse code
    composer analyse