public function testemail_addresses_query() { $table = 'accounts'; $module = 'Accounts'; $bean_id = 1; $expected = $table . ".id IN (SELECT ear.bean_id FROM email_addresses ea\n LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id\n WHERE ear.bean_module = '{$module}'\n AND ear.bean_id != '{$bean_id}'\n AND ear.deleted = 0"; $mergeRecord = new MergeRecord(); $result = $mergeRecord->email_addresses_query($table, $module, $bean_id); $this->assertSame($expected, $result); }