Method createDB

common_tools/src/main/java/com/icodici/db/Db.java:255–286

(final String migrationResource)

    }

    public void createDB(final String migrationResource) {
        if (migrationResource == null)
            return;
        try {
            myVersion = 0;
            try {
                Integer v = queryOne("SELECT ivalue FROM vars WHERE name = 'version'");
                if (v != null)
                    myVersion = v;
            } catch (SQLException e) {
                if (e.getMessage().indexOf("vars") < 0)
                    e.printStackTrace();
            }
            currentDbVersion = detectMaxMigrationVersion(migrationResource);
            log.d("My db version is %d current is %d", myVersion, currentDbVersion);
            while (myVersion < currentDbVersion) transaction(() -> {
                log.d("Migrating to %d", myVersion + 1);
                preMigrate(myVersion);
                executeFile(migrationResource + myVersion + ".sql");
                postMigrate(myVersion);
                myVersion++;
                update("update vars set ivalue=? where name='version'", myVersion);
                return null;
            });
        } catch (RuntimeException e) {
            throw e;
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException("migrations failed", e);
        }
        log.d("Db migrated successfully");
    }

    private int detectMaxMigrationVersion(String migrationResource) {
        if (migrationResource == null || migrationResource.length() == 0)