Multiline statements do not work

[ValentinKaisermayer]

The following example:

using SQLite

sql = "
CREATE TABLE accounts ( 
    account_no INTEGER NOT NULL, 
    balance DECIMAL NOT NULL DEFAULT 0
);
 
CREATE TABLE account_changes (
    change_no INT NOT NULL PRIMARY KEY,
    account_no INTEGER NOT NULL, 
    flag TEXT NOT NULL, 
    amount DECIMAL NOT NULL, 
    changed_at TEXT NOT NULL 
);
"
db = SQLite.DB("test.db")

SQLite.execute!(db, sql)

does not create the correct SQLite db.

[ValentinKaisermayer]

It seems that execute! only takes one SQL statement at a time.

[quinnj]

Currently, we just pass whatever the input string is straight to the sqlite engine. We could potentially split the input string on ; and loop through the results. Maybe we just do that for SQLite.execute! though, since it wouldn't really make sense for SQLite.query.

[quinnj]

sqlite doesn't really offer great support for this