From 48fbce3ca35def15e546376a104f9ec4dba24953 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Maur=C3=ADcio=20Meneghini=20Fauth?= Date: Mon, 28 Feb 2022 15:10:12 -0300 Subject: [PATCH] Add basic test for `Table\AddFieldController` MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Maurício Meneghini Fauth --- .../Controllers/Table/AddFieldControllerTest.php | 259 +++++++++++++++++++++ 1 file changed, 259 insertions(+) create mode 100644 test/classes/Controllers/Table/AddFieldControllerTest.php diff --git a/test/classes/Controllers/Table/AddFieldControllerTest.php b/test/classes/Controllers/Table/AddFieldControllerTest.php new file mode 100644 index 0000000000..9b93dc5eaf --- /dev/null +++ b/test/classes/Controllers/Table/AddFieldControllerTest.php @@ -0,0 +1,259 @@ +defaultServer; + $_POST = [ + 'db' => 'test_db', + 'table' => 'test_table', + 'num_fields' => '1', + 'field_where' => 'after', + 'after_field' => 'datetimefield', + ]; + + $this->dummyDbi->addSelectDb('test_db'); + $this->dummyDbi->addResult('SHOW TABLES LIKE \'test_table\';', [['test_table']]); + + $contentCell = [ + 'column_number' => 0, + 'column_meta' => ['Type' => ''], + 'type_upper' => '', + 'default_value' => '', + 'length_values_input_size' => 8, + 'length' => '', + 'extracted_columnspec' => [], + 'submit_attribute' => null, + 'comments_map' => [], + 'fields_meta' => null, + 'is_backup' => false, + 'move_columns' => [], + 'available_mime' => [ + 'mimetype' => [ + 'Image/JPEG' => 'Image/JPEG', + 'Text/Plain' => 'Text/Plain', + 'Application/Octetstream' => 'Application/Octetstream', + 'Image/PNG' => 'Image/PNG', + 'Text/Octetstream' => 'Text/Octetstream', + ], + 'input_transformation' => [ + 'Image/JPEG: Upload', + 'Text/Plain: FileUpload', + 'Text/Plain: Iptobinary', + 'Text/Plain: Iptolong', + 'Text/Plain: JsonEditor', + 'Text/Plain: RegexValidation', + 'Text/Plain: SqlEditor', + 'Text/Plain: XmlEditor', + 'Text/Plain: Link', + 'Text/Plain: Longtoipv4', + 'Text/Plain: PreApPend', + 'Text/Plain: Substring', + ], + 'input_transformation_file' => [ + 'Input/Image_JPEG_Upload.php', + 'Input/Text_Plain_FileUpload.php', + 'Input/Text_Plain_Iptobinary.php', + 'Input/Text_Plain_Iptolong.php', + 'Input/Text_Plain_JsonEditor.php', + 'Input/Text_Plain_RegexValidation.php', + 'Input/Text_Plain_SqlEditor.php', + 'Input/Text_Plain_XmlEditor.php', + 'Text_Plain_Link.php', + 'Text_Plain_Longtoipv4.php', + 'Text_Plain_PreApPend.php', + 'Text_Plain_Substring.php', + ], + 'transformation' => [ + 'Application/Octetstream: Download', + 'Application/Octetstream: Hex', + 'Image/JPEG: Inline', + 'Image/JPEG: Link', + 'Image/PNG: Inline', + 'Text/Octetstream: Sql', + 'Text/Plain: Binarytoip', + 'Text/Plain: Bool2Text', + 'Text/Plain: Dateformat', + 'Text/Plain: External', + 'Text/Plain: Formatted', + 'Text/Plain: Imagelink', + 'Text/Plain: Json', + 'Text/Plain: Sql', + 'Text/Plain: Xml', + 'Text/Plain: Link', + 'Text/Plain: Longtoipv4', + 'Text/Plain: PreApPend', + 'Text/Plain: Substring', + ], + 'transformation_file' => [ + 'Output/Application_Octetstream_Download.php', + 'Output/Application_Octetstream_Hex.php', + 'Output/Image_JPEG_Inline.php', + 'Output/Image_JPEG_Link.php', + 'Output/Image_PNG_Inline.php', + 'Output/Text_Octetstream_Sql.php', + 'Output/Text_Plain_Binarytoip.php', + 'Output/Text_Plain_Bool2Text.php', + 'Output/Text_Plain_Dateformat.php', + 'Output/Text_Plain_External.php', + 'Output/Text_Plain_Formatted.php', + 'Output/Text_Plain_Imagelink.php', + 'Output/Text_Plain_Json.php', + 'Output/Text_Plain_Sql.php', + 'Output/Text_Plain_Xml.php', + 'Text_Plain_Link.php', + 'Text_Plain_Longtoipv4.php', + 'Text_Plain_PreApPend.php', + 'Text_Plain_Substring.php', + ], + 'input_transformation_file_quoted' => [ + 'Input/Image_JPEG_Upload\\.php', + 'Input/Text_Plain_FileUpload\\.php', + 'Input/Text_Plain_Iptobinary\\.php', + 'Input/Text_Plain_Iptolong\\.php', + 'Input/Text_Plain_JsonEditor\\.php', + 'Input/Text_Plain_RegexValidation\\.php', + 'Input/Text_Plain_SqlEditor\\.php', + 'Input/Text_Plain_XmlEditor\\.php', + 'Text_Plain_Link\\.php', + 'Text_Plain_Longtoipv4\\.php', + 'Text_Plain_PreApPend\\.php', + 'Text_Plain_Substring\\.php', + ], + 'transformation_file_quoted' => [ + 'Output/Application_Octetstream_Download\\.php', + 'Output/Application_Octetstream_Hex\\.php', + 'Output/Image_JPEG_Inline\\.php', + 'Output/Image_JPEG_Link\\.php', + 'Output/Image_PNG_Inline\\.php', + 'Output/Text_Octetstream_Sql\\.php', + 'Output/Text_Plain_Binarytoip\\.php', + 'Output/Text_Plain_Bool2Text\\.php', + 'Output/Text_Plain_Dateformat\\.php', + 'Output/Text_Plain_External\\.php', + 'Output/Text_Plain_Formatted\\.php', + 'Output/Text_Plain_Imagelink\\.php', + 'Output/Text_Plain_Json\\.php', + 'Output/Text_Plain_Sql\\.php', + 'Output/Text_Plain_Xml\\.php', + 'Text_Plain_Link\\.php', + 'Text_Plain_Longtoipv4\\.php', + 'Text_Plain_PreApPend\\.php', + 'Text_Plain_Substring\\.php', + ], + ], + 'mime_map' => [], + ]; + + $relation = new Relation($this->dbi); + $response = new ResponseRenderer(); + $template = new Template(); + $expected = $template->render('columns_definitions/column_definitions_form', [ + 'is_backup' => false, + 'fields_meta' => null, + 'relation_parameters' => $relation->getRelationParameters(), + 'action' => 'index.php?route=/table/add-field&lang=en', + 'form_params' => [ + 'db' => 'test_db', + 'field_where' => 'after', + 'after_field' => 'datetimefield', + 'table' => 'test_table', + 'orig_num_fields' => 1, + 'orig_field_where' => 'after', + 'orig_after_field' => 'datetimefield', + ], + 'content_cells' => [$contentCell], + 'partition_details' => [ + 'partition_by' => null, + 'partition_expr' => null, + 'subpartition_by' => null, + 'subpartition_expr' => null, + 'partition_count' => 0, + 'subpartition_count' => 0, + 'can_have_subpartitions' => false, + 'value_enabled' => false, + ], + 'primary_indexes' => null, + 'unique_indexes' => null, + 'indexes' => null, + 'fulltext_indexes' => null, + 'spatial_indexes' => null, + 'table' => 'test_table', + 'comment' => null, + 'tbl_collation' => null, + 'charsets' => [ + [ + 'name' => 'armscii8', + 'description' => 'armscii8_general_ci', + 'collations' => [['name' => 'armscii8_general_ci', 'description' => 'Armenian, case-insensitive']], + ], + [ + 'name' => 'latin1', + 'description' => 'cp1252 West European', + 'collations' => [['name' => 'latin1_swedish_ci', 'description' => 'Swedish, case-insensitive']], + ], + [ + 'name' => 'utf8', + 'description' => 'UTF-8 Unicode', + 'collations' => [ + ['name' => 'utf8_bin', 'description' => 'Unicode, binary'], + ['name' => 'utf8_general_ci', 'description' => 'Unicode, case-insensitive'], + ], + ], + [ + 'name' => 'utf8mb4', + 'description' => 'utf8mb4_0900_ai_ci', + 'collations' => [ + ['name' => 'utf8mb4_general_ci', 'description' => 'Unicode (UCA 4.0.0), case-insensitive'], + ], + ], + ], + 'tbl_storage_engine' => null, + 'storage_engines' => ['dummy' => ['name' => 'dummy', 'comment' => 'dummy comment', 'is_default' => false]], + 'connection' => null, + 'change_column' => null, + 'is_virtual_columns_supported' => true, + 'is_integers_length_restricted' => false, + 'browse_mime' => true, + 'supports_stored_keyword' => false, + 'server_version' => $this->dbi->getVersion(), + 'max_rows' => 25, + 'char_editing' => 'input', + 'attribute_types' => ['', 'BINARY', 'UNSIGNED', 'UNSIGNED ZEROFILL', 'on update CURRENT_TIMESTAMP'], + 'privs_available' => false, + 'max_length' => 1024, + 'have_partitioning' => true, + 'dbi' => $this->dbi, + 'disable_is' => true, + ]); + + (new AddFieldController( + $response, + $template, + new Transformations(), + new Config(), + $relation, + $this->dbi + ))(); + + $this->assertSame($expected, $response->getHTMLResult()); + } +} -- 2.11.4.GIT