/** * @test */ public function itShouldGetColumns() { $values = ['user_id' => 1, 'username' => 'nilportugues']; $this->query->setValues($values); $columns = $this->query->getColumns(); $this->assertInstanceOf('NilPortugues\\Sql\\QueryBuilder\\Syntax\\Column', $columns[0]); }
/** * @param Insert $insert * * @throws QueryException * * @return string */ public function write(Insert $insert) { $columns = $insert->getColumns(); if (empty($columns)) { throw new QueryException('No columns were defined for the current schema.'); } $columns = $this->writeQueryColumns($columns); $values = $this->writeQueryValues($insert->getValues()); $table = $this->writer->writeTable($insert->getTable()); $comment = AbstractBaseWriter::writeQueryComment($insert); return $comment . "INSERT INTO {$table} ({$columns}) VALUES ({$values})"; }