/**
* fetchOne 從 $table 找出符合 $primary_values 條件的一筆
*
* @param Pix_Table $table
* @param array $primary_values
* @access public
* @return array or null
*/
public function fetchOne($table, $primary_values)
{
$sql = 'SELECT * FROM ' . $this->column_quote($table->getTableName());
$sql .= ' WHERE ';
$terms = array();
foreach (array_combine($table->getPrimaryColumns(), $primary_values) as $k => $v) {
$terms[] = $this->column_quote($k) . ' = ' . $this->quoteWithColumn($table, $v, $k);
}
$sql .= implode(' AND ', $terms);
if (!($res = $this->query($sql))) {
return null;
}
$row = $res->fetch_assoc();
$res->free_result();
return $row;
}
/**
* fetch 取得符合 $search 條件的資料
*
* @param Pix_Table $table
* @param Pix_Table_Search $search
* @param string|array $select_columns
* @access public
* @return void
*/
public function fetch($table, $search, $select_columns = '*')
{
$db = $this->_getDb();
$condictions = $search->getSearchCondictions();
if (count($condictions) == 0) {
// 完全沒有條件就是 scan table
$options = array();
$options['TableName'] = $table->getTableName();
// 加上指定 column
if ('*' != $select_columns) {
$options['AttributesToGet'] = $select_columns;
}
$response = $db->scan($options);
} elseif (count($condictions) == 1) {
// 只給一個條件的話只能是 HashKey
$primary_keys = $table->getPrimaryColumns();
// 只能是 map
if ('map' != $condictions[0][0]) {
throw new Pix_Table_Exception("不支援的 search 條件");
}
// 只能是 Primary Key 的第一個
if ($primary_keys[0] != $condictions[0][1]) {
throw new Pix_Table_Exception("不支援的 search 條件");
}
$options = array();
$options['TableName'] = $table->getTableName();
$options['HashKeyValue'] = array($this->_getColumnType($table, $primary_keys[0]) => $condictions[0][2]);
// 加上 Limit
if (!is_null($limit = $search->limit())) {
$options['Limit'] = $limit;
}
// 加上 after or before
if ($row = $search->after()) {
$options['RangeKeyCondition'] = array('ComparisonOperator' => AmazonDynamoDB::CONDITION_GREATER_THAN, 'AttributeValueList' => array(array($this->_getColumnType($table, $primary_keys[1]) => $row->{$primary_keys[1]})));
} elseif ($row = $search->before()) {
$options['RangeKeyCondition'] = array('ComparisonOperator' => AmazonDynamoDB::CONDITION_LESS_THAN, 'AttributeValueList' => array(array($this->_getColumnType($table, $primary_keys[1]) => $row->{$primary_keys[1]})));
$options['ScanIndexForward'] = false;
}
// 加上指定 column
if ('*' != $select_columns) {
$options['AttributesToGet'] = $select_columns;
}
$response = $db->query($options);
} else {
throw new Pix_Table_Exception("不支援的 search 條件");
}
if (200 != $response->status) {
throw new Pix_Table_Exception("AmazonDynamoDB: " . $get_response->body->Message);
}
$ret = array();
foreach ($response->body->Items[0] as $item) {
$row = array();
foreach ($table->_columns as $name => $col) {
if ($item->{$name}) {
$row[$name] = strval($item->{$name}->S);
}
}
$ret[] = $row;
}
return $ret;
}
