/** * @expectedException \InvalidArgumentException * @expectedExceptionMessage value is invalid: array */ public function testInvalidLine() { $interpreter = new Interpreter(); $table = 'test'; $options = array('user' => $this->manager->getUser(), 'password' => $this->manager->getPassword()); $sqlObserver = new PdoObserver($table, array('id', 'name'), $this->manager->getDsn(), $options); $interpreter->addObserver(array($sqlObserver, 'notify')); $interpreter->interpret(array('123', array('test', 'test'))); }
public function testUsageWithCallbackCollection() { $pdo = $this->manager->getPdo(); $stmt = $pdo->prepare("SELECT * FROM collection_test"); $stmt->execute(); $pdoCollection = new PdoCollection($stmt); $callbackCollection = new CallbackCollection($pdoCollection, function ($row) { $row['test'] = 'test'; return $row; }); foreach ($callbackCollection as $line) { $this->assertEquals('test', $line['test']); } }
public function testUsage() { $pdo = $this->manager->getPdo(); $stmt = $pdo->prepare("SELECT * FROM collection_test"); $stmt->execute(); $this->assertFileNotExists('vfs://output/data.csv'); $collection = new PdoCollection($stmt); $config = new ExporterConfig(); $exporter = new Exporter($config); $exporter->export('vfs://output/data.csv', $collection); $expectedContents = "1,name\r\n"; $expectedContents .= "2,name\r\n"; $expectedContents .= "3,name\r\n"; $this->assertSame($expectedContents, file_get_contents('vfs://output/data.csv')); }