public void Update_GodArguments_TheQueryUpdateTheNewsRows() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); string c1FirstRowData = "aaa"; string c2FirstRowData = "1"; string c1SecondRowData = "aaaa"; string c2SecondRowData = "2"; Database database = new Database("TestInsert3"); ITable table = new Table("table1"); Column column1 = new Column("c1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.StringTypeKey)); Column column2 = new Column("c2", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.IntTypeKey)); Assert.IsTrue(column1.dataType.IsAValidDataType(c1FirstRowData)); Assert.IsTrue(column2.dataType.IsAValidDataType(c2FirstRowData)); Assert.IsTrue(column1.dataType.IsAValidDataType(c1SecondRowData)); Assert.IsTrue(column2.dataType.IsAValidDataType(c2SecondRowData)); table.AddColumn(column1); table.AddColumn(column2); database.AddTable(table); databaseContainer.AddDatabase(database); int rowCount = table.GetRowCount(); Select firstSelect = TestSelect.CreateSelect(databaseContainer, database.databaseName, table.tableName, true); firstSelect.ValidateParameters(); firstSelect.Execute(); Assert.AreEqual(0, firstSelect.GetAfectedRowCount()); Insert insert = CreateInsert(databaseContainer, database.databaseName, table.tableName); insert.AddValue(c1FirstRowData); insert.AddValue(c2FirstRowData); Assert.IsTrue(insert.ValidateParameters()); insert.Execute(); Select secondSelect = TestSelect.CreateSelect(databaseContainer, database.databaseName, table.tableName, true); secondSelect.ValidateParameters(); secondSelect.Execute(); Assert.IsTrue(firstSelect.GetAfectedRowCount() < secondSelect.GetAfectedRowCount()); Assert.IsTrue(column1.GetCells(c1FirstRowData).Count > 0); Assert.IsTrue(column2.GetCells(c2FirstRowData).Count > 0); Assert.AreEqual(rowCount + 1, table.GetRowCount()); Update update = CreateUpdate(databaseContainer, database.databaseName, table.tableName); update.AddValue(column1.columnName, c1FirstRowData); update.AddValue(column2.columnName, c2FirstRowData); Assert.IsTrue(update.ValidateParameters()); update.Execute(); Select thirdSelect = TestSelect.CreateSelect(databaseContainer, database.databaseName, table.tableName, true); thirdSelect.ValidateParameters(); thirdSelect.Execute(); Assert.IsTrue(firstSelect.GetAfectedRowCount() < thirdSelect.GetAfectedRowCount()); Assert.IsTrue(column1.GetCells(c1FirstRowData).Count > 0); Assert.IsTrue(column2.GetCells(c2FirstRowData).Count > 0); Assert.AreEqual(rowCount + 1, table.GetRowCount()); }
public void GrantDatabasePrivilege_AllParametersAreGood_GrantDatabasePrivilege() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); GrantDatabasePrivilege grantDatabasePrivilege = CreateGrantDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName); grantDatabasePrivilege.SetData(SystemeConstants.CreatePrivilegeName, SystemeConstants.DefaultProfile, SystemeConstants.DefaultDatabaseName); Assert.IsTrue(grantDatabasePrivilege.ValidateParameters()); grantDatabasePrivilege.Execute(); Select select = TestSelect.CreateSelect(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName, true); select.whereClause.AddCritery(SystemeConstants.PrivilegesOfProfilesOnDatabasesProfileColumnName, SystemeConstants.DefaultProfile, Operator.equal); select.whereClause.AddCritery(SystemeConstants.PrivilegesOfProfilesOnDatabasesDatabaseNameColumnName, SystemeConstants.DefaultDatabaseName, Operator.equal); select.whereClause.AddCritery(SystemeConstants.PrivilegesOfProfilesOnDatabasesPrivilegeColumnName, SystemeConstants.CreatePrivilegeName, Operator.equal); select.ValidateParameters(); select.Execute(); Assert.AreEqual(1, select.GetAfectedRowCount()); }