理论DBAL和sqlite问题

Question

我正在尝试使用Doctrine DBAL连接到sqlite数据库文件。

<?php
use Doctrine\DBAL\DriverManager;
require_once 'bootstrap.php';
$connectionParams = [
    'url' => 'sqlite:///crawls.db',
];
$conn = DriverManager::getConnection($connectionParams);

但是，当我尝试执行sql代码时，它显示该表不存在(当然，我手动检查了，它确实存在)。

$conn->exec('SELECT * FROM crawl_item');

输出

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: crawl_item' in /home/px/Documents/phpcrawler/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:57
Stack trace:...

此输出可能对您有所帮助

 var_dump($conn->connect());
 var_dump($conn->getDatabase());

 bool(true)
 NULL

Answer 1

如果您查看AbstractSQLiteDriver::_constructPdoDsn()方法，您将看到参数是'path'：

$connectionParams = [
    [
        'driver' => 'pdo_sqlite',
        'path' => '../products.db'
    ]
);

$conn = DriverManager::getConnection($connectionParams);

你好，托马斯