Testing a Salesforce App: Apex vs Selenium vs DevAssure O2 — A Side-by-Side Comparison

public with sharing class PropertyController {

    @AuraEnabled(cacheable=true)
    public static PagedResult getPagedPropertyList(
        String searchKey,
        Decimal minPrice,
        Decimal maxPrice,
        Integer minBedrooms,
        Integer minBathrooms,
        Integer pageSize,
        Integer pageNumber
    ) {
        Integer offset = (pageNumber - 1) * pageSize;
        Integer totalCount = 0;

        String query = 'SELECT Id, Name, Address__c, City__c, State__c, ' +
            'Price__c, Beds__c, Baths__c, Status__c, Thumbnail__c, ' +
            'Broker__c, Broker__r.Name ' +
            'FROM Property__c';

        String conditions = '';

        if (String.isNotBlank(searchKey)) {
            String key = '%' + String.escapeSingleQuotes(searchKey) + '%';
            conditions += ' AND (Address__c LIKE :key OR City__c LIKE :key)';
        }
        if (minPrice != null) {
            conditions += ' AND Price__c >= :minPrice';
        }
        if (maxPrice != null) {
            conditions += ' AND Price__c <= :maxPrice';
        }
        if (minBedrooms != null) {
            conditions += ' AND Beds__c >= :minBedrooms';
        }
        if (minBathrooms != null) {
            conditions += ' AND Baths__c >= :minBathrooms';
        }

        if (String.isNotBlank(conditions)) {
            query += ' WHERE ' + conditions.removeStart(' AND ');
        }

        String countQuery = query.replaceFirst(
            'SELECT.*FROM',
            'SELECT COUNT() FROM'
        );
        totalCount = Database.countQuery(countQuery);

        query += ' ORDER BY Price__c ASC LIMIT :pageSize OFFSET :offset';

        PagedResult result = new PagedResult();
        result.records = Database.query(query);
        result.totalCount = totalCount;
        result.pageSize = pageSize;
        result.pageNumber = pageNumber;
        return result;
    }

    @AuraEnabled
    public static Property__c createProperty(Property__c prop) {
        insert prop;
        return prop;
    }
}

@isTest
private class PropertyControllerTest {

    @TestSetup
    static void setupTestData() {
        Broker__c broker = new Broker__c(
            Name = 'Jane Smith',
            Email__c = 'jane@dreamhouse.com',
            Phone__c = '555-0100'
        );
        insert broker;

        List<Property__c> properties = new List<Property__c>();

        properties.add(new Property__c(
            Name = 'Victorian Mansion',
            Address__c = '123 Oak Street',
            City__c = 'San Francisco',
            State__c = 'CA',
            Price__c = 1250000,
            Beds__c = 4,
            Baths__c = 3,
            Status__c = 'Available',
            Broker__c = broker.Id
        ));

        properties.add(new Property__c(
            Name = 'Modern Condo',
            Address__c = '456 Market Street',
            City__c = 'San Francisco',
            State__c = 'CA',
            Price__c = 650000,
            Beds__c = 2,
            Baths__c = 1,
            Status__c = 'Available',
            Broker__c = broker.Id
        ));

        properties.add(new Property__c(
            Name = 'Beach House',
            Address__c = '789 Coast Hwy',
            City__c = 'Malibu',
            State__c = 'CA',
            Price__c = 3500000,
            Beds__c = 5,
            Baths__c = 4,
            Status__c = 'Sold',
            Broker__c = broker.Id
        ));

        insert properties;
    }

    @isTest
    static void testGetPagedPropertyList_NoFilters() {
        PagedResult result = PropertyController.getPagedPropertyList(
            null, null, null, null, null, 10, 1
        );

        System.assertEquals(3, result.totalCount,
            'Should return all 3 properties when no filters applied');
        System.assertEquals(3, result.records.size());
    }

    @isTest
    static void testGetPagedPropertyList_PriceFilter() {
        PagedResult result = PropertyController.getPagedPropertyList(
            null, 500000, 1500000, null, null, 10, 1
        );

        System.assertEquals(2, result.totalCount,
            'Should return 2 properties within $500K-$1.5M range');

        for (Property__c prop : (List<Property__c>) result.records) {
            System.assert(prop.Price__c >= 500000,
                'Price should be >= 500000');
            System.assert(prop.Price__c <= 1500000,
                'Price should be <= 1500000');
        }
    }

    @isTest
    static void testGetPagedPropertyList_BedroomFilter() {
        PagedResult result = PropertyController.getPagedPropertyList(
            null, null, null, 4, null, 10, 1
        );

        System.assertEquals(2, result.totalCount,
            'Should return 2 properties with 4+ bedrooms');
    }

    @isTest
    static void testGetPagedPropertyList_SearchKey() {
        PagedResult result = PropertyController.getPagedPropertyList(
            'Malibu', null, null, null, null, 10, 1
        );

        System.assertEquals(1, result.totalCount,
            'Should return 1 property matching Malibu');
        System.assertEquals('Beach House',
            ((Property__c) result.records[0]).Name);
    }

    @isTest
    static void testGetPagedPropertyList_CombinedFilters() {
        PagedResult result = PropertyController.getPagedPropertyList(
            'San Francisco', 600000, 2000000, 2, 1, 10, 1
        );

        System.assertEquals(2, result.totalCount,
            'Should return 2 SF properties in price range with 2+ beds');
    }

    @isTest
    static void testGetPagedPropertyList_Pagination() {
        PagedResult page1 = PropertyController.getPagedPropertyList(
            null, null, null, null, null, 2, 1
        );
        PagedResult page2 = PropertyController.getPagedPropertyList(
            null, null, null, null, null, 2, 2
        );

        System.assertEquals(2, page1.records.size(),
            'Page 1 should have 2 records');
        System.assertEquals(1, page2.records.size(),
            'Page 2 should have 1 record');
        System.assertEquals(3, page1.totalCount,
            'Total count should be 3');
    }

    @isTest
    static void testGetPagedPropertyList_NoResults() {
        PagedResult result = PropertyController.getPagedPropertyList(
            'Nonexistent City', null, null, null, null, 10, 1
        );

        System.assertEquals(0, result.totalCount,
            'Should return 0 for non-matching search');
        System.assertEquals(0, result.records.size());
    }

    @isTest
    static void testCreateProperty() {
        Broker__c broker = [SELECT Id FROM Broker__c LIMIT 1];

        Property__c newProp = new Property__c(
            Name = 'New Listing',
            Address__c = '100 New Ave',
            City__c = 'Los Angeles',
            State__c = 'CA',
            Price__c = 800000,
            Beds__c = 3,
            Baths__c = 2,
            Status__c = 'Available',
            Broker__c = broker.Id
        );

        Test.startTest();
        Property__c created = PropertyController.createProperty(newProp);
        Test.stopTest();

        System.assertNotEquals(null, created.Id,
            'Created property should have an Id');

        Property__c fetched = [
            SELECT Name, City__c, Price__c
            FROM Property__c
            WHERE Id = :created.Id
        ];
        System.assertEquals('New Listing', fetched.Name);
        System.assertEquals('Los Angeles', fetched.City__c);
        System.assertEquals(800000, fetched.Price__c);
    }
}