Yaffs site version 1.1

[yaffs-website] / vendor / gabordemooij / redbean / testing / RedUNIT / Mysql / Preexist.php

diff --git a/vendor/gabordemooij/redbean/testing/RedUNIT/Mysql/Preexist.php b/vendor/gabordemooij/redbean/testing/RedUNIT/Mysql/Preexist.php
new file mode 100644 (file)
index 0000000..dcf4c2a
--- /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
+       }
+}