dibi forum

DIBI API – vyhledává v Nette API (Bug Reports)

iguana007 — Wed, 27 Oct 2010 15:30:38 +0200

Rád bych nahlásil bug v Dibi API, který s počívá v tom, že, když si dám něco vyhledat přes input v pravo nahoře, tak mi to vyhledává na nette webu místo na dibi :)

implementace DibiDatabaseInfo::initForeignKeys() (General Discussion)

pekelnik — Tue, 23 Mar 2010 14:06:53 +0100

ahoj,

tady je zkusmá implementace této metody pro postgres – myslím, že tato metoda bude muset být delegována na driver.

<?php
/**
 * Init Foreign Key Information
 * @return void
 */
protected function initForeignKeys()
{
        $this->foreignKeys = array();
        $r = dibi::getConnection()->getDriver()->getResource();

        $q = "
                SELECT
                        tc.constraint_name, tc.table_name, kcu.column_name,
                        ccu.table_name AS foreign_table_name,
                        ccu.column_name AS foreign_column_name
                FROM
                        information_schema.table_constraints AS tc
                        JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name
                        JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name
                WHERE constraint_type = 'FOREIGN KEY' AND tc.table_name = '" . $this->name . "'";

        $result = pg_query($r, $q);

        $rows = array();
        $rows = pg_fetch_all($result);
        while($row = pg_fetch_assoc($result)) {
                $rows[] = $row;
        }

        if ($rows) {
                foreach ($rows as $row) {
                        $references = array();
                        $references['local']['table'] = $row['table_name'];
                        $references['local']['column'] = $row['column_name'];
                        $references['foreign']['table'] = $row['foreign_table_name'];
                        $references['foreign']['column'] = $row['foreign_column_name'];

                        $info = new DibiForeignKeyInfo($row['constraint_name'], $references);
                        $this->foreignKeys[] = $info;
                }
        }
}
?>

feature request: cache (General Discussion)

gotisch — Sun, 07 Mar 2010 20:54:35 +0100

Hello,

is there a planned feature to add cache for queries?

something like

$connection->querywithcache(“thequery”,1800);

to query database only every 1800 seconds and else return cached values?
i solved it currently with

<?php
$query = "SELECT ach.achievement AS achievementID, from_unixtime(ach.date) as achievementTime, g.name AS guildname,g.guildId,`c`.*,a.locked AS accbanned,a.gmlevel,a.username,gr.rname FROM [:chars:character_achievement] ach
                                LEFT JOIN [:chars:characters] AS c ON c.guid=ach.guid
                                LEFT JOIN [:chars:guild_member] AS gd ON c.guid=gd.guid
                                LEFT JOIN [:chars:guild_rank] AS gr ON gr.guildid=gd.guildid AND gr.rid=gd.rank
                                LEFT JOIN [:chars:guild] AS g ON gd.guildid = g.guildId
                                LEFT JOIN [:realm:account] AS a ON a.id=c.account
                                WHERE ach.date > ( UNIX_TIMESTAMP( ) - ( 3 *24 *60 *60 ) )
                                ORDER BY ach.date DESC LIMIT 0,15";
        $filename = "/tmp/dbcache/" . md5($query);
        // check cache:
        $limit = 300; // limit of 5 min
        if (file_exists($filename) && filemtime($filename) > time()-$limit) {
                $all = unserialize(file_get_contents($filename));
        } else {
                $result = $connection->query($query);
                $all = $result->fetchAll();
                if (!file_exists("/tmp/dbcache/"))
                        mkdir("/tmp/dbcache/", 0777);
                if($fp = fopen($filename, 'w')) {
                        fwrite($fp, serialize($all));
                        fclose($fp);
                }
        }
?>

having dibi do it automagically (if wanted) would be really cool.

inserting html tags – embeds or so (General Discussion)

Jan Tvrdík — Wed, 06 Jan 2010 13:03:02 +0100

AFAIK dibi do not escape HTML characters in any case. Isn't the problem somewhere else? Are you sure that the string you put in query method isn't already escaped?

inserting html tags – embeds or so (General Discussion)

Kukosk — Tue, 05 Jan 2010 23:25:28 +0100

hi,
i have got one problem in dibi…
when i want to insert html code of some embed, and i use %s, or so, it inserts escaped characters…

dont you want to add some modifier ? for example %html or so ? it would be perfect :)

any solution ?
thanks

[dibi, nette 0.9.1] DibiFluent->applyLimit() nefunguje (Bug Reports)

