sqlite_wallet_metadata_test.dart

import 'package:bb_mobile/core/storage/sqlite_database.dart';
import 'package:bb_mobile/core/storage/tables/wallet_metadata_table.dart';
import 'package:bb_mobile/core/wallet/data/models/wallet_metadata_model.dart';
import 'package:bb_mobile/core/wallet/domain/entities/wallet.dart';
import 'package:bb_mobile/core/wallet/wallet_metadata_service.dart';
import 'package:bb_mobile/locator.dart';
import 'support/integration_test_profile.dart';
import 'package:flutter_test/flutter_test.dart';

Future<void> main({bool isInitialized = false}) async {
  TestWidgetsFlutterBinding.ensureInitialized();
  await initializeIntegrationTestApp(isInitialized: isInitialized);

  final sqlite = locator<SqliteDatabase>();

  group('WalletMetadata Sqlite Integration Tests', () {
    test('can store and fetch a wallet metadata', () async {
      const fingerprint = 'master';
      const scriptType = ScriptType.bip84;

      final metadata = WalletMetadataModel(
        masterFingerprint: fingerprint,
        id: WalletMetadataService.encodeOrigin(
          fingerprint: fingerprint,
          network: Network.bitcoinMainnet,
          scriptType: scriptType,
        ),
        xpubFingerprint: 'abc12345',
        xpub: 'xpub6CUGRUonZSQ4TWtTMmzXdrXDtypWKiKp5i1Lsfk...',
        externalPublicDescriptor: 'wpkh([abcd1234/84h/0h/0h]xpub.../0/*)',
        internalPublicDescriptor: 'wpkh([abcd1234/84h/0h/0h]xpub.../1/*)',
        signer: Signer.local,
        latestEncryptedBackup: 1680000000,
        latestPhysicalBackup: 1681000000,
        isEncryptedVaultTested: true,
        isPhysicalBackupTested: true,
        isDefault: true,
        label: 'My Main Wallet',
        syncedAt: DateTime.now(),
      );

      // Clear any leftover row with the same id from a crashed prior run so the
      // insert below never trips the unique constraint.
      await sqlite.managers.walletMetadatas
          .filter((e) => e.id(metadata.id))
          .delete();

      // Store a metadata
      await sqlite.into(sqlite.walletMetadatas).insert(metadata.toSqlite());

      // Fetch one
      final fetchedMetadata = await sqlite.managers.walletMetadatas
          .filter((e) => e.id(metadata.id))
          .getSingleOrNull();
      expect(fetchedMetadata, isNotNull);
      expect(fetchedMetadata!.id, metadata.id);

      // Delete the one we inserted
      await sqlite.managers.walletMetadatas
          .filter((f) => f.id(metadata.id))
          .delete();

      // Ensure the row we inserted is gone. Scoped to our own id so the test is
      // isolated from any other wallet metadata already present in the database
      // (asserting the whole table is empty made this test order-dependent).
      final afterDelete = await sqlite.managers.walletMetadatas
          .filter((e) => e.id(metadata.id))
          .getSingleOrNull();
      expect(afterDelete, isNull);
    });
  });
}