kmjD0nKM

1local luasql = require "luasql.sqlite3"
2
3
4f = io.popen(string.gsub([[sqlite3 attachments.db
5'.mode csv'
6'DROP TABLE IF EXISTS correspondence;'
7'DROP TABLE IF EXISTS documents;'
8'DROP TABLE IF EXISTS attachments;'
9'CREATE TABLE IF NOT EXISTS correspondence(RowID TEXT PRIMARY KEY, Date, Filename, `From`, `To`, Email, Subject) WITHOUT ROWID;'
10'CREATE TABLE IF NOT EXISTS documents(RowID TEXT PRIMARY KEY, Date, Filename, Subject) WITHOUT ROWID;'
11'CREATE TABLE IF NOT EXISTS attachments(RowID TEXT PRIMARY KEY, Date, Filename, `From`, `To`, Email, Subject) WITHOUT ROWID;'
12'.import correspondence.csv correspondence'
13'.import documents.csv documents'
14'INSERT INTO attachments SELECT RowID, Date, Filename, `From`, `To`, Email, Subject FROM correspondence
15 UNION
16SELECT RowID, Date, Filename,NULL AS `From`,NULL AS `To`,NULL AS Email, Subject
17FROM documents;'
18'.exit']], "\n", " "))
19-- print(s)
20-- f = io.popen(s)
21print(f)
22f:close()