public function testData() { $d = new Data(__DIR__ . '/../tmp/test.sql'); $ary = $d->parseFile(); $keys = array('id', 'username', 'password', 'email', 'access'); $this->assertEquals(9, count($ary)); $this->assertEquals($keys, array_keys($ary['row_1'])); }
require_once '../../bootstrap.php'; use Pop\Data\Data; try { echo 'From a CSV file<br />-------------------<br />' . PHP_EOL; $data = new Data('../assets/files/test.csv'); $obj = $data->parseFile(); print_r($obj); echo PHP_EOL . '<br /><br />' . PHP_EOL; echo 'From a JSON file<br />-------------------<br />' . PHP_EOL; $data = new Data('../assets/files/test.json'); $obj = $data->parseFile(); print_r($obj); echo PHP_EOL . '<br /><br />' . PHP_EOL; echo 'From a SQL file<br />-------------------<br />' . PHP_EOL; $data = new Data('../assets/files/test.sql'); $obj = $data->parseFile(); print_r($obj); echo PHP_EOL . '<br /><br />' . PHP_EOL; echo 'From an XML file<br />-------------------<br />' . PHP_EOL; $data = new Data('../assets/files/test.xml'); $obj = $data->parseFile(); print_r($obj); echo PHP_EOL . '<br /><br />' . PHP_EOL; echo 'From a YML file<br />-------------------<br />' . PHP_EOL; $data = new Data('../assets/files/test.yml'); $obj = $data->parseFile(); print_r($obj); } catch (\Exception $e) { echo $e->getMessage(); }
<?php require_once '../../bootstrap.php'; use Pop\Data\Data; try { $data = new Data('../assets/files/test.csv'); $csv = $data->parseFile(); $data = new Data('../assets/files/test.json'); $json = $data->parseFile(); $data = new Data('../assets/files/test.sql'); $sql = $data->parseFile(); $data = new Data('../assets/files/test.xml'); $xml = $data->parseFile(); $data = new Data('../assets/files/test.yml'); $yml = $data->parseFile(); echo 'CSV data to XML file<br />-------------------<br />' . PHP_EOL; $data = new Data($csv); $obj = $data->parseData('xml'); echo $obj; echo PHP_EOL . '<br /><br />' . PHP_EOL; echo 'SQL data to CSV file<br />-------------------<br />' . PHP_EOL; $data = new Data($sql); $obj = $data->parseData('csv'); echo $obj; echo PHP_EOL . '<br /><br />' . PHP_EOL; echo 'SQL data to YAML file<br />-------------------<br />' . PHP_EOL; $data = new Data($sql); $obj = $data->parseData('yaml'); echo $obj; echo PHP_EOL . '<br /><br />' . PHP_EOL; echo 'XML data to SQL file<br />-------------------<br />' . PHP_EOL;