Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

[2] Fix | Delete

namespace Nextend\Framework\Database\WordPress;

[3] Fix | Delete

[4] Fix | Delete

use Nextend\Framework\Database\AbstractPlatformConnector;

[5] Fix | Delete

use Nextend\Framework\Database\AbstractPlatformConnectorTable;

[6] Fix | Delete

use wpdb;

[7] Fix | Delete

[8] Fix | Delete

class WordPressConnectorTable extends AbstractPlatformConnectorTable {

[9] Fix | Delete

[10] Fix | Delete

/** @var wpdb */

[11] Fix | Delete

protected static $db;

[12] Fix | Delete

[13] Fix | Delete

/**

[14] Fix | Delete

* @param AbstractPlatformConnector $connector

[15] Fix | Delete

* @param wpdb $db

[16] Fix | Delete

[17] Fix | Delete

public static function init($connector, $db) {

[18] Fix | Delete

self::$connector = $connector;

[19] Fix | Delete

self::$db = $db;

[20] Fix | Delete

}

[21] Fix | Delete

[22] Fix | Delete

public function findByPk($primaryKey) {

[23] Fix | Delete

$query = self::$db->prepare("SELECT * FROM " . $this->tableName . " WHERE " . self::$connector->quoteName($this->primaryKeyColumn) . " = %s", $primaryKey);

[24] Fix | Delete

[25] Fix | Delete

return self::$connector->checkError(self::$db->get_row($query, ARRAY_A));

[26] Fix | Delete

}

[27] Fix | Delete

[28] Fix | Delete

public function findByAttributes(array $attributes, $fields = false, $order = false) {

[29] Fix | Delete

[30] Fix | Delete

return self::$connector->checkError(self::$db->get_row($this->_findByAttributesSQL($attributes, $fields, $order), ARRAY_A));

[31] Fix | Delete

}

[32] Fix | Delete

[33] Fix | Delete

[34] Fix | Delete

public function findAll($order = false) {

[35] Fix | Delete

[36] Fix | Delete

return self::$connector->checkError(self::$db->get_results($this->_findByAttributesSQL(array(), false, $order), ARRAY_A));

[37] Fix | Delete

}

[38] Fix | Delete

[39] Fix | Delete

public function findAllByAttributes(array $attributes, $fields = false, $order = false) {

[40] Fix | Delete

[41] Fix | Delete

return self::$connector->checkError(self::$db->get_results($this->_findByAttributesSQL($attributes, $fields, $order), ARRAY_A));

[42] Fix | Delete

}

[43] Fix | Delete

[44] Fix | Delete

public function insert(array $attributes) {

[45] Fix | Delete

return self::$connector->checkError(self::$db->insert($this->tableName, $attributes));

[46] Fix | Delete

}

[47] Fix | Delete

[48] Fix | Delete

public function insertId() {

[49] Fix | Delete

return self::$db->insert_id;

[50] Fix | Delete

}

[51] Fix | Delete

[52] Fix | Delete

public function update(array $attributes, array $conditions) {

[53] Fix | Delete

[54] Fix | Delete

return self::$connector->checkError(self::$db->update($this->tableName, $attributes, $conditions));

[55] Fix | Delete

}

[56] Fix | Delete

[57] Fix | Delete

public function updateByPk($primaryKey, array $attributes) {

[58] Fix | Delete

[59] Fix | Delete

$where = array();

[60] Fix | Delete

$where[$this->primaryKeyColumn] = $primaryKey;

[61] Fix | Delete

self::$connector->checkError(self::$db->update($this->tableName, $attributes, $where));

[62] Fix | Delete

}

[63] Fix | Delete

[64] Fix | Delete

public function deleteByPk($primaryKey) {

[65] Fix | Delete

$where = array();

[66] Fix | Delete

$where[$this->primaryKeyColumn] = $primaryKey;

[67] Fix | Delete

self::$connector->checkError(self::$db->delete($this->tableName, $where));

[68] Fix | Delete

}

[69] Fix | Delete

[70] Fix | Delete

public function deleteByAttributes(array $conditions) {

[71] Fix | Delete

self::$connector->checkError(self::$db->delete($this->tableName, $conditions));

[72] Fix | Delete

}

[73] Fix | Delete

[74] Fix | Delete

private function _findByAttributesSQL(array $attributes, $fields = array(), $order = false) {

[75] Fix | Delete

[76] Fix | Delete

$args = array('');

[77] Fix | Delete

[78] Fix | Delete

$query = 'SELECT ';

[79] Fix | Delete

if (!empty($fields)) {

[80] Fix | Delete

[81] Fix | Delete

$fields = array_map(array(

[82] Fix | Delete

self::$connector,

[83] Fix | Delete

'quoteName'

[84] Fix | Delete

), $fields);

[85] Fix | Delete

[86] Fix | Delete

$query .= implode(', ', $fields);

[87] Fix | Delete

} else {

[88] Fix | Delete

$query .= '*';

[89] Fix | Delete

}

[90] Fix | Delete

$query .= ' FROM ' . $this->tableName;

[91] Fix | Delete

[92] Fix | Delete

$where = array();

[93] Fix | Delete

foreach ($attributes as $key => $val) {

[94] Fix | Delete

$valueFormat = is_numeric($val) ? '%d' : '%s';

[95] Fix | Delete

if ($key === 'hash') {

[96] Fix | Delete

/**

[97] Fix | Delete

* @see SSDEV-3927

[98] Fix | Delete

* Hashes are typically 32 character long and generated by md5 hashing algorithm.

[99] Fix | Delete

* In rare cases the hashed value might consist of numbers only, which can lead to overflow.

[100] Fix | Delete

* MD5 hashes should be prepared always as string values.

[101] Fix | Delete

[102] Fix | Delete

[103] Fix | Delete

$valueFormat = '%s';

[104] Fix | Delete

}

[105] Fix | Delete

$where[] = self::$connector->quoteName($key) . ' = ' . $valueFormat;

[106] Fix | Delete

$args[] = $val;

[107] Fix | Delete

}

[108] Fix | Delete

if (count($where)) {

[109] Fix | Delete

$query .= ' WHERE ' . implode(' AND ', $where);

[110] Fix | Delete

}

[111] Fix | Delete

[112] Fix | Delete

if ($order) {

[113] Fix | Delete

$query .= ' ORDER BY ' . $order;

[114] Fix | Delete

}

[115] Fix | Delete

[116] Fix | Delete

if (count($args) > 1) {

[117] Fix | Delete

$args[0] = $query;

[118] Fix | Delete

[119] Fix | Delete

return call_user_func_array(array(

[120] Fix | Delete

self::$db,

[121] Fix | Delete

'prepare'

[122] Fix | Delete

), $args);

[123] Fix | Delete

} else {

[124] Fix | Delete

return $query;

[125] Fix | Delete

}

[126] Fix | Delete

}

[127] Fix | Delete

}

[128] Fix | Delete