Integrate 3rd party Search Replace DB script

[alkah3st]

Does the find/replace part of this task account for serialized data?

[getdave]

Not at the moment. I'm planning on making use of a 3rd party script to integrate this. However pull requests are more than welcome.

[getdave]

@alkah3st I've recently upped by knowledge of NPM. I now understand we can reference a Git repo as a dependency. Therefore I propose the following

1. Define https://github.com/interconnectit/Search-Replace-DB as a dependency in package.json
2. Replace the sed (or allow as fallback?) with searchreplacedb2cli.php CLI script to account for Serialized data. We can use exec to do this easily.

If you're experienced in Grunt/Node I'd welcome some help on this.

[alkah3st]

Sweet, searchreplacedb is exactly the script I use to do the find/replace. I'm not by any means a pro with Grunt/node but I'll see what I can do.

[getdave]

Should be pretty simple. I'm planning to get to this Thurs/Fri

[getdave]

@alkah3st if you're interested I've made some good progress on this at

https://github.com/getdave/grunt-deployments/tree/feature/advanced-search-replace

Requires a lot of testing however. Would you be able to give it a whirl and see if it works for you?

[alkah3st]

Awesome, I'll check it out this weekend. I just in fact was retooling my own website, so I can experiment on it there.

[getdave]

That would be much appreciated. Be sure to do a fresh install. Dependencies have changed a lot. NPM update...

Cheers

[getdave]

@alkah3st Just checking to see if you've had any chance to test this out?

[alkah3st]

Hi Dave, sorry I have disappeared from the face of the earth these past two months. I've been settling into a new job. Quick question I have about your advanced search/replace deployments script: I have everything set up properly in my gruntfile, but what's not clear to me is steps 1) and 2) you described above:

1. Define https://github.com/interconnectit/Search-Replace-DB as a dependency in package.json
2. Replace the sed (or allow as fallback?) with searchreplacedb2cli.php CLI script to account for Serialized data. We can use exec to do this easily.

I understand I need to include a reference to searchreplacedb2 script in my package.json, but am I including the git path (i.e., https://github.com/interconnectit/Search-Replace-DB.git) in the package like so:

"grunt-deployments": "~0.2.0",
"https://github.com/interconnectit/Search-Replace-DB.git": ??

Also I'm not sure what you mean by #2.

[getdave]

@alkah3st Not a problem.

I've actually already done most of the work on this branch

https://github.com/getdave/grunt-deployments/tree/feature/advanced-search-replace

Check out this branch and give it a whirl. I'm interested to see what issues you encounter.

[alkah3st]

Ah cool, that's the one I'm testing out. I have an environment where I'll regularly be moving a WP site from dev -> stage -> live, so I think this would be an ideal test.

[getdave]

@alkah3st I would be great if you could test this. Be careful with it as it's not production-ready code yet!

[alkah3st]

Here's a question for you: so I have everything set up in my external file:

{
"local": {
"title": "Local",
"database": "xxx",
"user": "xxx",
"pass": "",
"host": "xxx",
"url": "xxx"
},
"develop": {
"title": "xxx",
"database": "xxx",
"user": "xxx",
"pass": "xxx",
"host": "xxx",
"url": "xxx",
"ssh_user": "xxx",
"ssh_host": "xxx",
"ssh_port": "xxx"
},
"stage": {
"title": "xxx",
"database": "xxx",
"user": "xxx",
"pass": "xxx",
"host": "xxx",
"url": "xxx",
"ssh_user": "xxx",
"ssh_host": "xxx",
"ssh_port": "xxx"
}
}

as .dbpass, and the task in my gruntfile is:

    deployments: {
        options: {
          backups_dir: 'db'
        },
        local: '<%= untracked_targets.local %>',
        develop: '<%= untracked_targets.develop %>',
        stage: '<%= untracked_targets.stage %>'
     },

When I run db_pull --src="local" --dest="develop" I get this error:

"Warning: An error occurred while processing a template (Cannot read property 'local' of undefined). Use --force to continue."

Is "untracked_targets" correct to reference the external file with the credentials?

[getdave]

Thanks for giving this a shot. I've tried to help below...

Is "untracked_targets" correct to reference the external file with the credentials?

You can name and reference the external file however you'd like. A good explanation of how to achieve this is found on the readme. My file is similar to the below:

{
    "local": {
        "title": "Local",
        "database": "my_db_name",        
        "user": "my_db_user",
        "pass": "my_db_pass",
        "host": "localhost",  
        "url": "www.test.local"
    },
    "develop": {
        "title": "Development Server",
        "database": "my_db_name",        
        "user": "my_db_user",
        "pass": "my_db_pass",
        "host": "localhost",      
        "url": "www.mydevurl.com",
        "ssh_user": "my_ssh_user",
        "ssh_host": "111.111.11.11"  
    }
}

...and the portion of the my Gruntfile which references it is:

grunt.initConfig({
    db_fixture: grunt.file.readJSON('test/fixtures/basic_config.json'), // the path can be to any location where you'd like to store the config file
    deployments: {
        options: {
            backups_dir: ''
        },
        local: '<%= db_fixture.local %>', // make sure you've created valid fixture DB creds
        develop: '<%= db_fixture.develop %>' // make sure you've created valid fixture DB creds
    },

    // remainder of Gruntfile continues...

When I run db_pull --src="local" --dest="develop" I get this error:

In hindsight the use of db_pull as the CLI command is stupid. I would like to rename is to db_migrate. Feel free to do this via a pull request into the advanced search replace branch (or I'll do it later!).

"Warning: An error occurred while processing a template (Cannot read property 'local' of undefined). Use --force to continue."

This is because it cannot find a reference to "local". You will need to double check that the script has a "local" target. Hopefully it's just a minor typo rather than an issue with the script.

Happy to help you get this working. Sorry it's been less than smooth so far!