PHP linter_exec_directの例

コード例 #1

ファイル: fixture.inc.php プロジェクト: knevcher/limb

function DriverLinterExec($conn, $sql)
{
    $result = @linter_exec_direct($conn, $sql);
    if ($result < 0 && stripos($sql, 'DROP') === false) {
        //ignoring drop errors
        _raiseError($result, $conn, array('sql' => $sql));
        throw new lmbDbException('Linter execute error happened: ' . $sql . linter_last_error($conn));
    }
}

コード例 #2

ファイル: lmbLinterConnection.class.php プロジェクト: knevcher/limb

 function execute($sql)
 {
     $result = null;
     $sql = $this->prepare_sql($sql);
     $result = $this->handle_cursor_pool();
     $res = linter_exec_direct($this->useConnection ? $this->connectionId : $result, $sql);
     $this->log("Query direct executed: {$sql}, result:{$res}");
     return $this->handle_call_result($res, $result, $sql);
 }

コード例 #3

ファイル: fetching_linter.php プロジェクト: knevcher/limb

<?php

set_include_path(dirname(__FILE__) . '/../../../../');
$mark = microtime(true);
require_once 'limb/core/common.inc.php';
require_once 'limb/dbal/common.inc.php';
echo "dbal common includes: " . (microtime(true) - $mark) . "\n";
$linter_db = linter_open_connect('SYSTEM', 'MANAGER', 'Demo', TM_AUTOCOMMIT);
$cur = linter_open_cursor($linter_db);
linter_exec_direct($cur, 'CREATE OR REPLACE TABLE "foo" ("bar" varchar(10));');
linter_exec_direct($cur, 'INSERT INTO "foo" VALUES (\'some value\');');
$mark = microtime(true);
for ($i = 0; $i < 1000; $i++) {
    linter_exec_direct($cur, 'SELECT "bar" FROM "foo";');
    while (is_array($entry = linter_fetch_array($cur))) {
        $bar = $entry['bar'];
    }
}
echo "native linter fetching: " . (microtime(true) - $mark) . "\n";
$conn = lmbDBAL::newConnection('linter://*****:*****@localhost/Demo');
$mark = microtime(true);
for ($i = 0; $i < 1000; $i++) {
    $rs = lmbDBAL::fetch('SELECT "bar" FROM "foo";', $conn);
    foreach ($rs as $record) {
        $bar = $record['bar'];
    }
    $rs->freeQuery();
}
echo "lmbDBAL :: fetch(), array access: " . (microtime(true) - $mark) . "\n";
$mark = microtime(true);
for ($i = 0; $i < 1000; $i++) {