<?php
namespace RedUNIT\Mysql;
use RedUNIT\Mysql as Mysql;
use RedBeanPHP\Facade as R;
use RedBeanPHP\AssociationManager as AssociationManager;
/**
* Preexist
*
* Tests whether RedBeanPHP can work with existing
* MySQL schemas.
*
* @file RedUNIT/Mysql/Preexist.php
* @desc Tests integration with pre-existing schemas.
* @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 Preexist extends Mysql
{
/**
* Test integration with pre-existing schemas.
*
* @return void
*/
public function testPlaysNiceWithPreExitsingSchema()
{
$toolbox = R::getToolBox();
$adapter = $toolbox->getDatabaseAdapter();
$writer = $toolbox->getWriter();
$redbean = $toolbox->getRedBean();
$pdo = $adapter->getDatabase();
$a = new AssociationManager( $toolbox );
$page = $redbean->dispense( "page" );
$page->name = "John's page";
$idpage = $redbean->store( $page );
$page2 = $redbean->dispense( "page" );
$page2->name = "John's second page";
$idpage2 = $redbean->store( $page2 );
$a->associate( $page, $page2 );
$adapter->exec( "ALTER TABLE " . $writer->esc( 'page' ) . "
CHANGE " . $writer->esc( 'name' ) . " " . $writer->esc( 'name' ) . "
VARCHAR( 254 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL " );
$page = $redbean->dispense( "page" );
$page->name = "Just Another Page In a Table";
$cols = $writer->getColumns( "page" );
asrt( $cols["name"], "varchar(254)" );
$redbean->store( $page );
pass(); // No crash?
$cols = $writer->getColumns( "page" );
asrt( $cols["name"], "varchar(254)" ); //must still be same
}
}
|
Download
