Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support SQL dump import (to enable complex setups, e.g. for WooCommerce) #692

Closed
adamziel opened this issue Oct 13, 2023 · 2 comments
Closed

Support SQL dump import (to enable complex setups, e.g. for WooCommerce) #692

adamziel opened this issue Oct 13, 2023 · 2 comments
Assignees
@seanmorris
Labels
[Package][@wp-playground] Blueprints [Type] Developer Experience [Type] Enhancement New feature or request

Comments

@adamziel
Copy link
Collaborator

There's no easy way to set up Playground for a complex plugin like WooCommerce:

  • WXR doesn't support custom tables
  • Preparing an entire custom SQLite file is tedious and may not be portable between WordPress versions

The ability to import entire SQL files was requested by multiple developers. Let's support it, or something equally expressive and convenient.
@adamziel adamziel changed the title Support importing SQL dumps Enable complex setups by supporting SQL dump import Oct 13, 2023
@adamziel adamziel changed the title Enable complex setups by supporting SQL dump import Support SQL dump import Oct 13, 2023
@adamziel adamziel changed the title Support SQL dump import Support SQL dump import (to enable complex setups, e.g. for WooCommerce) Oct 13, 2023
@adamziel
Copy link
Collaborator Author

This shouldn't be too hard with the SQLite integration plugin:

  1. Read SQL dump
  2. Consume a single query, remember the offset where the parser finished
  3. Translate to SQLite and run
  4. Go back to step 2 until there are no more queries

cc @aristath

@adamziel adamziel mentioned this issue Oct 19, 2023
Closed
@adamziel adamziel mentioned this issue Nov 22, 2023
Open
1 task
@seanmorris seanmorris mentioned this issue Nov 22, 2023
Merged
@adamziel adamziel mentioned this issue Nov 24, 2023
Closed
@seanmorris seanmorris self-assigned this Nov 29, 2023
@adamziel
Copy link
Collaborator Author

Shipped in #745

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@seanmorris seanmorris

Labels
[Package][@wp-playground] Blueprints [Type] Developer Experience [Type] Enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@adamziel @seanmorris