Ian Mackie

100 papers A* 3A 2B 8C 9Misc 2Journal 26Unranked 36
YearRankTypeTitle / Venue / Authors
2024 C conf
PPDP
Maribel Fernández, Ian Mackie
2024 ed.
DCM
Sandra Alves, Ian Mackie
2020 C conf
ICFEM
Maribel Fernández, Ian Mackie
2019 J jnl
Int. J. Inf. Sec.
Merve Yildirim, Ian Mackie
2019 J jnl
J. Autom. Reason.
Ian Mackie
2019 ed.
TERMGRAPH@FSCD
Maribel Fernández, Ian Mackie
2019 conf
CODASPY
Maribel Fernández, Ian Mackie, Bhavani Thuraisingham
2018 B conf
DBSec
Ian Mackie, Merve Yildirim
2017 C conf
WoLLIC
Ian Mackie
2017 J jnl
Theor. Comput. Sci.
Mauricio Ayala-Rincón, Ian Mackie, Ugo Montanari
2016 Misc conf
FLOPS
Ian Mackie, Shinya Sato
2016 conf
TERMGRAPH
Ian Mackie
2016 conf
LSFA
Rakan A. Alsowail, Ian Mackie
2016 conf
TERMGRAPH
Ian Mackie, Shinya Sato
2015 Misc conf
ICDCIT
Manish Gaur, Simon J. Gay, Ian Mackie
2015 ed.
LSFA
Mauricio Ayala-Rincón, Ian Mackie
2015 J jnl
Electron. Commun. Eur. Assoc. Softw. Sci. Technol.
Ian Mackie, Shinya Sato
2015 conf
GCM@ICGT
Ian Mackie, Shinya Sato
2014 conf
TERMGRAPH
Abubakar Hassan, Ian Mackie, Shinya Sato
2014 J jnl
J. Log. Comput.
Mário Florido, Ian Mackie
2014 J jnl
J. Log. Comput.
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2014 conf
LSFA
Mauricio Ayala-Rincón, Ian Mackie
2014 ed.
DCM
Mauricio Ayala-Rincón, Eduardo Bonelli, Ian Mackie
2014 C conf
CiE
Maribel Fernández, Hélène Kirchner, Ian Mackie, Bruno Pinaud
2013 conf
TERMGRAPH
Maribel Fernández, Ian Mackie, Matthew Walker
2012 ed.
LINEARITY
Sandra Alves, Ian Mackie
2011 conf
TERMGRAPH
Sandra Alves, Maribel Fernández, Ian Mackie
2011 C conf
PPDP
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2011 ed.
QPL/DCM@ICALP
Bob Coecke, Ian Mackie, Prakash Panangaden, Peter Selinger
2010 C conf
TAMC
Ian Mackie
2010 J jnl
Electron. Commun. Eur. Assoc. Softw. Sci. Technol.
Abubakar Hassan, Ian Mackie, Shinya Sato
2010 J jnl
Theor. Comput. Sci.
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2010 J jnl
CoRR
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2010 J jnl
High. Order Symb. Comput.
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2009 B conf
VL/HCC
Ian Mackie
2009 conf
TERMGRAPH@ETAPS
Abubakar Hassan, Ian Mackie, Shinya Sato
2009 J jnl
CoRR
Ian Mackie, Jorge Sousa Pinto, Miguel Vilaça
2009 ed.
LINEARITY
Mário Florido, Ian Mackie
2009 ed.
RULE
Ian Mackie, Anamaria Martins Moreira
2009 conf
TERMGRAPH@ETAPS
Maribel Fernández, Ian Mackie, Shinya Sato, Matthew Walker
2008 conf
IFL
Ian Mackie
2008 J jnl
Electron. Commun. Eur. Assoc. Softw. Sci. Technol.
Abubakar Hassan, Ian Mackie, Shinya Sato
2008 conf
QPL/DCM@ICALP
Bob Coecke, Ian Mackie, Prakash Panangaden, Peter Selinger
2008 ed.
TERMGRAPH@ETAPS
Ian Mackie, Detlef Plump
2008 C conf
Diagrams
Abubakar Hassan, Ian Mackie, Jorge Sousa Pinto
2007 conf
DCM@ICALP
Ian Mackie, Shinya Sato
2007 B conf
FoSSaCS
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2007 conf
Rewriting, Computation and Proof
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2007 conf
WRS@RDP
Sandra Alves, Mário Florido, Ian Mackie, François-Régis Sinot
2007 J jnl
Math. Struct. Comput. Sci.
Maribel Fernández, Ian Mackie
2007 conf
TERMGRAPH@ETAPS
Ian Mackie, Detlef Plump
2007 ed.
TERMGRAPH
Ian Mackie, Detlef Plump
2007 ed.
DCM@ICALP
Jean-Pierre Jouannaud, Ian Mackie
2007 ed.
TERMGRAPH@ETAPS
Ian Mackie
2007 J jnl
Math. Struct. Comput. Sci.
Ian Mackie, Detlef Plump
2007 J jnl
Electron. Commun. Eur. Assoc. Softw. Sci. Technol.
Ian Mackie, Jorge Sousa Pinto, Miguel Vilaça
2006 J jnl
Math. Struct. Comput. Sci.
Maribel Fernández, Ian Mackie
2006 conf
WRS@FLoC
Horatiu Cirstea, Germain Faure, Maribel Fernández, Ian Mackie, François-Régis Sinot
2006 conf
DCM@ICALP
Jean-Pierre Jouannaud, Ian Mackie
2006 conf
TERMGRAPH@ETAPS
Ian Mackie
2006 ed.
DCM@ICALP
Maribel Fernández, Ian Mackie
2006 conf
WRS@FLoC
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2006 B conf
CSL
Sandra Alves, Maribel Fernández, Mário Florido, Ian Mackie
2005 J jnl
Math. Struct. Comput. Sci.
Maribel Fernández, Ian Mackie, François-Régis Sinot
2005 conf
IFL
Ian Mackie
2005 J jnl
J. Log. Comput.
Ian Mackie
2005 conf
EXPRESS
Maribel Fernández, Ian Mackie, François-Régis Sinot
2005 J jnl
Appl. Algebra Eng. Commun. Comput.
Maribel Fernández, Ian Mackie, François-Régis Sinot
2005 conf
DCM@ICALP
Maribel Fernández, Ian Mackie
2004 conf
RTA
Ian Mackie
2004 conf
TERMGRAPH
François-Régis Sinot, Ian Mackie
2004 C conf
PPDP
Maribel Fernández, Murdoch Gabbay, Ian Mackie
2004 conf
TERMGRAPH
Ian Mackie
2003 conf
RTA
François-Régis Sinot, Maribel Fernández, Ian Mackie
2003 J jnl
Theor. Comput. Sci.
Maribel Fernández, Ian Mackie
2003 J jnl
CLEI Electron. J.
Maribel Fernández, Ian Mackie, Paula Severi, Nora Szasz
2002 conf
TERMGRAPH
Maribel Fernández, Ian Mackie, Jorge Sousa Pinto
2002 B conf
ICGT
Maribel Fernández, Ian Mackie
2002 J jnl
Inf. Comput.
Ian Mackie, Jorge Sousa Pinto
2002 conf
TERMGRAPH
Ian Mackie, Detlef Plump
2001 conf
APPIA-GULP-PRODE
Maribel Fernández, Ian Mackie, Jorge Sousa Pinto
2000 B conf
LATIN
Maribel Fernández, Ian Mackie
2000 J jnl
Theor. Comput. Sci.
Ian Mackie
1999 C conf
PPDP
Maribel Fernández, Ian Mackie
1999 B conf
CSL
Maribel Fernández, Ian Mackie
1998 A* conf
LICS
Maribel Fernández, Ian Mackie
1998 J jnl
Theor. Comput. Sci.
Maribel Fernández, Ian Mackie
1998 A* conf
LICS
Ian Mackie
1998 A conf
ICFP
Ian Mackie
1997 B conf
SAS
Ian Mackie
1996 A conf
ESOP
Thomas P. Jensen, Ian Mackie
1996 conf
PLILP
Maribel Fernández, Ian Mackie
1996 conf
CAAP
Maribel Fernández, Ian Mackie
1995 ed.
Theory and Formal Methods
Chris Hankin, Ian Mackie, Rajagopal Nagarajan
1995 A* conf
POPL
Ian Mackie
1994 conf
Theory and Formal Methods
Ian Mackie
1994 J jnl
J. Funct. Program.
Ian Mackie
1994 conf
Theory and Formal Methods
Chris Hankin, Ian Mackie, Rajagopal Nagarajan
1993 conf
Theory and Formal Methods
Ian Mackie, Leopoldo Román, Samson Abramsky
1993 J jnl
Appl. Categorical Struct.
Ian Mackie, Leopoldo Román, Samson Abramsky
tests/integration/test_elf_extractors.py
← Index tests/integration/test_elf_extractors.py python
"""
Integration tests for ELF-specific extractors.
"""
import pytest
from unittest.mock import Mock, patch, MagicMock

