public void TestValidReport()
{
using (MySqlDataManipulator manipulator = new MySqlDataManipulator())
{
manipulator.Connect(TestingConstants.ConnectionString);
var reportedUser = manipulator.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser2.Email))[0];
try
{
reportedUser.UpdateSettings(UserSettingsEntryKeys.DisplayName, "TerribleName");
Assert.IsTrue(manipulator.UpdateUsersSettings(reportedUser));
NetTestingUserUtils.AuthenticateTestingUser(TestingUserStorage.ValidUser1, manipulator);
var reportingUser = manipulator.GetUsersWhere(
string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser1.Email)
)[0];
var loginTokens = UserVerificationUtil.ExtractLoginTokens(reportingUser);
object[] contextAndRequest = ServerTestingMessageSwitchback.SwitchbackMessage(
TestingUserStorage.ValidUser1.ConstructReportMessage(
reportingUser.UserId,
loginTokens.LoginToken,
loginTokens.AuthToken,
"TerribleName"
), "POST"
);
var ctx = contextAndRequest[0] as HttpListenerContext;
var req = contextAndRequest[1] as HttpWebRequest;
HttpWebResponse resp = null;
TestApi.POST(ctx);
try {
resp = req.EndGetResponse(contextAndRequest[2] as IAsyncResult) as HttpWebResponse;
} catch (WebException) {
Assert.Fail("Received an error message when one was not expected");
}
Assert.AreEqual(HttpStatusCode.OK, resp.StatusCode);
reportedUser = manipulator.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser2.Email))[0];
var reportedUserSettings = JsonDataObjectUtil <List <UserSettingsEntry> > .ParseObject(reportedUser.Settings);
bool foundDisplayName = false;
foreach (UserSettingsEntry entry in reportedUserSettings)
{
if (entry.Key == UserSettingsEntryKeys.DisplayName)
{
foundDisplayName = true;
Assert.AreEqual("Default User " + reportedUser.UserId, entry.Value);
break;
}
}
Assert.IsTrue(foundDisplayName);
} finally
{
reportedUser.Settings = OverallUser.GenerateDefaultSettings();
Assert.IsTrue(manipulator.UpdateUsersSettings(reportedUser));
}
}
}
/// <summary>
/// <para>Uses the supplied <see cref="MySqlDataManipulator"/> to add the setting to all of the specified targets</para>
/// </summary>
/// <param name="manipulator"></param>
public override void PerformFunction(MySqlDataManipulator manipulator)
{
if (Target.Equals("user"))
{
var users = manipulator.GetUsersWhere("id > 0");
foreach (OverallUser user in users)
{
//Add the setting to the user if they do not already have a setting with the same key
List <UserSettingsEntry> settings = JsonDataObjectUtil <List <UserSettingsEntry> > .ParseObject(user.Settings);
bool found = false;
foreach (UserSettingsEntry entry in settings)
{
if (entry.Key.Equals(Key))
{
found = true;
break;
}
}
if (!found)
{
settings.Add(new UserSettingsEntry()
{
Key = Key, Value = Value
});
user.Settings = JsonDataObjectUtil <List <UserSettingsEntry> > .ConvertObject(settings);
if (!manipulator.UpdateUsersSettings(user))
{
Console.WriteLine("Failed to update settings for user " + user.UserId);
continue;
}
Console.WriteLine("Updated settings for user " + user.UserId);
continue;
}
Console.WriteLine("User " + user.UserId + " already had a setting with key " + Key);
}
}
else if (Target.Equals("company"))
{
var companies = manipulator.GetCompaniesWithNamePortion("");
foreach (CompanyId company in companies)
{
//Add the setting to the company if it does not already have one with the same key
int companyId = company.Id;
bool found = manipulator.GetCompanySettingsWhere(companyId, "SettingKey = \"" + Key + "\"").Count == 1;
if (!found)
{
if (!manipulator.AddCompanySetting(companyId, new CompanySettingsEntry(Key, Value)))
{
Console.WriteLine("Company " + company.LegalName + " failed to have the setting added");
continue;
}
Console.WriteLine("Successfully added setting for company " + company.LegalName);
continue;
}
Console.WriteLine("Company " + company.LegalName + " already had a setting with key " + Key);
}
}
}
public void TestRetrieveUserSettingsModifiedSettings()
{
using (MySqlDataManipulator manipulator = new MySqlDataManipulator())
{
manipulator.Connect(TestingConstants.ConnectionString);
Assert.IsTrue(NetTestingUserUtils.LogInTestingUser(TestingUserStorage.ValidUser1));
var user = manipulator.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser1.Email))[0];
user.UpdateSettings(UserSettingsEntryKeys.DisplayName, "New Name!");
manipulator.UpdateUsersSettings(user);
var currentSettings = user.Settings;
object[] contextAndRequest = ServerTestingMessageSwitchback.SwitchbackMessage(
TestingUserStorage.ValidUser1.ConstructRetrieveSettingsRequest(
user.UserId,
UserVerificationUtil.ExtractLoginTokens(user).LoginToken),
"PUT");
var ctx = contextAndRequest[0] as HttpListenerContext;
var req = contextAndRequest[1] as HttpWebRequest;
TestApi.PUT(ctx);
user.Settings = OverallUser.GenerateDefaultSettings();
Assert.IsTrue(manipulator.UpdateUsersSettings(user));
HttpWebResponse resp = null;
try
{
resp = req.EndGetResponse(contextAndRequest[2] as IAsyncResult) as HttpWebResponse;
}
catch (Exception e)
{
Assert.Fail(e.Message);
}
using (resp)
{
Assert.AreEqual(HttpStatusCode.OK, resp.StatusCode);
byte[] data = new byte[resp.ContentLength];
resp.GetResponseStream().Read(data, 0, data.Length);
string received = Encoding.UTF8.GetString(data);
Assert.AreEqual(currentSettings, received);
}
}
}
public void TestUpdateUserSetting()
{
using (MySqlDataManipulator manipulator = new MySqlDataManipulator())
{
manipulator.Connect(TestingConstants.ConnectionString);
Assert.IsTrue(NetTestingUserUtils.AuthenticateTestingUser(TestingUserStorage.ValidUser1, manipulator));
var user = manipulator.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser1.Email))[0];
user.Settings = OverallUser.GenerateDefaultSettings();
Assert.IsTrue(manipulator.UpdateUsersSettings(user));
var currentSettings = user.Settings;
var loginTokens = UserVerificationUtil.ExtractLoginTokens(user);
object[] contextAndRequest = ServerTestingMessageSwitchback.SwitchbackMessage(
TestingUserStorage.ValidUser1.ConstructChangeSettingRequest(
user.UserId,
loginTokens.LoginToken,
loginTokens.AuthToken,
UserSettingsEntryKeys.DisplayName,
"New Name #2!"),
"PATCH");
var ctx = contextAndRequest[0] as HttpListenerContext;
var req = contextAndRequest[1] as HttpWebRequest;
TestApi.PATCH(ctx);
HttpWebResponse resp = null;
try
{
resp = req.EndGetResponse(contextAndRequest[2] as IAsyncResult) as HttpWebResponse;
}
catch (Exception e)
{
Assert.Fail(e.Message);
}
using (resp)
Assert.AreEqual(HttpStatusCode.OK, resp.StatusCode);
user = manipulator.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser1.Email))[0];
var newSettings = JsonDataObjectUtil <List <UserSettingsEntry> > .ParseObject(user.Settings);
foreach (UserSettingsEntry entry in newSettings)
{
if (entry.Key == UserSettingsEntryKeys.DisplayName)
{
Assert.AreEqual("New Name #2!", entry.Value);
break;
}
}
}
}
public void TestBadRequestOnInvalidUserId()
{
using (MySqlDataManipulator manipulator = new MySqlDataManipulator())
{
manipulator.Connect(TestingConstants.ConnectionString);
Assert.IsTrue(NetTestingUserUtils.AuthenticateTestingUser(TestingUserStorage.ValidUser1, manipulator));
var user = manipulator.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser1.Email))[0];
user.Settings = OverallUser.GenerateDefaultSettings();
Assert.IsTrue(manipulator.UpdateUsersSettings(user));
var currentSettings = user.Settings;
var loginTokens = UserVerificationUtil.ExtractLoginTokens(user);
object[] contextAndRequest = ServerTestingMessageSwitchback.SwitchbackMessage(
TestingUserStorage.ValidUser1.ConstructChangeSettingRequest(
0,
loginTokens.LoginToken,
loginTokens.AuthToken,
UserSettingsEntryKeys.DisplayName,
"New Name #2!"),
"PATCH");
var ctx = contextAndRequest[0] as HttpListenerContext;
var req = contextAndRequest[1] as HttpWebRequest;
TestApi.PATCH(ctx);
HttpWebResponse resp = null;
try
{
resp = req.EndGetResponse(contextAndRequest[2] as IAsyncResult) as HttpWebResponse;
Assert.Fail("Expected an error response, but did not receive one");
}
catch (WebException e)
{
resp = e.Response as HttpWebResponse;
}
using (resp)
Assert.AreEqual(HttpStatusCode.BadRequest, resp.StatusCode);
}
}
/// <summary>
/// Request editing a user's setting's value. Documention is found in the Web API Enumeration file
/// in the User/Settings tab, starting at row 30
/// </summary>
/// <param name="ctx">The HttpListenerContext to respond to</param>
private void HandlePatchRequest(HttpListenerContext ctx)
{
try
{
#region Input Validation
if (!ctx.Request.HasEntityBody)
{
WriteBodyResponse(ctx, 400, "No Body", "Request lacked a body");
return;
}
UserSettingsEditRequest req = JsonDataObjectUtil <UserSettingsEditRequest> .ParseObject(ctx);
if (req == null)
{
WriteBodyResponse(ctx, 400, "Incorrect Format", "Request was in the wrong format");
return;
}
if (!ValidateEditRequest(req))
{
WriteBodyResponse(ctx, 400, "Incorrect Format", "Not all fields of the request were filled");
return;
}
#endregion
MySqlDataManipulator connection = new MySqlDataManipulator();
using (connection)
{
bool res = connection.Connect(MySqlDataManipulator.GlobalConfiguration.GetConnectionString());
if (!res)
{
WriteBodyResponse(ctx, 500, "Unexpected ServerError", "Connection to database failed");
return;
}
#region User Validation
var user = connection.GetUserById(req.UserId);
if (user == null)
{
WriteBodyResponse(ctx, 404, "Not Found", "User was not found on the server");
return;
}
if (!UserVerificationUtil.LoginTokenValid(user, req.LoginToken))
{
WriteBodyResponse(ctx, 401, "Unauthorized", "Login Token was expired or incorrect");
return;
}
if (!UserVerificationUtil.AuthTokenValid(user, req.AuthToken))
{
WriteBodyResponse(ctx, 401, "Unauthorized", "Auth Token was expired or incorrect");
return;
}
#endregion
#region Action Handling
if (!user.UpdateSettings(req.Key, req.Value))
{
WriteBodyResponse(ctx, 404, "NotFound", "Setting with key " + req.Key + " was not found.");
return;
}
if (!connection.UpdateUsersSettings(user))
{
WriteBodyResponse(ctx, 500, "Unexpected Server Error", "Exception: " + connection.LastException.Message);
return;
}
WriteBodylessResponse(ctx, 200, "OK");
#endregion
}
}
catch (HttpListenerException)
{
//HttpListeners dispose themselves when an exception occurs, so we can do no more.
}
catch (Exception e)
{
WriteBodyResponse(ctx, 500, "Internal Server Error", e.Message);
}
}