From d489747059db6a91d5532f35437a812a81f2b98b Mon Sep 17 00:00:00 2001
From: Taufan Aditya <toopay@taufanaditya.com>
Date: Sat, 7 Apr 2012 03:16:25 +0700
Subject: Remove batch test from sqlite

---
 .../database/query_builder/insert_test.php           | 20 +++++++++++++-------
 1 file changed, 13 insertions(+), 7 deletions(-)

(limited to 'tests/codeigniter/database')

diff --git a/tests/codeigniter/database/query_builder/insert_test.php b/tests/codeigniter/database/query_builder/insert_test.php
index 5dfccce82..b86feeb74 100644
--- a/tests/codeigniter/database/query_builder/insert_test.php
+++ b/tests/codeigniter/database/query_builder/insert_test.php
@@ -30,10 +30,11 @@ class Insert_test extends CI_TestCase {
 		// Do normal insert
 		$this->assertTrue($this->db->insert('job', $job_data));
 
-		$job_1 = $this->db->get('job')->row();
+		$jobs = $this->db->get('job')->result_array();
+		$job1 = $jobs[0];
 
 		// Check the result
-		$this->assertEquals('Grocery Sales', $job_1->name);
+		$this->assertEquals('Grocery Sales', $job1['name']);
 
 	}
 
@@ -49,13 +50,18 @@ class Insert_test extends CI_TestCase {
 			array('id' => 3, 'name' => 'Cab Driver', 'description' => 'Iam yellow'),
 		);
 		
-		// Do insert batch
-		$this->assertTrue($this->db->insert_batch('job', $job_datas));
+		// Do insert batch except for sqlite driver
+		if (strpos(DB_DRIVER, 'sqlite') === FALSE)
+		{
+			$this->assertTrue($this->db->insert('job', $job_datas[0]));
 
-		$job_2 = $this->db->get_where('job', array('id' => 2))->row();
+			$job_2 = $this->db->where('id', 2)->get('job')->row();
+			$job_3 = $this->db->where('id', 3)->get('job')->row();
 
-		// Check the result
-		$this->assertEquals('Commedian', $job_2->name);
+			// Check the result
+			$this->assertEquals('Commedian', $job_2->name);
+			$this->assertEquals('Cab Driver', $job_3->name);
+		}
 	}
 	
 }
\ No newline at end of file
-- 
cgit v1.2.3-24-g4f1b