function testSingleWhereWithLikeWithFunction() { $pixelDb = new PixelDb(); $pixelDb->select(['*'])->from(['users'])->where('password', 'avaga', 'SHA1', WhereExpression::OPERATOR_LIKE); $this->assertEquals('SELECT * FROM users WHERE password LIKE %SHA1(:p_password)%', $pixelDb->getSqlString()); $pixelDb->getSqlBuffer()->clear(); $pixelDb->select(['*'])->from(['users'])->where('password', 'avaga', 'SHA1', WhereExpression::OPERATOR_LIKE_STARTS); $this->assertEquals('SELECT * FROM users WHERE password LIKE %SHA1(:p_password)', $pixelDb->getSqlString()); $pixelDb->getSqlBuffer()->clear(); $pixelDb->select(['*'])->from(['users'])->where('password', 'avaga', 'SHA1', WhereExpression::OPERATOR_LIKE_ENDS); $this->assertEquals('SELECT * FROM users WHERE password LIKE SHA1(:p_password)%', $pixelDb->getSqlString()); }
function testSqlBufferProperty() { $db = new PixelDb(); $this->assertNotNull($db->getSqlBuffer()); $newBuffer = new StringBuffer(); $newBuffer->append('SAMPLE BUFFER'); $db->setSqlBuffer($newBuffer); $this->assertEquals('SAMPLE BUFFER', $db->getSqlString()); }