#create a db connection
$db = DB::createDb($dsn, $user,$password );

#create an app object containing db and other parameters
$app=new App($db);

#define the form structure
$aForm=array(  
	'table_name' => 'test' ,
		'primary_key'=> array('id'),
		'fields'     => array(
				'id' => array('label'   => 'ID', 'type' => 'int', 'key' => 1 ) ,
				'name' => array('label'   => 'Name', 'type' => 'varchar')
		),
);
#define a param array
$aParam=array();

#create a Dbmng object
$dbmng=new Dbmng($app, $aForm, $aParam);

#return the data
$ret = $dbmng->select();

    protected function sortRoutesByComplexity()
    {
        usort(
            $this->routes,
            function ($a, $b) {
                $elementsa = preg_split('#/#', $a->pattern, 0, PREG_SPLIT_NO_EMPTY);
                $elementsb = preg_split('#/#', $b->pattern, 0, PREG_SPLIT_NO_EMPTY);
                if(end($elementsa) == '**' && end($elementsb) == '**')
                   return count($elementsa) < count($elementsb);
                if(end($elementsa) == '**')
                   return 1;
                if(end($elementsb) == '**')
                   return -1;
                if(count($elementsa) < count($elementsb)){
                   return -1;
                }
                if(count($elementsa) > count($elementsb)){
                   return 1;
                }
                $keysa = array_keys($elementsa, '*');
                $keysb = array_keys($elementsb, '*');
                if(count($keysa) < count($keysb)){
                   return -1;
                }
                if(count($keysa) > count($keysb)){
                   return 1;
                }
                for($index=0; $index < count($keysa); $index++){
                   if($keysa[$index] == $keysb[$index])
                       continue;
                   return $keysa[$index]<$keysb[$index];
                }
                return $a->method>$b->method;
                /*
		// Previous code - do not work correct with PHP 7
                $a = $a->pattern;
                $b = $b->pattern;
                $pi = AbstractRoute::PARAM_IDENTIFIER;

                //Compare similarity and ocurrences of "/"
                if (Router::compareRoutePatterns($a, $b, '/')) {
                    return 1;

                //Compare similarity and ocurrences of /*
                } elseif (Router::compareRoutePatterns($a, $b, $pi)) {
                    return -1;

                //Hard fallback for consistency
                } else {
                    return 1;
                }
                */
           }
        );
    }