File size: 2,114 Bytes
bf8c0ce | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 | <?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Tests\Integration\Db;
use Piwik\Common;
use Piwik\Db;
use Piwik\Db\BatchInsert;
use Piwik\Tests\Framework\TestCase\IntegrationTestCase;
class BatchInsertTest extends IntegrationTestCase
{
public function testTableInsertBatchSql()
{
$access = Common::prefixTable('access');
$fields = array('login', 'idsite', 'access', 'idaccess');
$insertValues = array(
array('foo', '1', 'view', 1),
array('foo', '1', 'view', 2), // duplicate
array('foo', '2', 'view', 3),
array('bar', '1', 'write', 4),
array('foo', '2', 'admin', 5),
array('baz', '1', 'view', 6),
);
BatchInsert::tableInsertBatchSql($access, $fields, $insertValues);
$all = Db::fetchAll('SELECT * FROM ' . $access);
$this->assertEquals(array(
array(
'idaccess' => '1',
'login' => 'foo',
'idsite' => '1',
'access' => 'view',
),
array(
'idaccess' => '2',
'login' => 'foo',
'idsite' => '1',
'access' => 'view',
),
array(
'idaccess' => '3',
'login' => 'foo',
'idsite' => '2',
'access' => 'view',
),
array(
'idaccess' => '4',
'login' => 'bar',
'idsite' => '1',
'access' => 'write',
),
array(
'idaccess' => '5',
'login' => 'foo',
'idsite' => '2',
'access' => 'admin',
),
5 =>
array(
'idaccess' => '6',
'login' => 'baz',
'idsite' => '1',
'access' => 'view',
),
), $all);
}
}
|