updateInDatabase

[pturbin-bfg]

hello there!)
why did you skipped function updateInDatabase from original Db module?

public function updateInDatabase($table, array $data, array $criteria = [])
   {
       $query = $this->currentDriver->update($table, $data, $criteria);
       $parameters = array_merge(array_values($data), array_values($criteria));
       $this->debugSection('Query', $query);
       if (!empty($parameters)) {
           $this->debugSection('Parameters', $parameters);
       }
       $this->currentDriver->executeQuery($query, $parameters);
   }

[iamdevice]

Hello
Thanks, I'll update that soon

[MrHaroldA]

We are using this helper to be able to update (and delete) records, until this gets implemented in MultiDb itself.

<?php

namespace Helper;

use Codeception\Exception\ModuleException;

class MultiDb extends \Codeception\Module
{

    /**
     * @param string $table
     * @param array $criteria
     *
     * @return mixed
     * @throws ModuleException
     */
    public function deleteFromDatabase(string $table, array $criteria)
    {
        $driver = $this->getCurrentDriver();

        // Debug information.
        $this->debugSection('Table', $driver->getDb() . '.' . $table);
        $this->debugSection('Parameters', $criteria);

        // Execute.
        $driver->deleteQueryByCriteria($table, $criteria);
    }

    /**
     * @param string $table
     * @param array $data
     * @param array $criteria
     *
     * @throws ModuleException
     * @throws \Exception
     *
     * @see https://github.com/iamdevice/codeception-multidb/issues/8
     */
    public function updateInDatabase(string $table, array $data, array $criteria = [])
    {
        $driver = $this->getCurrentDriver();

        // Build the update query.
        $query = $driver->update($table, $data, $criteria);

        // Debug information.
        $this->debugSection('Query', $query);
        $parameters = array_merge(array_values($data), array_values($criteria));
        if (!empty($parameters)) {
            $this->debugSection('Parameters', $parameters);
        }

        // Execute the query.
        $driver->executeQuery($query, $parameters);
    }

    /**
     * @see \Codeception\Module\MultiDb::getCurrentDriver
     *
     * @return \Codeception\Lib\Driver\Db
     * @throws ModuleException
     */
    private function getCurrentDriver()
    {
        /** @var \Codeception\Module\MultiDb $module */
        $module = $this->getModule('MultiDb');
        return $module->getCurrentDriver();
    }
}

Enable the MultiDb helper in your suite:

modules:
  enabled:
  - \Helper\MultiDb

[Thenodai]

+1

[eXorus]

From Codeception 2.5.0, Multi database support is enable.
So you don't need this package anymore and each new feature inside DB module will support multi database.