Kernel test throws errors: field not found, and Base table or view not found:

naomi

5/10/24, 10:03 PM

Here's the class I want to test:

class Thing {
  
    public function foo() {
      return \Drupal::entityQuery('node')->condition('body', 'blah')->execute();
    }
  
  }

And the test:

class footest extends \Drupal\KernelTests\KernelTestBase {

  public static $modules = ['node', 'user', 'field'];

 public function testFoo() {
   $thing = new Thing();
   \PHPUnit\Framework\assertEquals($thing->foo() ,4);
 }
}

Obviously this is not a real class or a real test, but they are pared down to the basics to demonstrate the issue.

When I run the test I get "Drupal\Core\Entity\Query\QueryException : 'body' not found".

If I replace "body" with "field_baz', a field that I know exists on at least some content types, I get "Drupal\Core\Entity\Query\QueryException : 'field_baz' not found".

Removing the condition entirely, so that the function body becomes:

return \Drupal::entityQuery('node')->execute();

produces "Drupal\Core\Database\DatabaseExceptionWrapper : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'carbon.test65392739node' doesn't exist"

What am I doing wrong? How can I write tests for code that uses EntityQuery? Thanks!

1 + 0

testing

Score:2

Drupal

apaderno

5/10/24, 10:46 PM

Test classes that extend KernelTestBase needs to create the database tables in their setUp() method. See EntityDisplayTest::setUp(), for example, which creates the database tables for the Node entity.

  parent::setUp();
  $this->installEntitySchema('entity_test');
  $this->installEntitySchema('node');
  $this->installEntitySchema('user');
  $this->installConfig(['field', 'node', 'user']);

Setting $modules to the required modules is not sufficient for the database tables to be created. EntityDisplayTest itself sets EntityDisplayTest::$modules to ['field_ui', 'field', 'entity_test', 'user', 'text', 'field_test', 'node', 'system'] but then calls KernelTestBase::installEntitySchema() for the User and Node entities.

For database tables that are not for entities, there is KernelTestBase::installSchema(), which creates the database tables a module defines in its hook_schema() hook.

+ 3

naomi

5/11/24, 5:57 AM

Thanks! This seems to have helped, but now I have another error: "Exception : Exception when installing config for module node, message was: No schema for system.action.node_delete_action"

apaderno

5/11/24, 7:12 AM

It means you need to create that database table with `KernelTestBase::installConfig()`. If then the exception is referring to the configuration schema, probably that is not sufficient.

naomi

5/11/24, 4:36 PM

Thanks. I'm struggling a great deal to find a way of writing automated tests for Drupal code that manipulates entities. Your answer solved the immediate issues that I asked about, but I ended up down another rabbit hole when it came to loading site config. This probably breaks the rules of stack exchange but do you offer paid help? I've noticed your name on a few Drupal testing questions so you seem to know what you are on about!

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Kernel test throws errors: field not found, and Base table or view not found:

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.