private void RewriteActualDataSignatures(List <Dictionary <string, string> > keepers, List <Dictionary <string, string> > items)
{
try
{
DataKeepersDbConnector streaming = new DataKeepersDbConnector();
DataKeepersDbConnector local = new DataKeepersDbConnector();
local.ConnectToLocalStorage();
local.DropTableIfExists(typeof(KeeperSignature).Name);
local.CreateTable <KeeperSignature>();
streaming.ConnectToStreamingStorage();
streaming.DropTableIfExists(typeof(KeeperSignature).Name);
streaming.CreateTable <KeeperSignature>();
// generate sql
foreach (var keeper in keepers)
{
var kSignature = new KeeperSignature
{
KeeperName = keeper["Type"],
ItemType = keeper["Items"]
};
local.Insert(kSignature);
streaming.Insert(kSignature);
}
foreach (var item in items)
{
local.DropTableIfExists(item["Type"]);
streaming.DropTableIfExists(item["Type"]);
var query = GenerateCreateTableQueryFromSignature(item);
// Debug.Log(query);
if (!local.Query(query))
{
Debug.Log("Error when executing creating of table " + item["Type"]);
}
if (!streaming.Query(query))
{
Debug.Log("Error when executing creating of table " + item["Type"]);
}
}
local.Close();
streaming.Close();
Debug.Log("Current signatures rewrited successfully!");
}
catch (Exception e)
{
Debug.LogError("Signature rewriting error: " + e.Message);
}
}