checkStyleTable method

void checkStyleTable()

Implementation

void checkStyleTable() {
  if (!_sqliteDb
      .hasTable(TableName(HM_STYLES_TABLE, schemaSupported: false))) {
    var createTablesQuery = '''
    CREATE TABLE $HM_STYLES_TABLE (
      tablename TEXT NOT NULL,
      sld TEXT,
      simplified TEXT
    );
    CREATE UNIQUE INDEX ${HM_STYLES_TABLE}_tablename_idx ON $HM_STYLES_TABLE (tablename);
  ''';
    var split = createTablesQuery.replaceAll("\n", "").trim().split(";");
    for (int i = 0; i < split.length; i++) {
      var sql = split[i].trim();
      if (sql.length > 0 && !sql.startsWith("--")) {
        _sqliteDb.execute(sql);
      }
    }
  }
}