/** * @depends testDbDriver */ public function testQuote() { $dbh = Rorm::getDatabase(); $this->assertEquals('TRUE', Rorm::quote($dbh, true)); $this->assertEquals('FALSE', Rorm::quote($dbh, false)); $this->assertEquals('NULL', Rorm::quote($dbh, null)); $this->assertEquals(17, Rorm::quote($dbh, 17)); $this->assertEquals(28.75, Rorm::quote($dbh, 28.75)); $this->assertInternalType('integer', Rorm::quote($dbh, 10)); $this->assertInternalType('float', Rorm::quote($dbh, 10.6)); $this->assertEquals("'lorem'", Rorm::quote($dbh, 'lorem')); // todo test object with __toString }
public function testQuote() { $dbh = Rorm::getDatabase('sqlite'); $this->assertEquals(1, Rorm::quote($dbh, true)); $this->assertEquals(0, Rorm::quote($dbh, false)); }
/** * @return bool */ public function delete() { $dbh = static::getDatabase(); $quoteIdentifier = Rorm::getIdentifierQuoter($dbh); $idColumns = static::$_idColumn; if (!is_array($idColumns)) { $idColumns = array($idColumns); } $where = array(); foreach ($idColumns as $columnName) { $where[] = $quoteIdentifier($columnName) . ' = ' . Rorm::quote($dbh, $this->{$columnName}); } $sql = 'DELETE FROM ' . $quoteIdentifier(static::getTable()) . ' WHERE ' . implode(' AND ', $where); return $dbh->exec($sql) > 0; }