Trying to set invalid time_zone property for Postgresql

[arunahk]

Creating a connection to postgres database fails due to wrong parameter setup.
*** https://github.com/natterbox/Codeception-MultiDb/blame/master/src/Codeception/Extension/MultiDb.php

 /**
 * @see MultiDb::amConnectedToDb
 *
 * @param string $connector
 *
 * @throws ModuleException
 * @return \Codeception\Lib\Driver\Db
 */
 private function getDriver($connector)
 {
 if (!(isset($this->drivers[$connector]) && is_object($this->drivers[$connector]))) {
 if (!isset($this->config['connectors'][$connector])) {
 throw new ModuleException(
 __CLASS__,
 "The specified connector, {$connector}, does not exist in the configuration"
 );
 }
 $config = $this->config['connectors'][$connector];

 try {
 $this->drivers[$connector] = Driver::create($config['dsn'], $config['user'], $config['password']);
 $this->executeSqlAgainstDriver(
 $this->drivers[$connector]->getDbh(),
 "SET time_zone = '{$this->timezone}'" 
 );
 } catch (\PDOException $e) {
 throw new ModuleException(
 __CLASS__,
 $e->getMessage() . ' while creating PDO connection ['.get_class($e).']'
 );
 } catch (\Exception $e) {
 throw new ModuleException(
 __CLASS__,
 $e->getMessage() . ' while creating PDO connection ['.get_class($e).']'
 );
 }
 }

 return $this->drivers[$connector];
 }

[codemedic]

@arunahk sorry; I should have been more specific in the README.
This module currently only supports MySQL. I will update the docs.

It will be fabulous if you could refactor the module to support PostgreSQL as well.
If you are keen; let me know. I can help with the current implementation refactored, to expose appropriate interfaces.

[arunahk]

Yes, we thought to use this extension for testing our projects. We have mixture of different DB connections in the project.

[aschwin]

I experience similar problems with SQLite. Too bad this is not supported at all.