summaryrefslogtreecommitdiff
path: root/libs/picodb/tests/MysqlLobTest.php
diff options
context:
space:
mode:
authorFrédéric Guillot <fred@kanboard.net>2018-06-21 14:13:41 -0700
committerFrédéric Guillot <fred@kanboard.net>2018-06-21 14:13:41 -0700
commita491348d442ab8e6cd2fa403d4365cdad78e52ce (patch)
treea00f575d82afb2c9051bad95398b4250f4a3d44d /libs/picodb/tests/MysqlLobTest.php
parentc73ac5f1f818b6b21083f6785b4b2f6d778a6496 (diff)
Vendoring deprecated composer libs
Diffstat (limited to 'libs/picodb/tests/MysqlLobTest.php')
-rw-r--r--libs/picodb/tests/MysqlLobTest.php83
1 files changed, 83 insertions, 0 deletions
diff --git a/libs/picodb/tests/MysqlLobTest.php b/libs/picodb/tests/MysqlLobTest.php
new file mode 100644
index 00000000..1291d422
--- /dev/null
+++ b/libs/picodb/tests/MysqlLobTest.php
@@ -0,0 +1,83 @@
+<?php
+
+require_once __DIR__.'/../../../vendor/autoload.php';
+
+class MysqlLobTest extends PHPUnit_Framework_TestCase
+{
+ /**
+ * @var PicoDb\Database
+ */
+ private $db;
+
+ public function setUp()
+ {
+ $this->db = new PicoDb\Database(array('driver' => 'mysql', 'hostname' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'picodb'));
+ $this->db->getConnection()->exec('DROP TABLE IF EXISTS large_objects');
+ $this->db->getConnection()->exec('CREATE TABLE large_objects (id VARCHAR(20), file_content BLOB)');
+ $this->db->getStatementHandler()->withLogging();
+ }
+
+ public function testInsert()
+ {
+ $result = $this->db->largeObject('large_objects')->insertFromFile('file_content', __FILE__, array('id' => 'test'));
+ $this->assertTrue($result);
+ }
+
+ public function testInsertFromString()
+ {
+ $data = 'test';
+ $result = $this->db->largeObject('large_objects')->insertFromString('file_content', $data, array('id' => 'test'));
+ $this->assertTrue($result);
+ }
+
+ public function testInsertWithOptionalParams()
+ {
+ $result = $this->db->largeObject('large_objects')->insertFromFile('file_content', __FILE__);
+ $this->assertTrue($result);
+ }
+
+ public function testFindOneColumnAsStream()
+ {
+ $result = $this->db->largeObject('large_objects')->insertFromFile('file_content', __FILE__, array('id' => 'test'));
+ $this->assertTrue($result);
+
+ $contents = $this->db->largeObject('large_objects')->eq('id', 'test')->findOneColumnAsStream('file_content');
+ $this->assertSame(md5(file_get_contents(__FILE__)), md5($contents));
+ }
+
+ public function testFindOneColumnAsString()
+ {
+ $result = $this->db->largeObject('large_objects')->insertFromFile('file_content', __FILE__, array('id' => 'test'));
+ $this->assertTrue($result);
+
+ $contents = $this->db->largeObject('large_objects')->eq('id', 'test')->findOneColumnAsString('file_content');
+ $this->assertSame(md5(file_get_contents(__FILE__)), md5($contents));
+ }
+
+ public function testUpdate()
+ {
+ $result = $this->db->largeObject('large_objects')->insertFromFile('file_content', __FILE__, array('id' => 'test1'));
+ $this->assertTrue($result);
+
+ $result = $this->db->largeObject('large_objects')->insertFromFile('file_content', __FILE__, array('id' => 'test2'));
+ $this->assertTrue($result);
+
+ $result = $this->db->largeObject('large_objects')->eq('id', 'test1')->updateFromFile('file_content', __DIR__.'/../LICENSE');
+ $this->assertTrue($result);
+
+ $contents = $this->db->largeObject('large_objects')->eq('id', 'test1')->findOneColumnAsString('file_content');
+ $this->assertSame(md5(file_get_contents(__DIR__.'/../LICENSE')), md5($contents));
+
+ $contents = $this->db->largeObject('large_objects')->eq('id', 'test2')->findOneColumnAsString('file_content');
+ $this->assertSame(md5(file_get_contents(__FILE__)), md5($contents));
+
+ $result = $this->db->largeObject('large_objects')->updateFromFile('file_content', __DIR__.'/../composer.json');
+ $this->assertTrue($result);
+
+ $contents = $this->db->largeObject('large_objects')->eq('id', 'test1')->findOneColumnAsString('file_content');
+ $this->assertSame(md5(file_get_contents(__DIR__.'/../composer.json')), md5($contents));
+
+ $contents = $this->db->largeObject('large_objects')->eq('id', 'test2')->findOneColumnAsString('file_content');
+ $this->assertSame(md5(file_get_contents(__DIR__.'/../composer.json')), md5($contents));
+ }
+}