public void TestSelect()
{
TableColumn column = new TableColumn("name");
column.AddString("adolfo");
column.AddString("eider");
Condition condition = new Condition(Condition.Operations.equals, "adolfo", column.GetTableColumnName());
List <String> l = column.Select(condition);
foreach (String element in l)
{
Assert.AreEqual(element, "adolfo");
}
Assert.IsTrue(l.Count > 0);
TableColumn column2 = new TableColumn("numbers");
column2.AddString("6");
column2.AddString("9");
Condition condition2 = new Condition(Condition.Operations.min, "7", column2.GetTableColumnName());
List <String> list = column2.Select(condition2);
foreach (String element in list)
{
Assert.AreEqual("6", element);
}
}
public void TestDeleteFrom()
{
TableColumn names = new TableColumn("myColumn");
names.AddString("Ane");
names.AddString("Joseba");
names.DeleteFrom("Ane");
int num = names.GetColumns().Count;
Assert.AreEqual(1, num);
Boolean encontrado = false;
foreach (String element in names.GetColumns())
{
if (element.Equals("Ane"))
{
encontrado = true;
}
}
if (encontrado)
{
Assert.Fail();
}
}
public void TestSelectWhere()
{
m_db = new DB("db");
Table t = new Table("Tabla");
TableColumn columna1 = new TableColumn("Coches");
columna1.AddString("Renault");
columna1.AddString("Nissan");
columna1.AddString("Audi");
t.AddColumn(columna1);
TableColumn columna2 = new TableColumn("Propietarios");
columna2.AddString("Miren");
columna2.AddString("Claudia");
columna2.AddString("Pedro");
TableColumn columna3 = new TableColumn("Precio");
columna3.AddString("2000");
columna3.AddString("8520");
columna3.AddString("10000");
t.AddColumn(columna1);
t.AddColumn(columna2);
t.AddColumn(columna3);
m_db.AddTable(t);
}
public void TestUpdate()
{
DB db = new DB("MyDB", "admin", "admin");
Table t = new Table("People");
TableColumn column = new TableColumn("name");
column.AddString("Juan");
column.AddString("Pedro");
TableColumn column2 = new TableColumn("age");
column2.AddString("20");
column2.AddString("21");
string table = t.GetName();
t.AddColumn(column);
t.AddColumn(column2);
db.AddTable(t);
string colName = column.GetTableColumnName();
List <string> cols = new List <string>();
cols.Add(colName);
Condition condition = new Condition(Condition.Operations.equals, "Juan", column.GetTableColumnName());
List <string> values = new List <string>();
values.Add("David");
db.Update(cols, values, table, condition);
Assert.AreEqual("'David'", column.GetColumns()[0]);
Assert.AreEqual("20", column2.GetColumns()[0]);
}
public void TestSelectAllWhere()
{
m_db = new DB("db");
Table t = new Table("Tabla");
m_db.AddTable(t);
TableColumn columna1 = new TableColumn("Coches");
columna1.AddString("Renault");
columna1.AddString("Nissan");
columna1.AddString("Audi");
t.AddColumn(columna1);
TableColumn columna2 = new TableColumn("Propietarios");
columna2.AddString("Miren");
columna2.AddString("Claudia");
columna2.AddString("Pedro");
t.AddColumn(columna2);
Condition c = new Condition(Condition.Operations.equals, "Audi", "Coches");
Table table = m_db.SelectAllWhere("Tabla", c);
String s = table.ToString();
Assert.AreEqual("['Coches','Propietarios']{Audi,Pedro}", s);
}
public void TestGetPositions()
{
//List<int> positions = new List<int>();
TableColumn column = new TableColumn("name");
column.AddString("adolfo");
column.AddString("eider");
column.AddString("pepe");
Condition condition = new Condition(Condition.Operations.equals, "pepe", column.GetTableColumnName());
List <int> positions = column.GetPositions(condition);
foreach (int element in positions)
{
Assert.AreEqual(2, element);
}
}
public void TestSelectAll()
{
DB db = new DB("MyDB", "admin", "admin");
Table newTable = new Table("newTable");
TableColumn column = new TableColumn("a");
column.AddString("name");
column.AddString("surname");
string table = newTable.GetName();
newTable.AddColumn(column);
db.AddTable(newTable);
Table newTable2 = new Table("newTable2");
newTable2 = db.SelectAll(table);
Assert.AreEqual("['a']{name}{surname}", newTable2.ToString());
}
public void TestDeleteCondition()
{
TableColumn column = new TableColumn("name");
column.AddString("Ane");
column.AddString("Lara");
Condition condition = new Condition(Condition.Operations.equals, "Ane", column.GetTableColumnName());
List <String> names = column.GetColumns();
column.DeleteCondition(names, condition);
Assert.AreEqual(1, column.GetColumns().Count);
Boolean find = false;
foreach (String element in names)
{
if (element.Equals("Ane"))
{
find = true;
}
}
if (find)
{
Assert.Fail();
}
TableColumn column2 = new TableColumn("numbers");
column2.AddString("7");
column2.AddString("10");
Condition condition1 = new Condition(Condition.Operations.min, "8", column2.GetTableColumnName());
List <String> numbers = column2.GetColumns();
column2.DeleteCondition(numbers, condition1);
foreach (String element in column2.GetColumns())
{
Assert.AreEqual("10", element);
}
Assert.AreEqual(1, column2.GetColumns().Count);
}
public void TestAddColumn()
{
TableColumn names = new TableColumn("myColumn");
names.AddString("Ane");
int num = names.GetColumns().Count;
Assert.AreEqual(1, num);
}
public void TestDeleteFrom()
{
DB db = new DB("MyDB", "admin", "admin");
Table newTable = new Table("newTable");
TableColumn column = new TableColumn("a");
column.AddString("name");
column.AddString("surname");
string table = newTable.GetName();
newTable.AddColumn(column);
db.AddTable(newTable);
List <string> col = column.GetColumns();
Condition condition = new Condition(Condition.Operations.equals, "name", column.GetTableColumnName());
db.DeleteFrom(table, col, condition);
Assert.AreEqual("surname", col[0]);
}
public void TestGetValues()
{
TableColumn list = new TableColumn("numbers");
list.AddString("0");
list.AddString("1");
list.AddString("2");
list.AddString("3");
List <int> positions = new List <int>();
positions.Add(1);
List <string> list2 = new List <string>();
list2 = list.GetValues(positions);
string resultado = list2[0];
Assert.AreEqual(1, int.Parse(resultado));
}
