Longman\TelegramBot\Tests\Unit\TestHelpers::emptyDB PHP Méthode

emptyDB() public static méthode

Empty all tables for the passed database
public static emptyDB ( array $credentials )
$credentials array
    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();
    }

Usage Example

 /**
  * 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);
 }