/**
* @test
*/
public function constructor()
{
$expressions = TestHelper::getPrivateProperty($this->where, 'expressions');
$this->assertInstanceOf('\\Ackintosh\\Higher\\Query\\Expression\\ExpressionUnit', $expressions[0], '-> sets "ExpressionUnit" object.');
$this->assertSame('AND', $expressions[1], '-> sets string.');
$this->assertInstanceOf('\\Ackintosh\\Higher\\Query\\Expression\\ExpressionUnit', $expressions[2], '-> sets "ExpressionUnit" object.');
}
/**
* @test
*/
public function setValue()
{
$value = 'testvalue';
$column = new Column($this->name, $this->type, $this->option);
$column->setValue($value);
$this->assertSame($value, TestHelper::getPrivateProperty($column, 'value'));
}
/**
* @test
*/
public function constructorSetsProperties()
{
$join = new Join($this->t1, $this->t2, $this->on);
$this->assertSame($this->t1, TestHelper::getPrivateProperty($join, 'owner'));
$this->assertSame($this->t2, TestHelper::getPrivateProperty($join, 'target'));
$this->assertSame($this->on, TestHelper::getPrivateProperty($join, 'on'));
}
/**
* @test
*/
public function constructor()
{
$str = 'foo';
$val = [1, 2, 3];
$sql = new Sql($str, $val);
$this->assertSame($str, TestHelper::getPrivateProperty($sql, 'sql'), '-> sets string to its "sql" property.');
$this->assertSame($val, TestHelper::getPrivateProperty($sql, 'values'), '-> sets array to its "values" property.');
}
/**
* @test
*/
public function set()
{
$table = new Table();
$update = new Update($table);
$params = ['foo' => 123, 'bar' => 456];
$update->set($params);
$this->assertInstanceOf('\\Ackintosh\\Higher\\Query\\Set', TestHelper::getPrivateProperty($update, 'set'), '-> sets "Set" object to "set" property.');
}
/**
* @test
*/
public function OrHasOR()
{
$table = new Table();
$params[0] = '';
$params[1] = '';
$params[2] = '';
$expression = new Orx($table, $params);
$this->assertSame('OR', TestHelper::getPrivateProperty($expression, 'pre'));
}
/**
* @test
*/
public function valuesSetsProperty()
{
$table = new Table();
$columns = ['test1', 'test2'];
$upsert = new Upsert($table, $columns);
$values = ['value1', 'value2'];
$upsert->values($values);
$this->assertSame($values, TestHelper::getPrivateProperty($upsert, 'values'));
}
/**
* @test
*/
public function setColumns()
{
$table = new Table();
$schema = ['id' => ['int', 'sequence'], 'name' => ['varchar'], 'created' => ['datetime']];
$record = new Record($table);
$record->setColumns($schema);
$columns = TestHelper::getPrivateProperty($record, 'columns');
$this->assertSame(count($schema), count($columns), '-> sets number of columns the same as the schema information.');
$this->assertSame(array_keys($schema), $record->getColumnNames(), '-> sets the column that has been defined in schema information.');
}
/**
* @test
*/
public function joinPushesJoinObjecttoProperty()
{
$table = new Table();
$columns = ['col1', 'col2'];
$select = new Select($columns);
$select->from($table);
$table2 = new Table();
$select->join($table2, ['on1' => 'on2']);
$joins = TestHelper::getPrivateProperty($select, 'joins');
$this->assertInstanceOf('Ackintosh\\Higher\\Query\\Join', array_pop($joins));
}
/**
* @test
*/
public function constructorSetsProperties()
{
$table = new Table();
$params[0] = 'testcolumn';
$params[1] = 'testexpr';
$params[2] = 'testvlaue';
$expression = new Andx($table, $params);
$this->assertSame($table, TestHelper::getPrivateProperty($expression, 'table'));
$this->assertSame($params[0], TestHelper::getPrivateProperty($expression, 'column'));
$this->assertSame($params[1], TestHelper::getPrivateProperty($expression, 'expr'));
$this->assertSame($params[2], TestHelper::getPrivateProperty($expression, 'value'));
}
/**
* @test
*/
public function _orAddsObjectToProperty()
{
$this->unit->_or(new Table(), [0, 0, 0]);
$exprs = TestHelper::getPrivateProperty($this->unit, 'exprs');
$this->assertInstanceOf('Ackintosh\\Higher\\Query\\Expression\\Orx', array_pop($exprs));
}
/**
* @test
*/
public function constructor()
{
$params = ['foo' => 123, 'bar' => 456];
$set = new Set($params);
$this->assertSame($params, TestHelper::getPrivateProperty($set, 'params'), '-> sets the params to "params" property.');
}
