NotORM panel – profiler panel pre Nette\Debug

Spravil som panelik pre NotORM, ktory loguje SQL dotazy, ktore NotORM kladie do DB. Nakolko profiler NotORM je velmi primitivny – vola iba callback ktoremu preda polozeny SQL dotaz a pole argumentov, neposkytuje panel ziadne info o casovej narocnosti dotazov.

download

download

Implementacia:

• stiahnut Panel.php a panel.phtml a ulozit do %libsDir%/Diggriola
• vytvorit BaseModel a metodu initialize()
• inicializovat DB connection v app/bootstrap.php
• podedit BaseModel a klast dotazy (vid. API)

app/models/BaseModel.php

<?php


use Nette\Object,
    Nette\Environment,
    Nette\Diagnostics\Debugger,
    PDO,
    NotORM,
    Diggriola\Panel;

class BaseModel extends Object
{
    protected static $notORM = null;

    public static function initialize()
    {
        $db = Environment::getConfig('database');

        $pdo = new PDO("{$db['driver']}:host={$db['host']};dbname={$db['database']}", $db['username'], $db['password']);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $pdo->query('SET NAMES utf8');

        self::$notORM = new NotORM($pdo);

        if ($db->profiler) {
            $panel = Panel::getInstance();
            $panel->setPlatform($db['driver']);
            Debug::addPanel($panel);

            self::$notORM->debug = function($query, $parameters) {
                Panel::getInstance()->logQuery($query, $parameters);
            };
        }
    }
}

app/bootstrap.php

$application->onStartup[] = 'BaseModel::initialize';

// pre "predpovedanie buducnosti"
Environment::getSession()->setExpiration('+ 90 days');
Environment::getSession()->start();

app/models/Article.php

class Article extends BaseModel
{
    public static function test()
    {
        $articles = self::$notORM->article()
            ->select('id, title')
            ->where('text LIKE ?', '%PHP%')
            ->order('title')
            ->limit(10);

        foreach ($articles as $article) {
            print_r($article['title']); echo '<br>';
        }

        $rowId = self::$notORM->article()->insert(array(
            'title' => 'Lorem',
            'text' => 'ipsup dolor sit amet',
            'published' => '2010-11-19 18:00:00',
            'category_id' => '1',
        ));

    }
}

Editoval srigi (1. 6. 2011 9:21)