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); }