public void CreateTable_BadArgumentsTwoColumnsWithSameName_DontCreateNewTableAndNotifiedInResult() { IDatabaseContainer container = ObjectConstructor.CreateDatabaseContainer(); Database database = new Database("testDatabase"); container.AddDatabase(database); string tableName = "testTable"; Assert.IsFalse(database.ExistTable(tableName)); Create create = CreateCreate(container, database.databaseName, tableName); Tuple <string, string> columnAndType = new Tuple <string, string>("c1", TypesKeyConstants.StringTypeKey); create.AddColumn(columnAndType.Item1, columnAndType.Item2); create.AddColumn(columnAndType.Item1, columnAndType.Item2); Assert.IsFalse(create.ValidateParameters()); create.Execute(); Console.WriteLine(create.GetResult()); }
public void CreateTable_GoodArguments_TableExists_DontCreateNewTableAndNoticedinValidateParameters() { IDatabaseContainer container = ObjectConstructor.CreateDatabaseContainer(); Database database = new Database("testDatabase"); ITable table = new Table("table1"); database.AddTable(table); container.AddDatabase(database); Assert.IsTrue(database.ExistTable(table.tableName)); //( ͡° ͜ʖ ͡°) Create create = CreateCreate(container, database.databaseName, table.tableName); create.AddColumn("rellenuto", TypesKeyConstants.StringTypeKey); Assert.IsFalse(create.ValidateParameters()); create.Execute(); Console.WriteLine(create.GetResult()); }
public void CreateTable_GoodArguments_TableDoenstExist_CreateNewTable() { IDatabaseContainer container = ObjectConstructor.CreateDatabaseContainer(); Database database = new Database("testDatabase"); container.AddDatabase(database); string tableName = "testTable"; Assert.IsFalse(database.ExistTable(tableName)); Create create = CreateCreate(container, database.databaseName, tableName); List <Tuple <string, string> > columnsAndTypes = new List <Tuple <string, string> >() { new Tuple <string, string>("c1", TypesKeyConstants.StringTypeKey), new Tuple <string, string>("c2", TypesKeyConstants.IntTypeKey), new Tuple <string, string>("c3", TypesKeyConstants.DoubleTypeKey) }; foreach (Tuple <string, string> tuple in columnsAndTypes) { create.AddColumn(tuple.Item1, tuple.Item2); } Assert.IsTrue(create.ValidateParameters()); create.Execute(); Assert.IsTrue(database.ExistTable(tableName)); ITable table = database.GetTable(tableName); bool allColumnExist = true; bool correctDataType = true; for (int i = 0; i < columnsAndTypes.Count && allColumnExist; i++) { allColumnExist = table.ExistColumn(columnsAndTypes[i].Item1); if (allColumnExist) { correctDataType = table.GetColumn(columnsAndTypes[i].Item1).dataType.GetSimpleTextValue().Equals(columnsAndTypes[i].Item2); } } Assert.IsTrue(allColumnExist); Assert.IsTrue(correctDataType); Console.WriteLine(create.GetResult()); }