Ignacio Arganda-Carreras

72 papers B 1C 2Journal 45Unranked 24
YearRankTypeTitle / Venue / Authors
2025 conf
ICVES
Aitor Iglesias, Nerea Aranjuelo, Patricia Javierre, Ainhoa Menendez, Ignacio Arganda-Carreras, Marcos Nieto
2025 J jnl
CoRR
Aitor Iglesias, Nerea Aranjuelo, Patricia Javierre, Ainhoa Menendez, Ignacio Arganda-Carreras, Marcos Nieto
2025 J jnl
CoRR
Xabier Lekunberri, Ahmad Kamal, Izaro Goienetxea, Jon Ruiz, Iñaki Quincoces, Jaime Valls Miró, Ignacio Arganda-Carreras, Jose A. Fernandes-Salvador
2025 J jnl
Digit. Appl. Archaeol. Cult. Heritage
Verónica Fernández-Navarro, Aitor González-Marfil, Ignacio Arganda-Carreras, Diego Garate
2025 conf
ISBI
Daniel Franco-Barranco, Aitor González-Marfil, Albert Cardona, Arrate Muñoz-Barrutia, Ignacio Arganda-Carreras
2024 J jnl
Nat. Mac. Intell.
Davide Carnevali, Limei Zhong, Esther González-Almela, Carlotta Viana, Mikhail Rotkevich, Aiping Wang, Daniel Franco-Barranco, Aitor González-Marfil, Maria Victoria Neguembor, Alvaro Castells-Garcia, Ignacio Arganda-Carreras, Maria Pia Cosma
2024 conf
VISIGRAPP (4): VISAPP
Aitor Iglesias, Mikel García, Nerea Aranjuelo, Ignacio Arganda-Carreras, Marcos Nieto
2024 J jnl
Int. J. Appl. Earth Obs. Geoinformation
Xabier Lekunberri, J. David Ballester-Berman, Ignacio Arganda-Carreras, Jose A. Fernandes-Salvador
2024 J jnl
Proc. ACM Comput. Graph. Interact. Tech.
Nerea Aranjuelo, Siyu Huang, Ignacio Arganda-Carreras, Luis Unzueta, Oihana Otaegui, Hanspeter Pfister, Donglai Wei
2024 J jnl
CoRR
Nerea Aranjuelo, Siyu Huang, Ignacio Arganda-Carreras, Luis Unzueta, Oihana Otaegui, Hanspeter Pfister, Donglai Wei
2024 conf
IS
Francisco Javier Iriarte, Miguel E. Ortiz, Luis Unzueta, Javier Martínez, Javier Zaldivar, Ignacio Arganda-Carreras
2024 conf
SADASC (1)
Mohamad Abou Ali, Fadi Dornaika, Ignacio Arganda-Carreras, Hussein Ali, Malak Karaouni
2024 conf
ISBI
Daniel Franco-Barranco, Aitor González-Marfil, Ignacio Arganda-Carreras
2024 J jnl
Mach. Learn. Knowl. Extr.
Mohamad Abou Ali, Fadi Dornaika, Ignacio Arganda-Carreras
2024 J jnl
Eng. Appl. Artif. Intell.
Adrián Núñez-Marcos, Ignacio Arganda-Carreras
2023 J jnl
IEEE J. Biomed. Health Informatics
Leander Lauenburg, Zudi Lin, Ruihan Zhang, Márcia dos Santos, Siyu Huang, Ignacio Arganda-Carreras, Edward S. Boyden, Hanspeter Pfister, Donglai Wei
2023 conf
ISBI
Daniel Franco-Barranco, Jesús A. Andrés-San Román, Pedro Gómez-Gálvez, Luis M. Escudero, Arrate Muñoz-Barrutia, Ignacio Arganda-Carreras
2023 J jnl
Algorithms
Mohamad Abou Ali, Fadi Dornaika, Ignacio Arganda-Carreras
2023 J jnl
IEEE Trans. Medical Imaging
Daniel Franco-Barranco, Zudi Lin, Won-Dong Jang, Xueying Wang, Qijia Shen, Wenjie Yin, Yutian Fan, Mingxing Li, Chang Chen, Zhiwei Xiong, Rui Xin, Hao Liu, Huai Chen, Zhili Li, Jie Zhao, Xuejin Chen, Constantin Pape, Ryan Conrad, Luke Nightingale, Joost de Folter, Martin L. Jones, Yanling Liu, Dorsa Ziaei, Stephan Huschauer, Ignacio Arganda-Carreras, Hanspeter Pfister, Donglai Wei
2023 conf
ISBI
Lenka Backová, Guillermo Bengoetxea, Svana Rogalla, Daniel Franco-Barranco, Jérôme Solon, Ignacio Arganda-Carreras
2023 J jnl
IEEE Access
Unai Elordi, Nerea Aranjuelo, Luis Unzueta, Jose Luis Apellaniz, Ignacio Arganda-Carreras
2023 J jnl
Algorithms
Mohamad Abou Ali, Fadi Dornaika, Ignacio Arganda-Carreras
2022 J jnl
Sensors
Aitor Almeida, Unai Bermejo, Aritz Bilbao, Gorka Azkune, Unai Aguilera, Mikel Emaldi, Fadi Dornaika, Ignacio Arganda-Carreras
2022 J jnl
Comput. Methods Programs Biomed.
Daniel Franco-Barranco, Julio Pastor-Tronch, Aitor González-Marfil, Arrate Muñoz-Barrutia, Ignacio Arganda-Carreras
2022 J jnl
CoRR
Daniel Franco-Barranco, Julio Pastor-Tronch, Aitor González-Marfil, Arrate Muñoz-Barrutia, Ignacio Arganda-Carreras
2022 J jnl
Neurocomputing
Adrián Núñez-Marcos, Gorka Azkune, Ignacio Arganda-Carreras
2022 J jnl
Ecol. Informatics
Xabier Lekunberri, Jon Ruiz, Iñaki Quincoces, Fadi Dornaika, Ignacio Arganda-Carreras, Jose A. Fernandes
2022 J jnl
CoRR
Leander Lauenburg, Zudi Lin, Ruihan Zhang, Márcia dos Santos, Siyu Huang, Ignacio Arganda-Carreras, Edward S. Boyden, Hanspeter Pfister, Donglai Wei
2022 J jnl
Neuroinformatics
Daniel Franco-Barranco, Arrate Muñoz-Barrutia, Ignacio Arganda-Carreras
2021 C conf
IJCCI
Nerea Aranjuelo, Guus Engels, David Montero, Marcos Nieto, Ignacio Arganda-Carreras, Luis Unzueta, Oihana Otaegui
2021 conf
MICCAI (1)
Donglai Wei, Kisuk Lee, Hanyu Li, Ran Lu, J. Alexander Bae, Zequan Liu, Lifu Zhang, Márcia dos Santos, Zudi Lin, Thomas D. Uram, Xueying Wang, Ignacio Arganda-Carreras, Brian Matejek, Narayanan Kasthuri, Jeff Lichtman, Hanspeter Pfister
2021 J jnl
CoRR
Donglai Wei, Kisuk Lee, Hanyu Li, Ran Lu, J. Alexander Bae, Zequan Liu, Lifu Zhang, Márcia dos Santos, Zudi Lin, Thomas D. Uram, Xueying Wang, Ignacio Arganda-Carreras, Brian Matejek, Narayanan Kasthuri, Jeff Lichtman, Hanspeter Pfister
2021 J jnl
IEEE Softw.
Unai Elordi, Luis Unzueta, Jon Goenetxea, Sergio Sanchez-Carballido, Ignacio Arganda-Carreras, Oihana Otaegui
2021 J jnl
J. Medical Syst.
Karim Hammoudi, Halim Benhabiles, Mahmoud Melkemi, Fadi Dornaika, Ignacio Arganda-Carreras, Dominique Collard, Arnaud Scherpereel
2021 J jnl
Inf.
Unai Elordi, Chiara Lunerti, Luis Unzueta, Jon Goenetxea, Nerea Aranjuelo, Álvaro Bertelsen, Ignacio Arganda-Carreras
2021 J jnl
Expert Syst. Appl.
Abdelmalik Moujahid, Fadi Dornaika, Ignacio Arganda-Carreras, Jorge Reta
2021 J jnl
CoRR
Aitzol Elu, Gorka Azkune, Oier Lopez de Lacalle, Ignacio Arganda-Carreras, Aitor Soroa, Eneko Agirre
2021 J jnl
Pattern Recognit.
Aitzol Elu, Gorka Azkune, Oier Lopez de Lacalle, Ignacio Arganda-Carreras, Aitor Soroa, Eneko Agirre
2021 conf
MICCAI (1)
Zudi Lin, Donglai Wei, Mariela D. Petkova, Yuelong Wu, Zergham Ahmed, Krishna Swaroop K, Silin Zou, Nils Wendt, Jonathan Boulanger-Weill, Xueying Wang, Nagaraju Dhanyasi, Ignacio Arganda-Carreras, Florian Engert, Jeff Lichtman, Hanspeter Pfister
2021 J jnl
CoRR
Zudi Lin, Donglai Wei, Mariela D. Petkova, Yuelong Wu, Zergham Ahmed, Krishna Swaroop K, Silin Zou, Nils Wendt, Jonathan Boulanger-Weill, Xueying Wang, Nagaraju Dhanyasi, Ignacio Arganda-Carreras, Florian Engert, Jeff Lichtman, Hanspeter Pfister
2021 conf
VISIGRAPP (4: VISAPP)
Unai Elordi, Luis Unzueta, Jon Goenetxea, Estíbaliz Loyo, Ignacio Arganda-Carreras, Oihana Otaegui
2021 B conf
KES
Unai Elordi, Álvaro Bertelsen, Luis Unzueta, Nerea Aranjuelo, Jon Goenetxea, Ignacio Arganda-Carreras
2021 J jnl
CoRR
Daniel Franco-Barranco, Arrate Muñoz-Barrutia, Ignacio Arganda-Carreras
2020 J jnl
CoRR
Guus Engels, Nerea Aranjuelo, Ignacio Arganda-Carreras, Marcos Nieto, Oihana Otaegui
2020 C conf
VEHITS
Guus Engels, Nerea Aranjuelo, Ignacio Arganda-Carreras, Marcos Nieto, Oihana Otaegui
2020 J jnl
IEEE Trans. Medical Imaging
Jirí Borovec, Jan Kybic, Ignacio Arganda-Carreras, Dmitry V. Sorokin, Gloria Bueno, Alexander V. Khvostikov, Spyridon Bakas, Eric I-Chao Chang, Stefan Heldmann, Kimmo Kartasalo, Leena Latonen, Johannes Lotz, Michelle Noga, Sarthak Pati, Kumaradevan Punithakumar, Pekka Ruusuvuori, Andrzej Skalski, Nazanin Tahmasebi, Masi Valkonen, Ludovic Venet, Yizhe Wang, Nick Weiss, Marek Wodzinski, Yu Xiang, Yan Xu, Yan Yan, Paul A. Yushkevich, Shengyu Zhao, Arrate Muñoz-Barrutia
2020 J jnl
Math. Morphol. Theory Appl.
Sylvain Lempereur, Arnim Jenett, Elodie Machado, Ignacio Arganda-Carreras, Matthieu Simion, Pierre Affaticati, Jean-Stéphane Joly, Hugues Talbot
2020 J jnl
CoRR
Karim Hammoudi, Halim Benhabiles, Mahmoud Melkemi, Fadi Dornaika, Ignacio Arganda-Carreras, Dominique Collard, Arnaud Scherpereel
2020 J jnl
Multim. Tools Appl.
Fadi Dornaika, Anne Elorza, Kunwei Wang, Ignacio Arganda-Carreras
2020 conf
TIA@MICCAI
Maialen Stephens, Raúl San José Estépar, Jesús Ruiz-Cabello, Ignacio Arganda-Carreras, Iván Macía, Karen López-Linares
2020 conf
MICCAI (5)
Donglai Wei, Zudi Lin, Daniel Franco-Barranco, Nils Wendt, Xingyu Liu, Wenjie Yin, Xin Huang, Aarush Gupta, Won-Dong Jang, Xueying Wang, Ignacio Arganda-Carreras, Jeff W. Lichtman, Hanspeter Pfister
2020 conf
SOCO
Nerea Aranjuelo, Guus Engels, Luis Unzueta, Ignacio Arganda-Carreras, Marcos Nieto, Oihana Otaegui
2020 J jnl
Expert Syst. Appl.
Fadi Dornaika, Salah Eddine Bekhouche, Ignacio Arganda-Carreras
2020 J jnl
Expert Syst. Appl.
Fadi Dornaika, Kunwei Wang, Ignacio Arganda-Carreras, Anne Elorza, Abdelmalik Moujahid
2020 J jnl
Neural Comput. Appl.
Fadi Dornaika, Ignacio Arganda-Carreras, Oscar Serradilla
2020 conf
ICIAR (1)
Adrián Núñez-Marcos, Gorka Azkune, Eneko Agirre, Diego López-de-Ipiña, Ignacio Arganda-Carreras
2019 J jnl
Mach. Vis. Appl.
Fadi Dornaika, Ignacio Arganda-Carreras, C. Belver
2019 conf
IPTA
Halim Benhabiles, Karim Hammoudi, Ziheng Yang, Féryal Windal, Mahmoud Melkemi, Fadi Dornaika, Ignacio Arganda-Carreras
2019 J jnl
J. Electronic Imaging
Fadi Dornaika, Anne Elorza, Kunwei Wang, Ignacio Arganda-Carreras
2018 J jnl
Frontiers Neuroinformatics
Ignacio Arganda-Carreras, Tudor Manoliu, Nicolas Mazuras, Florian Schulze, Juan Eugenio Iglesias, Katja Bühler, Arnim Jenett, François Rouyer, Philippe Andrey
2018 conf
IPTA
Fadi Dornaika, Jorge Reta, Ignacio Arganda-Carreras, Abdelmalik Moujahid
2018 conf
AMDO
Unai Elordi, Luis Unzueta, Ignacio Arganda-Carreras, Oihana Otaegui
2018 conf
FFER/DLPR@ICPR
Fadi Dornaika, Fawzi Khattar, Jorge Reta, Ignacio Arganda-Carreras, M. Hernandez, Yassine Ruichek
2018 conf
AMDO
Nerea Aranjuelo, Luis Unzueta, Ignacio Arganda-Carreras, Oihana Otaegui
2017 conf
Computational Imaging
C. Belver, Ignacio Arganda-Carreras, Fadi Dornaika
2017 conf
ISBI
Ignacio Arganda-Carreras, D. G. Gordon, S. Arganda, M. Beaudoin, J. F. A. Traniello
2017 J jnl
Bioinform.
Ignacio Arganda-Carreras, Verena Kaynig, Curtis Rueden, Kevin W. Eliceiri, Johannes E. Schindelin, Albert Cardona, H. Sebastian Seung
2017 J jnl
Wirel. Commun. Mob. Comput.
Adrián Núñez-Marcos, Gorka Azkune, Ignacio Arganda-Carreras
2016 conf
VAAM/FFER@ICPR
C. Belver, Ignacio Arganda-Carreras, Fadi Dornaika
2016 J jnl
Bioinform.
David Legland, Ignacio Arganda-Carreras, Philippe Andrey
2014 J jnl
BMC Bioinform.
Jaza Gul-Mohammed, Ignacio Arganda-Carreras, Philippe Andrey, Vincent Galy, Thomas Boudier
2006 conf
CVAMIA
Ignacio Arganda-Carreras, Carlos Oscar Sánchez Sorzano, Roberto Marabini, José María Carazo, Carlos Ortiz-de-Solorzano, Jan Kybic
tests/unit/test_apk_cfg_features.py
← Index tests/unit/test_apk_cfg_features.py python
"""
Unit tests for APK CFG feature parity with the Binary Ninja pipeline.

Tests advanced CFG features computed from smali (topology hash, MD-index,
WL-MinHash, prime product, packed adjacency, block features export) and
the slimmed similarity table.

All tests use mocked smali input — no JADX/apktool/Java required.
"""
import pytest

