Forum Unit testing method wrapped with a DB::transaction closure

gayanhewa

posted 10 years ago

Testing

Hi Guys,

I have been trying to get my head around this.

I have a method thats wrapped with a DB::transaction closure , what is the best way to unit test this piece of code ?

 public function createOrder()
  {
  	DB::transaction(function(){
	        // is the user logged in ?
	  	if(Auth::check()){
	 			try {

		  		$cart_items = $this->cart->getItems()->content;

		  		//create an order first , I need to have an order_id when populating the
		  		//order rows
	  			$order = new Order();
	  			$order->user_id = Auth::user()->id;
	  			$order->total = $this->cart->getTotal();
	  			$order->save();

	  			if($cart_items->count() < 1)
	  			{
	  				throw new \Exception('Cart seems to be empty.');
	  			}
		  		foreach($cart_items as $item)
		  		{
		  			$order->products()->attach($item->id,['qty'=>$item->qty]);
		  		}

		  		return $order;

	 			} catch (Exception $e) {
					Log::error('Failed populating order for user '.Auth::user()->id);
					Log::error(serialize($this->cart->content()));
					Log::error($e);
	 			}
	  	}
  	});

        return false;
  }

Last updated 2 years ago.

gayanhewa

replied 10 years ago

Current approach for the testing :

// With an annotation @expectedException Exception

			DB::transaction(function(){

				$order = new Order();
				$order->user_id = 9999; // No fk constraint. So I can use a random number to i can be 100% sure there was no record created.
				$order->total = 100;
				$order->save();
				throw new Exception('Error occured , so don\'t hit the database');
			
			});

I can only confirm that the DB transaction works as expected and that the method throws an exception as expected and the records are never saved. Has to be verified by another unit test that verifies that the query didnt create a record in the database.

Last updated 2 years ago.