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;
}