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()); }
function testFrom() { $pixelDb = new PixelDb(); $pixelDb->select(['username', 'password'])->select(['mstoken', 'fbtoken', 'gotoken'], 'auths.')->from(['users', 'auths']); $this->assertEquals('SELECT username, password, auths.mstoken, auths.fbtoken, auths.gotoken FROM users, auths', $pixelDb->getSqlString()); }
function testTwoSet() { $pixelDb = new PixelDb(); $pixelDb->update('users')->set(['username' => 'Antigya Avaga'])->set(['password' => 'New Password'], null, 'sensitive_'); $this->assertEquals('UPDATE users SET username = :p_username, password = :sensitive_password', $pixelDb->getSqlString()); }
function testTwoSelect() { $pixeldb = new PixelDb(); $pixeldb->select(['username', 'password'])->select(['title', 'description'], 'post.'); $this->assertEquals('SELECT username, password, post.title, post.description', $pixeldb->getSqlString()); }
public function testDelete() { $db = new PixelDb(); $db->delete('users'); $this->assertEquals('DELETE FROM users', $db->getSqlString()); }
function testUpdate() { $pixelDb = new PixelDb(); $pixelDb->update('users'); $this->assertEquals('UPDATE users', $pixelDb->getSqlString()); }
function testTwoOrderBy() { $pixelDb = new PixelDb(); $pixelDb->select(['*'])->from(['users'])->orderBy('username')->orderBy('register_date', OrderByExpression::ORDER_DIRECTION_DESCENDING); $this->assertEquals('SELECT * FROM users ORDER BY username ASC, register_date DESC', $pixelDb->getSqlString()); }
function testWhereOrWithFunction() { $pixelDb = new PixelDb(); $pixelDb->select(['*'])->from(['users'])->where('username', 'abumyria')->orWhere('password', 'avaga', 'SHA1'); $this->assertEquals('SELECT * FROM users WHERE username = :p_username OR password = SHA1(:p_password)', $pixelDb->getSqlString()); }
function testLimit() { $pixelDb = new PixelDb(); $pixelDb->select(['*'])->from(['users'])->limit(0, 10); $this->assertEquals('SELECT * FROM users LIMIT 0, 10', $pixelDb->getSqlString()); }