personal dotfiles: my Hyprland config
| -rwxr-xr-x | .local/bin/csv2INSERT.sh | 2 | ||||
| -rwxr-xr-x | .local/bin/csv2sql.sh | 4 |
2 files changed, 5 insertions, 1 deletions
diff --git a/.local/bin/csv2INSERT.sh b/.local/bin/csv2INSERT.sh index 1e20a67..efeb31b 100755 --- a/.local/bin/csv2INSERT.sh +++ b/.local/bin/csv2INSERT.sh @@ -1,6 +1,6 @@ #!/bin/sh read line -echo "INSERT INTO $1 ($line) VALUES" +echo "INSERT IGNORE INTO $1 ($line) VALUES" csv2sql.sh | head -c -2 echo ";" diff --git a/.local/bin/csv2sql.sh b/.local/bin/csv2sql.sh index 7f4a8d5..f080f36 100755 --- a/.local/bin/csv2sql.sh +++ b/.local/bin/csv2sql.sh @@ -3,6 +3,10 @@ tr , "\t" | sed 's/\t\([^"\t]\+\)/\t"\1"/g' | sed 's/\([^"\t]\+\)\t/"\1"\t/g' | +# Switch CSV " escaping to SQL escaping +sed 's/""/\\"/g' | +#sed 's/\\r/\\\\r/g' | +#sed 's/\\n/\\\\n/g' | # replace empty with null, sed 's/\t\t/\tnull\t/g' | sed 's/\t\t/\tnull\t/g' | |