PS импорт csv файла в sqlite

$db = "C:\sqlite\pr.db"
$sql = ".mode csv"
$sql | C:\sqlite\sqlite3.exe $db
 
$db = "C:\sqlite\pr.db"
$sql = ".separator ,"
$sql | C:\sqlite\sqlite3.exe $db
 
$db = "C:\sqlite\pr.db"
$sql = ".import C:\Daily.csv event"
$sql | C:\sqlite\sqlite3.exe $db

@"
.open pr.db
 
create table event (
        date text,
        day int,
        month int, 
        year int,
        user text,
        pc text,
        printer text,
        page int,
        copies int,
        totalpage int
);
 
.mode csv
.separator , 
.import Daily.csv event
 
select * from event;
 
.quit
 
"@ | out-file script.sql
 
gc script.sql | sqlite3

$datafile= 'data.csv'
$table_name = 'event'
$db_name = 'event'
# origin:
$command = @"
.open ${db_name}
drop table ${table_name};
create table ${table_name} (
        date text,
        day int,
        month int, 
        year int,
        user text,
        pc text,
        printer text,
        page int,
        copies int,
        totalpage int
);
 
.mode csv
.separator , 
.import ${datafile} ${table_name}
 
select user from ${table_name};
 
.quit 
"@
 
$script = "${env:TEMP}\command.sql"
out-File -FilePath $script -Encoding ascii -InputObject $command;
write-output 'Version 1'
get-content $script | sqlite3.exe
write-output 'Version 2'