--TEST-- SqlDriverManager test insert into table #2 --FILE-- <?php use php\sql\SqlDriverManager; use php\sql\SqlResult; use php\util\Flow; SqlDriverManager::install('sqlite'); $conn = SqlDriverManager::getConnection('sqlite::memory:'); $conn->query('create table person (id integer, name string)')->update(); $result = $conn->query("insert into person values(?, ?)", [1, 'leo'])->update(); $result += $conn->query("insert into person values(?, ?)", [2, 'yui'])->update(); var_dump($result); $array = Flow::of($conn->query('select * from person'))->map(function (SqlResult $result) { return $result->toArray(); })->toArray(); var_dump($array); ?> --EXPECTF-- int(2) array(2) { [0]=> array(2) { ["id"]=> int(1) ["name"]=> string(3) "leo" } [1]=> array(2) { ["id"]=>
--TEST-- SqlDriverManager test metadata #2 --FILE-- <?php use php\sql\SqlDriverManager; SqlDriverManager::install('sqlite'); $conn = SqlDriverManager::getConnection('sqlite::memory:', ['username' => 'admin', 'password' => 'admin']); var_dump($conn->getCatalogs()); var_dump($conn->getSchemas()); var_dump($conn->getMetaData()); ?> --EXPECT-- array(0) { } array(0) { } array(34) { ["userName"]=> string(0) "" ["driverName"]=> string(10) "SQLiteJDBC" ["driverVersion"]=> string(6) "native" ["databaseName"]=> string(6) "SQLite" ["databaseVersion"]=> string(5) "3.8.7" ["catalogSeparator"]=> string(1) "." ["catalogTerm"]=> string(7) "catalog"