PHP lmbDBAL::newConnection Exemples

Exemple #1

Fichier : fetching_pgsql.php Projet : snowjobgit/limb

require_once 'limb/core/common.inc.php';
require_once 'limb/dbal/common.inc.php';
echo "dbal common includes: " . (microtime(true) - $mark) . "\n";
$conn_string = "host=sheep port=5432 dbname=test user=lamb password=bar";
$pgsql_db = pg_connect('host=localhost user=php password=1561611 dbname=medkrug');
pg_query($pgsql_db, 'CREATE TABLE foo (bar varchar(10))');
pg_query($pgsql_db, 'INSERT INTO foo VALUES (\'some value\')');
$mark = microtime(true);
for ($i = 0; $i < 1000; $i++) {
    $q = pg_query($pgsql_db, 'SELECT bar FROM foo');
    while ($entry = pg_fetch_assoc($q)) {
        $bar = $entry['bar'];
    }
}
echo "native pgsql fetching: " . (microtime(true) - $mark) . "\n";
$conn = lmbDBAL::newConnection('pgsql://*****:*****@localhost/medkrug');
$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++) {
    $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn);
    foreach ($rs as $record) {
        $bar = $record->get('bar');
    }

Exemple #2

Fichier : fetching.php Projet : snowjobgit/limb

        sqlite_query($native_db, "INSERT INTO foo VALUES (null, 'some value{$i}')");
    }
} else {
    throw new Exception("Could not open sqlite db '{$db}'");
}
if (++$counter == $test || $test == null) {
    $mark = microtime(true);
    for ($i = 0; $i < 1000; $i++) {
        $query = sqlite_query($native_db, 'SELECT bar FROM foo');
        while ($entry = sqlite_fetch_array($query, SQLITE_ASSOC)) {
            $bar = $entry['bar'];
        }
    }
    echo "{$counter}) native sqlite fetching: " . (microtime(true) - $mark) . "\n";
}
$conn = lmbDBAL::newConnection('sqlite://localhost/' . $db);
if (++$counter == $test || $test == null) {
    $mark = microtime(true);
    for ($i = 0; $i < 1000; $i++) {
        $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn);
        foreach ($rs as $record) {
            $bar = $record->get('bar');
        }
    }
    echo "{$counter}) lmbDBAL :: fetch(), getter: " . (microtime(true) - $mark) . "\n";
}
if (++$counter == $test || $test == null) {
    $mark = microtime(true);
    $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn);
    for ($i = 0; $i < 1000; $i++) {
        foreach ($rs as $record) {

Exemple #3

Fichier : fetching_linter.php Projet : knevcher/limb

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++) {
    $rs = lmbDBAL::fetch('SELECT "bar" FROM "foo";', $conn);
    foreach ($rs as $record) {
        $bar = $record->get('bar');
    }

Exemple #4

Fichier : lmbDBALTest.class.php Projet : snowjobgit/limb

 function testNewConnection()
 {
     $conn = lmbDBAL::newConnection($this->dsn);
     $this->assertIsA($conn, 'lmbDbConnection');
 }

Exemple #5

Fichier : fetching_mysql.php Projet : snowjobgit/limb

require_once 'limb/core/common.inc.php';
require_once 'limb/dbal/common.inc.php';
echo "dbal common includes: " . (microtime(true) - $mark) . "\n";
$mysql_db = mysql_connect('localhost', 'gfu', '1561611');
mysql_select_db('gfu');
mysql_query('CREATE TABLE foo (bar varchar(10))');
mysql_query('INSERT INTO foo VALUES (\'some value\')');
$mark = microtime(true);
for ($i = 0; $i < 1000; $i++) {
    $q = mysql_query('SELECT bar FROM foo');
    while ($entry = mysql_fetch_assoc($q)) {
        $bar = $entry['bar'];
    }
}
echo "native mysql fetching: " . (microtime(true) - $mark) . "\n";
$conn = lmbDBAL::newConnection('mysql://*****:*****@localhost/gfu');
$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++) {
    $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn);
    foreach ($rs as $record) {
        $bar = $record->get('bar');
    }