PHP October\Rain\Database Dongle::parseConcat Examples

Example #1

File: DongleTest.php Project: aaronleslie/aaronunix

 public function testSqliteParseConcat()
 {
     $dongle = new Dongle('sqlite');
     $result = $dongle->parseConcat("concat(first_name, ' ', last_name)");
     $this->assertEquals("first_name || ' ' || last_name", $result);
     $result = $dongle->parseConcat("CONCAT(  first_name   , ' ',    last_name  )");
     $this->assertEquals("first_name || ' ' || last_name", $result);
     $result = $dongle->parseConcat("group_concat(first_name, ' ', last_name)");
     $this->assertEquals("group_concat(first_name, ' ', last_name)", $result);
 }

Example #2

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

 public function testSqliteParseConcat()
 {
     $dongle = new Dongle('sqlite');
     $result = $dongle->parseConcat("concat(first_name, ' ', last_name)");
     $this->assertEquals("first_name || ' ' || last_name", $result);
     $result = $dongle->parseConcat("CONCAT(  first_name   , ' ',    last_name  )");
     $this->assertEquals("first_name || ' ' || last_name", $result);
     $result = $dongle->parseConcat('concat("#", id, " - ", amount, "(", currency_code, ")")');
     $this->assertEquals('"#" || id || " - " || amount || "(" || currency_code || ")"', $result);
     $result = $dongle->parseConcat("group_concat(first_name, ' ', last_name)");
     $this->assertEquals("group_concat(first_name, ' ', last_name)", $result);
 }

Example #3

File: _ide_helper.php Project: Smony/njphoto

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