Create a new Query instance for this connection.
|
public newQuery ( ) : |
||
| return | ||
/**
* Test executing "mark_migration"
*
* @return void
*/
public function testExecute()
{
$commandTester = new CommandTester($this->command);
$commandTester->execute(['command' => $this->command->getName(), 'version' => '20150416223600', '--connection' => 'test']);
$this->assertContains('Migration successfully marked migrated !', $commandTester->getDisplay());
$result = $this->Connection->newQuery()->select(['*'])->from('phinxlog')->execute()->fetch('assoc');
$this->assertEquals('20150416223600', $result['version']);
}
/**
* Imports all records of the given fixture.
*
* @param string $fixtureClassName Fixture class name
* @param \Cake\Database\Schema\Table $schema Table schema for which records
* will be imported
* @param \Cake\Database\Connection $connection Database connection to use
* @return bool True on success
*/
protected function _importRecords($fixtureClassName, TableSchema $schema, Connection $connection)
{
$fixture = new $fixtureClassName();
if (!isset($fixture->records) || empty($fixture->records)) {
return true;
}
$fixture->records = (array) $fixture->records;
if (count($fixture->records) > 100) {
$chunk = array_chunk($fixture->records, 100);
} else {
$chunk = [0 => $fixture->records];
}
foreach ($chunk as $records) {
list($fields, $values, $types) = $this->_getRecords($records, $schema);
$query = $connection->newQuery()->insert($fields, $types)->into($schema->name());
foreach ($values as $row) {
$query->values($row);
}
try {
$statement = $query->execute();
$statement->closeCursor();
} catch (\Exception $ex) {
$this->error(__d('installer', 'Error while importing data for table "{0}". Details: {1}', $schema->name(), $ex->getMessage()));
return false;
}
}
return true;
}
/**
* Run before each tests is executed, should return a set of SQL statements to insert records for the table
* of this fixture could be executed successfully.
*
* @param Connection $db An instance of the database into which the records will be inserted
* @return bool on success or if there are no records to insert, or false on failure
*/
public function insert(Connection $db)
{
if (isset($this->records) && !empty($this->records)) {
list($fields, $values, $types) = $this->_getRecords();
$query = $db->newQuery()->insert($fields, $types)->into($this->table);
foreach ($values as $row) {
$query->values($row);
}
$statement = $query->execute();
$statement->closeCursor();
return $statement;
}
return true;
}
