jeudi 28 décembre 2017

Using logical or in seeInDatabase

How can i implement a logic 'or' operator in Codeception's seeInDatabase method?.

For example: the methods syntax is

seeInDatabase('table', array('column1' => 'value1', 'column2' => 'value2'));

Wich generates this query

SELECT COUNT(*) FROM `table` WHERE `column1` = 'value1' AND `column2` = 'value2'

How can i generate the following query?

SELECT COUNT(*) FROM `table` WHERE `column1` = 'value1' AND (`column2` = 'value2' OR `column2` = 'value3')

Thanks for your help!

Aucun commentaire:

Enregistrer un commentaire