from redb.extractors.decompiler.apk.smali_cfg import (
    SmaliCFGMetrics,
    compute_cfg_metrics,
)
from redb.extractors.decompiler.apk.method_extractor import (
    SMALI_OP_PRIMES,
    compute_prime_product_smali,
    count_call_instructions,
)

pytestmark = [pytest.mark.unit, pytest.mark.apk, pytest.mark.decompile]


# ===================================================================
# Sample smali bodies for testing
# ===================================================================

# Simple linear method: 3 instructions, 1 block
SMALI_LINEAR = """\
    const/4 v0, 0x0
    invoke-virtual {p0, v0}, Lcom/Foo;->bar(I)V
    return-void
"""

# Diamond CFG: if-else with two paths merging
SMALI_DIAMOND = """\
    const/4 v0, 0x1
    if-eqz v0, :cond_0
    invoke-virtual {p0}, Lcom/Foo;->pathA()V
    goto :goto_0
    :cond_0
    invoke-virtual {p0}, Lcom/Foo;->pathB()V
    :goto_0
    return-void
"""

# Loop: a back edge from goto to a label before it
SMALI_LOOP = """\
    const/4 v0, 0x0
    :loop_start
    add-int/lit8 v0, v0, 0x1
    if-lt v0, v1, :loop_start
    return-void
"""

