getPaymentChannelsForWallet method

@override Future<List> getPaymentChannelsForWallet(String walletId)

Get all payment channels for a wallet

Implementation

@override
Future<List<dynamic>> getPaymentChannelsForWallet(String walletId) async {
  _ensureInitialized();

  final result = await _pool!.execute(
    Sql.named('''
      SELECT channel_id, wallet_id, role, client_peer_id, server_peer_id,
             funding_tx_id, funding_tx_hex, funding_output_index, funding_amount_sats,
             client_pub_key_hex, server_pub_key_hex, client_address_b58, server_address_b58,
             lock_time_unix, state, client_balance_sats, server_balance_sats,
             latest_sequence_number, latest_payment_tx_hex, refund_tx_hex,
             refund_client_sig_hex, refund_server_sig_hex, funding_ancestor_txids,
             context, created_at, closed_at, has_funding_merkle_proof
      FROM payment_channels
      WHERE wallet_id = @walletId
      ORDER BY created_at DESC
    '''),
    parameters: {'walletId': walletId},
  );

  return result.map(_rowToPaymentChannel).toList();
}