tutorial doesn't work

[collmomo]

PHP 7.0

                    ->setTable('user')
                    ->setColumns(['userId' => 'user_id', 'username' => 'name', 'email' => 'email']);
echo $builder->write($query);
`

``` [Symfony\Component\Debug\Exception\FatalThrowableError]
  Type error: Argument 1 passed to NilPortugues\Sql\QueryBuilder\Builder\GenericBuilder::write() must implement interface NilPortugues\Sql\QueryBuilder\Manipulation\QueryInterface, instance of NilPortu  
  gues\Sql\QueryBuilder\Manipulation\ColumnQuery given, `

Confirmed here, too.

[ovflowd]

If i use where()
Here gives error too. What the hell are those erros.

[nilportugues]

@Sant0ro provide the code of the query and I'll look into it :)

[ovflowd]

I researched a little and discovered that the core isn't soo hackable, see an example:
If i create the SQL Instruction directly by invoking the correspondent methods,
as an example where() and setColumns() statement, they return respectively Where and ColumnQuery class instances.

Generating the following error:

Catchable fatal error: Argument 1 passed to NilPortugues\Sql\QueryBuilder\Builder\GenericBuilder::write() must implement interface NilPortugues\Sql\QueryBuilder\Manipulation\QueryInterface, instance of NilPortugues\Sql\QueryBuilder\Syntax\Where given, called in C:\Users\NOTEBOOKRIC\Documents\GitHub\middleware_mc_srvcl_rest_raise\UIoT\Factories\InstructionFactory.php on line 102 and defined in C:\Users\NOTEBOOKRIC\Documents\GitHub\middleware_mc_srvcl_rest_raise\UIoT\Vendor\nilportugues\sql-query-builder\src\Builder\GenericBuilder.php on line 216

I simply used.

$query = $builder->select()->setTable('DEVICES')->setColumns($deviceArray)->where()->equals('ID', 7);
$builder->write($query);

as example, and the error ahead was returned to me.

BUT, if i do in this way:

$parteOne = $builder->select()->setTable('DEVICES');
$parteOne->setColumns($deviceArray);
$parteOne->where()->equals('ID', 7);
$builder->write($parteOne);

Everything works correctly. Maybe your Variable Injection isn't working correctly.

[ovflowd]

@nilportugues what you think can be? The tutorial is a demonstration? or is intended to wisely work?
I didn't give a look in the source code of this library, but i think that's a bug?

Since also phpStorm is warning me that the return types of the variables aren't the expected as the tutorial...

[smeeckaert]

I had to add

/**
* @return QueryInterface
*/
public function end()
{
   return $this->query;
}

Then i can do something like this:

$query = $builder->select()->where()->equals('field', 'value')->end();
$builder->write($query);

It's not the best thing but it's the only workaround I found.

[assada]

Can u fix this shit?

[g-giani]

Would be great to fix it, same error here! This simple code just doesn't work:

$query = $builder->select()
    ->setTable('user')
    ->setColumns(['id','name']);

echo $builder->write($query);

Error:

PHP Fatal error: Uncaught TypeError: Argument 1 passed to NilPortugues\Sql\QueryBuilder\Builder\GenericBuilder::write() must implement interface NilPortugues\Sql\QueryBuilder\Manipulation\QueryInterface, instance of NilPortugues\Sql\QueryBuilder\Syntax\Where given, called in /var/www/site/includes/search.inc.php on line 26 and defined in /var/www/site/vendor/nilportugues/sql-query-builder/src/Builder/GenericBuilder.php:216

Removing '->setColumns(['id','name'])' everything works fine. And yes, the columns id and name exist ;-)

[volodymyrtym]

@g-giani
I've got the same problem, the tutorial has error true.
you can fix this - do not resign variable $query;
try to use this
$query = $builder->select(); // here you get the new Select instance
$query->setTable('user')
->setColumns(['id','name']);
echo $builder->write($query); //here is the place where you send new Select instance to builder

[SmattyCore]

Why can this still be open? Would be cool to get it solved asap.

[belaarany]

I believe it will never be solved.