<?php

/**
 * Class CRM_Utils_SQLTest
 * @group headless
 */
class CRM_Utils_SQLTest extends CiviUnitTestCase {

  public function testInterpolate() {
    // This function is a thin wrapper for `CRM_Utils_SQL_BaseParamQuery::interpolate()`, which already has
    // lots of coverage in other test classes. This test just checks the basic wiring.
    $sql = CRM_Utils_SQL::interpolate('FROBNICATE some_table WITH MAX(!dynamicField) OVER #times USING (@list) OR (#ids) OR @item', [
      '!dynamicField' => 'the(field)',
      '#times' => 123,
      '@list' => ['abc def', '45'],
      '#ids' => [6, 7, 8],
      '@item' => "it's text",
    ]);
    $this->assertEquals('FROBNICATE some_table WITH MAX(the(field)) OVER 123 USING ("abc def", "45") OR (6, 7, 8) OR "it\\\'s text"', $sql);
  }

  public function testInterpolateBad() {
    try {
      CRM_Utils_SQL::interpolate("UPDATE !the_table SET !the_field = @THE_VALUE", [
        // MISSING: 'the_table'
        'the_field' => 'my_field',
        'the_value' => 'ny value',
      ]);
    }
    catch (CRM_Core_Exception $e) {
      $this->assertRegExp(';Cannot build query. Variable "!the_table" is unknown.;', $e->getMessage());
    }
  }

  /**
   * Test isSSLDSN
   * @dataProvider dsnProvider
   * @param string $input
   * @param bool $expected
   */
  public function testIsSSLDSN(string $input, bool $expected) {
    $this->assertSame($expected, CRM_Utils_SQL::isSSLDSN($input));
  }

  /**
   * Data provider for testIsSSLDSN
   * @return array
   */
  public function dsnProvider():array {
    return [
      ['', FALSE],
      ['mysqli://user:pass@localhost/drupal', FALSE],
      ['mysqli://user:pass@localhost:3306/drupal', FALSE],
      ['mysql://user:pass@localhost:3306/drupal', FALSE],
      ['mysql://user:pass@localhost:3306/drupal', FALSE],
      ['mysql://user:pass@localhost:3306/drupal?new_link=true', FALSE],
      ['mysqli://user:pass@localhost:3306/drupal?ssl', FALSE],
      ['mysqli://user:pass@localhost:3306/drupal?ssl=1', TRUE],
      ['mysqli://user:pass@localhost:3306/drupal?new_link=true&ssl=1', TRUE],
      ['mysql://user:pass@localhost:3306/drupal?ssl=1', TRUE],
      ['mysqli://user:pass@localhost:3306/drupal?ca=%2Ftmp%2Fcacert.crt', TRUE],
      ['mysqli://user:pass@localhost/drupal?ca=%2Ftmp%2Fcacert.crt&cert=%2Ftmp%2Fcert.crt&key=%2Ftmp%2F', TRUE],
      ['mysqli://user:pass@localhost/drupal?ca=%2Fpath%20with%20spaces%2Fcacert.crt', TRUE],
      ['mysqli://user:pass@localhost:3306/drupal?cipher=aes', TRUE],
      ['mysqli://user:pass@localhost:3306/drupal?capath=%2Ftmp', TRUE],
      ['mysqli://user:pass@localhost:3306/drupal?cipher=aes&capath=%2Ftmp&food=banana', TRUE],
      ['mysqli://user:pass@localhost:3306/drupal?food=banana&cipher=aes', TRUE],
    ];
  }

}