public function testMultipleUpdateInJsonFormat()
{
// SQL Update in JSON format
$json = '
update: [
{ table: "books" , values: { author: "teste" } , where: { id: 1 } } ,
{ table: "users" , values: { lastname: "Doe" } , where: { id: 1 } } ,
{ table: "users" , values: { firstname: "Sparta", lastname: "" } , where: { id: 300 } }
]
';
// Executes the SQL and stores the result
$result = test::execute($json);
$this->assertEquals(2, self::getNumRowsAffected($result), 'Test with Update command');
}