/**
* @param $sql
* @param array|null $arBinds
* @param $offset
* @param $limit
* @param \Bitrix\Main\Diag\SqlTrackerQuery|null $trackerQuery
* @return resource
* @throws SqlException|\Bitrix\Main\ArgumentException
*/
protected function queryInternal($sql, array $arBinds = null, $offset = 0, $limit = 0, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
$offset = intval($offset);
$limit = intval($limit);
if ($offset > 0 && $limit <= 0) {
throw new \Bitrix\Main\ArgumentException("Limit should be set if offset is set");
}
if ($limit > 0) {
if (preg_match("#\\slimit\\s+\\d#i", $sql)) {
throw new \Bitrix\Main\ArgumentException("Duplicate limit settings");
}
$sql .= "\nLIMIT " . intval($offset) . ", " . intval($limit) . "\n";
}
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $arBinds);
}
$result = mysql_query($sql, $this->resource);
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
if (!$result) {
throw new SqlException('Mysql query error', mysql_error($this->resource));
}
return $result;
}
/**
* Executes a query against connected database.
* Rises SqlQueryException on any database error.
* <p>
* When object $trackerQuery passed then calls its startQuery and finishQuery
* methods before and after query execution.
*
* @param string $sql Sql query.
* @param array $binds Array of binds.
* @param \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery Debug collector object.
*
* @return resource
* @throws \Bitrix\Main\Db\SqlQueryException
*/
protected function queryInternal($sql, array $binds = null, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $binds);
}
$result = mysql_query($sql, $this->resource);
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
if (!$result) {
throw new SqlQueryException('Mysql query error', mysql_error($this->resource), $sql);
}
return $result;
}
/**
* @param $sql
* @param array|null $arBinds
* @param $offset
* @param $limit
* @param \Bitrix\Main\Diag\SqlTrackerQuery|null $trackerQuery
* @return resource
* @throws SqlException|\Bitrix\Main\ArgumentException
*/
protected function queryInternal($sql, array $arBinds = null, $offset = 0, $limit = 0, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
if ($limit > 0) {
$sql = $this->getSqlHelper()->getTopSql($sql, $limit, $offset);
}
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $arBinds);
}
$result = mysql_query($sql, $this->resource);
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
if (!$result) {
throw new SqlQueryException('Mysql query error', mysql_error($this->resource), $sql);
}
return $result;
}
/**
* @param $sql
* @param array|null $arBinds
* @param $offset
* @param $limit
* @param \Bitrix\Main\Diag\SqlTrackerQuery|null $trackerQuery
* @return mixed
* @throws SqlException|\Bitrix\Main\ArgumentException
*/
protected function queryInternal($sql, array $arBinds = null, $offset = 0, $limit = 0, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
if ($limit > 0) {
$sql = $this->getSqlHelper()->getTopSql($sql, $limit, $offset);
}
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $arBinds);
}
$result = sqlsrv_query($this->resource, $sql, array(), array("Scrollable" => 'forward'));
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
if (!$result) {
throw new SqlQueryException('MS Sql query error', $this->getErrorMessage(), $sql);
}
return $result;
}
/**
* @param $sql
* @param array|null $arBinds
* @param $offset
* @param $limit
* @param \Bitrix\Main\Diag\SqlTrackerQuery|null $trackerQuery
* @return mixed
* @throws SqlException|\Bitrix\Main\ArgumentException
*/
protected function queryInternal($sql, array $arBinds = null, $offset = 0, $limit = 0, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
$offset = intval($offset);
$limit = intval($limit);
if ($offset > 0 && $limit <= 0) {
throw new \Bitrix\Main\ArgumentException("Limit should be set if offset is set");
}
if ($limit > 0) {
if (preg_match("#\\sROW_NUMBER\\s*\\(\\s*\\)#i", $sql) || preg_match("#SELECT\\s+TOP\\s+\\d#i", $sql)) {
throw new \Bitrix\Main\ArgumentException("Duplicate limit settings");
}
if ($offset <= 0) {
$sql = preg_replace("/^\\s*SELECT/i", "SELECT TOP " . $limit, $sql);
} else {
if (preg_match("#(\\s+order\\s+by(\\s+[a-z0-9_.]+(\\s+(asc|desc))?\\s*,)*(\\s+[a-z0-9_.]+(\\s+(asc|desc))?)\\s*)\$#i", $sql, $matches)) {
$orderBy = $matches[1];
$sqlTmp = substr($sql, 0, -strlen($orderBy));
} else {
$orderBy = "ORDER BY (SELECT 1)";
$sqlTmp = $sql;
}
$sqlTmp = preg_replace("/^\\s*SELECT/i", "SELECT ROW_NUMBER() OVER (" . $orderBy . ") AS ROW_NUMBER_ALIAS,", $sqlTmp);
$sql = "WITH ROW_NUMBER_QUERY_ALIAS AS (" . $sqlTmp . ") " . "SELECT * " . "FROM ROW_NUMBER_QUERY_ALIAS " . "WHERE ROW_NUMBER_ALIAS BETWEEN " . $offset . " AND " . ($offset + $limit - 1) . "";
}
}
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $arBinds);
}
$result = sqlsrv_query($this->connectionResource, $sql, array(), array("Scrollable" => 'forward'));
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
if (!$result) {
throw new SqlException('MS Sql query error', $this->getErrorMessage());
}
return $result;
}
/**
* Executes a query against connected database.
* Rises SqlQueryException on any database error.
* <p>
* When object $trackerQuery passed then calls its startQuery and finishQuery
* methods before and after query execution.
*
* @param string $sql Sql query.
* @param array $binds Array of binds.
* @param \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery Debug collector object.
*
* @return resource
* @throws \Bitrix\Main\Db\SqlQueryException
*/
protected function queryInternal($sql, array $binds = null, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $binds);
}
$result = oci_parse($this->resource, $sql);
if (!$result) {
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
throw new SqlQueryException("", $this->getErrorMessage($this->resource), $sql);
}
$executionMode = $this->transaction;
/** @var \OCI_Lob[] $clob */
$clob = array();
if (!empty($binds)) {
$executionMode = OCI_DEFAULT;
foreach ($binds as $key => $val) {
$clob[$key] = oci_new_descriptor($this->resource, OCI_DTYPE_LOB);
oci_bind_by_name($result, ":" . $key, $clob[$key], -1, OCI_B_CLOB);
}
}
if (!oci_execute($result, $executionMode)) {
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
throw new SqlQueryException("", $this->getErrorMessage($result), $sql);
}
if (!empty($binds)) {
if (oci_num_rows($result) > 0) {
foreach ($binds as $key => $val) {
if ($clob[$key]) {
$clob[$key]->save($binds[$key]);
}
}
}
if ($this->transaction == OCI_COMMIT_ON_SUCCESS) {
oci_commit($this->resource);
}
foreach ($binds as $key => $val) {
if ($clob[$key]) {
$clob[$key]->free();
}
}
}
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
return $result;
}
/**
* @param $sql
* @param array|null $arBinds
* @param $offset
* @param $limit
* @param \Bitrix\Main\Diag\SqlTrackerQuery|null $trackerQuery
* @return resource
* @throws SqlException|\Bitrix\Main\ArgumentException
*/
protected function queryInternal($sql, array $arBinds = null, $offset = 0, $limit = 0, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
if ($limit > 0) {
$sql = $this->getSqlHelper()->getTopSql($sql, $limit, $offset);
}
$bindsKeys = array();
if (!empty($arBinds)) {
$binds1 = $binds2 = "";
foreach ($arBinds as $key => $value) {
if (strlen($value) > 0) {
if ($binds1 != "") {
$binds1 .= ",";
$binds2 .= ",";
}
$bindsKeys[] = $key;
$binds1 .= $key;
$binds2 .= ":" . $key;
}
}
if ($binds1 != "") {
$sql .= " RETURNING " . $binds1 . " INTO " . $binds2;
}
}
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $arBinds);
}
$result = oci_parse($this->resource, $sql);
if (!$result) {
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
throw new SqlQueryException("", $this->getErrorMessage(), $sql);
}
$executionMode = $this->transaction;
$clob = array();
if (!empty($arBinds)) {
$executionMode = OCI_DEFAULT;
foreach ($bindsKeys as $key) {
$clob[$key] = oci_new_descriptor($this->resource, OCI_D_LOB);
oci_bind_by_name($result, ":" . $key, $clob[$key], -1, OCI_B_CLOB);
}
}
if (!oci_execute($result, $executionMode)) {
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
throw new SqlQueryException("", $this->getErrorMessage(), $sql);
}
if (!empty($arBinds)) {
if (oci_num_rows($result) > 0) {
foreach ($bindsKeys as $key) {
$clob[$key]->save($arBinds[$key]);
}
}
if ($this->transaction == OCI_COMMIT_ON_SUCCESS) {
oci_commit($this->resource);
}
foreach ($bindsKeys as $key) {
$clob[$key]->free();
}
}
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
return $result;
}
/**
* @param $sql
* @param array|null $arBinds
* @param $offset
* @param $limit
* @param \Bitrix\Main\Diag\SqlTrackerQuery|null $trackerQuery
* @return resource
* @throws SqlException|\Bitrix\Main\ArgumentException
*/
protected function queryInternal($sql, array $arBinds = null, $offset = 0, $limit = 0, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
$offset = intval($offset);
$limit = intval($limit);
if ($offset > 0 && $limit <= 0) {
throw new \Bitrix\Main\ArgumentException("Limit should be set if offset is set");
}
$bindsKeys = array();
if (!empty($arBinds)) {
$binds1 = $binds2 = "";
foreach ($arBinds as $key => $value) {
if (strlen($value) > 0) {
if ($binds1 != "") {
$binds1 .= ",";
$binds2 .= ",";
}
$bindsKeys[] = $key;
$binds1 .= $key;
$binds2 .= ":" . $key;
}
}
if ($binds1 != "") {
$sql .= " RETURNING " . $binds1 . " INTO " . $binds2;
}
}
if ($limit > 0) {
if (preg_match("#\\sROWNUM\\W#i", $sql)) {
throw new \Bitrix\Main\ArgumentException("Duplicate limit settings");
}
if ($offset <= 0) {
$sql = "SELECT * " . "FROM (" . $sql . ") " . "WHERE ROWNUM <= " . $limit . "";
} else {
$sql = "SELECT * " . "FROM (" . " SELECT rownum_query_alias.*, ROWNUM rownum_alias " . " FROM (" . $sql . ") rownum_query_alias " . " WHERE ROWNUM <= " . ($offset + $limit - 1) . " " . ") " . "WHERE rownum_alias >= " . $offset . "";
}
}
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $arBinds);
}
$result = oci_parse($this->connectionResource, $sql);
if (!$result) {
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
throw new SqlException("", $this->getErrorMessage());
}
$executionMode = $this->transaction;
$clob = array();
if (!empty($arBinds)) {
$executionMode = OCI_DEFAULT;
foreach ($bindsKeys as $key) {
$clob[$key] = oci_new_descriptor($this->connectionResource, OCI_D_LOB);
oci_bind_by_name($result, ":" . $key, $clob[$key], -1, OCI_B_CLOB);
}
}
if (!oci_execute($result, $executionMode)) {
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
throw new SqlException("", $this->getErrorMessage());
}
if (!empty($arBinds)) {
if (oci_num_rows($result) > 0) {
foreach ($bindsKeys as $key) {
$clob[$key]->save($arBinds[$key]);
}
}
if ($this->transaction == OCI_COMMIT_ON_SUCCESS) {
oci_commit($this->connectionResource);
}
foreach ($bindsKeys as $key) {
$clob[$key]->free();
}
}
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
return $result;
}
/**
* Executes a query against connected database.
* Rises SqlQueryException on any database error.
* <p>
* When object $trackerQuery passed then calls its startQuery and finishQuery
* methods before and after query execution.
*
* @param string $sql Sql query.
* @param array $binds Array of binds.
* @param \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery Debug collector object.
*
* @return resource
* @throws \Bitrix\Main\Db\SqlQueryException
*/
protected function queryInternal($sql, array $binds = null, \Bitrix\Main\Diag\SqlTrackerQuery $trackerQuery = null)
{
$this->connectInternal();
if ($trackerQuery != null) {
$trackerQuery->startQuery($sql, $binds);
}
/** @var $con \mysqli */
$con = $this->resource;
$result = $con->query($sql, MYSQLI_STORE_RESULT);
if ($trackerQuery != null) {
$trackerQuery->finishQuery();
}
$this->lastQueryResult = $result;
if (!$result) {
throw new SqlQueryException('Mysql query error', $this->getErrorMessage(), $sql);
}
return $result;
}