# Multi-block with several invoke calls
SMALI_MULTI_CALL = """\
    invoke-virtual {p0}, Lcom/Foo;->a()V
    invoke-static {v0}, Lcom/Bar;->b(I)V
    invoke-direct {p0, v1}, Lcom/Baz;-><init>(I)V
    const/4 v0, 0x0
    return-void
"""


# ===================================================================
# TestSmaliCFGMetricsAdvanced — new fields in SmaliCFGMetrics
# ===================================================================

class TestSmaliCFGMetricsAdvanced:
    """Test that advanced CFG fields are populated by compute_cfg_metrics."""

    def test_topology_hash_is_bytes(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        assert isinstance(m.cfg_topology_hash, bytes)
        assert len(m.cfg_topology_hash) == 16

    def test_topology_hash_nonzero_for_multiblock(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        assert m.cfg_topology_hash != b'\x00' * 16

    def test_topology_hash_zero_for_empty(self):
        m = compute_cfg_metrics("")
        assert m.cfg_topology_hash == b'\x00' * 16

    def test_identical_cfg_same_topology_hash(self):
        """Two smali methods with the same CFG structure produce the same hash."""
        smali_a = """\
    const/4 v0, 0x1
    if-eqz v0, :cond_0
    const/4 v1, 0x2
    goto :goto_0
    :cond_0
    const/4 v1, 0x3
    :goto_0
    return-void
"""
        smali_b = """\
    const/4 v5, 0x9
    if-nez v5, :cond_0
    add-int v6, v5, v5
    goto :goto_0
    :cond_0
    sub-int v6, v5, v5
    :goto_0
    return-void
"""
        m_a = compute_cfg_metrics(smali_a)
        m_b = compute_cfg_metrics(smali_b)
        assert m_a.cfg_topology_hash == m_b.cfg_topology_hash

    def test_different_cfg_different_topology_hash(self):
        m_linear = compute_cfg_metrics(SMALI_LINEAR)
        m_diamond = compute_cfg_metrics(SMALI_DIAMOND)
        assert m_linear.cfg_topology_hash != m_diamond.cfg_topology_hash

    def test_md_index_topdown_nonzero(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        assert m.md_index_topdown != 0

    def test_md_index_bottomup_nonzero(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        assert m.md_index_bottomup != 0

    def test_md_index_zero_for_empty(self):
        m = compute_cfg_metrics("")
        assert m.md_index_topdown == 0
        assert m.md_index_bottomup == 0

    def test_wl_minhash_length(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        assert len(m.wl_minhash) == 128

    def test_wl_minhash_sentinel_for_empty(self):
        m = compute_cfg_metrics("")
        assert m.wl_minhash == [255] * 128

    def test_wl_minhash_values_are_uint8(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        for val in m.wl_minhash:
            assert 0 <= val <= 255

    def test_cfg_adjacency_nonempty_for_multiblock(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        assert len(m.cfg_adjacency) > 0

    def test_cfg_adjacency_empty_for_empty(self):
        m = compute_cfg_metrics("")
        assert m.cfg_adjacency == []

    def test_cfg_adjacency_packed_format(self):
        """Each entry should be (src << 16) | tgt."""
        m = compute_cfg_metrics(SMALI_DIAMOND)
        for edge in m.cfg_adjacency:
            assert isinstance(edge, int)
            src = edge >> 16
            tgt = edge & 0xFFFF
            assert src < m.block_count
            assert tgt < m.block_count

    def test_block_features_exported(self):
        m = compute_cfg_metrics(SMALI_DIAMOND)
        assert len(m.block_features) == m.block_count
        for bf in m.block_features:
            assert len(bf) == 8  # 7 categories + successor_count

    def test_cfg_feature_tlsh_none_for_small(self):
        """Small methods produce None (< 50 bytes of feature data)."""
        m = compute_cfg_metrics(SMALI_LINEAR)
        # Single-block linear method — too small for TLSH
        assert m.cfg_feature_tlsh is None

    def test_loop_count_with_back_edge(self):
        m = compute_cfg_metrics(SMALI_LOOP)
        assert m.loop_count >= 1


# ===================================================================
# TestPrimeProductSmali
# ===================================================================

class TestPrimeProductSmali:

    def test_empty_returns_zero(self):
        assert compute_prime_product_smali("") == 0

    def test_none_returns_zero(self):
        assert compute_prime_product_smali(None) == 0

    def test_known_computation(self):
        """Single invoke instruction → CALL category → prime 17."""
        smali = "    invoke-virtual {p0}, Lcom/Foo;->bar()V"
        assert compute_prime_product_smali(smali) == 17

    def test_two_instructions(self):
        """const (CONST→2) * invoke (CALL→17) = 34."""
        smali = """\
    const/4 v0, 0x0
    invoke-virtual {p0, v0}, Lcom/Foo;->bar(I)V
"""
        assert compute_prime_product_smali(smali) == 2 * 17

    def test_skips_directives_and_labels(self):
        """Directives, labels, and comments should be skipped."""
        smali = """\
.registers 2
.line 10
    :label
    # comment
    const/4 v0, 0x0
"""
        # Only const/4 → CONST → prime 2
        assert compute_prime_product_smali(smali) == 2

    def test_position_independent(self):
        """Reordering instructions produces the same product (multiplication is commutative)."""
        smali_a = """\
    add-int v0, v1, v2
    invoke-virtual {p0}, Lcom/Foo;->bar()V
"""
        smali_b = """\
    invoke-virtual {p0}, Lcom/Foo;->bar()V
    add-int v0, v1, v2
"""
        assert compute_prime_product_smali(smali_a) == compute_prime_product_smali(smali_b)

    def test_all_categories_have_primes(self):
        """Every category in SMALI_OP_PRIMES is a positive integer."""
        for cat, prime in SMALI_OP_PRIMES.items():
            assert isinstance(prime, int)
            assert prime >= 1

    def test_mod_2_64(self):
        """Result should be mod 2^64 (doesn't overflow)."""
        # A very long method — product stays within uint64
        smali = "\n".join(["    mul-int v0, v1, v2"] * 1000)
        result = compute_prime_product_smali(smali)
        assert 0 <= result < 2**64


# ===================================================================
# TestCallCount
# ===================================================================

class TestCallCount:

    def test_empty(self):
        assert count_call_instructions("") == 0

    def test_none(self):
        assert count_call_instructions(None) == 0

    def test_single_invoke(self):
        smali = "    invoke-virtual {p0}, Lcom/Foo;->bar()V"
        assert count_call_instructions(smali) == 1

    def test_multiple_invoke_types(self):
        assert count_call_instructions(SMALI_MULTI_CALL) == 3

    def test_non_invoke_not_counted(self):
        smali = """\
    const/4 v0, 0x0
    add-int v1, v0, v0
    return-void
"""
        assert count_call_instructions(smali) == 0


# ===================================================================
# TestSimilarityTableSlimmed
# ===================================================================

class TestSimilarityTableSlimmed:
    """Verify the similarity table no longer contains moved fields."""

    def test_export_similarity_no_block_count(self):
        """block_count should not be in similarity export columns."""
        from redb.extractors.decompiler.DecompileAPK import DecompileAPK
        from unittest.mock import MagicMock

        extractor = DecompileAPK.__new__(DecompileAPK)
        extractor.log = MagicMock()
        extractor.sha256 = "a" * 64
        extractor.sha1 = "b" * 40
        extractor.md5 = "c" * 32
        extractor.analysis_results = {
            "sha256": "a" * 64,
            "sha1": "b" * 40,
            "md5": "c" * 32,
            "similarity_metrics": [{
                "smali_method_hash": "d" * 64,
                "cyclomatic_complexity": 3,
                "ssdeep_smali": None,
                "tlsh_smali": None,
                "minhash": [1, 2, 3],
            }],
        }

        export = extractor.prepare_export_data("ClickHouseExporter")
        sim_cols = export["method_similarity_metrics"]["column_names"]
        assert "block_count" not in sim_cols
        assert "edge_count" not in sim_cols
        assert "loop_count" not in sim_cols
        assert "max_depth" not in sim_cols
        assert "max_fan_out" not in sim_cols
        # These should still be there
        assert "smali_method_hash" in sim_cols
        assert "ssdeep_smali" in sim_cols
        assert "minhash" in sim_cols
        # cyclomatic_complexity moved to cfg table
        assert "cyclomatic_complexity" not in sim_cols


# ===================================================================
# TestCFGTableExport
# ===================================================================

class TestCFGTableExport:
    """Verify the new CFG table is exported correctly."""

    def test_export_cfg_table_present(self):
        from redb.extractors.decompiler.DecompileAPK import DecompileAPK
        from unittest.mock import MagicMock

        extractor = DecompileAPK.__new__(DecompileAPK)
        extractor.log = MagicMock()
        extractor.analysis_results = {
            "sha256": "a" * 64,
            "sha1": "b" * 40,
            "md5": "c" * 32,
            "cfg": [{
                "smali_method_hash": "d" * 64,
                "cfg_topology_hash": b'\x01' * 16,
                "block_count": 4,
                "edge_count": 5,
                "instructions_count": 20,
                "call_count": 3,
                "cyclomatic_complexity": 3,
                "loop_count": 1,
                "max_depth": 2,
                "max_fan_out": 2,
                "md_index_topdown": 12345,
                "md_index_bottomup": 67890,
                "prime_product_smali": 999,
                "cfg_feature_tlsh": None,
                "wl_minhash": [0] * 128,
                "bb_features": [[10, 1, 0, 2, 1, 0, 0, 2]] * 4,
                "cfg_adjacency": [0x00010000, 0x00010002],
            }],
        }

        export = extractor.prepare_export_data("ClickHouseExporter")
        assert "cfg_methods" in export
        cfg_export = export["cfg_methods"]
        assert cfg_export["table"] == "code_apk_cfg_methods"
        assert len(cfg_export["data"]) == 1
        assert "cfg_topology_hash" in cfg_export["column_names"]
        assert "prime_product_smali" in cfg_export["column_names"]
        assert "wl_minhash" in cfg_export["column_names"]
        assert "bb_features" in cfg_export["column_names"]
        assert "cfg_adjacency" in cfg_export["column_names"]
        # Verify column count matches data width
        assert len(cfg_export["column_names"]) == len(cfg_export["data"][0])
        assert len(cfg_export["column_type_names"]) == len(cfg_export["data"][0])