颤音：如何单位测试摩尔/漂移？

Question

我已经实现了用于本地存储的漂移，并希望使其可测试功能。但是我得到了堆栈和IDK如何修复单元测试。

Homedao

@DriftAccessor(tables: [RepositoriesTable])
class HomeDao extends DatabaseAccessor<AppDatabase> with _$HomeDaoMixin {
  HomeDao(AppDatabase db) : super(db);

  Future<List<RepositoriesTableData>> getRepositories() async =>
      await select(repositoriesTable).get();
}

AppDatabase

@DriftDatabase(
  tables: [RepositoriesTable],
  daos: [HomeDao],
)
class AppDatabase extends _$AppDatabase {
  AppDatabase() : super(_openConnection());

  @override
  int get schemaVersion => 1;
}

QueryExecutor _openConnection() {
  return SqfliteQueryExecutor.inDatabaseFolder(
    path: 'db.sqlite',
    logStatements: true,
  );
}

LocalDataSources

abstract class GTHomeLocalDataSource {
  const GTHomeLocalDataSource();

  Future<List<RepositoriesTableData>> getRepositories();
}

class GTHomeLocalDataSourceImpl implements GTHomeLocalDataSource {
  final AppDatabase appDatabase;

  const GTHomeLocalDataSourceImpl({required this.appDatabase});

  @override
  Future<List<RepositoriesTableData>> getRepositories() async =>
      await appDatabase.homeDao.getRepositories();
}

Unitesting

void main() => testGTHomeLocalDataSource();

class MockDatabaseHandler extends Mock implements AppDatabase {}

void testGTHomeLocalDataSource() {
  late GTHomeLocalDataSource localDataSource;
  late AppDatabase databaseHandler;

  setUp(() {
    databaseHandler = MockDatabaseHandler();
    localDataSource = GTHomeLocalDataSourceImpl(
      appDatabase: databaseHandler,
    );
  });

  group("GTHomeLocalDataSource -", () {
    test(''' \t
      GIVEN Nothing
      WHEN call getRepositories
      THEN databaseHandler select function has been called and return list of RepositoriesTableData
      ''', () async {
      // GIVEN
      when(() => databaseHandler.homeDao.getRepositories())
          .thenAnswer((_) => Future.value(repositoriesDummyTable));

      // WHEN
      final result = await localDataSource.getRepositories();

      // THEN
      verify(() => databaseHandler.homeDao.getRepositories());

      expect(result, isA<List<RepositoriesTableData>>());
      expect(result.length, repositoriesDummyTable.length);
      expect(result.first.language, repositoriesDummyTable.first.language);
    });
  });

  tearDown(() async {
    await databaseHandler.close();
  });
}

我的功能可以很好地从本地数据库获取数据并在应用程序中显示，但是在作为单元测试运行时，我堆叠了此错误。

package:gt_core/local/database/database_module.g.dart 424:22           MockDatabaseHandler.homeDao
package:gt_home/data/data_sources/gt_home_local_datasource.dart 20:25  GTHomeLocalDataSourceImpl.getRepositories
test/data/data_sources/gt_home_local_datasource_test.dart 35:44        testGTHomeLocalDataSource.<fn>.<fn>
test/data/data_sources/gt_home_local_datasource_test.dart 29:12        testGTHomeLocalDataSource.<fn>.<fn>
type 'Null' is not a subtype of type 'Future<void>'
package:drift/src/runtime/api/db_base.dart 125:16                MockDatabaseHandler.close
test/data/data_sources/gt_home_local_datasource_test.dart 47:27  testGTHomeLocalDataSource.<fn>
test/data/data_sources/gt_home_local_datasource_test.dart 46:12  testGTHomeLocalDataSource.<fn>
===== asynchronous gap ===========================
dart:async                                                       _completeOnAsyncError
test/data/data_sources/gt_home_local_datasource_test.dart        testGTHomeLocalDataSource.<fn>
test/data/data_sources/gt_home_local_datasource_test.dart 46:12  testGTHomeLocalDataSource.<fn>

type 'Future<List<RepositoriesTableData>>' is not a subtype of type 'HomeDao'

有人知道如何解决吗？

Answer 1

如果您使用模拟测试漂移数据库，那么您还需要模拟方法调用，其他方法将返回null，这是Mockito的默认行为。例如。

// return rowid
when(db.insertItem(any)).thenAnswer((_) => 1);

但是，建议按漂移文档需要真实的设备或模拟器进行测试。

也已经讨论了这个问题在这里

在内存数据库中使用

import 'package:drift/native.dart';
import 'package:test/test.dart';

import 'package:my_app/src/database.dart'; 

void main() {
  MyDatabase database;
  MyRepo repo;

  setUp(() {
    database = MyDatabase(NativeDatabase.memory());
    repo = MyRepo(appDatabase: database);
  });

  tearDown(() async {
    await database.close();
  });

  group('mytest', () {
    test('test create', () async {
      await repo.create(MyDateCompanion(title: 'some name'));

      final list = await repo.getItemList();
      expect(list, isA<MyDataObject>())
    })
  });
}