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); }
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); }
/** * Transforms CONCAT statement. * * @param string $sql * @return string * @static */ public static function parseConcat($sql) { return \October\Rain\Database\Dongle::parseConcat($sql); }