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 testTwoSelect()
{
$pixeldb = new PixelDb();
$pixeldb->select(['username', 'password'])->select(['title', 'description'], 'post.');
$this->assertEquals('SELECT username, password, post.title, post.description', $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 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 testLimit()
{
$pixelDb = new PixelDb();
$pixelDb->select(['*'])->from(['users'])->limit(0, 10);
$this->assertEquals('SELECT * FROM users LIMIT 0, 10', $pixelDb->getSqlString());
}
