dsj83686 2017-10-30 10:15
浏览 78
已采纳

PHP 7 MongoDB - 删除所有数据库

I'm trying to unit test my mongodb methods, thus I need a tearDown() method to flush my entire mongo database after testing.

Here is the function:

public function tearDown()
{
    $databases = $this->mongoClient->listDatabases();
    foreach ($databases as $db) {
        $db.dropDatabase();
    }
}

However it can't see the method on my $db.

Error: Call to undefined function Api\Test\Unit\dropDatabase()

It seems listDatabases() only return some information model of my dbs, not the actual databases themselves:

/var/www/html/tests/backend/Service/MongoStorageTest.php:35:
class MongoDB\Model\DatabaseInfo#1563 (3) {
  public $name =>
  string(5) "local"
  public $sizeOnDisk =>
  double(83886080)
  public $empty =>
  bool(false)
}

/var/www/html/tests/backend/Service/MongoStorageTest.php:35:
class MongoDB\Model\DatabaseInfo#1483 (3) {
  public $name =>
  string(2) "db"
  public $sizeOnDisk =>
  double(83886080)
  public $empty =>
  bool(false)
}

Is there any practical or simple way to really select them, or just drop everything with one method?

  • 写回答

1条回答 默认 最新

  • douri4459 2017-10-30 10:41
    关注

    The method to drop is actually on MongoClient, and of course there is getName() from the MongoDB\Model\DatabaseInfo types that are returned from listDatabases()

    public function tearDown()
    {
        $databases = $this->mongoClient->listDatabases();
        foreach ($databases as $db) {
            $this->mongoClient->dropDatabase($db->getName());
        }
    }
    

    Alternately you could selectDatabase() and use the drop() method on MongoDB\Database:

    public function tearDown()
    {
        $databases = $this->mongoClient->listDatabases();
        foreach ($databases as $db) {
            $this->mongoClient->selectDatabase($db->getName())->drop();
        }
    }
    

    But to my mind that's a little more terse, and the first form feels more expressive.

    Being that a "database" is a base container for namespace, then there actually is no command to "drop everything". Listing and looping the list is how you do it. Bottom line is if it's not in the "command reference", then there is no such thing.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 宇视监控服务器无法登录
  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥15 DruidDataSource一直closing
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
  • ¥50 STM32单片机传感器读取错误
  • ¥50 power BI 从Mysql服务器导入数据,但连接进去后显示表无数据