public static function emptyDB(array $credentials)
{
$dsn = 'mysql:host=' . $credentials['host'] . ';dbname=' . $credentials['database'];
$options = [\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'];
$pdo = new \PDO($dsn, $credentials['user'], $credentials['password'], $options);
$pdo->prepare('
DELETE FROM `conversation`;
DELETE FROM `telegram_update`;
DELETE FROM `chosen_inline_result`;
DELETE FROM `inline_query`;
DELETE FROM `message`;
DELETE FROM `user_chat`;
DELETE FROM `chat`;
DELETE FROM `user`;
')->execute();
}
/** * setUp */ protected function setUp() { $credentials = ['host' => PHPUNIT_DB_HOST, 'database' => PHPUNIT_DB_NAME, 'user' => PHPUNIT_DB_USER, 'password' => PHPUNIT_DB_PASS]; $this->telegram = new Telegram('apikey', 'testbot'); $this->telegram->enableMySql($credentials); //Make sure we start with an empty DB for each test. TestHelpers::emptyDB($credentials); }