| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/11585/cwd/html/ppaobm/vendor/codeception/base/src/Codeception/Lib/Driver/ |
Upload File : |
<?php
namespace Codeception\Lib\Driver;
class SqlSrv extends Db
{
public function getDb()
{
$matches = [];
$matched = preg_match('~Database=(.*);?~s', $this->dsn, $matches);
if (!$matched) {
return false;
}
return $matches[1];
}
public function cleanup()
{
$this->dbh->exec(
"
DECLARE constraints_cursor CURSOR FOR SELECT name, parent_object_id FROM sys.foreign_keys;
OPEN constraints_cursor
DECLARE @constraint sysname;
DECLARE @parent int;
DECLARE @table nvarchar(128);
FETCH NEXT FROM constraints_cursor INTO @constraint, @parent;
WHILE (@@FETCH_STATUS <> -1)
BEGIN
SET @table = OBJECT_NAME(@parent)
EXEC ('ALTER TABLE [' + @table + '] DROP CONSTRAINT [' + @constraint + ']')
FETCH NEXT FROM constraints_cursor INTO @constraint, @parent;
END
DEALLOCATE constraints_cursor;"
);
$this->dbh->exec(
"
DECLARE tables_cursor CURSOR FOR SELECT name FROM sysobjects WHERE type = 'U';
OPEN tables_cursor DECLARE @tablename sysname;
FETCH NEXT FROM tables_cursor INTO @tablename;
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC ('DROP TABLE [' + @tablename + ']')
FETCH NEXT FROM tables_cursor INTO @tablename;
END
DEALLOCATE tables_cursor;"
);
}
protected function generateWhereClause(array &$criteria)
{
if (empty($criteria)) {
return '';
}
$params = [];
foreach ($criteria as $k => $v) {
if ($v === null) {
$params[] = $this->getQuotedName($k) . " IS NULL ";
unset($criteria[$k]);
continue;
}
if (strpos(strtolower($k), ' like') > 0) {
$k = str_replace(' like', '', strtolower($k));
$params[] = $this->getQuotedName($k) . " LIKE ? ";
} else {
$params[] = $this->getQuotedName($k) . " = ? ";
}
}
return 'WHERE ' . implode('AND ', $params);
}
public function getQuotedName($name)
{
return '[' . str_replace('.', '].[', $name) . ']';
}
/**
* @param string $tableName
*
* @return array[string]
*/
public function getPrimaryKey($tableName)
{
if (!isset($this->primaryKeys[$tableName])) {
$primaryKey = [];
$query = "
SELECT Col.Column_Name from
INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab,
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col
WHERE
Col.Constraint_Name = Tab.Constraint_Name
AND Col.Table_Name = Tab.Table_Name
AND Constraint_Type = 'PRIMARY KEY' AND Col.Table_Name = ?";
$stmt = $this->executeQuery($query, [$tableName]);
$columns = $stmt->fetchAll(\PDO::FETCH_ASSOC);
foreach ($columns as $column) {
$primaryKey []= $column['Column_Name'];
}
$this->primaryKeys[$tableName] = $primaryKey;
}
return $this->primaryKeys[$tableName];
}
}