Pop\Db\Sql::setQuoteId PHP Method

setQuoteId() public method

Set the quote ID type
public setQuoteId ( integer $type = Pop\Db\Sql::NO_QUOTE ) : Sql
$type integer
return Sql
    public function setQuoteId($type = \Pop\Db\Sql::NO_QUOTE)
    {
        $this->quoteIdType = (int) $type;
        return $this;
    }

Usage Example

Exemplo n.º 1
0
 public function testQuoteId()
 {
     $s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users');
     $this->assertEquals('"users"', $s->quoteId('users'));
     $this->assertEquals('"users"."id"', $s->quoteId('users.id'));
     $s->setQuoteId(Sql::BACKTICK);
     $this->assertEquals('`users`', $s->quoteId('users'));
     $this->assertEquals('`users`.`id`', $s->quoteId('users.id'));
     $s->setQuoteId(Sql::BRACKET);
     $this->assertEquals('[users]', $s->quoteId('users'));
     $this->assertEquals('[users].[id]', $s->quoteId('users.id'));
 }