pytestmark = [pytest.mark.integration, pytest.mark.elf]


# ============================================================================
# ELFFeaturesExtractor Tests
# ============================================================================

class TestELFFeaturesExtractor:
    """Tests for ELFFeaturesExtractor class."""

    def test_extract_valid_elf(self, elf_binary_path, mock_logger):
        """Test extracting features from valid ELF file."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor
        from redb.models.dataclasses import ELFFeatures

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert isinstance(result, ELFFeatures)

    def test_extract_header_data(self, elf_binary_path, mock_logger):
        """Test ELF header data extraction."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            # Check header fields
            assert isinstance(result.ei_class, int)
            assert isinstance(result.ei_data, int)
            assert isinstance(result.e_type, int)
            assert isinstance(result.e_machine, int)
            assert isinstance(result.e_entry, int)

    def test_extract_human_readable_strings(self, elf_binary_path, mock_logger):
        """Test human-readable string fields."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert result.ei_class_str in ['32-bit', '64-bit', 'unknown']
            assert result.ei_data_str in ['Little-endian', 'Big-endian', 'unknown']
            assert result.e_type_str is not None
            assert result.e_machine_str is not None

    def test_extract_security_properties(self, elf_binary_path, mock_logger):
        """Test security property extraction."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            # Security flags should be 0 or 1
            assert result.is_pie in [0, 1]
            assert result.has_canary in [0, 1]
            assert result.has_nx in [0, 1]
            assert result.has_relro in [0, 1]
            assert result.has_fortify in [0, 1]

    def test_extract_counts(self, elf_binary_path, mock_logger):
        """Test section/segment/symbol counts."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert result.number_of_segments >= 0
            assert result.number_of_sections >= 0
            assert result.number_of_symbols >= 0
            assert result.number_of_dynamic_symbols >= 0
            assert result.number_of_relocations >= 0
            assert result.number_of_dependencies >= 0

    def test_extract_build_info(self, elf_binary_path, mock_logger):
        """Test build information extraction."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            # Build ID may or may not be present
            if result.build_id is not None:
                assert isinstance(result.build_id, str)
            assert result.gnu_hash_present in [0, 1]
            assert result.has_debug_info in [0, 1]

    def test_extract_invalid_elf(self, pe_binary_path, mock_logger):
        """Test extraction with non-ELF file."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(pe_binary_path, mock_logger)

            result = extractor.extract()

            # Should return None for invalid ELF
            assert result is None


# ============================================================================
# ELFSectionExtractor Tests
# ============================================================================

class TestELFSectionExtractor:
    """Tests for ELFSectionExtractor class."""

    def test_extract_sections(self, elf_binary_path, mock_logger):
        """Test section extraction."""
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSectionExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert isinstance(result, list)
            assert len(result) > 0

    def test_section_properties(self, elf_binary_path, mock_logger):
        """Test section property extraction."""
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor
        from redb.models.dataclasses import ELFSection

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSectionExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None and len(result) > 0:
                section = result[0]
                assert isinstance(section, ELFSection)
                assert section.section_name is not None
                assert isinstance(section.section_type, int)
                assert isinstance(section.section_flags, int)
                assert section.section_entropy >= 0

    def test_section_hashes(self, elf_binary_path, mock_logger):
        """Test section hash computation."""
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSectionExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None and len(result) > 0:
                for section in result:
                    if section.section_sha256:
                        assert len(section.section_sha256) == 64
                    if section.section_md5:
                        assert len(section.section_md5) == 32


# ============================================================================
# ELFSegmentExtractor Tests
# ============================================================================

class TestELFSegmentExtractor:
    """Tests for ELFSegmentExtractor class."""

    def test_extract_segments(self, elf_binary_path, mock_logger):
        """Test segment extraction."""
        from redb.extractors.elf_extractors.elf_segments import ELFSegmentExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSegmentExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert isinstance(result, list)

    def test_segment_properties(self, elf_binary_path, mock_logger):
        """Test segment property extraction."""
        from redb.extractors.elf_extractors.elf_segments import ELFSegmentExtractor
        from redb.models.dataclasses import ELFSegment

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSegmentExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None and len(result) > 0:
                segment = result[0]
                assert isinstance(segment, ELFSegment)
                assert isinstance(segment.segment_type, int)
                assert isinstance(segment.segment_flags, int)


# ============================================================================
# ELFSymbolExtractor Tests
# ============================================================================

class TestELFSymbolExtractor:
    """Tests for ELFSymbolExtractor class."""

    def test_extract_symbols(self, elf_binary_path, mock_logger):
        """Test symbol extraction."""
        from redb.extractors.elf_extractors.elf_symbols import ELFSymbolExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSymbolExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            # May be None if stripped
            if result is not None:
                assert isinstance(result, list)

    def test_symbol_properties(self, elf_binary_path, mock_logger):
        """Test symbol property extraction."""
        from redb.extractors.elf_extractors.elf_symbols import ELFSymbolExtractor
        from redb.models.dataclasses import ELFSymbol

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSymbolExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None and len(result) > 0:
                symbol = result[0]
                assert isinstance(symbol, ELFSymbol)
                assert symbol.symbol_name is not None
                assert isinstance(symbol.symbol_type, int)
                assert isinstance(symbol.symbol_bind, int)


# ============================================================================
# ELFImportExtractor Tests
# ============================================================================

class TestELFImportExtractor:
    """Tests for ELFImportExtractor class."""

    def test_extract_imports(self, elf_binary_path, mock_logger):
        """Test import extraction."""
        from redb.extractors.elf_extractors.elf_imports import ELFImportExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFImportExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            # May be None if no imports
            if result is not None:
                assert hasattr(result, 'elf_imports_total')

    def test_import_functions(self, elf_binary_path, mock_logger):
        """Test import function extraction."""
        from redb.extractors.elf_extractors.elf_imports import ELFImportExtractor
        from redb.models.dataclasses import ELFImport

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFImportExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None:
                assert isinstance(result, ELFImport)
                assert isinstance(result.elf_imports_total, int)


# ============================================================================
# ELFExportExtractor Tests
# ============================================================================

class TestELFExportExtractor:
    """Tests for ELFExportExtractor class."""

    def test_extract_exports(self, elf_binary_path, mock_logger):
        """Test export extraction."""
        from redb.extractors.elf_extractors.elf_exports import ELFExportExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFExportExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            # May be None if no exports
            if result is not None:
                assert hasattr(result, 'elf_exports_total')

    def test_export_functions(self, elf_binary_path, mock_logger):
        """Test export function extraction."""
        from redb.extractors.elf_extractors.elf_exports import ELFExportExtractor
        from redb.models.dataclasses import ELFExport

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFExportExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None:
                assert isinstance(result, ELFExport)


# ============================================================================
# ELFDependencyExtractor Tests
# ============================================================================

class TestELFDependencyExtractor:
    """Tests for ELFDependencyExtractor class."""

    def test_extract_dependencies(self, elf_binary_path, mock_logger):
        """Test dependency extraction."""
        from redb.extractors.elf_extractors.elf_dependencies import ELFDependencyExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFDependencyExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            # May be None if no dependencies
            if result is not None:
                assert isinstance(result, list)

    def test_dependency_properties(self, elf_binary_path, mock_logger):
        """Test dependency property extraction."""
        from redb.extractors.elf_extractors.elf_dependencies import ELFDependencyExtractor
        from redb.models.dataclasses import ELFDependency

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFDependencyExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None and len(result) > 0:
                dep = result[0]
                assert isinstance(dep, ELFDependency)
                assert dep.dependency_name is not None


# ============================================================================
# ELFRelocationExtractor Tests
# ============================================================================

class TestELFRelocationExtractor:
    """Tests for ELFRelocationExtractor class."""

    def test_extract_relocations(self, elf_binary_path, mock_logger):
        """Test relocation extraction."""
        from redb.extractors.elf_extractors.elf_relocations import ELFRelocationExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFRelocationExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            # May be None if no relocations
            if result is not None:
                assert isinstance(result, list)

    def test_relocation_properties(self, elf_binary_path, mock_logger):
        """Test relocation property extraction."""
        from redb.extractors.elf_extractors.elf_relocations import ELFRelocationExtractor
        from redb.models.dataclasses import ELFRelocation

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFRelocationExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None and len(result) > 0:
                reloc = result[0]
                assert isinstance(reloc, ELFRelocation)
                assert isinstance(reloc.relocation_offset, int)
                assert isinstance(reloc.relocation_type, int)


# ============================================================================
# ELFNotesExtractor Tests
# ============================================================================

class TestELFNotesExtractor:
    """Tests for ELFNotesExtractor class."""

    def test_extract_notes(self, elf_binary_path, mock_logger):
        """Test notes extraction."""
        from redb.extractors.elf_extractors.elf_notes import ELFNotesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFNotesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            # May be None if no notes
            if result is not None:
                assert isinstance(result, list)

    def test_note_properties(self, elf_binary_path, mock_logger):
        """Test note property extraction."""
        from redb.extractors.elf_extractors.elf_notes import ELFNotesExtractor
        from redb.models.dataclasses import ELFNote

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFNotesExtractor(elf_binary_path, mock_logger)

            result = extractor.extract()

            if result is not None and len(result) > 0:
                note = result[0]
                assert isinstance(note, ELFNote)
                assert note.note_name is not None
                assert isinstance(note.note_type, int)


# ============================================================================
# Integration Tests
# ============================================================================

class TestELFExtractorIntegration:
    """Integration tests for ELF extractors."""

    def test_all_extractors_valid_elf(self, elf_binary_path, mock_logger):
        """Test all ELF extractors with valid ELF file."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor
        from redb.extractors.elf_extractors.elf_segments import ELFSegmentExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            features_ext = ELFFeaturesExtractor(elf_binary_path, mock_logger)
            sections_ext = ELFSectionExtractor(elf_binary_path, mock_logger)
            segments_ext = ELFSegmentExtractor(elf_binary_path, mock_logger)

            features_result = features_ext.extract()
            sections_result = sections_ext.extract()
            segments_result = segments_ext.extract()

            # All should extract something
            assert features_result is not None
            assert sections_result is not None
            assert segments_result is not None

    def test_hash_consistency_across_extractors(self, elf_binary_path, mock_logger):
        """Test that hashes are consistent across all extractors."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            features_ext = ELFFeaturesExtractor(elf_binary_path, mock_logger)
            sections_ext = ELFSectionExtractor(elf_binary_path, mock_logger)

            # Hashes should be the same
            assert features_ext.sha256 == sections_ext.sha256
            assert features_ext.md5 == sections_ext.md5
            assert features_ext.sha1 == sections_ext.sha1

    def test_clickhouse_tables_unique(self, elf_binary_path, mock_logger):
        """Test that each extractor has a unique ClickHouse table."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor
        from redb.extractors.elf_extractors.elf_segments import ELFSegmentExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            features_ext = ELFFeaturesExtractor(elf_binary_path, mock_logger)
            sections_ext = ELFSectionExtractor(elf_binary_path, mock_logger)
            segments_ext = ELFSegmentExtractor(elf_binary_path, mock_logger)

            tables = {
                features_ext.get_clickhouse_table(),
                sections_ext.get_clickhouse_table(),
                segments_ext.get_clickhouse_table(),
            }

            # All tables should be unique
            assert len(tables) == 3


