protected function setUp()
{
$this->dttOne = new QDateTime();
$this->dttTwo = new QDateTime();
$this->arrTimes = array(QDateTime::FromTimeOnly('00:00:00'), QDateTime::FromTimeOnly('06:35:00'), QDateTime::FromTimeOnly('23:59:59'));
$this->arrDates = array(new QDateTime('1980-06-13'), new QDateTime('today'));
$this->arrDatetimes = array(new QDateTime('1980-06-13 04:34'), new QDateTime(QDateTime::Now));
}
public function GetColumn($strColumnName, $strColumnType = null)
{
if (array_key_exists($strColumnName, $this->strColumnArray)) {
if (is_null($this->strColumnArray[$strColumnName])) {
return null;
}
switch ($strColumnType) {
case QDatabaseFieldType::Bit:
return $this->strColumnArray[$strColumnName] ? true : false;
case QDatabaseFieldType::Blob:
case QDatabaseFieldType::Char:
case QDatabaseFieldType::VarChar:
return QType::Cast($this->strColumnArray[$strColumnName], QType::String);
case QDatabaseFieldType::Date:
case QDatabaseFieldType::DateTime:
return new QDateTime($this->strColumnArray[$strColumnName]);
case QDatabaseFieldType::Time:
return QDateTime::FromTimeOnly($this->strColumnArray[$strColumnName]);
case QDatabaseFieldType::Float:
return QType::Cast($this->strColumnArray[$strColumnName], QType::Float);
case QDatabaseFieldType::Integer:
return QType::Cast($this->strColumnArray[$strColumnName], QType::Integer);
default:
return $this->strColumnArray[$strColumnName];
}
} else {
return null;
}
}
public function GetColumn($strColumnName, $strColumnType = null)
{
if (array_key_exists($strColumnName, $this->strColumnArray)) {
if (is_null($this->strColumnArray[$strColumnName])) {
return null;
}
switch ($strColumnType) {
case QDatabaseFieldType::Bit:
// Account for single bit value
$chrBit = $this->strColumnArray[$strColumnName];
if (strlen($chrBit) == 1 && ord($chrBit) == 0) {
return false;
}
// Otherwise, use PHP conditional to determine true or false
return $this->strColumnArray[$strColumnName] ? true : false;
case QDatabaseFieldType::Blob:
case QDatabaseFieldType::Char:
case QDatabaseFieldType::VarChar:
return QType::Cast($this->strColumnArray[$strColumnName], QType::String);
case QDatabaseFieldType::Date:
case QDatabaseFieldType::DateTime:
return new QDateTime($this->strColumnArray[$strColumnName]);
case QDatabaseFieldType::Time:
return QDateTime::FromTimeOnly($this->strColumnArray[$strColumnName]);
case QDatabaseFieldType::Float:
return QType::Cast($this->strColumnArray[$strColumnName], QType::Float);
case QDatabaseFieldType::Integer:
return QType::Cast($this->strColumnArray[$strColumnName], QType::Integer);
default:
return $this->strColumnArray[$strColumnName];
}
} else {
return null;
}
}
