37 lines
1.1 KiB
PowerShell
37 lines
1.1 KiB
PowerShell
|
$ErrorActionPreference = "Stop"
|
||
|
|
$base = "https://raw.githubusercontent.com/MIT-LCP/mimic-code/main/mimic-iii/concepts_postgres"
|
||
|
|
|
||
|
|
$files = @(
|
||
|
|
"postgres-functions.sql",
|
||
|
|
"echo_data.sql",
|
||
|
|
"fluid_balance/urine_output.sql",
|
||
|
|
"durations/ventilation_classification.sql",
|
||
|
|
"durations/ventilation_durations.sql",
|
||
|
|
"durations/weight_durations.sql",
|
||
|
|
"durations/dobutamine_dose.sql",
|
||
|
|
"durations/dopamine_dose.sql",
|
||
|
|
"durations/epinephrine_dose.sql",
|
||
|
|
"durations/norepinephrine_dose.sql",
|
||
|
|
"firstday/blood_gas_first_day.sql",
|
||
|
|
"firstday/blood_gas_first_day_arterial.sql",
|
||
|
|
"firstday/gcs_first_day.sql",
|
||
|
|
"firstday/labs_first_day.sql",
|
||
|
|
"firstday/urine_output_first_day.sql",
|
||
|
|
"firstday/vitals_first_day.sql",
|
||
|
|
"severityscores/sapsii.sql"
|
||
|
|
)
|
||
|
|
|
||
|
|
foreach ($rel in $files) {
|
||
|
|
$url = "$base/$rel"
|
||
|
|
$dest = Join-Path "sql" $rel
|
||
|
|
$dir = Split-Path $dest -Parent
|
||
|
|
if (-not (Test-Path $dir)) {
|
||
|
|
New-Item -ItemType Directory -Force -Path $dir | Out-Null
|
||
|
|
}
|
||
|
|
Write-Host "Fetching $rel"
|
||
|
|
Invoke-WebRequest -Uri $url -OutFile $dest -UseBasicParsing
|
||
|
|
}
|
||
|
|
|
||
|
|
Write-Host ""
|
||
|
|
Write-Host "Done. Files saved under .\sql\"
|