public async Task <RequestResult> AddTable(string dbName, string tableName)
{
try
{
IDataBaseService dataBase = await _fileHelper.GetDb(dbName);
dataBase.AddTable(tableName);
return(new RequestResult {
IsSuccess = true, Message = _setting.SuccessMessage
});
}
catch (Exception ex)
{
return(new RequestResult {
IsSuccess = false, Message = ex.Message
});
}
}
public void AddTable(string tableName)
{
_dataBaseService.AddTable(tableName);
}
public void Initialize()
{
string name = "EntityServiceTest";
long fileSize = 1000000;
string path = @"D:\Programming\4term\IT\Proj";
dataBaseService = new DataBaseService(name, path, fileSize);
dataBaseService.AddTable("Table1");
dataBaseService.AddTable("Table2");
dataBaseService.AddTable("Table3");
var table3 = dataBaseService.GetEntityService("Table3");
var table1 = dataBaseService.GetEntityService("Table1");
var table2 = dataBaseService.GetEntityService("Table2");
table2.AddColumn("Name2", DataValueType.StringDataValueTypeId);
table2.AddColumn("Age2", DataValueType.IntegerDataValueTypeId);
table2.AddColumn("Income2", DataValueType.IntegerDataValueTypeId);
var data2 = new List <List <object> >()
{
new List <object> {
"name1", 10, 3
},
new List <object> {
"name3", -12, 2
},
new List <object> {
"name2", 124, -10
}
};
table2.InsertRange(data2);
table1.AddColumn("Name", DataValueType.StringDataValueTypeId);
table1.AddColumn("Age", DataValueType.IntegerDataValueTypeId,
new List <IValidator> {
new Validator <int>(ComparsonType.Greater, 0)
});
table1.AddColumn("Income", DataValueType.IntegerDataValueTypeId);
var data = new List <List <object> >()
{
new List <object> {
"name1", 10, 1
},
new List <object> {
"name3", -12, 2
},
new List <object> {
"name2", 124, -10
}
};
table1.InsertRange(data);
table3.AddColumn("Name", DataValueType.StringDataValueTypeId, new List <IValidator> {
new Validator <string>(ComparsonType.Contains, "Test")
});
table3.AddColumn("ComplexInt", DataValueType.ComplexIntegerDataValueTypeId);
table3.AddColumn("ComplexReal", DataValueType.ComplexRealDataValueTypeId);
var data3 = new List <List <object> >()
{
new List <object> {
"Test1", new ComplexInteger {
RealValue = 1, ImageValue = -1
}, new ComplexReal {
RealValue = 1.5, ImageValue = 2.04
}
},
new List <object> {
"Test2", new ComplexInteger {
RealValue = 2, ImageValue = -5
}, new ComplexReal {
RealValue = 4.5, ImageValue = 2.04
}
},
new List <object> {
"Test3", new ComplexInteger {
RealValue = 1, ImageValue = -1
}, new ComplexReal {
RealValue = 1.7, ImageValue = 2.04
}
}
};
table3.InsertRange(data3);
_storage = StorageFactory.GetStorage(dataBaseService.DataBase);
}
