grabFromDatabase doesn’t work

[pim]

Hey,

I’m new to Codeception but and I have a small problem. It might be me who doesn’t fully understand the framework, don’t bite me in that case please ;)

I have WebGuy test in which I wanted to get some data from database, just like this: $I->grabFromDatabase('users_data', array('phone' => '555666777'));.
I keep getting this error:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I thought it’s my mistake, but when I changed the grabFromDatabase to seeInDatabase it worked properly, so my syntax was apparently okay. It looks like Codeception is generating invalid SQL code, but it’s only my theory there’s a possibility that I’m wrong.

Cheers!

[DavertMik]

There is different syntax in grabFromDatabase. In this command you need to specify a column to grab.

->grabFromDatabase('users', 'email', array('name' => 'davert'));

Ok, ok, bad example in docs.
Fixing...

[pim]

Thanks for help! :)