Aimeos\MW\Container\PHPExcelTest

Complexity

Total Complexity

10

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	testGet()	0	9	1
A	testExistingFile()	0	5	1
A	setUp()	0	4	2
A	testIterator()	0	12	2
A	testNewFile()	0	13	1
A	testFormat()	0	10	1
A	testAdd()	0	16	2

<?php

namespace Aimeos\MW\Container;


/**
 * @license LGPLv3, http://www.gnu.org/licenses/lgpl.html
 * @copyright Metaways Infosystems GmbH, 2013
 * @copyright Aimeos (aimeos.org), 2015-2018
 */
class PHPExcelTest extends \PHPUnit\Framework\TestCase

The type PHPUnit\Framework\TestCase was not found. Maybe you did not declare it correctly or list all dependencies?

{
	protected function setUp()
	{
		if( !class_exists( '\PHPExcel' ) ) {
			$this->markTestSkipped( 'PHPExcel not available' );
		}
	}


	public function testExistingFile()
	{
		$filename = __DIR__ . DIRECTORY_SEPARATOR . 'excel5.xls';

		new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
	}


	public function testNewFile()
	{
		$filename = __DIR__ . DIRECTORY_SEPARATOR . 'tempfile';

		$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
		$container->close();

		$result = file_exists( $container->getName() );
		unlink( $container->getName() );

		$this->assertTrue( $result );
		$this->assertEquals( '.xls', substr( $container->getName(), -4 ) );
		$this->assertFalse( file_exists( $container->getName() ) );
	}


	public function testFormat()
	{
		$container = new \Aimeos\MW\Container\PHPExcel( 'tempfile', 'Excel2007', [] );
		$this->assertEquals( '.xlsx', substr( $container->getName(), -5 ) );

		$container = new \Aimeos\MW\Container\PHPExcel( 'tempfile', 'OOCalc', [] );
		$this->assertEquals( '.ods', substr( $container->getName(), -4 ) );

		$container = new \Aimeos\MW\Container\PHPExcel( 'tempfile', 'CSV', [] );
		$this->assertEquals( '.csv', substr( $container->getName(), -4 ) );
	}


	public function testAdd()
	{
		$filename = __DIR__ . DIRECTORY_SEPARATOR . 'tempfile';

		$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );
		$container->add( $container->create( 'test' ) );

		$result = 0;
		foreach( $container as $content ) {
			$result++;
		}

		$container->close();
		unlink( $container->getName() );

		$this->assertEquals( 1, $result );
	}


	public function testGet()
	{
		$filename = __DIR__ . DIRECTORY_SEPARATOR . 'excel5.xls';
		$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );

		$this->assertInstanceOf( '\\Aimeos\\MW\\Container\\Content\\Iface', $container->get( 'Sheet2' ) );

		$this->setExpectedException( '\\Aimeos\\MW\\Container\\Exception' );
		$container->get( 'abc' );
	}


	public function testIterator()
	{
		$filename = __DIR__ . DIRECTORY_SEPARATOR . 'excel5.xls';

		$container = new \Aimeos\MW\Container\PHPExcel( $filename, 'Excel5', [] );

		$result = 0;
		foreach( $container as $key => $content ) {
			$result++;
		}

		$this->assertEquals( 3, $result );
	}

}