public static Login CreateLogin(IDatabaseContainer container, IUserThread thread, string databaseName, string tableName)
{
Login login = new Login(container, thread);
login.targetDatabase = databaseName;
login.targetTableName = tableName;
return(login);
}
private Login CreateLogin(IMessage request, IDatabaseContainer container, IUserThread thread)
{
Login login = new Login(container, thread);
login.targetDatabase = SystemeConstants.SystemDatabaseName;
login.targetTableName = SystemeConstants.UsersTableName;
login.SetData(request.GetElementsContentByTagName(RequestAndRegexConstants.usernameTagName)[0], request.GetElementsContentByTagName(RequestAndRegexConstants.passwordTagName)[0]);
return(login);
}
public void Login_UserDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
IUserThread userThread = ObjectConstructor.GetFakeUserThread();
string doenstExistUsername = ShittyUtilities.GetDoesntExistUserName(databaseContainer);
Login login = CreateLogin(databaseContainer, userThread, SystemeConstants.SystemDatabaseName, SystemeConstants.UsersTableName);
login.SetData(doenstExistUsername, "aaaa");
Assert.IsFalse(login.ValidateParameters());
}
public void LoginUserExist_Login()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
IUserThread userThread = ObjectConstructor.GetFakeUserThread();
ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.UsersTableName);
string newUsername = ShittyUtilities.GetDoesntExistUserName(databaseContainer);
string password = "******";
Row row = table.CreateRowDefinition();
row.GetCell(SystemeConstants.UsersNameColumnName).data = newUsername;
row.GetCell(SystemeConstants.UsersPasswordColumnName).data = password;
table.AddRow(row);
Login login = CreateLogin(databaseContainer, userThread, SystemeConstants.SystemDatabaseName, SystemeConstants.UsersTableName);
login.SetData(newUsername, password);
Assert.IsTrue(login.ValidateParameters());
}
public Exit(IDatabaseContainer container, IUserThread userThread, ISystemeDatabaseModule databaseModule) : base(container, userThread)
{
this.databaseModule = databaseModule;
}
public AbstractQuery GetQuery(IMessage request, IUserThread thread)
{
IDatabaseContainer container = ((ISystemeDatabaseModule)this.systeme.GetSystemeModule(SystemeConstants.SystemeDatabaseModule)).GetDatabaseContainer();
AbstractQuery query = null;
string queryTag = request.GetElementsContentByTagName(RequestAndRegexConstants.queryTagName)[0];
switch (queryTag)
{
case RequestAndRegexConstants.selectQueryIdentificator:
query = this.CreateSelectQuery(request, container);
break;
case RequestAndRegexConstants.createUserQueryIdentificator:
query = CreateUserQuery(request, container);
break;
case RequestAndRegexConstants.insertQueryIdentificator:
query = this.CreateInsertQuery(request, container);
break;
case RequestAndRegexConstants.updateQueryIdentificator:
query = this.CreateUpdateQuery(request, container);
break;
case RequestAndRegexConstants.deleteQueryIdentificator:
query = this.CreateDeleteQuery(request, container);
break;
case RequestAndRegexConstants.dropTableQueryIdentificator:
query = this.CreateDropTableQuery(request, container);
break;
case RequestAndRegexConstants.createTableQueryIdentificator:
query = this.CreateCreateTableQuery(request, container);
break;
case RequestAndRegexConstants.createDatabaseQueryIdentificator:
query = this.CreateDatabaseQuery(request, container);
break;
case RequestAndRegexConstants.dropDatabaseQueryIdentificator:
query = this.DropDatabaseQuery(request, container);
break;
case RequestAndRegexConstants.createSecurityProfileQueryIdentificator:
query = CreateSecurityProfileQuery(request, container);
break;
case RequestAndRegexConstants.deleteUserQueryIdentificator:
query = CreateDeleteUserQuery(request, container);
break;
case RequestAndRegexConstants.grantDatabasePrivilegeQueryIdentificator:
query = CreateGrantDatabasePrivilege(request, container);
break;
case RequestAndRegexConstants.revokeDatabasePrivilegeQueryIdentificator:
query = CreateRevoqueDatabasePrivilege(request, container);
break;
case RequestAndRegexConstants.dropSecurityProfileQueryIdentificator:
query = CreateDropSecurityProfile(request, container);
break;
case RequestAndRegexConstants.grantTablePrivilegeQueryIdentificator:
query = CreateGrantPrivilege(request, container);
break;
case RequestAndRegexConstants.revokeTablePrivilegeQueryIdentificator:
query = CreateRevoquePrivilege(request, container);
break;
case RequestAndRegexConstants.loginQueryIdentificator:
query = CreateLogin(request, container, thread);
break;
case RequestAndRegexConstants.exitIdentificator:
query = CreateExit(container, thread, (ISystemeDatabaseModule)systeme.GetSystemeModule(SystemeConstants.SystemeDatabaseModule));
break;
}
query.username = thread.username;
query.SetPrivilegeModule((ISystemePrivilegeModule)this.systeme.GetSystemeModule(SystemeConstants.SystemePrivilegeModule));
return(query);
}
private Exit CreateExit(IDatabaseContainer container, IUserThread thread, ISystemeDatabaseModule databaseModule)
{
return(new Exit(container, thread, databaseModule));
}
public Login(IDatabaseContainer container, IUserThread userThread) : base(container, userThread)
{
}
public UserManipulationQuery(IDatabaseContainer container, IUserThread userThread) : base(container)
{
this.userThread = userThread;
}
