public void TestSelectAll()
{
string password = "******";
Database database1 = new Database("aitor", "aitoru", password);
Table tab = new Table("Users", new List <TableColumn>());
TableColumn tablecolumn1 = new TableColumn("Name", "string");
tablecolumn1.AddValue("Alvaro");
tablecolumn1.AddValue("Ronny");
TableColumn tablecolumn2 = new TableColumn("Age", "int");
tablecolumn2.AddValue("20");
tablecolumn2.AddValue("22");
tab.AddTableColumn(tablecolumn1);
tab.AddTableColumn(tablecolumn2);
database1.AddTable(tab);
CompareWhere compared2 = new CompareWhere("Name", "Alvaro", "=");
Table newTab = database1.SelectAll(tab.GetName(), compared2, user);
Table tab1 = database1.SelectAll(tab.GetName(), null, user);
Assert.AreEqual("Users", tab1.GetName());
Assert.AreEqual(2, tab1.GetList().Count);
Assert.AreEqual("Alvaro", tab1.GetList().ElementAt(0).GetList().ElementAt(0));
Assert.AreEqual("Ronny", tab1.GetList().ElementAt(0).GetList().ElementAt(1));
Assert.AreEqual("20", tab1.GetList().ElementAt(1).GetList().ElementAt(0));
Assert.AreEqual("22", tab1.GetList().ElementAt(1).GetList().ElementAt(1));
Assert.AreEqual("Alvaro", newTab.GetList().ElementAt(0).GetList().ElementAt(0));
Assert.AreEqual(1, newTab.GetList().ElementAt(0).GetList().Count);
Assert.AreNotEqual("Margo", tab1.GetList().ElementAt(1).GetList().ElementAt(0));
}
public void TestUpdate()
{
string contraseña = "1234";
database = new Database("aitor", "aitoru", contraseña);
//Parameters that will be inserted in the function
List <string> setAttribute = new List <string>();
setAttribute.Add("Nombre");
setAttribute.Add("Apellido");
List <string> value = new List <string>();
value.Add("Aitor");
value.Add("Urabain");
string table = "Empleado";
CompareWhere compared = new CompareWhere("Nombre", "Ronny", "=");
//Creating the elements for changing with the update
Table tab = new Table("Empleado", new List <TableColumn>());
TableColumn tablecolumn1 = new TableColumn("Nombre", "string");
tablecolumn1.AddValue("Alvaro");
tablecolumn1.AddValue("Ronny");
TableColumn tablecolumn2 = new TableColumn("Apellido", "string");
tablecolumn2.AddValue("Margo");
tablecolumn2.AddValue("Caiza");
tab.AddTableColumn(tablecolumn1);
tab.AddTableColumn(tablecolumn2);
database.AddTable(tab);
// executing the update method
//user != admin
Assert.AreEqual(Messages.SecurityNotSufficientPrivileges, database.Update(setAttribute, value, table, compared, user2));
//user == admin
database.Update(setAttribute, value, table, compared, user);
// looking if it has changed
Boolean welldone = false;
foreach (TableColumn tc in tab.GetList())
{
if (tc.GetName() == "Nombre")
{
foreach (string st in tc.GetList())
{
if (st == "Aitor")
{
welldone = true;
}
}
}
}
Assert.AreEqual(true, welldone);
}
public void TestSelect()
{
string password = "******";
Database database1 = new Database("aitor", "aitoru", password);
//Creating elements for select method parameters
List <string> selects = new List <string>();
selects.Add("Name");
CompareWhere compared = new CompareWhere("Surname", "Caiza", "=");
Table tab = new Table("Employee", new List <TableColumn>());
TableColumn tablecolumn1 = new TableColumn("Name", "string");
tablecolumn1.AddValue("Alvaro");
tablecolumn1.AddValue("Ronny");
TableColumn tablecolumn2 = new TableColumn("Surname", "string");
tablecolumn2.AddValue("Margo");
tablecolumn2.AddValue("Caiza");
tab.AddTableColumn(tablecolumn1);
tab.AddTableColumn(tablecolumn2);
database1.AddTable(tab);
Table tableResult = new Table("Result", new List <TableColumn>());
TableColumn tcResult = new TableColumn("Name", "string");
tcResult.AddValue("Ronny");
tableResult.AddTableColumn(tcResult);
Table nullTable = new Table("nullTable", new List <TableColumn>());
nullTable.AddTableColumn(tcResult);
// executing the select method
Table result = database1.Select(tab.GetName(), selects, compared, user);
Assert.AreEqual("Ronny", result.GetList().ElementAt(0).GetList().ElementAt(0));
selects.Add("Surname");
CompareWhere compared2 = new CompareWhere("Name", "Alvaro", "=");
Table result2 = database1.Select(tab.GetName(), selects, compared2, user);
Assert.AreEqual("Alvaro", result2.GetList().ElementAt(0).GetList().ElementAt(0));
Assert.AreEqual("Margo", result2.GetList().ElementAt(1).GetList().ElementAt(0));
Assert.AreEqual("Ronny", nullTable.GetList().ElementAt(0).GetList().ElementAt(0));
}
public void TestToString()
{
Table tab = new Table("Users", new List <TableColumn>());
TableColumn tablecolumn1 = new TableColumn("Name", "string");
tablecolumn1.AddValue("Alvaro");
tablecolumn1.AddValue("Ronny");
TableColumn tablecolumn2 = new TableColumn("Age", "int");
tablecolumn2.AddValue("20");
tablecolumn2.AddValue("22");
tab.AddTableColumn(tablecolumn1);
tab.AddTableColumn(tablecolumn2);
String result = "['Name','Age']{'Alvaro','20'}{'Ronny','22'}";
Assert.AreEqual(result, tab.ToString());
}
public void TestDelete()
{
string contraseña = "1234";
database = new Database("aitor", "aitoru", contraseña);
CompareWhere compared = new CompareWhere("Nombre", "Ronny", "=");
//Creating the elements for changing with the update
Table tab = new Table("Empleado", new List <TableColumn>());
TableColumn tablecolumn1 = new TableColumn("Nombre", "string");
tablecolumn1.AddValue("Alvaro");
tablecolumn1.AddValue("Ronny");
TableColumn tablecolumn2 = new TableColumn("Apellido", "string");
tablecolumn2.AddValue("Margo");
tablecolumn2.AddValue("Caiza");
tab.AddTableColumn(tablecolumn1);
tab.AddTableColumn(tablecolumn2);
database.AddTable(tab);
// executing the update method
//user != admin
Assert.AreEqual(Messages.SecurityNotSufficientPrivileges, database.Delete(tab.GetName(), compared, user2));
//user == admin
database.Delete(tab.GetName(), compared, user);
// looking if it has changed
Boolean welldone = false;
foreach (TableColumn tc in tab.GetList())
{
foreach (string st in tc.GetList())
{
if (st == "Ronny")
{
welldone = true;
}
}
}
Assert.AreNotEqual(true, welldone);
}
public void TestSaveAndLoad()
{
string password = "******";
database = new Database("UnitTestDatabase", "UN", password);
Table tab = new Table("Employee", new List <TableColumn>());
TableColumn tablecolumn1 = new TableColumn("Name", "string");
tablecolumn1.AddValue("Alvaro");
tablecolumn1.AddValue("Ronny");
TableColumn tablecolumn2 = new TableColumn("Surname", "string");
tablecolumn2.AddValue("Margo");
tablecolumn2.AddValue("Caiza");
tab.AddTableColumn(tablecolumn1);
tab.AddTableColumn(tablecolumn2);
database.AddTable(tab);
database.Save();
Database db = Database.Load(database.GetName());
string result = "['Name','Surname']{'Alvaro','Margo'}{'Ronny','Caiza'}";
Assert.AreEqual(result, db.ToString());
}
public void TestAddValue()
{
Assert.AreEqual(0, tableColumn.GetList().Count);
tableColumn.AddValue("Aitor");
Assert.AreEqual(1, tableColumn.GetList().Count);
}
public void TestInsertInto()
{
string password = "******";
database = new Database("aitor", "aitoru", password);
//Creating the elements for data in Empleado table
Table tab = new Table("Empleado", new List <TableColumn>());
TableColumn tablecolumn1 = new TableColumn("Nombre", "string");
tablecolumn1.AddValue("Alvaro");
tablecolumn1.AddValue("Ronny");
TableColumn tablecolumn2 = new TableColumn("Apellido", "string");
tablecolumn2.AddValue("Margo");
tablecolumn2.AddValue("Caiza");
tab.AddTableColumn(tablecolumn1);
tab.AddTableColumn(tablecolumn2);
database.AddTable(tab);
//Creating the parameters for executing the method
string table = "Empleado";
List <string> columns = new List <string>();
columns.Add("Nombre");
List <string> values = new List <string>();
List <string> value2 = new List <string>();
values.Add("Unai");
values.Add("Ruiz");
value2.Add("Aitor");
// executing the insert method
//user != admin
Assert.AreEqual(Messages.SecurityNotSufficientPrivileges, database.InsertInto(table, null, values, user2));
//user == admin
database.InsertInto(table, null, values, user);
database.InsertInto(table, columns, value2, user);
// looking if it has changed
Boolean welldone = false;
Boolean welldone2 = false;
Boolean welldone3 = false;
foreach (TableColumn tc in tab.GetList())
{
foreach (string st in tc.GetList())
{
if (st == "Unai")
{
welldone = true;
}
if (st == "Ruiz")
{
welldone2 = true;
}
if (st == "Aitor")
{
welldone3 = true;
}
}
}
if (welldone == true && welldone2 == true && welldone3 == true)
{
welldone = true;
}
else
{
welldone = false;
}
Assert.AreEqual(true, welldone);
}