DbRowDirectOperator

Complexity

Total Complexity

6

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getById()	0	9	1
A	deleteById()	0	7	1
B	insert()	0	23	4

<?php

/**
 * Class DbRowDirectOperator
 *
 * Handle Entity storing/loading operations
 */

class DbRowDirectOperator implements \Common\IEntityOperator {

  /**
   * @param Entity $entity
   */
  public function getById($entity) {
    $stmt = classSupernova::$gc->query

The method setIdField cannot be called on \classSupernova::$gc->query (of type callable).

      ->setIdField($entity->getIdFieldName())
      ->field('*')
      ->from($entity->getTableName())
      ->where($entity->getIdFieldName() . ' = "' . $entity->dbId . '"');

    $entity->importDbRow($stmt->selectRow());
  }

  /**
   * @param Entity $entity
   */
  public function deleteById($entity) {
    $db = $entity->getDbStatic();

    $db->doquery("DELETE FROM `{{" . $entity->getTableName() . "}}` WHERE `{$entity->getIdFieldName()}` = '{$entity->dbId}' LIMIT 1;");

    return $db->db_affected_rows();
  }

  /**
   * @param Entity $entity
   */
  public function insert($entity) {
    $db = $entity->getDbStatic();

    $query = array();
    foreach ($entity->exportRowWithoutId() as $fieldName => $fieldValue) {
      // TODO: MORE type detection
      if(!is_numeric($fieldValue)) {
        $fieldValue = "'" . $db->db_escape($fieldValue) . "'";
      }
      $query[] = "`{$fieldName}` = {$fieldValue}";
    }

    $query = implode(',', $query);
    if (empty($query)) {
      // TODO Exceptiion
      return 0;
    }

    $db->doquery("INSERT INTO `{{" . $entity->getTableName() . "}}` SET " . $query);

    // TODO Exceptiion if db_insert_id() is empty
    return $entity->dbId = $db->db_insert_id();
  }

}