private static function loadCache()

in pp3/au/Importer.php [191:253]
60 lines of code
7 McCabe index (conditional complexity)

    private static function loadCache() {
        $memBeforeCache = memory_get_usage();
        $res = Db::query('SELECT id, path FROM catalogs WHERE source="' . self::$_source . '"');
        if ($res) {
            while ($r = mysqli_fetch_assoc($res)) {
                self::$catalogCache[$r['path']] = $r['id'];
            }
        }
        $res = Db::query('SELECT id, config FROM configs');
        if ($res) {
            while ($r = mysqli_fetch_assoc($res)) {
                self::$configCache[$r['config']] = $r['id'];
            }
        }
        $res = Db::query('SELECT id, distro FROM distros');
        if ($res) {
            while ($r = mysqli_fetch_assoc($res)) {
                self::$distroCache[$r['distro']] = $r['id'];
            }
        }

        // log some stats on the memory usage so we know how is the cache expensive
        Logger::write(Logger::INFO, 'Caching distros, catalogs, configs took ' . round((memory_get_usage() - $memBeforeCache) / 1024000, 1) . 'MB');

        self::$_packs = array(
            'CND' => 0x0001,
            'CRE' => 0x0002,
            'ENT' => 0x0004,
            'MOB' => 0x0008,
            'PROF' => 0x0010,
            'CDC' => 0x0020,
            'CLDC' => 0x0040,
            'JAVA' => 0x0080,
            'JAVASE' => 0x0100,
            'JAVAEE' => 0x0200,
            'JAVAME' => 0x0400,
            'WEBEE' => 0x0800,
            'PROFILER' => 0x1000,
            'PHP' => 0x2000,
            'RUBY' => 0x4000,
            'MOBILITY' => 0x8000,
            'UML' => 0x10000,
            'SOA' => 0x20000,
            'GLASSFISH' => 0x40000,
            'SJSAS' => 0x80000,
            'TOMCAT' => 0x100000,
            'VISUALWEB' => 0x200000,
            'JDK' => 0x400000,
            'MYSQL' => 0x800000,
            'GROOVY' => 0x1000000,
            'GFMOD' => 0x2000000,
            'JAVAFX' => 0x4000000,
            'WEBCOMMON' => 0x8000000,
            'FX' => 0x10000000,
            'PY' => 0x20000000,
            'JC' => 0x40000000,
            'WEBLOGIC' => 0x80000000,
            'JAVAFXSDK' => 0x100000000,
            'NB' => 0x200000000,
            'EXTIDE' => 0x400000000
            );
self::$_cacheLoaded = true;
}