Code Duplication - ci-bonfire/Sprint - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 24-24 lines in 6 locations

system/database/drivers/mssql/mssql_driver.php 1 location


	 * @param	string	$table
	 * @return	array
	 */
	public function field_data($table)
	{
		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
			FROM INFORMATION_SCHEMA.Columns
			WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));

		if (($query = $this->query($sql)) === FALSE)
		{
			return FALSE;
		}
		$query = $query->result_object();

		$retval = array();
		for ($i = 0, $c = count($query); $i < $c; $i++)
		{
			$retval[$i]			= new stdClass();
			$retval[$i]->name		= $query[$i]->COLUMN_NAME;
			$retval[$i]->type		= $query[$i]->DATA_TYPE;
			$retval[$i]->max_length		= ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
			$retval[$i]->default		= $query[$i]->COLUMN_DEFAULT;
		}

		return $retval;
	}

	// --------------------------------------------------------------------


system/database/drivers/pdo/subdrivers/pdo_dblib_driver.php 1 location


	 * @param	string	$table
	 * @return	array
	 */
	public function field_data($table)
	{
		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
			FROM INFORMATION_SCHEMA.Columns
			WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));

		if (($query = $this->query($sql)) === FALSE)
		{
			return FALSE;
		}
		$query = $query->result_object();

		$retval = array();
		for ($i = 0, $c = count($query); $i < $c; $i++)
		{
			$retval[$i]			= new stdClass();
			$retval[$i]->name		= $query[$i]->COLUMN_NAME;
			$retval[$i]->type		= $query[$i]->DATA_TYPE;
			$retval[$i]->max_length		= ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
			$retval[$i]->default		= $query[$i]->COLUMN_DEFAULT;
		}

		return $retval;
	}

	// --------------------------------------------------------------------


system/database/drivers/pdo/subdrivers/pdo_sqlsrv_driver.php 1 location


	 * @param	string	$table
	 * @return	array
	 */
	public function field_data($table)
	{
		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
			FROM INFORMATION_SCHEMA.Columns
			WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));

		if (($query = $this->query($sql)) === FALSE)
		{
			return FALSE;
		}
		$query = $query->result_object();

		$retval = array();
		for ($i = 0, $c = count($query); $i < $c; $i++)
		{
			$retval[$i]			= new stdClass();
			$retval[$i]->name		= $query[$i]->COLUMN_NAME;
			$retval[$i]->type		= $query[$i]->DATA_TYPE;
			$retval[$i]->max_length		= ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
			$retval[$i]->default		= $query[$i]->COLUMN_DEFAULT;
		}

		return $retval;
	}

	// --------------------------------------------------------------------


system/database/drivers/sqlsrv/sqlsrv_driver.php 1 location


	 * @param	string	$table
	 * @return	array
	 */
	public function field_data($table)
	{
		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
			FROM INFORMATION_SCHEMA.Columns
			WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));

		if (($query = $this->query($sql)) === FALSE)
		{
			return FALSE;
		}
		$query = $query->result_object();

		$retval = array();
		for ($i = 0, $c = count($query); $i < $c; $i++)
		{
			$retval[$i]			= new stdClass();
			$retval[$i]->name		= $query[$i]->COLUMN_NAME;
			$retval[$i]->type		= $query[$i]->DATA_TYPE;
			$retval[$i]->max_length		= ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
			$retval[$i]->default		= $query[$i]->COLUMN_DEFAULT;
		}

		return $retval;
	}

	// --------------------------------------------------------------------


