Skip to main content

Modules

Doc:https://codeception.com/docs

Modules

DB

-Install

composer require --dev codeception/module-db

-Config

api.suite.yml

actor: ApiTester
suite_namespace: Tests\Api
modules:
enabled:
- Db:
dsn: "mysql:host=dome-mysql;port=3306;dbname=test"
user: 'root'
password: '123456'
dump:
- 'tests/_data/dump.sql'
- 'tests/_data/dump-2.sql'

-Build

php vendor/bin/codecept build

-Case

<?php

namespace Tests\Api;

use \Tests\Support\ApiTester;

class UserCest
{
public function _before(ApiTester $I)
{
}

// tests
public function loginUserTest(ApiTester $I)
{
$I->seeInDatabase('users',['name' => '22']);
}
}

Doc:https://codeception.com/docs/modules/Db

ASSERTS

-Install

composer require --dev codeception/module-asserts

-Config

api.suite.yml

actor: ApiTester
suite_namespace: Tests\Api
modules:
enabled:
- Asserts

-Build

php vendor/bin/codecept build

-Case

<?php

namespace Tests\Api;

use Codeception\Module\Asserts;
use \Tests\Support\ApiTester;


class UserCest
{
public function _before(ApiTester $I)
{
}

// tests
public function loginUserTest(ApiTester $I,Asserts $A)
{
$userData = $I->grabColumnFromDatabase('users','name');

$A->assertIsArray($userData);
$A->assertArrayNotHasKey('case',$userData);
}
}