public static function queryCount($query)
{
$count = 0;
$query = trim($query);
if ($result = self::query($query)) {
$operation = strtolower(substr($query, 0, 6));
self::$lastQueryType = $operation;
switch ($operation) {
case 'select':
$count = cubrid_num_rows($result);
cubrid_close_request($result);
break;
case 'insert':
case 'update':
case 'delete':
case 'replac':
default:
$count = cubrid_affected_rows($result);
break;
}
}
return $count;
}
public static function query($query)
{
if (function_exists('__tcSqlLogBegin')) {
__tcSqlLogBegin($query);
$result = self::$db->query($query);
__tcSqlLogEnd($result, 0);
} else {
$result = self::$db->query($query);
}
self::$lastQueryType = strtolower(substr($query, 0, 6));
if (stristr($query, 'update ') || stristr($query, 'insert ') || stristr($query, 'delete ') || stristr($query, 'replace ')) {
self::clearCache();
}
return $result;
}
public static function query($query, $compatibility = true)
{
// var_dump($query);
if ($compatibility) {
$query = str_replace('UNIX_TIMESTAMP()', Timestamp::getUNIXtime(), $query);
// compatibility issue.
$query = str_replace('RAND()', 'RANDOM()', $query);
// compatibility issue.
$origPagingInst = array('/CHAR_LENGTH(.*) /si', '/IF\\(([A-Za-z0-9]+),([A-Za-z0-9]+),([A-Za-z0-9]+)\\)/si');
$descPagingInst = array('LENGTH($1) ', 'CASE WHEN $1 THEN $2 ELSE $3 END');
$query = preg_replace($origPagingInst, $descPagingInst, $query);
}
if (function_exists('__tcSqlLogBegin')) {
__tcSqlLogBegin($query);
$result = self::$db->query($query);
__tcSqlLogEnd($result, 0);
} else {
$result = self::$db->query($query);
}
self::$lastQueryType = strtolower(substr($query, 0, 6));
if (stristr($query, 'update ') || stristr($query, 'insert ') || stristr($query, 'delete ') || stristr($query, 'replace ')) {
self::clearCache();
}
return $result;
}
