X-Git-Url: http://www.aleph1.co.uk/gitweb/?p=yaffs-website;a=blobdiff_plain;f=vendor%2Fgabordemooij%2Fredbean%2Ftesting%2FRedUNIT%2FMysql%2FPreexist.php;fp=vendor%2Fgabordemooij%2Fredbean%2Ftesting%2FRedUNIT%2FMysql%2FPreexist.php;h=dcf4c2a9dbdebca87ca1eaf2a525e7459a75ff27;hp=0000000000000000000000000000000000000000;hb=eba34333e3c89f208d2f72fa91351ad019a71583;hpb=a2bd1bf0c2c1f1a17d188f4dc0726a45494cefae

diff --git a/vendor/gabordemooij/redbean/testing/RedUNIT/Mysql/Preexist.php b/vendor/gabordemooij/redbean/testing/RedUNIT/Mysql/Preexist.php
new file mode 100644
index 000000000..dcf4c2a9d
--- /dev/null
+++ b/vendor/gabordemooij/redbean/testing/RedUNIT/Mysql/Preexist.php
@@ -0,0 +1,58 @@
+<?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
+	}
+}