Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
behat	[ DIR ]	drwxr-sr-x	2017-06-22 15:51
fixtures	[ DIR ]	drwxr-sr-x	2017-06-22 15:52
other	[ DIR ]	drwxr-sr-x	2017-06-22 15:52
performance	[ DIR ]	drwxr-sr-x	2017-06-22 15:52
accesslib_test.php	155.23 KB	-rw-r--r--	2017-06-22 15:51
adhoc_task_test.php	3.6 KB	-rw-r--r--	2017-06-22 15:51
admintree_test.php	12.62 KB	-rw-r--r--	2017-06-22 15:51
ajaxlib_test.php	4.35 KB	-rw-r--r--	2017-06-22 15:51
antivirus_test.php	3.63 KB	-rw-r--r--	2017-06-22 15:51
authlib_test.php	11.49 KB	-rw-r--r--	2017-06-22 15:51
blocklib_test.php	24.65 KB	-rw-r--r--	2017-06-22 15:51
collator_test.php	11.98 KB	-rw-r--r--	2017-06-22 15:51
completionlib_test.php	37.83 KB	-rw-r--r--	2017-06-22 15:51
component_test.php	37.04 KB	-rw-r--r--	2017-06-22 15:51
componentlib_test.php	6.64 KB	-rw-r--r--	2017-06-22 15:51
configonlylib_test.php	6.15 KB	-rw-r--r--	2017-06-22 15:51
coursecatlib_test.php	39.89 KB	-rw-r--r--	2017-06-22 15:51
cronlib_test.php	6.44 KB	-rw-r--r--	2017-06-22 15:51
csslib_test.php	8.57 KB	-rw-r--r--	2017-06-22 15:51
csvclass_test.php	5.56 KB	-rw-r--r--	2017-06-22 15:51
curl_security_helper_test.php	12.96 KB	-rw-r--r--	2017-06-22 15:51
customcontext_test.php	3.66 KB	-rw-r--r--	2017-06-22 15:51
datalib_test.php	28.64 KB	-rw-r--r--	2017-06-22 15:51
datalib_update_with_unique_index_test.php	6.31 KB	-rw-r--r--	2017-06-22 15:51
date_legacy_test.php	13.9 KB	-rw-r--r--	2017-06-22 15:51
date_test.php	24.13 KB	-rw-r--r--	2017-06-22 15:51
editorlib_test.php	2.01 KB	-rw-r--r--	2017-06-22 15:51
environment_test.php	7.66 KB	-rw-r--r--	2017-06-22 15:51
event_course_module_instance_list_viewed.php	2.7 KB	-rw-r--r--	2017-06-22 15:51
event_course_module_viewed.php	3.31 KB	-rw-r--r--	2017-06-22 15:51
event_deprecated_test.php	1.49 KB	-rw-r--r--	2017-06-22 15:51
event_grade_deleted_test.php	3.25 KB	-rw-r--r--	2017-06-22 15:51
event_test.php	40.93 KB	-rw-r--r--	2017-06-22 15:51
event_unknown_logged_test.php	1.92 KB	-rw-r--r--	2017-06-22 15:51
event_user_graded_test.php	10.06 KB	-rw-r--r--	2017-06-22 15:51
event_user_password_updated_test.php	2.89 KB	-rw-r--r--	2017-06-22 15:51
events_test.php	15.29 KB	-rw-r--r--	2017-06-22 15:51
eventslib_test.php	11.8 KB	-rw-r--r--	2017-06-22 15:51
externallib_test.php	22.73 KB	-rw-r--r--	2017-06-22 15:51
filelib_test.php	50.67 KB	-rw-r--r--	2017-06-22 15:51
filetypes_test.php	9.99 KB	-rw-r--r--	2017-06-22 15:51
filter_manager_test.php	3.1 KB	-rw-r--r--	2017-06-22 15:51
filterlib_test.php	28.43 KB	-rw-r--r--	2017-06-22 15:51
formslib_test.php	39.82 KB	-rw-r--r--	2017-06-22 15:52
gdlib_test.php	5.91 KB	-rw-r--r--	2017-06-22 15:52
gradelib_test.php	2.05 KB	-rw-r--r--	2017-06-22 15:52
grades_externallib_test.php	20.79 KB	-rw-r--r--	2017-06-22 15:52
grading_externallib_test.php	26.27 KB	-rw-r--r--	2017-06-22 15:52
grouplib_test.php	62.33 KB	-rw-r--r--	2017-06-22 15:52
html2text_test.php	7.56 KB	-rw-r--r--	2017-06-22 15:52
html_writer_test.php	8.74 KB	-rw-r--r--	2017-06-22 15:52
htmlpurifier_test.php	21.25 KB	-rw-r--r--	2017-06-22 15:52
ip_utils_test.php	13.4 KB	-rw-r--r--	2017-06-22 15:52
jquery_test.php	1.77 KB	-rw-r--r--	2017-06-22 15:52
ldaplib_test.php	7.14 KB	-rw-r--r--	2017-06-22 15:52
lock_config_test.php	2.33 KB	-rw-r--r--	2017-06-22 15:52
lock_test.php	3.96 KB	-rw-r--r--	2017-06-22 15:52
markdown_test.php	2.2 KB	-rw-r--r--	2017-06-22 15:52
mathslib_test.php	8.14 KB	-rw-r--r--	2017-06-22 15:52
medialib_test.php	20.95 KB	-rw-r--r--	2017-06-22 15:52
message_test.php	10.32 KB	-rw-r--r--	2017-06-22 15:52
messageinbound_test.php	5.92 KB	-rw-r--r--	2017-06-22 15:52
messagelib_test.php	39.51 KB	-rw-r--r--	2017-06-22 15:52
minify_test.php	3.13 KB	-rw-r--r--	2017-06-22 15:52
modinfolib_test.php	44.04 KB	-rw-r--r--	2017-06-22 15:52
moodle_page_test.php	25.52 KB	-rw-r--r--	2017-06-22 15:52
moodlelib_test.php	153.62 KB	-rw-r--r--	2017-06-22 15:52
mustache_template_finder_test.php	3.35 KB	-rw-r--r--	2017-06-22 15:52
myprofilelib_test.php	10.7 KB	-rw-r--r--	2017-06-22 15:52
navigationlib_test.php	26.04 KB	-rw-r--r--	2017-06-22 15:52
notification_test.php	4.18 KB	-rw-r--r--	2017-06-22 15:52
outputcomponents_test.php	19.33 KB	-rw-r--r--	2017-06-22 15:52
outputfactories_test.php	6.8 KB	-rw-r--r--	2017-06-22 15:52
outputrequirementslib_test.php	4.05 KB	-rw-r--r--	2017-06-22 15:52
plugin_manager_test.php	22.2 KB	-rw-r--r--	2017-06-22 15:52
portfoliolib_test.php	8.41 KB	-rw-r--r--	2017-06-22 15:52
progress_display_test.php	3.68 KB	-rw-r--r--	2017-06-22 15:52
progress_test.php	14.5 KB	-rw-r--r--	2017-06-22 15:52
questionlib_test.php	19.87 KB	-rw-r--r--	2017-06-22 15:52
regex_test.php	1.88 KB	-rw-r--r--	2017-06-22 15:52
requirejs_test.php	3.7 KB	-rw-r--r--	2017-06-22 15:52
rsslib_test.php	6.7 KB	-rw-r--r--	2017-06-22 15:52
scheduled_task_test.php	19.09 KB	-rw-r--r--	2017-06-22 15:52
scss_test.php	2.53 KB	-rw-r--r--	2017-06-22 15:52
session_manager_test.php	25.54 KB	-rw-r--r--	2017-06-22 15:52
session_redis_test.php	10.77 KB	-rw-r--r--	2017-06-22 15:52
sessionlib_test.php	12.57 KB	-rw-r--r--	2017-06-22 15:52
setuplib_test.php	18.57 KB	-rw-r--r--	2017-06-22 15:52
statslib_test.php	24.88 KB	-rw-r--r--	2017-06-22 15:52
string_manager_standard_test.php	6.91 KB	-rw-r--r--	2017-06-22 15:52
tablelib_test.php	18.07 KB	-rw-r--r--	2017-06-22 15:52
text_test.php	20.06 KB	-rw-r--r--	2017-06-22 15:52
theme_config_test.php	7.45 KB	-rw-r--r--	2017-06-22 15:52
unoconv_test.php	4 KB	-rw-r--r--	2017-06-22 15:52
update_api_test.php	6.75 KB	-rw-r--r--	2017-06-22 15:52
update_checker_test.php	10.92 KB	-rw-r--r--	2017-06-22 15:52
update_code_manager_test.php	9.11 KB	-rw-r--r--	2017-06-22 15:52
update_validator_test.php	18.47 KB	-rw-r--r--	2017-06-22 15:52
upgrade_util_test.php	5.65 KB	-rw-r--r--	2017-06-22 15:52
upgradelib_test.php	43.23 KB	-rw-r--r--	2017-06-22 15:52
user_menu_test.php	3.73 KB	-rw-r--r--	2017-06-22 15:52
user_test.php	17.23 KB	-rw-r--r--	2017-06-22 15:52
useragent_test.php	79.88 KB	-rw-r--r--	2017-06-22 15:52
weblib_format_text_test.php	8.43 KB	-rw-r--r--	2017-06-22 15:52
weblib_test.php	27.29 KB	-rw-r--r--	2017-06-22 15:52
xhtml_container_stack_test.php	4.16 KB	-rw-r--r--	2017-06-22 15:52

