WooCommerce Migration

Made a test fixture using the woocommerce dummy data and put in a new module.

Unfortunately this fixture doesn't load

  [Drupal\Core\Database\DatabaseExceptionWrapper]                                                                                       
  SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'utf8mb4_unicode_ci': CREATE TABLE {wp_commentmeta} (  
  `meta_id` BIGINT unsigned NOT NULL auto_increment,                                                                                    
  `comment_id` BIGINT unsigned NOT NULL DEFAULT '0',                                                                                    
  `meta_key` VARCHAR(255) NULL DEFAULT NULL,                                                                                            
  `meta_value` LONGTEXT NULL DEFAULT NULL,                                                                                              
  PRIMARY KEY (`meta_id`),                                                                                                              
  INDEX `comment_id` (`comment_id`),                                                                                                    
  INDEX `meta_key` (`meta_key`(191))                                                                                                    
  ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4_unicode_ci; Array                                                                     
  (                                                                                                                                     
  )          

Both the Woocommerce and the magento test fixture fail to load in the usual way. That is, they were created in the same way as the Drupal 6 and 7 test fixtures in core. And that is the problem, db-tools and the the load method expect a Drupal db. So, we need to do something different.

Talked to phenaproxima about this in #drupal-migrate, He suggested a temporary hack where the db is dumped with mysqldump and then loaded via by reading the entire SQL file into memory with file_get_contents() and call db_query().
db_query(file_get_contents('fixture.sql'))

So, I am going to try that here.

A new issue has been created for the wider issue of loading non Drupal db test fixtures, #2894055: Creating and loading non drupal db test fixtures.

No, does work. Even tried reading it line by line, as in, https://stackoverflow.com/questions/18559875/php-mysqldump-file-import. But it fails on inserting serialized data.

Let's revert this.

Does this still need a revert?

Yes, it contains a WooCommerce test fixture that we can't load.

Any work on solving that is in #2894055: Creating and loading non drupal db test fixtures.

Yes, this needs a revert.