db dump development; exclude all, except like 2

[seansan]

We use db dump development, no payments, orders, customers, etc anonymous

But sometimes we really really need 1 or 2 examples created on LIVE

How can we use db dump development for example, but retain 2 customers, 2 orders and their payments, shippings etc

So strip all: except maybe 2

Maybe an idea

[ktomk]

This is not really feasible with the routines we have. This sounds a bit like a fixture for a test-system (in the general sense this could be your development system for example). For Magento 1 there is a test-framework which has fixture support (e.g. EcomDev_PHPUnit or with less fixture support maybe Digital Pianism Test Framework), with that you can at least automate creation of sample customers (also possible with Magerun) but also orders etc..

[seansan]

​I know - and we can automatie user creation only in some cases you need some "generated from" the original system where DB comes from to test this is why I asko

…

On Fri, Oct 6, 2017 at 5:19 PM, Tom Klingenberg ***@***.***> wrote: This is not really feasible with the routines we have. This sounds a bit like a fixture for a test-system (in the general sense this could be your development system for example). For Magento 1 there is a test-framework which has fixture support (e.g. EcomDev_PHPUnit <https://github.com/EcomDev/EcomDev_PHPUnit> or with less fixture support maybe Digital Pianism Test Framework <https://github.com/digitalpianism/testframework>), with that you can at least automate creation of sample customers (also possible with Magerun) but also orders etc.. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#950 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAn0a9397g-tcWUZj8xEgvnOepYr3rSPks5spkTmgaJpZM4PwbCz> .

[cmuench]

I have no idea how we can do this. Most data have dependencies that why we only have a hard “export" or "skip" data. Filtering on datasets is not easy with export tools like mydqldump.