Rename

<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.

/**
 * Tests csv import and export functions.
 *
 * @package    core
 * @category   phpunit
 * @copyright  2012 Adrian Greeve
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

defined('MOODLE_INTERNAL') || die();

global $CFG;
require_once($CFG->dirroot . '/lib/csvlib.class.php');

class core_csvclass_testcase extends advanced_testcase {

protected $testdata = array();
    protected $teststring = '';
    protected $teststring2 = '';
    protected $teststring3 = '';
    protected $teststring4 = '';

protected function setUp() {

$this->resetAfterTest();

$csvdata = array();
 $csvdata[0][] = 'fullname';
 $csvdata[0][] = 'description of things';
 $csvdata[0][] = 'beer';
 $csvdata[1][] = 'William B Stacey';
 $csvdata[1][] = 'A field that contains "double quotes"';
 $csvdata[1][] = 'Asahi';
 $csvdata[2][] = 'Phillip Jenkins';
 $csvdata[2][] = 'This field has 
Multiple lines
and also contains "double quotes"';
 $csvdata[2][] = 'Yebisu';
 $this->testdata = $csvdata;

// Please note that each line needs a carriage return.
 $this->teststring = 'fullname,"description of things",beer
"William B Stacey","A field that contains ""double quotes""",Asahi
"Phillip Jenkins","This field has 
Multiple lines
and also contains ""double quotes""",Yebisu
';

$this->teststring2 = 'fullname,"description of things",beer
"Fred Flint","Find the stone inside the box",Asahi,"A fourth column"
"Sarah Smith","How are the people next door?,Yebisu,"Forget the next"
';

$this->teststring4 = 'fullname,"description of things",beer
"Douglas Dirk","I am fine, thankyou.",Becks

"Addelyn Francis","Thanks for the cake",Becks
"Josh Frankson","Everything is fine",Asahi

"Heath Forscyth","We are going to make you lose your mind",Fosters
';
 }

public function test_csv_functions() {
        global $CFG;
        $csvexport = new csv_export_writer();
        $csvexport->set_filename('unittest');
        foreach ($this->testdata as $data) {
            $csvexport->add_data($data);
        }
        $csvoutput = $csvexport->print_csv_data(true);
        $this->assertSame($csvoutput, $this->teststring);

$test_data = csv_export_writer::print_array($this->testdata, 'comma', '"', true);
        $this->assertSame($test_data, $this->teststring);

// Testing that the content is imported correctly.
        $iid = csv_import_reader::get_new_iid('lib');
        $csvimport = new csv_import_reader($iid, 'lib');
        $contentcount = $csvimport->load_csv_content($this->teststring, 'utf-8', 'comma');
        $csvimport->init();
        $dataset = array();
        $dataset[] = $csvimport->get_columns();
        while ($record = $csvimport->next()) {
            $dataset[] = $record;
        }
        $csvimport->cleanup();
        $csvimport->close();
        $this->assertSame($dataset, $this->testdata);

// Testing for the wrong count of columns.
        $errortext = get_string('csvweirdcolumns', 'error');
        $iid = csv_import_reader::get_new_iid('lib');
        $csvimport = new csv_import_reader($iid, 'lib');
        $contentcount = $csvimport->load_csv_content($this->teststring2, 'utf-8', 'comma');
        $importerror = $csvimport->get_error();
        $csvimport->cleanup();
        $csvimport->close();
        $this->assertSame($importerror, $errortext);

// Testing for empty content.
        $errortext = get_string('csvemptyfile', 'error');

$iid = csv_import_reader::get_new_iid('lib');
        $csvimport = new csv_import_reader($iid, 'lib');
        $contentcount = $csvimport->load_csv_content($this->teststring3, 'utf-8', 'comma');
        $importerror = $csvimport->get_error();
        $csvimport->cleanup();
        $csvimport->close();
        $this->assertSame($importerror, $errortext);

// Testing for a tab separated file.
        // The tab separated file has a trailing tab and extra blank lines at the end of the file.
        $filename = $CFG->dirroot . '/lib/tests/fixtures/tabfile.csv';
        $fp = fopen($filename, 'r');
        $tabdata = fread($fp, filesize($filename));
        fclose($fp);
        $iid = csv_import_reader::get_new_iid('tab');
        $csvimport = new csv_import_reader($iid, 'tab');
        $contentcount = $csvimport->load_csv_content($tabdata, 'utf-8', 'tab');
        // This should import four rows including the headings.
        $this->assertEquals($contentcount, 4);

// Testing for empty lines.
        $iid = csv_import_reader::get_new_iid('blanklines');
        $csvimport = new csv_import_reader($iid, 'blanklines');
        $contentcount = $csvimport->load_csv_content($this->teststring4, 'utf-8', 'comma');
        // Five lines including the headings should be imported.
        $this->assertEquals($contentcount, 5);
    }
}