QhMjpgVG

1SET "BigFish=Z. UnsortedBig Fish AudioMidnight Jazz TrainBrass and Winds"
2SET "Fragments=Z. UnsortedLoopmastersFragments 02FR2_SOUNDS_&_FXFR2_BASS"
3SET "LCycles=Z. UnsortedLoopmastersHip-Hop Lunar CyclesLUN_SYNTH_MELODY_LOOPS"
4
5FOR %%A IN (Tenor_Sax, Trumpet) DO MD "%BigFish%%%A"
6MD "%Fragments%"
7MD "%LCycles%"
8
9@echo justtestjunk > "%Fragments%loop.wav"
10@echo justtestjunk > "%LCycles%drum.aiff"
11@echo justtestjunk > "%LCycles%file.txt"
12FOR %%A IN (Tenor_Sax, Trumpet) DO echo justtestjunk > "%BigFish%%%Adata.sql"
13	
14loop.wav, Testing, Z. Unsorted, Loopmasters, Fragments 02, 15
15	
16loop.wav, Loopmasters, Fragments 02, FR2_SOUNDS_&FX, FR2_BASS, 15
17	
18@echo off
19
20setlocal enabledelayedexpansion
21
22SET fld="Z. Unsorted"
23
24sqlite3 %fld%TestDb.sqlite "CREATE TABLE IF NOT EXISTS "Samples" (File TEXT NOT NULL, Publisher TEXT, Pack TEXT NOT NULL, Category TEXT, Type TEXT, Size INT);" 
25
26for /r %fld% %%A in (*.aiff *.wav) do (
27    call :part "%%~dpA"
28
29    set "File=%%~nxA"
30    set "File=!File:'=''!"
31
32    sqlite3 %fld%TestDb.sqlite "INSERT OR REPLACE INTO "Samples" VALUES ('!File!', '!Publisher!', '!Pack!', '!Category!', '!Type!', '%%~zA');"
33
34    @echo '!File!', '!Publisher!', '!Pack!', '!Category!', '%%~zA'
35)
36
37PAUSE
38
39:part
40    for /f "tokens=6-10 delims=" %%A in ("%~1") do (
41        set "Publisher=%%~A"
42        set "Publisher=!Publisher:'=''!"
43
44        set "Pack=%%~B"
45        set "Pack=!Pack:'=''!"
46
47        set "Category=%%~C"  
48        set "Category=!Category:'=''!"
49
50        set "Type=%%~D"  
51        set "Type=!Type:'=''!"
52    )