test_fragmented_attributes.inc

<?php
class Test_Fragmented_Attributes
{


    public static function getName()
    {
        return 'Fragmented Attributes Test';

    }//end getName()


    public static function getDescription()
    {
        return 'A test to check for fragmented attributes on the attributes table';

    }//end getDescription()


    public static function test(&$messages, &$errors)
    {
        $status = TRUE;
        // Missing assets
        $asset_sql = 'SELECT assetid FROM sq_ast_attr_val WHERE assetid NOT IN (SELECT DISTINCT assetid FROM sq_ast) OR attrid NOT IN (SELECT DISTINCT attrid FROM sq_ast_attr)';
        $asset_results = MatrixDAL::executeSqlAssoc($asset_sql);

        foreach ($asset_results as $index => $result) {
            $asset_results[$index] = $result['assetid'];
        }
        $asset_results = array_unique($asset_results);

        if (!empty($asset_results)) {
            $status = FALSE;
            foreach ($asset_results as $result) {
                $errors[] = 'Asset #'.$result.' on the attributes table does not exist';
            }//end foreach
        }//end if

        // Missing attributes
        $attr_sql = 'SELECT attrid FROM sq_ast_attr_val WHERE attrid NOT IN (SELECT DISTINCT attrid FROM sq_ast_attr)';
        $attr_results = MatrixDAL::executeSqlAssoc($attr_sql);

        foreach ($attr_results as $index => $result) {
            $attr_results[$index] = $result['attrid'];
        }
        $attr_results = array_unique($asset_results);

        if (!empty($attr_results)) {
            $status = FALSE;
            foreach ($attr_results as $result) {
                $errors[] = 'Attribute #'.$result.' on the attributes table does not exist';
            }//end foreach
        }//end if

        if (!$status) {
            $count = count($asset_results) + count($attr_results);
            $messages[] = 'There are '.$count.' fragmented attribute(s) on the system';
        }//end if

        return $status;

    }//end test()

}//end class
?>