public function run() { $this->prepareTables(); $repeats = $this->getRepeats(); $value1 = 'string one'; $value2 = 'string two'; $value3 = 'string three'; $bar = new CliProgressBar($repeats); for ($i = 1; $i <= $repeats; ++$i) { Timer::start(); $sql = ' INSERT INTO test (txt) VALUES (?), (?), (?) '; Db::query($sql, [$value1, $value2, $value3]); Timer::stop(); $bar->update($i); } $this->addResult('Real', Timer::get()); PdoAdapter::instance()->getConnection()->setAttribute(PDO::ATTR_EMULATE_PREPARES, true); Timer::reset(); $bar = new CliProgressBar($repeats); for ($i = 1; $i <= $repeats; ++$i) { Timer::start(); $sql = ' INSERT INTO test (txt) VALUES (?), (?), (?) '; Db::query($sql, [$value1, $value2, $value3]); Timer::stop(); $bar->update($i); } $this->addResult('Emulated', Timer::get()); $this->cleanup(); }
/** * Delete data * * @param array|bool $ids Array of ID for delete * * @return bool */ public function delete($ids = false) { $sql = $this->builder->delete($this, $ids); return Db::query($sql); }
public static final function cleanup() { $sql = 'DROP TABLE test'; Db::query($sql); }
/** * @covers Veles\DataBase\Db::query * * @dataProvider queryProvider * * @param $adapter * @param $sql * @param $params * @param $types */ public function testQuery($adapter, $sql, $params, $types) { Db::setAdapter($adapter); if ($types) { Db::query($sql, $params, $types); } elseif ($params) { Db::query($sql, $params); } else { Db::query($sql); } }