Skip to main content
1 of 2
StudentsTea
  • 341
  • 1
  • 2
  • 8

I searched the Internet for an answer last night and found nothing. Of course, today after posting this question I try again--and find an adequate response almost immediately.

The gist of it? Put your commands in a text file and direct it to SQLite using the input file descriptor, or just script everything in a bash script.

###First Method:

sqlite3 database.db < commands.txt

###Second Method:

#!/bin/bash --
sqlite3 -batch $1 <<"EOF"
CREATE TABLE log_entry ( <snip> );
.separator "\t"
.import logfile.log log_entry
EOF

And then on the command line:

import.sh database.db
StudentsTea
  • 341
  • 1
  • 2
  • 8