From 71e647782764184e3aab4faffe6d99176758979f Mon Sep 17 00:00:00 2001
From: Andrey Andreev <narf@devilix.net>
Date: Thu, 22 Mar 2018 16:48:55 +0200
Subject: [ci skip] 3.1.8 release

---
 .../database/query_builder/join_test.php           | 101 ---------------------
 1 file changed, 101 deletions(-)
 delete mode 100644 tests/codeigniter/database/query_builder/join_test.php

(limited to 'tests/codeigniter/database/query_builder/join_test.php')

diff --git a/tests/codeigniter/database/query_builder/join_test.php b/tests/codeigniter/database/query_builder/join_test.php
deleted file mode 100644
index 54b2a4e18..000000000
--- a/tests/codeigniter/database/query_builder/join_test.php
+++ /dev/null
@@ -1,101 +0,0 @@
-<?php
-
-class Join_test extends CI_TestCase {
-
-	/**
-	 * @var object Database/Query Builder holder
-	 */
-	protected $db;
-
-	public function set_up()
-	{
-		$this->db = Mock_Database_Schema_Skeleton::init(DB_DRIVER);
-
-		Mock_Database_Schema_Skeleton::create_tables();
-		Mock_Database_Schema_Skeleton::create_data();
-	}
-
-	// ------------------------------------------------------------------------
-
-	/**
-	 * @see ./mocks/schema/skeleton.php
-	 */
-	public function test_join_simple()
-	{
-		$job_user = $this->db->select('job.id as job_id, job.name as job_name, user.id as user_id, user.name as user_name')
-							->from('job')
-							->join('user', 'user.id = job.id')
-							->get()
-							->result_array();
-
-		// Check the result
-		$this->assertEquals('1', $job_user[0]['job_id']);
-		$this->assertEquals('1', $job_user[0]['user_id']);
-		$this->assertEquals('Derek Jones', $job_user[0]['user_name']);
-		$this->assertEquals('Developer', $job_user[0]['job_name']);
-	}
-
-	// ------------------------------------------------------------------------
-
-	public function test_join_escape_is_null()
-	{
-		$expected = 'SELECT '.$this->db->escape_identifiers('field')
-				."\nFROM ".$this->db->escape_identifiers('table1')
-				."\nJOIN ".$this->db->escape_identifiers('table2').' ON '.$this->db->escape_identifiers('field').' IS NULL';
-
-		$this->assertEquals(
-			$expected,
-			$this->db->select('field')->from('table1')->join('table2', 'field IS NULL')->get_compiled_select()
-		);
-
-		$expected = 'SELECT '.$this->db->escape_identifiers('field')
-				."\nFROM ".$this->db->escape_identifiers('table1')
-				."\nJOIN ".$this->db->escape_identifiers('table2').' ON '.$this->db->escape_identifiers('field').' IS NOT NULL';
-
-		$this->assertEquals(
-			$expected,
-			$this->db->select('field')->from('table1')->join('table2', 'field IS NOT NULL')->get_compiled_select()
-		);
-	}
-
-	// ------------------------------------------------------------------------
-
-	public function test_join_escape_multiple_conditions()
-	{
-		// We just need a valid query produced, not one that makes sense
-		$fields = array($this->db->protect_identifiers('table1.field1'), $this->db->protect_identifiers('table2.field2'));
-
-		$expected = 'SELECT '.implode(', ', $fields)
-				."\nFROM ".$this->db->escape_identifiers('table1')
-				."\nLEFT JOIN ".$this->db->escape_identifiers('table2').' ON '.implode(' = ', $fields)
-				.' AND '.$fields[0]." = 'foo' AND ".$fields[1].' = 0';
-
-		$result = $this->db->select('table1.field1, table2.field2')
-				->from('table1')
-				->join('table2', "table1.field1 = table2.field2 AND table1.field1 = 'foo' AND table2.field2 = 0", 'LEFT')
-				->get_compiled_select();
-
-		$this->assertEquals($expected, $result);
-	}
-
-	// ------------------------------------------------------------------------
-
-	public function test_join_escape_multiple_conditions_with_parentheses()
-	{
-		// We just need a valid query produced, not one that makes sense
-		$fields = array($this->db->protect_identifiers('table1.field1'), $this->db->protect_identifiers('table2.field2'));
-
-		$expected = 'SELECT '.implode(', ', $fields)
-				."\nFROM ".$this->db->escape_identifiers('table1')
-				."\nRIGHT JOIN ".$this->db->escape_identifiers('table2').' ON '.implode(' = ', $fields)
-				.' AND ('.$fields[0]." = 'foo' OR ".$fields[1].' IS NULL)';
-
-		$result = $this->db->select('table1.field1, table2.field2')
-				->from('table1')
-				->join('table2', "table1.field1 = table2.field2 AND (table1.field1 = 'foo' OR table2.field2 IS NULL)", 'RIGHT')
-				->get_compiled_select();
-
-		$this->assertEquals($expected, $result);
-	}
-
-}
\ No newline at end of file
-- 
cgit v1.2.3-24-g4f1b