Moving sqlite to sqlcipher, we have a script that loads a table into the database with the command
sqlite3 database_file “.import csv_file tablename;”
Now withe sqlcipher, I have to give it the key, but you can’t do
sqlcipher database file “pragma key=mykey; .import csv_file tablename;”
as it croaks saying the . is invalid sql syntax. I don’t want to put the pragma into an init file as it plain text.
Any way to do this?
(I’m actually building up the command line in python so I can distribute just a compiled .pyc file so the key is not exposed)