<?php

namespace RedUNIT\Sqlite;

use RedUNIT\Sqlite as Sqlite;
use RedBeanPHP\Facade as R;

/**
 * Rebuild
 *
 * SQLite cannot ALTER tables like other databases can.
 * To implement fluid mode in RedBeanPHP we have to
 * rebuild the entire table whenever we add or remove a column.
 * This test class tests whether rebuilding tables works properly,
 * i.e. we get the same table plus/minus some column...
 *
 * @file    RedUNIT/Sqlite/Rebuild.php
 * @desc    Test rebuilding of tables for SQLite
 * @author  Gabor de Mooij and the RedBeanPHP Community
 * @license New BSD/GPLv2
 *
 * (c) G.J.G.T. (Gabor) de Mooij and the RedBeanPHP Community.
 * This source file is subject to the New BSD/GPLv2 License that is bundled
 * with this source code in the file license.txt.
 */
class Rebuild extends Sqlite
{
	/**
	 * Test SQLite table rebuilding.
	 *
	 * @return void
	 */
	public function testRebuilder()
	{
		$toolbox = R::getToolBox();
		$adapter = $toolbox->getDatabaseAdapter();
		$writer  = $toolbox->getWriter();
		$redbean = $toolbox->getRedBean();
		$pdo     = $adapter->getDatabase();
		$book = R::dispense( 'book' );
		$page = R::dispense( 'page' );
		$book->xownPage[] = $page;
		$id = R::store( $book );
		$book = R::load( 'book', $id );
		asrt( count( $book->xownPage ), 1 );
		asrt( (int) R::getCell( 'SELECT COUNT(*) FROM page' ), 1 );
		R::trash( $book );
		asrt( (int) R::getCell( 'SELECT COUNT(*) FROM page' ), 0 );
		$book = R::dispense( 'book' );
		$page = R::dispense( 'page' );
		$book->xownPage[] = $page;
		$id = R::store( $book );
		$book = R::load( 'book', $id );
		asrt( count( $book->xownPage ), 1 );
		asrt( (int) R::getCell( 'SELECT COUNT(*) FROM page' ), 1 );
		$book->added = 2;
		R::store( $book );
		$book->added = 'added';
		R::store( $book );
		R::trash( $book );
		asrt( (int) R::getCell( 'SELECT COUNT(*) FROM page' ), 0 );
	}
}