/** * @covers Zend\Db\Adapter\Platform\Sql92::quoteIdentifierInFragment */ public function testQuoteIdentifierInFragment() { $this->assertEquals('"foo"."bar"', $this->platform->quoteIdentifierInFragment('foo.bar')); $this->assertEquals('"foo" as "bar"', $this->platform->quoteIdentifierInFragment('foo as bar')); // single char words $this->assertEquals('("foo"."bar" = "boo"."baz")', $this->platform->quoteIdentifierInFragment('(foo.bar = boo.baz)', array('(', ')', '='))); // case insensitive safe words $this->assertEquals('("foo"."bar" = "boo"."baz") AND ("foo"."baz" = "boo"."baz")', $this->platform->quoteIdentifierInFragment('(foo.bar = boo.baz) AND (foo.baz = boo.baz)', array('(', ')', '=', 'and'))); }
/** * @covers Zend\Db\Adapter\Platform\Sql92::quoteIdentifierInFragment */ public function testQuoteIdentifierInFragment() { $this->assertEquals('"foo"."bar"', $this->platform->quoteIdentifierInFragment('foo.bar')); $this->assertEquals('"foo" as "bar"', $this->platform->quoteIdentifierInFragment('foo as bar')); }
/** * @group ZF2-386 * @covers Zend\Db\Adapter\Platform\Sql92::quoteIdentifierInFragment */ public function testQuoteIdentifierInFragmentIgnoresSingleCharSafeWords() { $this->assertEquals('("foo"."bar" = "boo"."baz")', $this->platform->quoteIdentifierInFragment('(foo.bar = boo.baz)', array('(', ')', '='))); }