Batch extract from multiple .db files

Question

I have many .db sqlite3 files. Files are in separated subfolders and most of them have same file name: base.db. Every file contains a table 'main' and I want to extract table from every .db file to separate csv file, so that every csv is extracted in the same subfolder next to .db file.

I tried with this script

cd C:\sqlite-tools-win32-x86
for /R %%G in (*.db) do sqlite3 -csv -header "%%G" "select * from main" > %%~nG.csv

The problem is, this script is reading .db files from subfolders, but extract csv's in root folder, and also overwrites previous csv file. I hope the explanation is clear. Any idea how to fix it?

aschipfl · Accepted Answer · 2019-06-13 11:58:44Z

2

You are redirecting the output to %%~nG, which is the base name because of the ~n modifier. To get also the full path to the parent directory use also ~d and ~p:

cd /D "C:\sqlite-tools-win32-x86"
for /R %%G in (*.db) do (
    sqlite3 -csv -header "%%~G" "select * from main" > "%%~dpnG.csv"
)

I also replaced cd by cd /D in order to also change the drive just in case.

answered Jun 13, 2019 at 11:58

aschipfl

35.3k12 gold badges62 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Batch extract from multiple .db files

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related