php - 单元测试 DB:: 在 Laravel 中使用 PhpUnit 调用
问题描述
我是 TDD 的新手。我正在编写一个小包,它用数据库中的值插入一个字符串。到目前为止,我设法编写了大部分测试,但现在我遇到了困难,因为我需要测试对数据库的调用。我想测试一个类,它在给定表、列和 id 的情况下检索数据库中的特定行。然后它应该返回该实例列值。
class DatabaseResolver
{
private $referredField;
private $dependencies;
public function __construct(ReferredField $referredField, array $dependencies)
{
$this->referredField = $referredField;
$this->dependencies = $dependencies;
}
public function resolve() : string
{
if(!isset($this->dependencies['id'])) {
throw new MissingDependencyException('id');
}
$instance = $this->getTargetedInstance();
if ($instance) {
return $instance->{$this->referredField->column};
}
return '';
}
public function getTargetedInstance()
{
return DB::table($this->referredField->table)
->select($this->referredField->column)
->where('id', $this->dependencies['id'])
->first();
}
}
我已经设法测试当依赖数组中没有 id 时它会抛出我的异常,并且当找不到令牌时它会返回原始句子:
/** @test */
public function it_will_throw_if_no_id_is_present_in_dependency()
{
$this->expectException(MissingDependencyException::class);
$rf = ReferredField::newFactory()->testAsTable()->create();
$rf->getReferredValue([]);
}
/** @test */
public function it_returns_blanked_tokens_when_referred_field_is_not_found()
{
$stringToInterpolate = 'This is a {{adj}} day!';
$interpolatedString = $this->interpoler->interpolate($stringToInterpolate, ['adj' => ['id' => -1]]);
$this->assertEquals('This is a day!', $interpolatedString);
}
编辑:这是 Interpoler 类的代码:
<?php
namespace Armcanada\LaravelReferredField\Concerns;
use Armcanada\LaravelReferredField\Exceptions\MissingDependencyException;
class Interpoler
{
private $tokenizer;
private $mapper;
public function __construct(Tokenizer $tokenizer = null, TokenReferredFieldMapper $mapper = null)
{
$this->tokenizer = $tokenizer ?: new Tokenizer;
$this->mapper = $mapper ?: new TokenReferredFieldMapper;
}
public function interpolate(string $text, array $dependencies = []) : string
{
$map = $this->getReferredFieldsFromText($text);
$replacedMap = $map->mapWithKeys(function($referredField, $token) use($dependencies) {
if (!isset($dependencies[$token])) {
throw new MissingDependencyException($token);
}
$key = str_replace(' ', $token, config('laravel-referred-field.interpolation_pattern'));
return [$key => $referredField?->getReferredValue($dependencies[$token]) ?? null];
});
$replacedMap->map(function($newValue, $token) use(&$text) {
$text = str_replace($token, $newValue, $text);
});
return $text;
}
public function getReferredFieldsFromText($text)
{
$tokens = $this->tokenizer->extract($text);
return $this->mapper->mapTokensToReferredFields($tokens);
}
}
还有我的 ReferredField 模型:
<?php
namespace Armcanada\LaravelReferredField\Models;
use Armcanada\LaravelReferredField\Database\Factories\ReferredFieldFactory;
use Armcanada\LaravelReferredField\Resolvers\DatabaseResolver;
use Armcanada\LaravelReferredField\Traits\Referrable;
use Illuminate\Database\Eloquent\Model;
class ReferredField extends Model
{
use Referrable;
protected $guarded = [];
protected $table = 'referred_fields';
protected static function newFactory()
{
return ReferredFieldFactory::new();
}
public function getReferredValue(array $dependencies) : string
{
$resolver = $this->getResolver($dependencies);
return $resolver->resolve();
}
private function getResolver($dependencies)
{
if ($this->table !== null) {
return new DatabaseResolver($this, $dependencies);
}
//return new HandlerResolver($this, $dependencies);
}
}
如何测试这条路径?
$instance = $this->getTargetedInstance();
if ($instance) {
return $instance->{$this->referredField->field};
}
解决方案
我不完全确定我理解您的代码,但如果您想测试$instance
不为空的路径,您可以部分模拟DatabaseResolver
'getTargetedInstance
方法。
public function test_insert_test_method_name_here()
{
$rf = ReferredField::factory()->create();
$this->partialMock(DatabaseResolver::class)
->shouldReceive('getTargetedInstance')
->andReturn((object) [$rf->column => 'nice']);
$stringToInterpolate = 'This is a {{ adj }} day!';
$interpolatedString = $this->interpoler->interpolate($stringToInterpolate, ['adj' => ['id' => -1]]);
$this->assertEquals('This is a nice day!', $interpolatedString);
}
推荐阅读
- r - ggplot2呈现地图的问题
- apache-spark - 如何确保 spark 结构化流处理 kafka 中的所有数据
- javascript - 具有存储功能的克隆对象
- android - 将 id 移动到样式文件时如何使用数据绑定?
- python - 如何使用 Python SQL“UPDATE”语句更新需要从下拉菜单中选择的 MS Access MySQL 表字段?
- security - 访问令牌有多安全?
- sql-server - 如果记录存在,则在插入存储过程中调用更新存储过程
- python - 用先前计算的值替换操作数据集中的值
- dm-script - 如何在程序流程继续之前强制更新 UI?
- java - 关联实体管理器已关闭!休眠环境