Php 如何在不指定symfony列的情况下从数据库中获取行数组

发布于02月20日

I want to have Repository class that can execute every 'SELECT' query
that I enter in it, random query from outside.
And I dont want to specify columns that I want to get from this native query.

通常，每个人都会使用以下代码:

$sql = 'select column_one, column_two from table';

$rsm = new ResultSetMapping();
$rsm->addScalarResult('column_one', 'columnOne');
$rsm->addScalarResult('column_two', 'columnTwo');

$query = $this->getEntityManager()->createNativeQuery($sql, $rsm);
$result = $query->getResult();

But in my case I can't specify 'column_one' or 'column_two',
because sql query and columns will be different.
And without $rsm->addScalarResult('column_one', 'columnOne') I don't get any results.

如何在不指定列的情况下获得结果

推荐答案

如果您不想配置预定义的结果集，则应该像下面的示例那样进行配置:https://symfony.com/doc/current/doctrine.html#querying-with-sql

$conn = $this->getEntityManager()->getConnection();

$sql = '
        SELECT * FROM product p
        WHERE p.price > :price
        ORDER BY p.price ASC
        ';

$resultSet = $conn->executeQuery($sql, ['price' => $price]);

// returns an array of arrays (i.e. a raw data set)
return $resultSet->fetchAllAssociative();

我认为NativeQuery不能满足您的需求，因为它依赖于将结果映射到已知实体的 idea .如果您事先不知道查询是什么，那么就无法进行映射.