Yaffs site version 1.1

[yaffs-website] / vendor / gabordemooij / redbean / testing / RedUNIT / Sqlite / Rebuild.php

diff --git a/vendor/gabordemooij/redbean/testing/RedUNIT/Sqlite/Rebuild.php b/vendor/gabordemooij/redbean/testing/RedUNIT/Sqlite/Rebuild.php
new file mode 100644 (file)
index 0000000..81ad405
--- /dev/null
+++ b/vendor/gabordemooij/redbean/testing/RedUNIT/Sqlite/Rebuild.php
@@ -0,0 +1,63 @@
+<?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 );
+       }
+}