<?php
require_once 'CiviTest/CiviUnitTestCase.php';

/**
 * Class CRM_Utils_SQL_SelectTest
 */
class CRM_Utils_SQL_InsertTest extends CiviUnitTestCase {
  public function testRow_twice() {
    $insert = CRM_Utils_SQL_Insert::into('foo')
      ->row(array('first' => '1', 'second' => '2'))
      ->row(array('second' => '2b', 'first' => '1b'));
    $expected = '
      INSERT INTO foo (`first`,`second`) VALUES
      ("1","2"),
      ("1b","2b")
    ';
    $this->assertLike($expected, $insert->toSQL());
  }

  public function testRows() {
    $insert = CRM_Utils_SQL_Insert::into('foo')
      ->row(array('first' => '1', 'second' => '2'))
      ->rows(array(
        array('second' => '2b', 'first' => '1b'),
        array('first' => '1c', 'second' => '2c'),
      ))
      ->row(array('second' => '2d', 'first' => '1d'));
    $expected = '
      INSERT INTO foo (`first`,`second`) VALUES
      ("1","2"),
      ("1b","2b"),
      ("1c","2c"),
      ("1d","2d")
    ';
    $this->assertLike($expected, $insert->toSQL());
  }

  /**
   * @param $expected
   * @param $actual
   * @param string $message
   */
  public function assertLike($expected, $actual, $message = '') {
    $expected = trim((preg_replace('/[ \r\n\t]+/', ' ', $expected)));
    $actual = trim((preg_replace('/[ \r\n\t]+/', ' ', $actual)));
    $this->assertEquals($expected, $actual, $message);
  }

}