mirror of
https://github.com/e107inc/e107.git
synced 2025-08-08 07:36:32 +02:00
ae3c57a5b4
https://jira.mariadb.org/browse/MDEV-29446 changes the output of `SHOW CREATE TABLE`, which MySQL and MariaDB 10.2 and older do not do. To tolerate the new behavior, this change strips the `COLLATE` clause from the `SHOW CREATE TABLE` output to ignore it. Fixes: https://github.com/e107inc/e107/issues/4912
396 lines
9.2 KiB
PHP
396 lines
9.2 KiB
PHP
<?php
|
|
/**
|
|
* e107 website system
|
|
*
|
|
* Copyright (C) 2008-2020 e107 Inc (e107.org)
|
|
* Released under the terms and conditions of the
|
|
* GNU General Public License (http://www.gnu.org/licenses/gpl.txt)
|
|
*
|
|
*/
|
|
|
|
|
|
class db_table_adminTest extends \Codeception\Test\Unit
|
|
{
|
|
|
|
/** @var db_table_admin */
|
|
protected $dta;
|
|
|
|
protected function _before()
|
|
{
|
|
|
|
try
|
|
{
|
|
$this->dta = $this->make('db_table_admin');
|
|
}
|
|
catch(Exception $e)
|
|
{
|
|
$this->assertTrue(false, "Couldn't load db_table_admin object");
|
|
}
|
|
|
|
}
|
|
/*
|
|
public function testCompare_field_lists()
|
|
{
|
|
|
|
}*/
|
|
|
|
public function testParse_field_defs()
|
|
{
|
|
$baseStruct = $this->dta->get_current_table('core');
|
|
$baseStruct = isset($baseStruct[0][2]) ? $baseStruct[0][2] : null;
|
|
|
|
$result = $this->dta->parse_field_defs($baseStruct);
|
|
|
|
$expected = array (
|
|
0 => array (
|
|
'type' => 'field',
|
|
'name' => 'e107_name',
|
|
'fieldtype' => 'varchar(100)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
1 => array (
|
|
'type' => 'field',
|
|
'name' => 'e107_value',
|
|
'fieldtype' => 'text',
|
|
'nulltype' => 'NOT NULL',
|
|
),
|
|
2 => array (
|
|
'type' => 'pkey',
|
|
'name' => '(e107_name)',
|
|
),
|
|
);
|
|
|
|
$this->assertSame($expected,$result);
|
|
|
|
$test2 = "userjournals_id int(10) unsigned NOT NULL auto_increment,
|
|
userjournals_userid int(10) unsigned NOT NULL default '0',
|
|
userjournals_subject varchar(64) NOT NULL default '',
|
|
userjournals_categories varchar(100) NOT NULL default '',
|
|
userjournals_playing varchar(50) NOT NULL default '',
|
|
userjournals_mood enum('','happy','sad','alienated','beat_up','angry','annoyed') NOT NULL default 'happy',
|
|
userjournals_entry longtext NOT NULL,
|
|
userjournals_date varchar(64) NOT NULL default '',
|
|
userjournals_timestamp varchar(32) NOT NULL default '',
|
|
userjournals_is_comment int(1) NOT NULL default '0',
|
|
PRIMARY KEY (userjournals_id)";
|
|
|
|
$result2 = $this->dta->parse_field_defs($test2);
|
|
|
|
$expected = array (
|
|
0 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_id',
|
|
'fieldtype' => 'int(10)',
|
|
'vartype' => 'unsigned',
|
|
'nulltype' => 'NOT NULL',
|
|
'autoinc' => true,
|
|
),
|
|
1 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_userid',
|
|
'fieldtype' => 'int(10)',
|
|
'vartype' => 'unsigned',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'0\'',
|
|
),
|
|
2 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_subject',
|
|
'fieldtype' => 'varchar(64)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
3 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_categories',
|
|
'fieldtype' => 'varchar(100)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
4 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_playing',
|
|
'fieldtype' => 'varchar(50)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
5 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_mood',
|
|
'fieldtype' => 'enum(\'\',\'happy\',\'sad\',\'alienated\',\'beat_up\',\'angry\',\'annoyed\')',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'happy\'',
|
|
),
|
|
6 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_entry',
|
|
'fieldtype' => 'longtext',
|
|
'nulltype' => 'NOT NULL',
|
|
),
|
|
7 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_date',
|
|
'fieldtype' => 'varchar(64)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
8 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_timestamp',
|
|
'fieldtype' => 'varchar(32)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
9 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_is_comment',
|
|
'fieldtype' => 'int(1)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'0\'',
|
|
),
|
|
10 =>
|
|
array (
|
|
'type' => 'pkey',
|
|
'name' => '(userjournals_id)',
|
|
),
|
|
);
|
|
|
|
$this->assertSame($expected,$result2);
|
|
|
|
|
|
}
|
|
|
|
/* public function testUpdate_table_structure()
|
|
{
|
|
|
|
}*/
|
|
|
|
public function testMake_field_types()
|
|
{
|
|
$fieldDefs = array (
|
|
0 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_id',
|
|
'fieldtype' => 'int(10)',
|
|
'vartype' => 'unsigned',
|
|
'nulltype' => 'NOT NULL',
|
|
'autoinc' => true,
|
|
),
|
|
1 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_userid',
|
|
'fieldtype' => 'int(10)',
|
|
'vartype' => 'unsigned',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'0\'',
|
|
),
|
|
2 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_subject',
|
|
'fieldtype' => 'varchar(64)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
3 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_categories',
|
|
'fieldtype' => 'varchar(100)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
4 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_playing',
|
|
'fieldtype' => 'varchar(50)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
5 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_mood',
|
|
'fieldtype' => 'enum(\'\',\'happy\',\'sad\',\'alienated\',\'beat_up\',\'angry\',\'annoyed\')',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'happy\'',
|
|
),
|
|
6 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_entry',
|
|
'fieldtype' => 'longtext',
|
|
'nulltype' => 'NOT NULL',
|
|
),
|
|
7 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_date',
|
|
'fieldtype' => 'varchar(64)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
8 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_timestamp',
|
|
'fieldtype' => 'varchar(32)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'\'',
|
|
),
|
|
9 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_is_comment',
|
|
'fieldtype' => 'int(1)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'0\'',
|
|
),
|
|
10 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_comment_parent',
|
|
'fieldtype' => 'int(1)',
|
|
'default' => 'NULL',
|
|
),
|
|
11 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_is_blog_desc',
|
|
'fieldtype' => 'int(1)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'0\'',
|
|
),
|
|
12 =>
|
|
array (
|
|
'type' => 'field',
|
|
'name' => 'userjournals_is_published',
|
|
'fieldtype' => 'int(1)',
|
|
'nulltype' => 'NOT NULL',
|
|
'default' => '\'0\'',
|
|
),
|
|
13 =>
|
|
array (
|
|
'type' => 'pkey',
|
|
'name' => '(userjournals_id)',
|
|
),
|
|
);
|
|
|
|
$result = $this->dta->make_field_types($fieldDefs);
|
|
|
|
$expected = array (
|
|
'_FIELD_TYPES' =>
|
|
array (
|
|
'userjournals_id' => 'int',
|
|
'userjournals_userid' => 'int',
|
|
'userjournals_subject' => 'escape',
|
|
'userjournals_categories' => 'escape',
|
|
'userjournals_playing' => 'escape',
|
|
'userjournals_mood' => 'escape',
|
|
'userjournals_entry' => 'escape',
|
|
'userjournals_date' => 'escape',
|
|
'userjournals_timestamp' => 'escape',
|
|
'userjournals_is_comment' => 'int',
|
|
'userjournals_comment_parent' => 'int',
|
|
'userjournals_is_blog_desc' => 'int',
|
|
'userjournals_is_published' => 'int',
|
|
),
|
|
'_NOTNULL' =>
|
|
array (
|
|
'userjournals_id' => '',
|
|
'userjournals_entry' => '',
|
|
),
|
|
);
|
|
|
|
$this->assertSame($expected, $result);
|
|
}
|
|
/*
|
|
public function testCreateTable()
|
|
{
|
|
|
|
}*/
|
|
|
|
public function testGet_current_table()
|
|
{
|
|
|
|
|
|
$expected = array (
|
|
0 =>
|
|
array (
|
|
0 => 'CREATE TABLE e107_core (
|
|
e107_name varchar(100) NOT NULL DEFAULT \'\',
|
|
e107_value text NOT NULL,
|
|
PRIMARY KEY (e107_name)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;',
|
|
1 => 'e107_core',
|
|
2 => 'e107_name varchar(100) NOT NULL DEFAULT \'\',
|
|
e107_value text NOT NULL,
|
|
PRIMARY KEY (e107_name)',
|
|
3 => 'MyISAM DEFAULT CHARSET=utf8',
|
|
),
|
|
);
|
|
|
|
$result = $this->dta->get_current_table('core');
|
|
|
|
array_walk_recursive($result, function(&$element)
|
|
{
|
|
// MySQL 8.0+
|
|
// Alias CHARSET=utf8mb3 to CHARSET=utf8
|
|
$element = str_replace("CHARSET=utf8mb3", "CHARSET=utf8", $element);
|
|
// MariaDB 10.3.37, 10.4.27, 10.5.18, 10.6.11, 10.7.7, 10.8.6, 10.9.4, 10.10.2, 10.11.0
|
|
// Ignore COLLATE clause (https://jira.mariadb.org/browse/MDEV-29446)
|
|
$element = preg_replace("/ COLLATE=[^\s;]+/", "", $element);
|
|
});
|
|
|
|
$this->assertSame($expected, $result);
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
/*
|
|
public function testMake_changes_list()
|
|
{
|
|
|
|
}
|
|
|
|
public function testMake_field_list()
|
|
{
|
|
|
|
}
|
|
|
|
public function testGet_table_def()
|
|
{
|
|
|
|
}
|
|
|
|
public function testMake_table_list()
|
|
{
|
|
|
|
}
|
|
|
|
public function testMake_def()
|
|
{
|
|
|
|
}
|
|
*/
|
|
|
|
|
|
|
|
}
|