test_general_status.inc

<?php
class Test_General_Status
{


    public static function getName()
    {
        return 'General Status Check';

    }//end getName()


    public static function getDescription()
    {
        return 'A basic test to get a general status and statistics on the system';

    }//end getDescription()


    public static function test(&$messages, &$errors)
    {
        $status = '2';

        $sql = 'SELECT COUNT(*) FROM sq_ast';
        $result = MatrixDAL::executeSqlOne($sql);
        if (!empty($result)) {
            $messages[] = 'There are '.$result.' asset(s) on the system';
        }//end if

        $sql = "SELECT COUNT(*) FROM sq_ast_lnk WHERE link_type<='4'";
        $result = MatrixDAL::executeSqlOne($sql);
        if (!empty($result)) {
            $messages[] = 'There are '.$result.' asset link(s) on the system';
        }//end if

        return $status;

    }//end test()

}//end class
?>