/** * Test a basic query * * @return void **/ public function testBasicQuery() { $db = m::mock('Slab\\DB\\Connections\\ConnectionInterface'); $compiler = m::mock('Slab\\DB\\QueryCompilers\\QueryCompilerInterface'); $compiler->shouldReceive('compileSelect')->once()->andReturn('select `id`, `name` from my_table'); $query = new SelectQueryBuilder($db, $compiler); $query->select('id', 'name'); $query->from('my_table'); $this->assertEquals('select `id`, `name` from my_table', $query->sql()); }
/** * Get a select query builder * * @param mixed... Fields * @return Slab\DB\QueryBuilder\SelectQueryBuilder **/ public function select($field = null) { $connection = $this->connection(); $compiler = $connection->getCompiler(); $query = new SelectQueryBuilder($connection, $compiler); if ($field !== null) { $query->addSelects(func_get_args()); } return $query; }