# ============================================================================
# Advanced Binary Tests
# ============================================================================

class TestELFAdvancedBinary:
    """Tests using the hello_advanced binary."""

    def test_advanced_features_extraction(self, elf_advanced_binary_path, mock_logger):
        """Test feature extraction from advanced ELF binary."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_advanced_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert result.number_of_sections > 0

    def test_advanced_sections_extraction(self, elf_advanced_binary_path, mock_logger):
        """Test section extraction from advanced ELF binary."""
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSectionExtractor(elf_advanced_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert len(result) > 0

            # Check for common ELF sections
            section_names = [s.section_name for s in result]
            # Most ELF files have .text section
            assert any('.text' in name for name in section_names)

    def test_advanced_segments_extraction(self, elf_advanced_binary_path, mock_logger):
        """Test segment extraction from advanced ELF binary."""
        from redb.extractors.elf_extractors.elf_segments import ELFSegmentExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSegmentExtractor(elf_advanced_binary_path, mock_logger)

            result = extractor.extract()

            assert result is not None
            assert len(result) > 0


# ============================================================================
# Export Data Tests
# ============================================================================

class TestELFExtractorExportData:
    """Tests for export data preparation."""

    def test_features_prepare_export_clickhouse(self, elf_binary_path, mock_logger):
        """Test ClickHouse export preparation for features."""
        from redb.extractors.elf_extractors.elf_features import ELFFeaturesExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFFeaturesExtractor(elf_binary_path, mock_logger)
            extractor.extract()

            result = extractor.prepare_export_data("ClickHouseExporter")

            assert result is not None
            data, column_names, column_type_names = result

            assert 'sha256' in column_names
            assert 'ei_class' in column_names
            assert 'e_machine' in column_names
            assert 'is_pie' in column_names

    def test_sections_prepare_export_clickhouse(self, elf_binary_path, mock_logger):
        """Test ClickHouse export preparation for sections."""
        from redb.extractors.elf_extractors.elf_sections import ELFSectionExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSectionExtractor(elf_binary_path, mock_logger)
            extractor.extract()

            result = extractor.prepare_export_data("ClickHouseExporter")

            if result is not None:
                data, column_names, column_type_names = result
                assert 'section_name' in column_names
                assert 'section_entropy' in column_names

    def test_segments_prepare_export_clickhouse(self, elf_binary_path, mock_logger):
        """Test ClickHouse export preparation for segments."""
        from redb.extractors.elf_extractors.elf_segments import ELFSegmentExtractor

        with patch('redb.settings.ELASTIC_BINARIES_COLLECTION', 'test'):
            extractor = ELFSegmentExtractor(elf_binary_path, mock_logger)
            extractor.extract()

            result = extractor.prepare_export_data("ClickHouseExporter")

            if result is not None:
                data, column_names, column_type_names = result
                assert 'segment_type' in column_names