Exemplo n.º 1
0
 public function testDatabaseDumpMysqli()
 {
     $table = new \Cli\Table();
     $db = new \mysqli('localhost', 'H675X16em4', 'XOc1pu3AcAnINA2eKEY4ruRO8i8iXI', 'test');
     if ($db->connect_errno) {
         throw new \Exception("Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error);
     }
     if (!($stmt = $db->prepare("SELECT * FROM `table`"))) {
         throw new \Exception("Prepare failed: (" . $db->errno . ") " . $db->error);
     }
     if (!$stmt->execute()) {
         throw new \Exception("Execute failed: (" . $stmt->errno . ") " . $stmt->error);
     }
     $table->importFromMysqli($stmt);
     $this->expectOutputString('+-------------+-------------+-------------+' . "\n" . '| Col 1       | Col 2       | Col 3       |' . "\n" . '+-------------+-------------+-------------+' . "\n" . '| Col 1 Row 1 | Col 2 Row 1 | Col 3 Row 1 |' . "\n" . '| Col 1 Row 2 | Col 2 Row 2 | Col 3 Row 2 |' . "\n" . '| Col 1 Row 3 | Col 2 Row 3 | Col 3 Row 3 |' . "\n" . '+-------------+-------------+-------------+' . "\n");
     $table->show();
     $stmt->close();
 }