system/database/drivers/pdo/subdrivers/pdo_pgsql_driver.php 1 location


	 * @param	string	$table
	 * @return	array
	 */
	public function field_data($table)
	{
		$sql = 'SELECT "column_name", "data_type", "character_maximum_length", "numeric_precision", "column_default"
			FROM "information_schema"."columns"
			WHERE LOWER("table_name") = '.$this->escape(strtolower($table));

		if (($query = $this->query($sql)) === FALSE)
		{
			return FALSE;
		}
		$query = $query->result_object();

		$retval = array();
		for ($i = 0, $c = count($query); $i < $c; $i++)
		{
			$retval[$i]			= new stdClass();
			$retval[$i]->name		= $query[$i]->column_name;
			$retval[$i]->type		= $query[$i]->data_type;
			$retval[$i]->max_length		= ($query[$i]->character_maximum_length > 0) ? $query[$i]->character_maximum_length : $query[$i]->numeric_precision;
			$retval[$i]->default		= $query[$i]->column_default;
		}

		return $retval;
	}

	// --------------------------------------------------------------------


system/database/drivers/postgre/postgre_driver.php 1 location


	 * @param	string	$table
	 * @return	array
	 */
	public function field_data($table)
	{
		$sql = 'SELECT "column_name", "data_type", "character_maximum_length", "numeric_precision", "column_default"
			FROM "information_schema"."columns"
			WHERE LOWER("table_name") = '.$this->escape(strtolower($table));

		if (($query = $this->query($sql)) === FALSE)
		{
			return FALSE;
		}
		$query = $query->result_object();

		$retval = array();
		for ($i = 0, $c = count($query); $i < $c; $i++)
		{
			$retval[$i]			= new stdClass();
			$retval[$i]->name		= $query[$i]->column_name;
			$retval[$i]->type		= $query[$i]->data_type;
			$retval[$i]->max_length		= ($query[$i]->character_maximum_length > 0) ? $query[$i]->character_maximum_length : $query[$i]->numeric_precision;
			$retval[$i]->default		= $query[$i]->column_default;
		}

		return $retval;
	}

	// --------------------------------------------------------------------


		@@ 323-346 (lines=24) @@
320		* @param string $table
321		* @return array
322		*/
323		public function field_data($table)
324		{
325		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
326		FROM INFORMATION_SCHEMA.Columns
327		WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));
328
329		if (($query = $this->query($sql)) === FALSE)
330		{
331		return FALSE;
332		}
333		$query = $query->result_object();
334
335		$retval = array();
336		for ($i = 0, $c = count($query); $i < $c; $i++)
337		{
338		$retval[$i] = new stdClass();
339		$retval[$i]->name = $query[$i]->COLUMN_NAME;
340		$retval[$i]->type = $query[$i]->DATA_TYPE;
341		$retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
342		$retval[$i]->default = $query[$i]->COLUMN_DEFAULT;
343		}
344
345		return $retval;
346		}
347
348		// --------------------------------------------------------------------
349

		@@ 195-218 (lines=24) @@
192		* @param string $table
193		* @return array
194		*/
195		public function field_data($table)
196		{
197		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
198		FROM INFORMATION_SCHEMA.Columns
199		WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));
200
201		if (($query = $this->query($sql)) === FALSE)
202		{
203		return FALSE;
204		}
205		$query = $query->result_object();
206
207		$retval = array();
208		for ($i = 0, $c = count($query); $i < $c; $i++)
209		{
210		$retval[$i] = new stdClass();
211		$retval[$i]->name = $query[$i]->COLUMN_NAME;
212		$retval[$i]->type = $query[$i]->DATA_TYPE;
213		$retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
214		$retval[$i]->default = $query[$i]->COLUMN_DEFAULT;
215		}
216
217		return $retval;
218		}
219
220		// --------------------------------------------------------------------
221

		@@ 224-247 (lines=24) @@
221		* @param string $table
222		* @return array
223		*/
224		public function field_data($table)
225		{
226		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
227		FROM INFORMATION_SCHEMA.Columns
228		WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));
229
230		if (($query = $this->query($sql)) === FALSE)
231		{
232		return FALSE;
233		}
234		$query = $query->result_object();
235
236		$retval = array();
237		for ($i = 0, $c = count($query); $i < $c; $i++)
238		{
239		$retval[$i] = new stdClass();
240		$retval[$i]->name = $query[$i]->COLUMN_NAME;
241		$retval[$i]->type = $query[$i]->DATA_TYPE;
242		$retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
243		$retval[$i]->default = $query[$i]->COLUMN_DEFAULT;
244		}
245
246		return $retval;
247		}
248
249		// --------------------------------------------------------------------
250

		@@ 329-352 (lines=24) @@
