PHP code example of ametsuramet / simple_orm

1. Go to this page and download the library: Download ametsuramet/simple_orm library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

ametsuramet / simple_orm example snippets


'providers' => [
    // ...
    Amet\SimpleORM\ModelBuilderServiceProvider::class,
],


$app->register(Amet\SimpleORM\ModelBuilderServiceProvider::class);


// ...

use App\ORM\Project;

class yourController extends Controller {
	
	public function yourMethod()
	{
		$projects = new Project;
		$projects = $projects->get();

		dd($projects);
	}
// ...



// ...
		$projects = (new Project)->get();
		dd($projects);
// ...



...
class Project extends BaseQuery
{
	protected $table = 'projects';
...


...
class Project extends BaseQuery
{
	protected $default_key = 'uuid';
...


// ...
		$projects = new Project;
		$projects = $projects->where(['id',1])->get();
		dd($projects);
// ...



// ...
		$wheres = [
			['id','>=',10], 
			['date','>=','2017-01-01'], 
		];
		$projects = new Project;
		$projects = $projects->where($wheres)->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->limit(10)->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->limit(20,10)->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->deleted_only()->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->deleted(true)->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->info();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->orderBy('id')->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->orderBy('id','desc')->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->groupBy('id')->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->groupBy(['id','date'])->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->insert(["name" => 'new project']);
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->update(29,["name" => 'new project']);
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->delete(29);
// ...



// ...
		$projects = new Project;
		$projects = $projects->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->first();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->find(29);
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->last();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->paginate($params);
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->set_show_column(['id','first_name','last_name'])->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->hide_relation()->get();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->count();
		dd($projects);
// ...



// ...
		$projects = new Project;
		$projects = $projects->getQueryLog();
		dd($projects);
// ...



...
class Project extends BaseQuery
{
	public function user()
	{
		$this->hasOne(User:class,'id','user_id','user');
	}
...


...
class Project extends BaseQuery
{
	public function user()
	{
		$this->hasOne(User:class,'id','user_id','user',['id','first_name','last_name']);
	}
...


...
class Project extends BaseQuery
{
	public function user()
	{
		$this->hasOne(User:class,'id','user_id','user');
	}
...


...
class Project extends BaseQuery
{
	public function user()
	{
		$this->hasOne(User:class,'id','user_id','user',['id','first_name','last_name']);
	}
...


...
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);
	}
...


...
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']);
	}
...

bash
php artisan simple_orm:model Project

bash
php artisan simple_orm:interactive