public function testSqliteParseGroupConcat() { $dongle = new Dongle('sqlite'); $result = $dongle->parseGroupConcat("group_concat(first_name separator ', ')"); $this->assertEquals("group_concat(first_name, ', ')", $result); $result = $dongle->parseGroupConcat("group_concat(sometable.first_name SEPARATOR ', ')"); $this->assertEquals("group_concat(sometable.first_name, ', ')", $result); }
public function testSqlSrvParseGroupConcat() { $dongle = new Dongle('sqlsrv'); $result = $dongle->parseGroupConcat("group_concat(first_name separator ', ')"); $this->assertEquals("dbo.GROUP_CONCAT_D(first_name, ', ')", $result); $result = $dongle->parseGroupConcat("group_concat(sometable.first_name SEPARATOR ', ')"); $this->assertEquals("dbo.GROUP_CONCAT_D(sometable.first_name, ', ')", $result); $result = $dongle->parseGroupConcat("group_concat(id separator ')')"); $this->assertEquals("dbo.GROUP_CONCAT_D(id, ')')", $result); }
/** * Transforms GROUP_CONCAT statement. * * @param string $sql * @return string * @static */ public static function parseGroupConcat($sql) { return \October\Rain\Database\Dongle::parseGroupConcat($sql); }