DbObject.md

安装

composer require ezswoole/dbobject

示例

假如你的项目的tp的风格，可以继承EasySwoole\Mysqli\DbObject来自定义

<?php

namespace App\Model;

use EasySwoole\Mysqli\DbObject;
use EasySwoole\Spl\SplString;
use 你的MysqlPool;
use 你的MysqlObject;

class Model extends DbObject
{
	protected $prefix = 'ez_';
	protected $modelPath = '\\App\\Model';
	protected $fields = [];
	protected $limit;

	public function initialize() : void
	{
		try{
			$db = MysqlPool::invoke( function( MysqlObject $mysqlObject ){
				return $mysqlObject;
			} );
			$this->setDb($db);
		}catch(\Exception $e){
			var_dump($e->getMessage());
		}

	}

	public function __construct( $data = null )
	{
		if( empty( $this->dbTable ) ){
			$split         = explode( "\\", get_class( $this ) );
			$end           = end( $split );
			$splString     = new SplString( $end );
			$name          = $splString->snake( '_' )->__toString();
			$this->dbTable = $this->prefix.$name." AS {$name}";
		}
		parent::__construct( $data );
	}

	protected function joins( array $joins ) : Model
	{
		foreach( $joins as $join ){
			self::join( ...$join );
		}
		return $this;
	}

	protected function find() : array
	{
		$list = parent::get( 1, $this->fields );
		return isset( $list[0] ) ? $list[0] : [];
	}

	protected function field( $field ) : Model
	{
		$this->fields = $field;
		return $this;
	}

	protected function limit( $limit ) : Model
	{
		$this->limit = $limit;
		return $this;
	}

	protected function page( string $page ) : Model
	{
		$split = explode( ",", $page );
		$page  = $split[0] - 1;
		$rows  = $split[1];
		return $this->limit( "{$page},{$rows}" );
	}

	protected function select() : array
	{
		return parent::get( $this->limit, $this->fields );
	}

	protected function wheres( array $whereProps ) : Model
	{
		foreach( $whereProps as $whereProp ){
			$this->where( ...$whereProp );
		}
		return $this;
	}

}