Jovis\DatabaseModel\CDatabaseModel

Complexity

Total Complexity

16

Size/Duplication

Total Lines	228
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

85.71%

Importance

Changes	4
Bugs	3	Features	0

13 Methods

Rating	Name	Duplication	Size	Complexity
A	setProperties()	0	9	3
A	create()	0	16	1
A	update()	0	19	1
A	getSource()	0	4	1
A	findAll()	0	9	1
A	getProperties()	0	8	1
A	find()	0	9	1
A	save()	0	12	2
A	delete()	0	9	1
A	query()	0	7	1
A	where()	0	6	1
A	andWhere()	0	6	1
A	execute()	0	7	1

<?php

namespace Jovis\DatabaseModel;
 
/**
 * Model for databasecommunication.
 *
 */
class CDatabaseModel implements \Anax\DI\IInjectionAware
{
    use \Anax\DI\TInjectable;
 
  public $id;
    
    
   /**
   * Get the table name.
   *
   * @return string with the table name.
   */
  public function getSource()
  {
      return strtolower(implode('', array_slice(explode('\\', get_class($this)), -1)));
  }  
  
  /**
   * Find and return all.
   *
   * @return array
   */
  public function findAll()
  {
      $this->db->select()

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

               ->from($this->getSource());
   
      $this->db->execute();

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

      $this->db->setFetchModeClass(__CLASS__);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

      return $this->db->fetchAll();

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

  }
  
  /**
   * Get object properties.
   *
   * @return array with object properties.
   */
  public function getProperties()
  {
      $properties = get_object_vars($this);
      unset($properties['di']);
      unset($properties['db']);
   
      return $properties;
  }
  
  
  /**
   * Find and return specific.
   *
   * @return this
   */
  public function find($id)
  {
    $this->db->select()

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

             ->from($this->getSource())
             ->where("id = ?");
 
    $this->db->execute([$id]);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

    return $this->db->fetchInto($this);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

  }
  
  /**
   * Save current object/row.
   *
   * @param array $values key/values to save or empty to use object properties.
   *
   * @return boolean true or false if saving went okey.
   */
    public function save($values = [])
    {

    $this->setProperties($values);
    $values = $this->getProperties();
 
    if (isset($values['id'])) {
        return $this->update($values);
    } else {
        return $this->create($values);
    }
  }
  
  /**
   * Set object properties.
   *
   * @param array $properties with properties to set.
   *
   * @return void
   */
  public function setProperties($properties)
  {
      // Update object with incoming values, if any
      if (!empty($properties)) {
          foreach ($properties as $key => $val) {
              $this->$key = $val;
          }
      }
  }
  
  /**
   * Create new row.
   *
   * @param array $values key/values to save.
   *
   * @return boolean true or false if saving went okey.
   */
  public function create($values)
  {
      $keys   = array_keys($values);
      $values = array_values($values);
   
      $this->db->insert(

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

          $this->getSource(),
          $keys
      );
   
      $res = $this->db->execute($values);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

   
      $this->id = $this->db->lastInsertId();

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

   
      return $res;
  }
  
  
  /**
   * Update row.
   *
   * @param array $values key/values to save.
   *
   * @return boolean true or false if saving went okey.
   */
  public function update($values)
  {
	  
	  $keys   = array_keys($values);
      $values = array_values($values);
   
      // Its update, remove id and use as where-clause
      unset($keys['id']);
      
      $values[] = $this->id;
      
      $this->db->update(

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

          $this->getSource(),
          $keys,
          "id = ?"
      );
   
      return $this->db->execute($values);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

  }
  
  /**
   * Delete row.
   *
   * @param integer $id to delete.
   *
   * @return boolean true or false if deleting went okey.
   */
  public function delete($id)
  {
      $this->db->delete(

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

          $this->getSource(),
          'id = ?'
      );
   
      return $this->db->execute([$id]);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

  }
  
  
  /**
   * Build a select-query.
   *
   * @param string $columns which columns to select.
   *
   * @return $this
   */
  public function query($columns = '*')
  {
      $this->db->select($columns)

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

               ->from($this->getSource());
   
      return $this;
  }
 
  /**
   * Build the where part.
   *
   * @param string $condition for building the where part of the query.
   *
   * @return $this
   */
  public function where($condition)
  {
      $this->db->where($condition);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

   
      return $this;
  }  
    
  /**
   * Build the where part.
   *
   * @param string $condition for building the where part of the query.
   *
   * @return $this
   */
  public function andWhere($condition)
  {
      $this->db->andWhere($condition);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

   
      return $this;
  }  
  
  /**
   * Execute the query built.
   *
   * @param array $params 
   *
   * @return $this
   */
  public function execute($params = [])
  {
      $this->db->execute($this->db->getSQL(), $params);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

      $this->db->setFetchModeClass(__CLASS__);

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

   
      return $this->db->fetchAll();

The property db does not exist on object<Jovis\DatabaseModel\CDatabaseModel>. Since you implemented __get, maybe consider adding a @property annotation.

  }

}