|
public static GetSystemData ( string system, decimal x, decimal y, decimal z ) : |
||
| system | string | |
| x | decimal | |
| y | decimal | |
| z | decimal | |
| return | ||
private static StarSystem DeserializeStarSystem(string systemName, string data, ref bool needToUpdate)
{
if (systemName == string.Empty || data == string.Empty)
{
return(null);
}
StarSystem result = null;
try
{
result = JsonConvert.DeserializeObject <StarSystem>(data);
if (result == null)
{
Logging.Info("Failed to obtain system for " + systemName + " from the SQLiteRepository");
}
}
catch (Exception)
{
Logging.Warn("Problem reading data for star system '" + systemName + "' from database, re-obtaining from source.");
try
{
result = DataProviderService.GetSystemData(systemName);
}
catch (Exception ex)
{
Logging.Warn("Problem obtaining data from source: " + ex);
result = null;
}
}
return(result);
}
private StarSystem DeserializeStarSystem(string systemName, string data, ref bool needToUpdate)
{
if (systemName == string.Empty || data == string.Empty)
{
return(null);
}
// Check our short term star system cache for a previously deserialized star system and return that if it is available.
if (starSystemCache.Contains(systemName))
{
return(starSystemCache.Get(systemName));
}
// Not found in memory, proceed with deserialization
StarSystem result;
try
{
result = JsonConvert.DeserializeObject <StarSystem>(data);
if (result == null)
{
Logging.Info("Failed to obtain system for " + systemName + " from the SQLiteRepository");
needToUpdate = true;
}
}
catch (Exception)
{
Logging.Warn("Problem reading data for star system '" + systemName + "' from database, re-obtaining from source.");
try
{
result = dataProviderService.GetSystemData(systemName);
result = dataProviderService.syncFromStarMapService(new List <StarSystem> {
result
})?.FirstOrDefault(); // Synchronize EDSM visits and comments
needToUpdate = true;
}
catch (Exception ex)
{
Logging.Warn("Problem obtaining data from source: " + ex);
result = null;
}
}
// Save the deserialized star system to our short term star system cache for reference
if (result != null)
{
starSystemCache.Add(result);
}
return(result);
}
public StarSystem GetOrFetchStarSystem(string name, bool fetchIfMissing = true)
{
StarSystem system = GetStarSystem(name, fetchIfMissing);
if (system == null)
{
if (fetchIfMissing)
{
system = DataProviderService.GetSystemData(name, null, null, null);
}
if (system != null)
{
insertStarSystem(system);
}
}
return(system);
}
public StarSystem GetOrCreateStarSystem(string name, bool fetchIfMissing = true)
{
StarSystem system = GetStarSystem(name, fetchIfMissing);
if (system == null)
{
if (fetchIfMissing)
{
system = DataProviderService.GetSystemData(name, null, null, null);
}
if (system == null)
{
system = new StarSystem();
system.name = name;
}
insertStarSystem(system);
}
return(system);
}
private StarSystem DeserializeStarSystem(string systemName, string data, ref bool needToUpdate)
{
if (systemName == string.Empty || data == string.Empty)
{
return(null);
}
StarSystem result;
try
{
result = JsonConvert.DeserializeObject <StarSystem>(data);
if (result == null)
{
Logging.Info("Failed to obtain system for " + systemName + " from the SQLiteRepository");
needToUpdate = true;
}
}
catch (Exception)
{
Logging.Warn("Problem reading data for star system '" + systemName + "' from database, re-obtaining from source.");
try
{
result = dataProviderService.GetSystemData(systemName);
result = dataProviderService.syncFromStarMapService(new List <StarSystem> {
result
})?.FirstOrDefault(); // Synchronize EDSM visits and comments
needToUpdate = true;
}
catch (Exception ex)
{
Logging.Warn("Problem obtaining data from source: " + ex);
result = null;
}
}
return(result);
}
public StarSystem GetStarSystem(string name, bool refreshIfOutdated = true)
{
if (!File.Exists(DbFile))
{
return(null);
}
StarSystem result = null;
try
{
bool needToUpdate = false;
using (var con = SimpleDbConnection())
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = SELECT_BY_NAME_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@name", name);
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = JsonConvert.DeserializeObject <StarSystem>(rdr.GetString(2));
if (result == null)
{
Logging.Info("Failed to obtain system for " + name);
}
if (result != null)
{
if (result.visits < 1)
{
// Old-style system; need to update
result.visits = rdr.GetInt32(0);
result.lastvisit = rdr.GetDateTime(1);
needToUpdate = true;
}
if (result.lastupdated == null)
{
result.lastupdated = rdr.GetDateTime(4);
}
if (result.comment == null)
{
if (!rdr.IsDBNull(4))
{
result.comment = rdr.GetString(4);
}
}
if (refreshIfOutdated && result.lastupdated < DateTime.Now.AddDays(-7))
{
// Data is stale
StarSystem updatedResult = DataProviderService.GetSystemData(name, null, null, null);
updatedResult.visits = result.visits;
updatedResult.lastvisit = result.lastvisit;
updatedResult.lastupdated = DateTime.Now;
result = updatedResult;
needToUpdate = true;
}
}
}
}
}
con.Close();
}
if (needToUpdate)
{
updateStarSystem(result);
}
}
catch (Exception ex)
{
Logging.Warn("Problem obtaining data: " + ex);
}
// TODO if star system data is out-of-date then refresh it
return(result);
}
public StarSystem GetStarSystem(string name, bool refreshIfOutdated = true)
{
if (!File.Exists(DbFile))
{
return(null);
}
StarSystem result = null;
try
{
bool needToUpdate = false;
using (var con = SimpleDbConnection())
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = SELECT_BY_NAME_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@name", name);
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
string data = rdr.GetString(2);
// Old versions of the data could have a string "No volcanism" for volcanism. If so we remove it
data = data.Replace(@"""No volcanism""", "null");
result = JsonConvert.DeserializeObject <StarSystem>(data);
if (result == null)
{
Logging.Info("Failed to obtain system for " + name);
}
if (result != null)
{
if (result.visits < 1)
{
// Old-style system; need to update
result.visits = rdr.GetInt32(0);
result.lastvisit = rdr.GetDateTime(1);
needToUpdate = true;
}
if (result.lastupdated == null)
{
result.lastupdated = rdr.GetDateTime(4);
}
if (result.comment == null)
{
if (!rdr.IsDBNull(4))
{
result.comment = rdr.GetString(4);
}
}
if (refreshIfOutdated && result.lastupdated < DateTime.UtcNow.AddHours(-1))
{
// Data is stale
StarSystem updatedResult = DataProviderService.GetSystemData(name, null, null, null);
updatedResult.visits = result.visits;
updatedResult.lastvisit = result.lastvisit;
updatedResult.lastupdated = DateTime.UtcNow;
result = updatedResult;
needToUpdate = true;
}
}
}
}
}
}
if (needToUpdate)
{
updateStarSystem(result);
}
}
catch (Exception)
{
Logging.Warn("Problem reading data from database, re-obtaining from source.");
try
{
result = DataProviderService.GetSystemData(name, null, null, null);
updateStarSystem(result);
}
catch (Exception ex)
{
Logging.Warn("Problem obtaining data from source: " + ex);
result = null;
}
}
return(result);
}
public StarSystem GetStarSystem(string name, bool refreshIfOutdated = true)
{
if (!File.Exists(DbFile))
{
return(null);
}
StarSystem result = null;
try
{
bool needToUpdate = false;
using (var con = SimpleDbConnection())
{
con.Open();
using (var cmd = new SQLiteCommand(con))
{
cmd.CommandText = SELECT_BY_NAME_SQL;
cmd.Prepare();
cmd.Parameters.AddWithValue("@name", name);
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
string data = rdr.GetString(2);
// Old versions of the data could have a string "No volcanism" for volcanism. If so we remove it
data = data.Replace(@"""No volcanism""", "null");
try
{
result = JsonConvert.DeserializeObject <StarSystem>(data);
if (result == null)
{
Logging.Info("Failed to obtain system for " + name + " from the SQLiteRepository");
}
if (result != null)
{
if (result.visits < 1)
{
// Old-style system; need to update
result.visits = rdr.GetInt32(0);
result.lastvisit = rdr.GetDateTime(1);
needToUpdate = true;
}
if (result.lastupdated == null)
{
result.lastupdated = rdr.GetDateTime(4);
}
if (result.comment == null)
{
if (!rdr.IsDBNull(4))
{
result.comment = rdr.GetString(4);
}
}
}
if (refreshIfOutdated && result.lastupdated < DateTime.UtcNow.AddHours(-1))
{
// Data is stale
StarSystem updatedResult = DataProviderService.GetSystemData(name);
if (updatedResult.systemAddress == null && result.systemAddress != null)
{
// The "updated" data might be a basic system, empty except for the name.
// If so, return the old result.
return(result);
}
else
{
updatedResult.visits = result.visits;
updatedResult.lastvisit = result.lastvisit;
updatedResult.lastupdated = DateTime.UtcNow;
result = updatedResult;
needToUpdate = true;
}
}
}
catch (Exception)
{
Logging.Warn("Problem reading data for star system '" + name + "' from database, re-obtaining from source. ");
try
{
result = DataProviderService.GetSystemData(name);
// Recover data unique to the local user and database
IDictionary <string, object> system = Deserializtion.DeserializeData(data);
system.TryGetValue("visits", out object visitVal);
result.visits = (int)(long)visitVal;
system.TryGetValue("comment", out object commentVal);
result.comment = (string)commentVal;
system.TryGetValue("lastvisit", out object lastVisitVal);
result.lastvisit = (DateTime?)lastVisitVal;
result.lastupdated = DateTime.UtcNow;
needToUpdate = true;
}
catch (Exception ex)
{
Logging.Warn("Problem obtaining data from source: " + ex);
result = null;
}
}
}
}
}
}
if (needToUpdate)
{
updateStarSystem(result);
}
}
catch (SQLiteException)
{
Logging.Warn("Problem reading data for star system '" + name + "' from database, refreshing database and re-obtaining from source.");
RecoverStarSystemDB();
GetStarSystem(name);
}
return(result);
}
public List <StarSystem> GetStarSystems(string[] names, bool refreshIfOutdated = true)
{
if (!File.Exists(DbFile))
{
return(null);
}
if (names.Count() == 0)
{
return(null);
}
List <StarSystem> results = new List <StarSystem>();
List <StarSystem> systemsToUpdate = new List <StarSystem>();
List <KeyValuePair <string, string> > dataSets = Instance.ReadStarSystems(names);
foreach (KeyValuePair <string, string> kv in dataSets)
{
bool needToUpdate = false;
StarSystem result = null;
if (kv.Value != null && kv.Value != "")
{
string name = kv.Key;
// Old versions of the data could have a string "No volcanism" for volcanism. If so we remove it
string data = ((string)kv.Value)?.Replace(@"""No volcanism""", "null");
// Determine whether our data is stale (We won't deserialize the the entire system if it's stale)
IDictionary <string, object> system = Deserializtion.DeserializeData(data);
system.TryGetValue("visits", out object visitVal);
system.TryGetValue("comment", out object commentVal);
system.TryGetValue("lastvisit", out object lastVisitVal);
system.TryGetValue("lastupdated", out object lastUpdatedVal);
system.TryGetValue("systemAddress", out object systemAddressVal);
int visits = (int)(long)visitVal;
string comment = (string)commentVal ?? "";
DateTime?lastvisit = (DateTime?)lastVisitVal;
DateTime?lastupdated = (DateTime?)lastUpdatedVal;
long? systemAddress = (long?)systemAddressVal;
if (lastvisit == null || lastupdated == null || comment == "")
{
if (Instance.OldDataFormat(name, ref visits, comment, ref lastupdated, ref lastvisit))
{
needToUpdate = true;
}
}
if (refreshIfOutdated && lastupdated < DateTime.UtcNow.AddHours(-1))
{
// Data is stale
StarSystem updatedResult = DataProviderService.GetSystemData(name);
if (updatedResult.systemAddress == null && systemAddress != null)
{
// The "updated" data might be a basic system, empty except for the name. If so, return the old result.
updatedResult = DeserializeStarSystem(name, data, ref needToUpdate);
}
else
{
needToUpdate = true;
}
result = updatedResult;
}
else
{
// Data is fresh
result = DeserializeStarSystem(name, data, ref needToUpdate);
}
result.visits = visits;
result.comment = comment;
result.lastvisit = lastvisit;
result.lastupdated = DateTime.UtcNow;
if (needToUpdate)
{
systemsToUpdate.Add(result);
}
}
results.Add(result);
}
Instance.updateStarSystems(systemsToUpdate);
return(results);
}
