Get NodeJS spawn to show ddev import-db progress

[Mathijs-Zuiderlicht]

Hi!

I'm tinkering with nodejs and trying to get node to execute some ddev commands.
My goal is to write the progress of a db import to the console.

If I run DDEV import-db --file=somefile.sql then I get a nice progress bar that shows me how long the import may take.
However, the same (?) command when executed in node does not, and only logs "Successfully imported database 'db' for myDB"

Here's a snippet of the code. In all 3 console.logs I get nothing but the final message.

                const importCommand = 'wsl -d Ubuntu --cd ' + appRoot + ` ddev import-db --file=${dumpFileName}`;
                const importProcess = spawn(importCommand, { shell: true });

                importProcess.stdout.on('data', (data) => {
                    console.log(`Output: ${data}`);
                });

                importProcess.on('message', (message) => {
                    console.log('Message:', message);
                });

                importProcess.stderr.on('data', (data) => {
                    console.error(`Error output: ${data}`);
                });

I have looked at the DDEV source and it seems to use pv (Pipe Viewer) to show the progress.

ddev/pkg/ddevapp/ddevapp.go

Line 746 in 4e22fe8

inContainerCommand = []string{"bash", "-c", fmt.Sprintf(`set -eu -o pipefail && (echo "%s" | psql -q -d postgres -v ON_ERROR_STOP=1) && pv %s/*.*sql | psql -q -v ON_ERROR_STOP=1 %s >/dev/null`, preImportSQL, insideContainerImportPath, targetDB)}

I would expect that to return something to stdout. But allas.
Can it be done? Any ideas?

[stasadev]

Hi @Mathijs-Zuiderlicht,

Please test:

• fix: always show pv output on ddev import-db #6484 (comment)

[Mathijs-Zuiderlicht]

This works:

const importCommand = 'wsl -d Ubuntu pv -f ' + dumpFilePath + ' | wsl -d Ubuntu --cd ' + appRoot + ' ddev mysql -uroot -proot ' + myDB