Pass --yes through to gzip in sql-dump

I was not able to find anything with the search for 'command-specific' at the link you provided, but I did find some info in the examples.alias.drushrc.php file that got me headed in the right direction. I added the follwing to my aliases.drushrc.php file:

  'command-specific' => array (
    'sql-dump' => array (
    'result-file' => 'sqldumps\test.sql',
    'gzip' => TRUE,
    ),
  ),

(Keep in mind I am using Drush 5.1 but have edited my sql.drush.inc file to change the ; to && for Windows to use multi-commands correctly.

But I could use just a bit more help. How to automatically answer "y" when writing over the test.sql.gz file on subsequent executions?

$ drush @mdjdev sql-dump
Database dump saved to sqldumps\test.sql.gz [success]

$ drush @mdjdev sql-dump
gzip: sqldumps\test.sql.gz already exists; do you wish to overwrite (y or n)? y (****need this to auto answer y)
Database dump saved to sqldumps\test.sql.gz [success]

Thanks for the quick respones!

I changed the alias and reloaded GIT Bash

  'command-specific' => array (
    'sql-dump' => array (
    'result-file' => 'sqldumps\nfsgunexsqldumps.sql',
    'gzip' => TRUE,
    'yes' => TRUE,
    ),
  ),

But not getting any love (Still asking for confirmation):

$ drush @nfsdev sql-dump -v
Load alias @nfsdev [notice]

Initialized Drupal 7.12 root directory at c:\wamp\www\local.example.com [notice]

Initialized Drupal site local.example.com at sites/default [notice]

Calling system(mysqldump --result-file sqldumps\example.sql --no-autocommit --single-transaction --opt -Q example --host=localhost --user=root --password= && gzip sqldumps\example.sql);
gzip: sqldumps\example.sql.gz already exists; do you wish to overwrite (y or n)?

Interesting that "drush sa does NOT list the command-specific options, even with --full --with-optional

$ drush sa @nfsdev --full --with-optional
$aliases['nfsdev'] = array (
'uri' => 'local.example.com',
'root' => 'c:\\wamp\\www\\local.example.com',
'db_url' => 'mysql://root@localhost/example',
'path-aliases' =>
array (
'%dump-dir' => 'sqldumps',
'%dump' => 'example.sql',
'%files' => 'sites/default/files',
'%drush' => 'c:/ProgramData/Propeople/Drush',
'%site' => 'sites/local.example.com/',
),
'#file' => 'c:/Users/USERNAME/.drush/aliases.drushrc.php',
);

It makes since that it is not working though, unless the code accounts for the fact that the -y is not --y as it does got --gzip and others.

Forgive me my PHP, for I am only 5 weeks into a 6 week "Beginning PHP" college extension course.

I found that Gzip has a -f flag to halt confirmation. This patch seems to work if 'yes' => TRUE. 'yes' => FALSE or not set at all. I did not do any other testing.

This is probably the second time I have ever made a patch file, so no guarantees!

I don't have a clue what the suggested changes do, but I entered them and tested for 'yes' => TRUE. 'yes' => FALSE or not set at all and everything still worked!

And as a bonus, I am honing my Git Diff patch skills.

Oops hold everythign. I made a rookie mistake and was testing on my original drush not the git clone. Need to test cuz am getting errors when using new changes.

I found that, but actually, even though you warned me about typos, your "drush_escape_shell_arg($file);" should have been "drush_escapeshellarg($file);"

Once I found that, Gzip did not like it.

$ drush @nfsdev sql-dump
gzip: illegal option -- s
usage: gzip [-acdfhlLnNrtvV19] [-S suffix] [file ...]
Database dump failed [error]

So I created a variable to hold the results of the function and that seemed to work

$escfile = drush_escapeshellarg($file);

$exec .= " && gzip -f $escfile";

Again I did all the same tests as before, and this time on the right file!

It wasn't quotes that got me, it was your extra Underscores
Thanks again!