René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SQLite Compatibility","articleBody":"When I manually run the tests locally with SQLite, the following scenarios are failing:\r\n\r\n```\r\n001 Scenario: Deleting all transients on single site # features/transient.feature:58\r\n      Then STDOUT should be:                         # features/transient.feature:76\r\n        $ wp transient delete --all\r\n        Success: No transients found.\r\n\r\n002 Scenario: Deleting expired transients on single site # features/transient.feature:123\r\n      Then STDOUT should be:                             # features/transient.feature:134\r\n        $ wp transient delete --expired\r\n        Success: No expired transients found.\r\n\r\n003 Scenario: Deleting all transients on multisite # features/transient.feature:194\r\n      Then STDOUT should be:                       # features/transient.feature:215\r\n        $ wp transient delete --all\r\n        Success: No transients found.\r\n\r\n004 Scenario: Deleting expired transients on multisite # features/transient.feature:286\r\n      Then STDOUT should be:                           # features/transient.feature:301\r\n        $ wp transient delete --expired\r\n        Success: No expired transients found.\r\n\r\n005 Scenario: List transients on single site # features/transient.feature:386\r\n      Then STDOUT should contain:            # features/transient.feature:400\r\n        $ wp transient list --format=csv\r\n        name,value,expiration\r\n\r\n006 Scenario: List transients on multisite # features/transient.feature:431\r\n      Then STDOUT should contain:          # features/transient.feature:445\r\n        $ wp transient list --format=csv\r\n        name,value,expiration\r\n\r\n007 Scenario: List transients with search and exclude pattern # features/transient.feature:476\r\n      Then STDOUT should be:                                  # features/transient.feature:485\r\n        $ wp transient list --format=csv --fields=name --search=\"foo\"\r\n        name\r\n```\r\n\r\nThe transient command uses lots of custom MySQL queries. The SQLite integration plugin is supposed to make those SQLite-compatible, but perhaps something is not working there.\r\n\r\nOr, since deletion and listing are failing, maybe the issue is that the insertion using `set_transient()` is failing in the first place.\r\n\r\nLet's figure it out together. This could involve changes to the command, the tests, core, or the SQLite plugin.","author":{"url":"https://github.com/swissspidy","@type":"Person","name":"swissspidy"},"datePublished":"2023-10-21T13:55:01Z","url":"https://github.com/wp-cli/cache-command/issues/92"}