I'm on Pantheon and I want to run some custom SQL queries to sanitize my dev server.
I have the queries in a file,
It looks something like this:
UPDATE user__field_useragent SET field_useragent_value = 'Sputnik'; UPDATE node__field_useragent SET field_useragent_value = 'Sputnik'; UPDATE node_revision__field_useragent SET field_useragent_value = 'Sputnik'; TRUNCATE TABLE watchdog;
I want to run these queries on a remote server with a single Drush command.
My Current Workaround
I connect to the database with Sequel Pro, cut and paste the queries in, and run them.
What I tried
Based on the Drush 8 sql-query documentation, I tried to execute my file like this:
drush @alias.dev sql-query --file=custom_sanitize.sqlqueries
failed to open stream: No [warning] such file or directory drush.inc:904
I assume this is because my local drush calls the remote drush on the server, and the file path is different.
So then I tried to input the content of the file this way:
`drush @alias.dev sql-connect` < custom_sanitize.sqlqueries
This fails with the following message:
-bash: PTY: command not found
So then I tried inputting the queries in at the command line:
drush @alias.dev sql-query "UPDATE node_revision__field_useragent SET field_useragent_value = 'Sputnik';TRUNCATE TABLE watchdog;"
This also fails:
PTY allocation request failed on channel 0 Command not supported as typed.
I also tried using
hook_drush_sql_sync_sanitize(), but I couldn't get my hook picked up by the drush on Pantheon.