+++ /dev/null
-<?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
- }
-}