--- /dev/null
+<?php
+
+/**
+* @file
+* For now we only test sql-sync in simulated mode.
+*
+* Future: Using two copies of Drupal, we could test
+* overwriting one site with another.
+*/
+
+namespace Unish;
+
+/**
+ * @group slow
+ * @group commands
+ * @group sql
+ */
+class sqlSyncTest extends CommandUnishTestCase {
+
+ /**
+ * Covers the following responsibilities.
+ * - A user created on the source site is copied to the destination site.
+ * - The email address of the copied user is sanitized on the destination site.
+ *
+ * General handling of site aliases will be in sitealiasTest.php.
+ */
+ public function testLocalSqlSync() {
+ if ($this->db_driver() == 'sqlite') {
+ $this->markTestSkipped('SQL Sync does not apply to SQLite.');
+ return;
+ }
+
+ $sites = $this->setUpDrupal(2, TRUE);
+ return $this->localSqlSync();
+ }
+ /**
+ * Do the same test as above, but use Drupal 6 sites instead of Drupal 7.
+ */
+ public function testLocalSqlSyncD6() {
+ if (UNISH_DRUPAL_MAJOR_VERSION != 6) {
+ $this->markTestSkipped('This test class is designed for Drupal 6.');
+ return;
+ }
+
+ chdir(UNISH_TMP); // Avoids perm denied Windows error.
+ $this->setUpBeforeClass();
+ $sites = $this->setUpDrupal(2, TRUE, '6');
+ return $this->localSqlSync();
+ }
+
+ public function localSqlSync() {
+
+ $options = array(
+ 'root' => $this->webroot(),
+ 'uri' => 'stage',
+ 'yes' => NULL,
+ );
+
+ // Create a user in the staging site
+ $name = 'joe.user';
+ $mail = "joe.user@myhome.com";
+
+ if (UNISH_DRUPAL_MAJOR_VERSION >= 8) {
+ // Add user fields and a test User.
+ $this->drush('pm-enable', array('field,text,telephone,comment'), $options + array('yes' => NULL));
+ $this->drush('php-script', array(
+ 'user_fields-D' . UNISH_DRUPAL_MAJOR_VERSION,
+ $name,
+ $mail
+ ), $options + array(
+ 'script-path' => __DIR__ . '/resources',
+ 'debug' => NULL
+ ));
+ }
+ else {
+ $this->drush('user-create', array($name), $options + array('password' => 'password', 'mail' => $mail));
+ }
+
+ // Copy stage to dev with --sanitize.
+ $sync_options = array(
+ 'sanitize' => NULL,
+ 'yes' => NULL,
+ // Test wildcards expansion from within sql-sync. Also avoid D8 persistent entity cache.
+ 'structure-tables-list' => 'cache,cache*',
+ );
+ $this->drush('sql-sync', array('@stage', '@dev'), $sync_options);
+
+ // Confirm that the sample user has the correct email address on the staging site
+ $this->drush('user-information', array($name), $options + array('pipe' => NULL));
+ $output = $this->getOutput();
+ $row = str_getcsv($output);
+ $uid = $row[1];
+ $this->assertEquals($mail, $row[2], 'email address is unchanged on source site.');
+ $this->assertEquals($name, $row[0]);
+
+ $options = array(
+ 'root' => $this->webroot(),
+ 'uri' => 'dev',
+ 'yes' => NULL,
+ );
+ // Confirm that the sample user's email address has been sanitized on the dev site
+ $this->drush('user-information', array($name), $options + array('pipe' => NULL));
+ $output = $this->getOutput();
+ $row = str_getcsv($output);
+ $uid = $row[1];
+ $this->assertEquals("user+$uid@localhost.localdomain", $row[2], 'email address was sanitized on destination site.');
+ $this->assertEquals($name, $row[0]);
+
+ // @todo Confirm that the role_permissions table no longer exists in dev site (i.e. wildcard expansion works in sql-sync).
+ // $this->drush('sql-query', array('SELECT * FROM role_permission'), $options, NULL, NULL, self::EXIT_ERROR);
+
+ // Copy stage to dev with --sanitize and a fixed sanitized email
+ $sync_options = array(
+ 'sanitize' => NULL,
+ 'yes' => NULL,
+ 'sanitize-email' => 'user@mysite.org',
+ // Test wildcards expansion from within sql-sync. Also avoid D8 persistent entity cache.
+ 'structure-tables-list' => 'cache,cache*',
+ );
+ $this->drush('sql-sync', array('@stage', '@dev'), $sync_options);
+
+ $options = array(
+ 'root' => $this->webroot(),
+ 'uri' => 'dev',
+ 'yes' => NULL,
+ );
+ // Confirm that the sample user's email address has been sanitized on the dev site
+ $this->drush('user-information', array($name), $options + array('pipe' => NULL));
+ $output = $this->getOutput();
+ $row = str_getcsv($output);
+ $uid = $row[1];
+ $this->assertEquals("user@mysite.org", $row[2], 'email address was sanitized (fixed email) on destination site.');
+ $this->assertEquals($name, $row[0]);
+
+ if (UNISH_DRUPAL_MAJOR_VERSION >= 8) {
+ $fields = [
+ 'field_user_email' => 'joe.user.alt@myhome.com',
+ 'field_user_string' => 'Private info',
+ 'field_user_string_long' => 'Really private info',
+ 'field_user_text' => 'Super private info',
+ 'field_user_text_long' => 'Super duper private info',
+ 'field_user_text_with_summary' => 'Private',
+ ];
+ // Assert that field DO NOT contain values.
+ foreach ($fields as $field_name => $value) {
+ $this->assertUserFieldContents($field_name, $value, $options);
+ }
+
+ // Assert that field_user_telephone DOES contain "5555555555".
+ $this->assertUserFieldContents('field_user_telephone', '5555555555', $options, TRUE);
+ }
+ }
+
+ /**
+ * Assert that a field on the user entity does or does not contain a value.
+ *
+ * @param string $field_name
+ * The machine name of the field.
+ * @param string $value
+ * The field value.
+ * @param array $options
+ * Options to be added to the sql-query command.
+ * @param bool $should_contain
+ * Whether the field should contain the value. Defaults to false.
+ */
+ public function assertUserFieldContents($field_name, $value, $options = [], $should_contain = FALSE) {
+ $table = 'user__' . $field_name;
+ $column = $field_name . '_value';
+ $this->drush('sql-query', [ "SELECT $column FROM $table LIMIT 1" ], $options);
+ $output = $this->getOutput();
+ $this->assertNotEmpty($output);
+
+ if ($should_contain) {
+ $this->assertContains($value, $output);
+ }
+ else {
+ $this->assertNotContains($value, $output);
+ }
+ }
+}