summaryrefslogtreecommitdiffstats
path: root/application/test/tests/test_database_schema.php
diff options
context:
space:
mode:
authorFlorian Pritz <bluewind@xinu.at>2017-07-11 10:58:31 +0200
committerFlorian Pritz <bluewind@xinu.at>2017-07-11 10:58:31 +0200
commit033c9729af6d66e3806d52382c5bc5f48ae8b63b (patch)
treed95d1fbfe0f4946f789e857ebd340e18a14be663 /application/test/tests/test_database_schema.php
parent7404267544848502d053ed2391832e799df3ec5c (diff)
Test inserting bigint values in DB
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'application/test/tests/test_database_schema.php')
-rw-r--r--application/test/tests/test_database_schema.php38
1 files changed, 38 insertions, 0 deletions
diff --git a/application/test/tests/test_database_schema.php b/application/test/tests/test_database_schema.php
new file mode 100644
index 000000000..02f188e1f
--- /dev/null
+++ b/application/test/tests/test_database_schema.php
@@ -0,0 +1,38 @@
+<?php
+/*
+ * Copyright 2017 Florian "Bluewind" Pritz <bluewind@server-speed.net>
+ *
+ * Licensed under AGPLv3
+ * (see COPYING for full license text)
+ *
+ */
+
+namespace test\tests;
+
+class test_database_schema extends \test\Test {
+
+ public function __construct()
+ {
+ parent::__construct();
+ }
+
+ public function test_file_storage_bigint() {
+ $filesize = pow(2, 35) + 1;
+
+ $CI =& get_instance();
+ $CI->db->insert("file_storage", array(
+ "filesize" => $filesize,
+ "mimetype" => "text/plain",
+ "hash" => md5("test"),
+ "date" => time(),
+ ));
+ $id = $CI->db->insert_id();
+ $db_value = $CI->db->select('filesize')
+ ->from('file_storage')
+ ->where('id', $id)
+ ->get()->result_array()[0]["filesize"];
+ $this->t->is(intval($db_value), $filesize, "Large filesize is stored correctly in db");
+ }
+
+
+}