public void dropSecurityProfile()
{
string secProfileName = "SECURITY";
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.createSecurityProfile("SECURITY");
db.addUser("Juan", "123456", "SECURITY");
db.dropSecurityProfile(secProfileName);
Assert.IsFalse(db.SecProfiles.ContainsKey(secProfileName));
Dictionary <string, User> .KeyCollection users = db.Users.Keys;
int i = 0;
foreach (string user in users)
{
User us = db.Users[user];
if (!us.SecurityProfiles.Contains(secProfileName))
{
Assert.IsFalse(us.SecurityProfiles.Contains(secProfileName));
}
}
}
public void writteloadUsers()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
if (db.Users.ContainsKey("ane") && db.Users.ContainsKey("yeray"))
{
User user1 = db.Users["ane"];
User user2 = db.Users["yeray"];
if (user1.Password.Equals("123") && user2.Password.Equals("321"))
{
if (user1.SecurityProfiles.Contains("profile1") && user2.SecurityProfiles.Contains("profile2"))
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
else
{
Assert.IsTrue(false);
}
}
else
{
Assert.IsTrue(false);
}
}
public void writeloadSecurity()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
if (db.SecProfiles.ContainsKey("profile1") && db.SecProfiles.ContainsKey("profile2"))
{
SecurityProfile sec1 = db.SecProfiles["profile1"];
SecurityProfile sec2 = db.SecProfiles["profile2"];
if (sec1.Privileges.ContainsKey("table") && sec2.Privileges.ContainsKey("table2"))
{
if (sec1.Privileges["table"].Contains(Privilege.SELECT) && sec1.Privileges["table"].Contains(Privilege.INSERT) && sec2.Privileges["table2"].Contains(Privilege.DELETE))
{
Assert.IsTrue(true);
}
}
else
{
Assert.IsTrue(false);
}
}
else
{
Assert.IsTrue(false);
}
}
public void delete()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.deletefile("BD");
Assert.IsFalse(File.Exists("BD"));
}
public void dropTable()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.dropTable("table");
Assert.IsFalse(db.Tables.ContainsKey("table"));
}
public void outputInsert()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string input = "INSERT INTO table VALUES ('data',5,5.05);";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.InsertSuccess));
}
public void outputDelete()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string input = "DELETE FROM table WHERE columnIntNumbers=1;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.TupleDeleteSuccess));
}
public void outputSelect()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string input = "SELECT columnIntNumbers FROM table WHERE columnIntNumbers=1;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals("['columnIntNumbers'] {'1'}"));
}
public void createTable()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
List <String> list = new List <string>();
db.createTable("newTable", list);
Assert.IsTrue(db.Tables.ContainsKey("newTable"));
}
public void outputUpdate()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string input = "UPDATE table SET columnIntNumbers=5 WHERE columnIntNumbers=1;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.TupleUpdateSuccess));
}
public void outputCreateTable()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string input = "CREATE TABLE table444 (column1 DOUBLE,column2 TEXT);";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.CreateTableSuccess));
}
// [TestMethod]
public void deleteData()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
Table table = db.Tables["table"];
Column column = table.Columns["column"];
column.deleteData(0);
Assert.IsTrue(column.list[0] != "data");
}
public void outputCreateSecurityProfile()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string input = "CREATE SECURITY PROFILE Employee;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.SecurityProfileCreated));
}
public void outputDropTable()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string input = "DROP TABLE table;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.TableDroppedSucess));
}
public void deleteData()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.deleteData("table", "column", Operator.Equal, "data");
Table table = db.Tables["table"];
Column column = table.Columns["column"];
Assert.IsFalse(column.list.Contains("data"));
}
public void createColumn()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
Table table = db.Tables["table"];
table.createColumn("column1", Library.Type.Text);
Assert.IsTrue(table.Columns.ContainsKey("column1"));
}
// [TestMethod]
/*public void updateData()
* {
* BDcreation.BDcreatioon();
* DataBase db = new DataBase();
* db.load("BD");
*
* Table table = db.Tables["table"];
* Column column = table.Columns["column"];
* string data = column.list[0];
*
* column.updateData("newdata", Operator.Equal, "data");
*
*
* string newdata = column.list[0];
*
* Assert.IsFalse(data == newdata);
* }
*/
// [TestMethod]
public void insert()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
Table table = db.Tables["table"];
Column column = table.Columns["column"];
column.insert("newData");
Assert.IsTrue(column.list.Contains("newData"));
}
public void existUser()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
Assert.IsTrue(db.existUser("yeray", "321"));
Assert.IsFalse(db.existUser("Borja", "123"));
Assert.IsFalse(db.existUser("ane", "789"));
}
public void deleteUser()
{
string user = "******";
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.createSecurityProfile("SECURITY");
db.addUser("Juan", "123456", "SECURITY");
db.deleteUser(user);
Assert.IsFalse(db.Users.ContainsKey(user));
}
public void createSecurityProfile()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
string secProf = "SECURITY";
db.createSecurityProfile(secProf);
SecurityProfile sp = db.SecProfiles[secProf];
Assert.IsTrue(secProf.Equals(sp.Name));
}
public void outputDeleteUser()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
string input = "DELETE USER yeray;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.SecurityUserDeleted));
}
public void outputAddUser()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
string input = "ADD USER ('Eva','1234',profile2);";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.SecurityUserAdded));
}
public void outputRevokePrivilege()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
string input = "REVOKE SELECT ON table TO profile1;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.SecurityPrivilegeRevoked));
}
public void outputGrantPrivilege()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
string input = "GRANT SELECT ON table2 TO profile2;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.SecurityPrivilegeGranted));
}
public void outputDropSecurityProfile()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
string input = "DROP SECURITY PROFILE profile1;";
string output = db.output(input, db.admin);
Assert.IsTrue(output.Equals(Constants.SecurityProfileDeleted));
}
public void update()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
Table table = db.Tables["table"];
Column column = table.Columns["column"];
db.update("table", "column", "newdata", "column", Operator.Equal, "data");
string newdata = column.list[0];
Assert.IsTrue("newdata" == newdata);
}
public void hasPrivilege()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.loadSecurity();
db.loadUsers();
User user = db.Users["yeray"];
Assert.IsTrue(db.hasPrivilege(user, "table2", Privilege.DELETE));
Assert.IsFalse(db.hasPrivilege(user, "table", Privilege.SELECT));
Assert.IsFalse(db.hasPrivilege(user, "table2", Privilege.SELECT));
}
public void revoke()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
db.createSecurityProfile("SECURITY");
Library.Privilege privilegeType = Library.Privilege.SELECT;
string table = "table";
string securityProfile = "SECURITY";
db.grant(privilegeType, table, securityProfile);
db.revoke(privilegeType, table, securityProfile);
Assert.IsFalse(db.SecProfiles[securityProfile].Privileges[table].Contains(privilegeType));
}
public void selectToString()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
Operator op = Operator.Equal;
IList <string> listColumns = new List <string>();
listColumns.Add("columnIntNumbers");
string select = db.select(listColumns, "table", "columnIntNumbers", op, "1").selectToString();
string result = "['columnIntNumbers'] {'1'}";
Assert.IsTrue(result.Equals(select));
}
public void select()
{
BDcreation.BDcreatioon();
DataBase db = DataBase.load("BD");
IList <string> list = new List <string>();
list.Add("column");
list.Add("columnIntNumbers");
Table table = db.select(list, "table", "column", Operator.Equal, "data");
Assert.IsTrue(table.Columns["columnIntNumbers"].list.Contains("1"));
//Assert.IsTrue(table.Columns.ContainsKey("column"));
}
