Codeception\Module\WPQueriesTest::it_should_allow_using_regexes_when_asserting_queries_by_statement PHP Метод

    public function it_should_allow_using_regexes_when_asserting_queries_by_statement()
    {
        $this->wpdb->queries = [["SELECT * FROM wp_posts p JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = 'some_type' AND pm.meta_key = 'some_key'", 'some ms timing', 'a stack trace including Acme\\MyPlugin->someMethod'], ['SELECT ID FROM ... (SELECT...)', 'some ms timing', 'a stack trace including Acme\\MyPlugin->someMethod'], ['SELECT * FROM ... INSERT', 'some ms timing', 'a stack trace including Acme\\MyPlugin->someMethod'], ['UPDATE some_table... (SELECT', 'some ms timing', 'a stack trace including Acme\\MyPlugin->someMethod']];
        $sut = $this->make_instance();
        $sut->assertQueriesCountByStatement(1, "/SELECT .* AND pm.meta_key = 'some_key'/");
        $sut->assertQueriesCountByStatement(3, 'SELECT');
        $sut->assertNotQueriesByStatement("/SELECT .* FROM wp_postmeta/");
    }