private static void SeedDefaultInstance(DevFluffDataStore keyStore)
{
keyStore.AddOrUpdate(new DataStoreInstance
{
DateCreated = DateTime.UtcNow,
Name = "Default",
Description = "Default instance"
});
}
private static void SeedTable_Values(DevFluffDataStore keyStore)
{
var componentName = "Rn.KeyStore.Tables.Keys";
var currentVersion = keyStore.GetVersion(componentName);
if (currentVersion == null)
{
CreateTableFromScriptFile(keyStore, DataStoreTable.Keys);
keyStore.SetVersion(componentName, 1, 0, 0);
}
// todo: add in upgrade path logic...
}
// Table Seeders
private static void SeedTable_Versions(DevFluffDataStore keyStore)
{
var componentName = "Rn.KeyStore.Tables.Versions";
var currentVersion = new Version(0, 0, 0);
if (keyStore.CheckTableExists(DataStoreTable.Versions))
{
currentVersion = keyStore.GetVersion(componentName).Version;
}
if (currentVersion == Version.Parse("0.0.0"))
{
CreateTableFromScriptFile(keyStore, DataStoreTable.Versions);
keyStore.SetVersion(componentName, 1, 0, 0);
}
// todo: work in upgrade logic here...
}
// Helper Methods
private static void CreateTableFromScriptFile(DevFluffDataStore keyStore, string tableName)
{
var commandText = keyStore.GetSqlScript(tableName, "create_table");
keyStore.DbConnection.ExecuteNonQuery(commandText);
}
private static void SeedDefaultInstanceValues(DevFluffDataStore keyStore)
{
keyStore.SetKey("hello.world", "Hello World!");
keyStore.SetKey("hello.world", "Hello World!!");
}
private static void SeedTables(DevFluffDataStore keyStore)
{
SeedTable_Versions(keyStore);
SeedTable_Instances(keyStore);
SeedTable_Values(keyStore);
}
public void SeedDatabase(DevFluffDataStore keyStore)
{
SeedTables(keyStore);
SeedDefaultInstance(keyStore);
SeedDefaultInstanceValues(keyStore);
}