326		* @param string $table
327		* @return array
328		*/
329		public function field_data($table)
330		{
331		$sql = 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT
332		FROM INFORMATION_SCHEMA.Columns
333		WHERE UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table));
334
335		if (($query = $this->query($sql)) === FALSE)
336		{
337		return FALSE;
338		}
339		$query = $query->result_object();
340
341		$retval = array();
342		for ($i = 0, $c = count($query); $i < $c; $i++)
343		{
344		$retval[$i] = new stdClass();
345		$retval[$i]->name = $query[$i]->COLUMN_NAME;
346		$retval[$i]->type = $query[$i]->DATA_TYPE;
347		$retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION;
348		$retval[$i]->default = $query[$i]->COLUMN_DEFAULT;
349		}
350
351		return $retval;
352		}
353
354		// --------------------------------------------------------------------
355

		@@ 269-292 (lines=24) @@
266		* @param string $table
267		* @return array
268		*/
269		public function field_data($table)
270		{
271		$sql = 'SELECT "column_name", "data_type", "character_maximum_length", "numeric_precision", "column_default"
272		FROM "information_schema"."columns"
273		WHERE LOWER("table_name") = '.$this->escape(strtolower($table));
274
275		if (($query = $this->query($sql)) === FALSE)
276		{
277		return FALSE;
278		}
279		$query = $query->result_object();
280
281		$retval = array();
282		for ($i = 0, $c = count($query); $i < $c; $i++)
283		{
284		$retval[$i] = new stdClass();
285		$retval[$i]->name = $query[$i]->column_name;
286		$retval[$i]->type = $query[$i]->data_type;
287		$retval[$i]->max_length = ($query[$i]->character_maximum_length > 0) ? $query[$i]->character_maximum_length : $query[$i]->numeric_precision;
288		$retval[$i]->default = $query[$i]->column_default;
289		}
290
291		return $retval;
292		}
293
294		// --------------------------------------------------------------------
295

		@@ 443-466 (lines=24) @@
440		* @param string $table
441		* @return array
442		*/
443		public function field_data($table)
444		{
445		$sql = 'SELECT "column_name", "data_type", "character_maximum_length", "numeric_precision", "column_default"
446		FROM "information_schema"."columns"
447		WHERE LOWER("table_name") = '.$this->escape(strtolower($table));
448
449		if (($query = $this->query($sql)) === FALSE)
450		{
451		return FALSE;
452		}
453		$query = $query->result_object();
454
455		$retval = array();
456		for ($i = 0, $c = count($query); $i < $c; $i++)
457		{
458		$retval[$i] = new stdClass();
459		$retval[$i]->name = $query[$i]->column_name;
460		$retval[$i]->type = $query[$i]->data_type;
461		$retval[$i]->max_length = ($query[$i]->character_maximum_length > 0) ? $query[$i]->character_maximum_length : $query[$i]->numeric_precision;
462		$retval[$i]->default = $query[$i]->column_default;
463		}
464
465		return $retval;
466		}
467
468		// --------------------------------------------------------------------
469

ci-bonfire / Sprint

GitHub Access Token became invalid

Code Duplication Length = 24-24 lines in 6 locations

system/database/drivers/mssql/mssql_driver.php 1 location

system/database/drivers/pdo/subdrivers/pdo_dblib_driver.php 1 location

system/database/drivers/pdo/subdrivers/pdo_sqlsrv_driver.php 1 location

system/database/drivers/sqlsrv/sqlsrv_driver.php 1 location

system/database/drivers/pdo/subdrivers/pdo_pgsql_driver.php 1 location

system/database/drivers/postgre/postgre_driver.php 1 location