Skip to content

SQLite Compatibility #430

@swissspidy

Description

@swissspidy

When I manually run the tests locally with SQLite, the following scenarios are failing:

001 Scenario: Approving/unapproving comments # features/comment.feature:161
Then STDERR should contain:            # features/comment.feature:173
$ wp comment approve 2 --url=www.example.com
Success: Approved comment 2.

002 Scenario: Publishing a post and setting a date succeeds if the edit_date flag is passed. # features/post.feature:460
Then STDOUT should contain:                                                            # features/post.feature:473
$ wp post get 4 --field=post_date
2005-01-24T09:52:00.000Z

003 Scenario: Empty a site                                    # features/site-empty.feature:3
When I run `wp db query "SOURCE insert_link_data.sql;"` # features/site-empty.feature:15
$ wp db query "SOURCE insert_link_data.sql;"

ERROR 1146 (42S02) at line 1 in file: 'insert_link_data.sql': Table 'wp_cli_test.wp_links' doesn't exist

004 Scenario: Empty a site and its uploads directory # features/site-empty.feature:103
When I run `wp site empty --uploads --yes`     # features/site-empty.feature:114
$ wp site empty --uploads --yes
Success: The site at 'https://example.com' was emptied.

WordPress database error

[...]

Error occurred at line 3373 in Function <code>handle_error</code>. Error message was: SQLSTATE[HY000]: General error: 1 incomplete input.
Backtrace:
WP_SQLite_Translator->get_error_message()
#1 src/Site_Command.php(83): WP_SQLite_DB->query('TRUNCATE wp_pos...')
#2 src/Site_Command.php(263): Site_Command->empty_posts()
#3 [internal function]: Site_Command->empty_(Array, Array)

[...]

005 Scenario: Filter options by `--site_id`                                                                                      # features/site-option.feature:130
When I run `wp db query "INSERT INTO wp_sitemeta (site_id,meta_key,meta_value) VALUES (2,'wp_cli_test_option','foobar');"` # features/site-option.feature:133
$ wp db query "INSERT INTO wp_sitemeta (site_id,meta_key,meta_value) VALUES (2,'wp_cli_test_option','foobar');"

ERROR 1146 (42S02) at line 1: Table 'wp_cli_test.wp_sitemeta' doesn't exist

Let's figure out the best course of action here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions