PHP October\Rain\Database Dongle::parseGroupConcat Examples

Example #1

File: DongleTest.php Project: aaronleslie/aaronunix

 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);
 }

Example #2

File: DongleTest.php Project: richlove1/avc-october

 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);
 }

Example #3

File: _ide_helper.php Project: Smony/njphoto

 /**
  * Transforms GROUP_CONCAT statement.
  *
  * @param string $sql
  * @return string 
  * @static 
  */
 public static function parseGroupConcat($sql)
 {
     return \October\Rain\Database\Dongle::parseGroupConcat($sql);
 }