gapon — Mon, 19 Oct 2009 13:48:06 +0200

ukázka (testováno s mysql i mysqli driverem):

<?php
    //$this->template->allNews = $news->applyLimit($paginator->getLength(), $paginator->getOffset()); // DOES NOT WORK!!!
    $this->template->allNews = $news->getIterator($paginator->getOffset(), $paginator->getLength());
?>

první řádek skončí nevalidním SQL dotazem (“… APPLY LIMIT 10 5”)

Close connection (General Discussion)

David Grudl — Wed, 15 Jul 2009 12:33:02 +0200

Connections (and resultset) are closed and released from memory automatically, you do not need to call disconnect().

Close connection (General Discussion)

gotisch — Tue, 14 Jul 2009 17:35:25 +0200

Do i need to call

dibi::disconnect();

at the end of every page or is that done automatically? currently im using

config.php

require_once("libs/dibi.min.php");
$config_Bugtracker = array (
        'driver'    => 'mysql',
        'host'      => 'localhost',
/*...*/
        'charset'   => 'utf8',
        'lazy'      => true     //we set lazy so that connection is only made if we use it.
        );
dibi::connect( $config_Bugtracker , 'BugTracker' );

and in file where query is done:

include("config.php");
        $connection = dibi::getConnection("BugTracker");
        $result = $connection->query("  SELECT  blablabla",$username);
        unset($result);

is that enough or do i need to add the dibi::disconnect in file where query is done?

SQL Function in query (General Discussion)

David Grudl — Mon, 25 May 2009 01:36:16 +0200

You can use this:

$insert = array(
        'username' => strtoupper($username),
        'pass%sql' => array('SHA1(%s)',  strtoupper("$username:$password")), // or only 'pass' => in last revision
        'email' => $email,
);

SQL Function in query (General Discussion)

gotisch — Sat, 23 May 2009 03:22:13 +0200

Hello,

how can i add a SQL function that takes parameters in the query?

<?php
function CreateUser($username, $email, $password)
{
        $connection = dibi::getConnection('Server');
        $insert = array(
                'username' => strtoupper($username),
                'pass' => "SHA1('" . strtoupper($username) . ":" . strtoupper($password) . "')",
                'email' => $email,
        );
        $connection->query("INSERT INTO users ", $insert);
        return;
}
CreateUser("test", "test@hotmail.com", "mypass123'%=,.");
?>

The problem is with the pass. If i just add the string it will esacpe the SHA1(' part too. SHA(\\' so in the end i end up with loads of \\ and the query not working.

if i do

<?php
new DibiVariable("SHA1('" . strtoupper($username) . ":" . strtoupper($password) . "')", "sql"),
?>

instead, it will not get escaped. And i can't use $connection->getDriver()->escape($username,dibi::TEXT) because that require a connection to the server already established, and i want the connection setting lazy = true

Thanks for any help!

Writing code in forum (Miscellaneous)

David Grudl — Mon, 01 Sep 2008 01:52:50 +0200

While posting and replying, you can use Texy syntax to enhance your messages.

Code phrases can be surrounded by `backtick quotes`.

Long code blocks write this way:

/--php
function importFile($m)
{
    list(, $file) = $m;
    $level = substr_count($file, '/');
    echo "$file\n";
}
\--

or

/--
RewriteEngine On
RewriteCond %{REQUEST_FILENAME}.php -f
RewriteRule .* $0.php [L]
\--

It is possible to use <?php and ?> delimiters to indicate a PHP code:

<?php
function importFile($m)
{
    list(, $file) = $m;
    $level = substr_count($file, '/');
    echo "$file\n";
}
?>

JavaScript delimites are supported too (the type attribute is optional):

<script type="text/javascript">
function queryMark(url) {
  return (url.indexOf('?') == -1) ? '?' : '&';
}
</script>

dibi forum

DIBI API – vyhledává v Nette API (Bug Reports)

implementace DibiDatabaseInfo::initForeignKeys() (General Discussion)

feature request: cache (General Discussion)

inserting html tags – embeds or so (General Discussion)

inserting html tags – embeds or so (General Discussion)

[dibi, nette 0.9.1] DibiFluent-&#x3E;applyLimit() nefunguje (Bug Reports)

Close connection (General Discussion)

Close connection (General Discussion)

SQL Function in query (General Discussion)

SQL Function in query (General Discussion)

Writing code in forum (Miscellaneous)

[dibi, nette 0.9.1] DibiFluent->applyLimit() nefunguje (Bug Reports)