insertDefaultValues method

Future<bool> insertDefaultValues()

Implementation

Future<bool> insertDefaultValues() async {
  ConfigurationDto configurationDto;
  bool updateConfigTable=!(await doesTableExist());
  if(updateConfigTable) {
    await initializeTable();
    print(sqlCommands.dbType.toString() +
        " Inserting Default Values for Configuration Table");
    try {
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.HOME_COUNTRY_ONLY,
          0,
          0,
          null,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.FIELDS_NEXT_SYNC_CHANGES_TS,
          0,
          null,
          null,
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.FIELDS_SYNC_INTERVAL_MINS,
          0,
          6,
          null,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.READ_SERVER_URL,
          0,
          UrlTools.C_SERVER_PORT,
          UrlTools.C_SERVER_ADDRESS,
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.READ_SERVER_URL,
          1,
          UrlTools.C_SERVER_PORT,
          UrlTools.C_SERVER_ADDRESS,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.ROWS_LIMIT,
          0,
          100,
          null,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.ROWS_NEXT_SYNC_CHANGES_TS,
          0,
          null,
          null,
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.ROWS_SYNC_INTERVAL,
          0,
          0,
          "Manual",
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.ROWS_SYNC_INTERVAL,
          1,
          720,
          "12 Hours",
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.ROWS_SYNC_INTERVAL,
          2,
          1440,
          "1 Day",
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.ROWS_SYNC_INTERVAL_MINS,
          0,
          1440,
          null,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.SEND_CHANGES_DELAY,
          0,
          120,
          "2 Hours",
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.SEND_CHANGES_DELAY,
          1,
          360,
          "6 Hours",
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.SEND_CHANGES_DELAY,
          2,
          1440,
          "1 Day",
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.SEND_CHANGES_DELAY_MINS,
          0,
          120,
          null,
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.SEND_CHANGES_DELAY_OPTS,
          0,
          0,
          null,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.SERVER_TIME_OFFSET,
          0,
          0,
          null,
          defaults);
      await insertDto(configurationDto);
      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.SYNC_WIFI_ONLY,
          0,
          1,
          null,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.USER_ID,
          0,
          1,
          null,
          defaults);
      await insertDto(configurationDto);

      configurationDto = ConfigurationDto.sep(
          null,
          0,
          WardenType.USER,
          ConfigurationNameEnum.WRITE_SERVER_URL,
          0,
          UrlTools.C_SERVER_PORT,
          UrlTools.C_SERVER_ADDRESS,
          defaults);
      await insertDto(configurationDto);
    } on SqlException catch (e) {
      if (e.sqlExceptionEnum == SqlExceptionEnum.FAILED_UPDATE ||
          e.sqlExceptionEnum == SqlExceptionEnum.FAILED_SELECT) print(
          "DB $e");
    }
  }
  return updateConfigTable;
}