public void update(SavableData received)
{
received.LastUpdate = DateTime.UtcNow;
var data = new SavedDataDto <SavableData> {
Data = received,
Uid = received.Uid,
Type = received.GetType(),
Updated = DateTime.UtcNow,
};
var serialized = JsonConvert.SerializeObject(data);
var serializedUid = JsonConvert.SerializeObject(data.Uid);
var query = $"UPDATE {defaultTable} SET Data = '{serialized}' WHERE Uid = '{serializedUid}';";
executeVoidQuery(query);
}
public void insert(SavableData received)
{
received.CreationDate = DateTime.UtcNow;
received.LastUpdate = DateTime.UtcNow;
var data = new SavedDataDto <SavableData> {
Data = received,
Uid = received.Uid,
Type = received.GetType(),
Updated = DateTime.UtcNow
};
var serialized = JsonConvert.SerializeObject(data);
var globalType = JsonConvert.SerializeObject(received.GetType());
var serializedUid = JsonConvert.SerializeObject(data.Uid);
Console.WriteLine(globalType);
var query = $"INSERT INTO {defaultTable} (Uid, Type, Data) VALUES ( '{serializedUid}', '{globalType}', '{serialized}');";
executeVoidQuery(query);
}