PHPackages ametsuramet/simple\_orm - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. ametsuramet/simple\_orm ActiveLibrary ametsuramet/simple\_orm ======================= DB Wrapper for build simple orm in laravel v1.2.6(8y ago)044MITPHPPHP >=5.3.0 Since Aug 3Pushed 8y ago1 watchersCompare [ Source](https://github.com/ametsuramet/simple_orm)[ Packagist](https://packagist.org/packages/ametsuramet/simple_orm)[ RSS](/packages/ametsuramet-simple-orm/feed)WikiDiscussions master Synced 3d ago READMEChangelog (10)DependenciesVersions (14)Used By (0) Simple ORM for LARAVEL ====================== [](#simple-orm-for-laravel) Laravel Package alternative for Eloquent ORM. Installation ------------ [](#installation) Begin by pulling in the package through Composer. ``` composer require ametsuramet/simple_orm:1.2.* ``` Or add in the `require` key of `composer.json` file manually ``` "ametsuramet/simple_orm": "1.2.*" ``` Register the ServiceProvider in `config/app.php` ``` 'providers' => [ // ... Amet\SimpleORM\ModelBuilderServiceProvider::class, ], ``` ### For Lumen [](#for-lumen) Add this service provider to your `bootstrap/app.php` file. ``` $app->register(Amet\SimpleORM\ModelBuilderServiceProvider::class); ``` Defining Models --------------- [](#defining-models) The easiest way to create a model instance is using the `simple_orm:model` Artisan command: ``` php artisan simple_orm:model Project ``` or you can use interactive mode: ``` php artisan simple_orm:interactive ``` ### Command Options [](#command-options) ``` php artisan simple_orm:model Project --soft_delete=1 --methods=transactions,users --default_key=uuid --migration=1 ``` All models will placed in `app/ORM` folder. Usage ----- [](#usage) in your controller file: ``` // ... use App\ORM\Project; class yourController extends Controller { public function yourMethod() { $projects = new Project; $projects = $projects->get(); dd($projects); } // ... ``` or something like this: ``` // ... $projects = (new Project)->get(); dd($projects); // ... ``` ### Table Names [](#table-names) By Default SimpleORM will generate *$table* attribut, but you can change name of table in Models ``` ... class Project extends BaseQuery { protected $table = 'projects'; ... ``` ### Default Keys [](#default-keys) SimpleORM will also assume that each table has a primary key column named id. You may define a *$default\_key* property to override. ``` ... class Project extends BaseQuery { protected $default_key = 'uuid'; ... ``` ### Public Method [](#public-method) #### where((array) $params) [](#wherearray-params) ``` // ... $projects = new Project; $projects = $projects->where(['id',1])->get(); dd($projects); // ... ``` or ``` // ... $wheres = [ ['id','>=',10], ['date','>=','2017-01-01'], ]; $projects = new Project; $projects = $projects->where($wheres)->get(); dd($projects); // ... ``` #### limit((int) $params, (int) $params) [](#limitint-params-int-params) ``` // ... $projects = new Project; $projects = $projects->limit(10)->get(); dd($projects); // ... ``` you can add offset : ``` // ... $projects = new Project; $projects = $projects->limit(20,10)->get(); dd($projects); // ... ``` #### deleted\_only() [](#deleted_only) Show deleted only ``` // ... $projects = new Project; $projects = $projects->deleted_only()->get(); dd($projects); // ... ``` #### deleted((boolean) $params) [](#deletedboolean-params) As noted above, soft deleted models will automatically be excluded from query results, you can use this method to include deleted records ``` // ... $projects = new Project; $projects = $projects->deleted(true)->get(); dd($projects); // ... ``` #### info() [](#info) ``` // ... $projects = new Project; $projects = $projects->info(); dd($projects); // ... ``` #### orderBy((string) $params, (string) $params) [](#orderbystring-params-string-params) ``` // ... $projects = new Project; $projects = $projects->orderBy('id')->get(); dd($projects); // ... ``` or ``` // ... $projects = new Project; $projects = $projects->orderBy('id','desc')->get(); dd($projects); // ... ``` #### groupBy() [](#groupby) ``` // ... $projects = new Project; $projects = $projects->groupBy('id')->get(); dd($projects); // ... ``` or ``` // ... $projects = new Project; $projects = $projects->groupBy(['id','date'])->get(); dd($projects); // ... ``` #### insert((array) $params) [](#insertarray-params) ``` // ... $projects = new Project; $projects = $projects->insert(["name" => 'new project']); dd($projects); // ... ``` #### update($id,(array) $params) [](#updateidarray-params) ``` // ... $projects = new Project; $projects = $projects->update(29,["name" => 'new project']); dd($projects); // ... ``` #### delete($id) [](#deleteid) ``` // ... $projects = new Project; $projects = $projects->delete(29); // ... ``` #### get() [](#get) ``` // ... $projects = new Project; $projects = $projects->get(); dd($projects); // ... ``` #### first() [](#first) ``` // ... $projects = new Project; $projects = $projects->first(); dd($projects); // ... ``` #### find($id) [](#findid) ``` // ... $projects = new Project; $projects = $projects->find(29); dd($projects); // ... ``` #### last() [](#last) ``` // ... $projects = new Project; $projects = $projects->last(); dd($projects); // ... ``` #### paginate((int) $params) [](#paginateint-params) ``` // ... $projects = new Project; $projects = $projects->paginate($params); dd($projects); // ... ``` #### set\_show\_column((array) $params) [](#set_show_columnarray-params) ``` // ... $projects = new Project; $projects = $projects->set_show_column(['id','first_name','last_name'])->get(); dd($projects); // ... ``` #### hide\_relation() [](#hide_relation) ``` // ... $projects = new Project; $projects = $projects->hide_relation()->get(); dd($projects); // ... ``` #### count() [](#count) ``` // ... $projects = new Project; $projects = $projects->count(); dd($projects); // ... ``` #### getQueryLog() [](#getquerylog) ``` // ... $projects = new Project; $projects = $projects->getQueryLog(); dd($projects); // ... ``` ### Relation [](#relation) #### hasOne($relation\_table,$relation\_key,$table\_key,$relation\_name,$show\_column(optional)) [](#hasonerelation_tablerelation_keytable_keyrelation_nameshow_columnoptional) ``` ... class Project extends BaseQuery { public function user() { $this->hasOne(User:class,'id','user_id','user'); } ... ``` with show\_column ``` ... class Project extends BaseQuery { public function user() { $this->hasOne(User:class,'id','user_id','user',['id','first_name','last_name']); } ... ``` #### hasMany($relation\_table,$relation\_key,$table\_key,$relation\_name,$show\_column(optional)) [](#hasmanyrelation_tablerelation_keytable_keyrelation_nameshow_columnoptional) ``` ... class Project extends BaseQuery { public function user() { $this->hasOne(User:class,'id','user_id','user'); } ... ``` with show\_column ``` ... class Project extends BaseQuery { public function user() { $this->hasOne(User:class,'id','user_id','user',['id','first_name','last_name']); } ... ``` #### manyToMany($relation\_table,$relation\_key,$table\_key,$relation\_name,$pivot\_table,$show\_column(optional)) [](#manytomanyrelation_tablerelation_keytable_keyrelation_namepivot_tableshow_columnoptional) ``` ... class Project extends BaseQuery { public function user() { $pivot_table = [UserProject::class,'user_id','company_id']; $this->manyToMany(User:class,'id','user_id','user',$pivot_table); } ... ``` with show\_column ``` ... class Project extends BaseQuery { public function user() { $pivot_table = [UserProject::class,'user_id','company_id']; $this->manyToMany(User:class,'id','user_id','user',$pivot_table,['id','first_name','last_name']); } ... ``` ### Health Score 28 — LowBetter than 54% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity8 Limited adoption so far Community7 Small or concentrated contributor base Maturity65 Established project with proven stability Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~0 days Total 13 Last Release 3200d ago Major Versions 0.1 → v1.02017-08-04 ### Community Maintainers ![](https://avatars.githubusercontent.com/u/7141326?v=4)[ametsuramet](/maintainers/ametsuramet)[@ametsuramet](https://github.com/ametsuramet) --- Top Contributors [![ametsuramet](https://avatars.githubusercontent.com/u/7141326?v=4)](https://github.com/ametsuramet "ametsuramet (18 commits)") ### Embed Badge ![Health badge](/badges/ametsuramet-simple-orm/health.svg) ``` [![Health](https://phpackages.com/badges/ametsuramet-simple-orm/health.svg)](https://phpackages.com/packages/ametsuramet-simple-orm) ``` PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)