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 UpdateFKColumn_BadArguments_ConcretelyFKViolated_NotifyInValidate()
{
// C phase
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Database database = new Database("database");
Table table1 = new Table("t1");
Column c1table1 = new Column("column1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.StringTypeKey));
table1.AddColumn(c1table1);
table1.primaryKey.AddKey(c1table1);
Table table2 = new Table("t2");
Column c1table2 = new Column("column1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.StringTypeKey));
table2.AddColumn(c1table2);
table2.primaryKey.AddKey(c1table2);
table2.foreignKey.AddForeignKey(c1table2, c1table1);
Row r1 = table1.CreateRowDefinition();
r1.GetCell(c1table1.columnName).data = "asda";
table1.AddRow(r1);
Row r2 = table2.CreateRowDefinition();
r2.GetCell(c1table2.columnName).data = r1.GetCell(c1table1.columnName).data;
table2.AddRow(r2);
database.AddTable(table1);
database.AddTable(table2);
databaseContainer.AddDatabase(database);
// T phase
Update update = CreateUpdate(databaseContainer, database.databaseName, table2.tableName);
update.AddValue(c1table2.columnName, r2.GetCell(c1table2.columnName).data + "aaa");
Assert.IsFalse(update.ValidateParameters());
}
public void UpdatePKColumn_ThisIsIlegal_NoticeInValidate()
{
// C phase
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Database database = new Database("database");
Table table1 = new Table("t1");
Column c1 = new Column("column1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.StringTypeKey));
table1.AddColumn(c1);
table1.primaryKey.AddKey(c1);
Row row = table1.CreateRowDefinition();
row.GetCell(c1.columnName).data = "data";
table1.AddRow(row);
Row row2 = table1.CreateRowDefinition();
row.GetCell(c1.columnName).data = row.GetCell(c1.columnName).data + "a";
table1.AddRow(row2);
database.AddTable(table1);
databaseContainer.AddDatabase(database);
// T phase
Update update = CreateUpdate(databaseContainer, database.databaseName, table1.tableName);
update.AddValue(c1.columnName, row2.GetCell(c1.columnName).data);
update.whereClause.AddCritery(c1.columnName, row.GetCell(c1.columnName).data, OperatorFactory.GetOperatorFactory().GetOperator(OperatorKeys.EqualKey));
Assert.IsFalse(update.ValidateParameters());
}
public void Update_BadArguments_TheDataTypesDontMatch_NoticeInValidateParameters()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Database database = new Database("TestUpdate2");
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));
table.AddColumn(column1);
table.AddColumn(column2);
database.AddTable(table);
databaseContainer.AddDatabase(database);
string[] rowData = new string[] { "aaa", "aaa" };
Assert.IsFalse(column1.dataType.IsAValidDataType(rowData[0]) && column2.dataType.IsAValidDataType(rowData[1]));
int rowCount = table.GetRowCount();
Update update = CreateUpdate(databaseContainer, database.databaseName, table.tableName);
update.AddValue(column1.columnName, rowData[0]);
update.AddValue(column2.columnName, rowData[1]);
Assert.IsFalse(update.ValidateParameters());
update.Execute();
Assert.AreEqual(rowCount, table.GetRowCount());
}
public void Update_BadArguments_ConcretelyDatabaseDoesntExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string doenstExistDatabaseNames = VariousFunctions.GenerateRandomString(6);
while (databaseContainer.ExistDatabase(doenstExistDatabaseNames))
{
doenstExistDatabaseNames = VariousFunctions.GenerateRandomString(6);
}
Assert.IsFalse(databaseContainer.ExistDatabase(doenstExistDatabaseNames));
Update update = CreateUpdate(databaseContainer, doenstExistDatabaseNames, "aa");
update.AddValue("c1", "zz");
Assert.IsFalse(update.ValidateParameters());
update.Execute();
}
public void UpdateFKColumn_GoodArguments_DoTheUpdate()
{
// C phase
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Database database = new Database("database");
Table table1 = new Table("t1");
Column c1table1 = new Column("column1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.StringTypeKey));
table1.AddColumn(c1table1);
table1.primaryKey.AddKey(c1table1);
Table table2 = new Table("t2");
Column c1table2 = new Column("column1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.StringTypeKey));
table2.AddColumn(c1table2);
table2.foreignKey.AddForeignKey(c1table2, c1table1);
Row r1 = table1.CreateRowDefinition();
r1.GetCell(c1table1.columnName).data = "asda";
table1.AddRow(r1);
Row r2 = table1.CreateRowDefinition();
r2.GetCell(c1table1.columnName).data = r1.GetCell(c1table1.columnName).data + "a";
table1.AddRow(r2);
Row r3 = table2.CreateRowDefinition();
r3.GetCell(c1table2.columnName).data = r1.GetCell(c1table1.columnName).data;
table2.AddRow(r3);
database.AddTable(table1);
database.AddTable(table2);
databaseContainer.AddDatabase(database);
// T phase
Update update = CreateUpdate(databaseContainer, database.databaseName, table2.tableName);
update.AddValue(c1table2.columnName, r2.GetCell(c1table2.columnName).data);
update.whereClause.AddCritery(c1table2.columnName, r3.GetCell(c1table2.columnName).data, OperatorFactory.GetOperatorFactory().GetOperator(OperatorKeys.EqualKey));
Assert.IsTrue(update.ValidateParameters());
}
