/// <summary>
/// Delete database structure
/// </summary>
/// <returns>errors</returns>
public List <string> CleanStructure()
{
var keyspace = Context.Config.Get("Keyspace");
var msgs = new List <string>();
var connection = GetCluster();
var manager = new KeyspaceManager(connection);
manager.DropKeyspace(keyspace);
return(msgs);
}
/// <summary>
/// Create database structure
/// </summary>
public List <string> CreateStructure()
{
var msgs = new List <string>();
var keyspace = Context.Config.Get("Keyspace");
var connection = GetCluster();
var manager = new KeyspaceManager(connection);
manager.TryAddKeyspace(keyspace, int.Parse(Context.Config.Get("Replication")));
var famManager = new ColumnFamilyManager(connection, keyspace);
famManager.TryAddColumnFamily("Machine", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type);
famManager.TryAddColumnFamily("User", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type);
famManager.TryAddColumnFamily("Status", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type);
famManager.TryAddColumnFamily("Task", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type);
famManager.TryAddColumnFamily("DataType", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type);
famManager.TryAddColumnFamily("DataSource", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type);
var columnDefs = new List <ColumnDef>
{
ColumnFamilyManager.NewColumnDefinition("RootId", true, ComparatorTypeEnum.BytesType),
};
famManager.TryAddColumnFamily("JobConfig", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type, columnDefs: columnDefs);
columnDefs = new List <ColumnDef>
{
ColumnFamilyManager.NewColumnDefinition("STA", true, ComparatorTypeEnum.BytesType), // status
};
famManager.TryAddColumnFamily("ScheduledJobs", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type, columnDefs: columnDefs);
famManager.TryAddColumnFamily("JobTracker", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type, columnDefs: columnDefs);
columnDefs = new List <ColumnDef>
{
ColumnFamilyManager.NewColumnDefinition("JID", true, ComparatorTypeEnum.BytesType), // jobid
ColumnFamilyManager.NewColumnDefinition("BID", true, ComparatorTypeEnum.BytesType), // bucket id
};
famManager.TryAddColumnFamily("JobData", ColumnTypeEnum.Standard, ComparatorTypeEnum.UTF8Type, columnDefs: columnDefs);
return(msgs);
}
