public void CreateDatabase_DatabaseDoenstExist_CreateDatabase()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string databaseName = VariousFunctions.GenerateRandomString(8);
while (databaseContainer.ExistDatabase(databaseName))
{
databaseName = VariousFunctions.GenerateRandomString(8);
}
CreateDatabase createDatabase = CreateCreateDatabase(databaseContainer, databaseName);
Assert.IsTrue(createDatabase.ValidateParameters());
createDatabase.Execute();
Assert.IsTrue(databaseContainer.ExistDatabase(databaseName));
}
public override bool ValidateParameters()
{
IDatabaseContainer container = this.GetContainer();
if (!container.ExistDatabase(this.targetDatabase))
{
this.SaveTheError(QuerysStringResultConstants.DatabaseDoesntExist(this.targetDatabase));
}
else
{
IDatabase targetDatabaseObject = container.GetDatabase(this.targetDatabase);
if (!targetDatabaseObject.ExistTable(this.targetTableName))
{
this.SaveTheError(QuerysStringResultConstants.TableDoensExist(this.targetDatabase, this.targetTableName));
}
else if (!this.GetPrivilegeModule().CheckProfileTablePrivileges(this.username, this.targetDatabase, this.targetTableName, this.GetNeededExecutePrivilege()))
{
this.SaveTheError("Not enought privileges");
}
else
{
this.DoTheOtherValidations(targetDatabaseObject.GetTable(this.targetTableName));
}
}
return(this.GetIsValidQuery());
}
public void Insert_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));
Insert insert = CreateInsert(databaseContainer, doenstExistDatabaseNames, "aa");
insert.AddValue("zz");
Assert.IsFalse(insert.ValidateParameters());
insert.Execute();
}
public void Select_BadArgument_DatabaseDoesntExit_NoticedInValidateParameters()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Database database = new Database("aa");
ITable table = new Table("table1");
string columnName = "c1";
Column column = new Column(columnName, DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.IntTypeKey));
table.AddColumn(column);
Row row = table.CreateRowDefinition();
row.GetCell(columnName).data = "1";
table.AddRow(row);
database.AddTable(table);
databaseContainer.AddDatabase(database);
string notValidDatabaseName = "bb";
Assert.IsFalse(databaseContainer.ExistDatabase(notValidDatabaseName));
Select select = CreateSelect(databaseContainer, notValidDatabaseName, table.tableName, true);
Assert.IsFalse(select.ValidateParameters());
select.Execute();
Assert.AreEqual(0, select.GetAfectedRowCount());
Console.WriteLine(select.GetResult());
}
private void CreateDefaultDatabase(ISystemeDatabaseModule databaseModule)
{
IDatabaseContainer databaseContainer = databaseModule.GetDatabaseContainer();
if (!databaseContainer.ExistDatabase(SystemeConstants.DefaultDatabaseName))
{
databaseContainer.AddDatabase(new Database(SystemeConstants.DefaultDatabaseName));
}
}
public static string NewDatabaseName(IDatabaseContainer container)
{
string databaseName = VariousFunctions.GenerateRandomString(12);
while (container.ExistDatabase(databaseName))
{
databaseName = VariousFunctions.GenerateRandomString(12);
}
return(databaseName);
}
public void DropDatabase_DatabaseDoesntExist_NoticeInValidate()
{
//Construct phase
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string databaseName = "tast1";
DropDatabase dropDatabase = CreateDropDatabase(databaseContainer, databaseName);
//Test phase
Assert.IsFalse(databaseContainer.ExistDatabase(databaseName));
Assert.IsFalse(dropDatabase.ValidateParameters());
}
private void CreateSystemDatabases(ISystemeDatabaseModule databaseModule)
{
IDatabaseContainer databaseContainer = databaseModule.GetDatabaseContainer();
if (!databaseContainer.ExistDatabase(SystemeConstants.SystemDatabaseName))
{
databaseModule.AddDatabase(DefaultDataConstructor.CreateSystemDatabase());
}
else
{
DefaultDataConstructor.CompleteSystemDatabase(databaseModule.GetDatabaseContainer().GetDatabase(SystemeConstants.SystemDatabaseName));
}
}
public void RevoqueDatabasePrivilege_DatabaseDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string databaseName = VariousFunctions.GenerateRandomString(8);
while (databaseContainer.ExistDatabase(databaseName))
{
databaseName = VariousFunctions.GenerateRandomString(8);
}
RevokeDatabasePrivilege revoqueDatabasePrivilege = CreateRevoqueDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName);
revoqueDatabasePrivilege.SetData(SystemeConstants.DefaultProfile, databaseName, SystemeConstants.CreatePrivilegeName);
Assert.IsFalse(revoqueDatabasePrivilege.ValidateParameters());
}
public void DropDatabase_DatabaseExist_DropDatabase()
{
//Construct phase
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Database database = new Database("database");
databaseContainer.AddDatabase(database);
DropDatabase dropDatabase = CreateDropDatabase(databaseContainer, database.databaseName);
//Test phase
Assert.IsTrue(dropDatabase.ValidateParameters());
dropDatabase.Execute();
Assert.IsFalse(databaseContainer.ExistDatabase(database.databaseName));
}
public void GrantPrivilege_DatabaseDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string randomDatabaseName = VariousFunctions.GenerateRandomString(8);
while (databaseContainer.ExistDatabase(randomDatabaseName))
{
randomDatabaseName = VariousFunctions.GenerateRandomString(8);
}
GrantPrivilege grantPrivilege = CreateGrantPrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName);
grantPrivilege.SetData(SystemeConstants.InsertPrivilegeName, SystemeConstants.DefaultProfile, randomDatabaseName, "aaa");
Assert.IsFalse(grantPrivilege.ValidateParameters());
}
public void Drop_GoodArguments_TableDroped()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Database database = new Database("aaa");
ITable table = new Table("table1"); //Realmente no hace falta ni añadir columnas ni nada para esta query
database.AddTable(table);
databaseContainer.AddDatabase(database);
Assert.IsTrue(databaseContainer.ExistDatabase(database.databaseName)); //Omitible, aunque nunca esta de mas por si acaso el problema esta en que en el container no se añaden las bases de datos
Drop drop = CreateDrop(databaseContainer, database.databaseName, table.tableName); //Aqui se añaden los parametros a la drop
Assert.IsTrue(drop.ValidateParameters()); //Poned esta linea en todos los test. En caso de que se metan parametros validos ponerla como Assert.IsTrue, en caso de que no, ponerla como Assert.IsFalse
drop.Execute();
Assert.IsFalse(database.ExistTable(table.tableName));
}
public void CreateDatabase_DatabaseExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string databaseName = VariousFunctions.GenerateRandomString(8);
while (databaseContainer.ExistDatabase(databaseName))
{
databaseName = VariousFunctions.GenerateRandomString(8);
}
IDatabase database = new Database(databaseName);
databaseContainer.AddDatabase(database);
CreateDatabase createDatabase = CreateCreateDatabase(databaseContainer, database.databaseName);
Assert.IsFalse(createDatabase.ValidateParameters());
}