X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Futils%2FMobileLedgerDatabase.java;h=32269fea612e7904b8daebade3fd2a87a47d3f24;hp=1c66f07d99c44351aace1e100ecdd198eaade6d3;hb=3ed17d6ccfa6aba1795d77ef24167fb9ef6a9ca1;hpb=e20e0d8049c843abfd8b9e2fd9da7461f9f8ab1c diff --git a/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java b/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java index 1c66f07d..32269fea 100644 --- a/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java +++ b/app/src/main/java/net/ktnx/mobileledger/utils/MobileLedgerDatabase.java @@ -33,6 +33,8 @@ import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.util.Locale; +import java.util.regex.Matcher; +import java.util.regex.Pattern; import static net.ktnx.mobileledger.utils.Logger.debug; @@ -87,7 +89,10 @@ public class MobileLedgerDatabase extends SQLiteOpenHelper { InputStreamReader isr = new InputStreamReader(res); BufferedReader reader = new BufferedReader(isr); + Pattern continuation = Pattern.compile("\\\\\\s*$"); + String line; + String sqlStatement = null; int line_no = 1; while ((line = reader.readLine()) != null) { if (line.startsWith("--")) { @@ -98,8 +103,20 @@ public class MobileLedgerDatabase extends SQLiteOpenHelper { line_no++; continue; } + if (sqlStatement == null) + sqlStatement = line; + else + sqlStatement = sqlStatement.concat(line); + + Matcher m = continuation.matcher(line); + if (m.matches()) { + line_no++; + continue; + } + try { - db.execSQL(line); + db.execSQL(sqlStatement); + sqlStatement = null; } catch (Exception e) { throw new RuntimeException( @@ -108,6 +125,10 @@ public class MobileLedgerDatabase extends SQLiteOpenHelper { line_no++; } + if (sqlStatement != null) + throw new RuntimeException( + String.format("Error applying %s: EOF after continuation", rev_file)); + db.setTransactionSuccessful(); } catch (IOException e) {