public IEnumerable <Int64> GetUserIds(AnonymizeToken token)
{
return(Connect <long>((connection) =>
{
List <Int64> parentAndChildIds = new List <Int64>();
using (MySqlCommand cmd = new MySqlCommand())
{
const string PARENT_ID_PARAM = "@IN_PARENT_ID";
const string USER_ID_ATTRIBUTE = "USER_ID";
cmd.Connection = connection;
cmd.CommandText = "WEB_SPS_USER_USERID_AND_CHILDRENID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(PARENT_ID_PARAM, (Int64)token.UserId);
cmd.Parameters[PARENT_ID_PARAM].Direction = ParameterDirection.Input;
using (MySqlDataReader myReader = cmd.ExecuteReader())
{
while (myReader.Read())
{
if (!Convert.IsDBNull(myReader[USER_ID_ATTRIBUTE]))
{
parentAndChildIds.Add(myReader.GetInt64(USER_ID_ATTRIBUTE));
}
}
} //using myReader
} //using cmd
return parentAndChildIds.ToArray <Int64>();
}));
}
public void AnonymizeUser(AnonymizeToken token)
{
Connect((connection) =>
{
using (MySqlCommand cmd = new MySqlCommand())
{
const string PARENT_ID_PARAM = "@IN_PARENT_ID";
const string REASON_PARAM = "@IN_REASON";
const string CASCADE_PARAM = "@IN_CASCADE";
cmd.Connection = connection;
cmd.CommandText = "WEB_SPU_USER_ANONYMIZE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(PARENT_ID_PARAM, (Int64)token.UserId);
cmd.Parameters[PARENT_ID_PARAM].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue(REASON_PARAM, token.CanCascade);
cmd.Parameters[REASON_PARAM].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue(CASCADE_PARAM, (bool)token.CanCascade);
cmd.Parameters[CASCADE_PARAM].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}//using cmd
});
}
static void Retrieve(string[] args)
{
if (args.Length < 3)
{
Console.WriteLine("AnonymizeUser <a/r> <userId> <canCascade> <reason>");
return;
}
if (!Int64.TryParse(args[1], out var result))
{
Console.WriteLine("user id must be integer");
return;
}
if (!bool.TryParse(args[2], out var canCascade))
{
Console.WriteLine("canCascade must be boolean true or false");
return;
}
AnonymizeToken token = new AnonymizeToken(args[1], null, args[2]);
MySqlUtility mySql = new MySqlUtility();
BlobUtility blobUtility = new BlobUtility();
GdprUtility gdprUtility = new GdprUtility(blobUtility, mySql);
gdprUtility.Retrieve((token));
}
public void Anonymize(AnonymizeToken token)
{
IEnumerable <string> blobs = _mySqlUtility.GetBlobUrls(token);
foreach (var blob in blobs)
{
_blobUtility.DeleteBlob(blob);
}
;
_mySqlUtility.AnonymizeUser(token);
}
public IEnumerable <User> RetrieveUser(AnonymizeToken token)
{
List <User> users = new List <User>();
Connect((connection) =>
{
using (MySqlCommand cmd = new MySqlCommand())
{
const string USER_ID_PARAM = "@IN_USER_ID";
cmd.Connection = connection;
cmd.CommandText = "WEB_SPS_USER_RETRIEVE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(USER_ID_PARAM, (Int64)token.UserId);
cmd.Parameters[USER_ID_PARAM].Direction = ParameterDirection.Input;
using (MySqlDataReader myReader = cmd.ExecuteReader())
{
while (myReader.Read())
{
//TODO
users.Add(new User()
{
ID = (long)myReader["USER_ID"],
Parent = (long)myReader["USER_PARENT"],
ParentName = (string)myReader["USER_PARENT_NAME"],
FullName = (string)myReader["USER_FULL_NAME"],
FirstName = (string)myReader["USER_FIRST_NAME"],
LastName = (string)myReader["USER_LAST_NAME"],
Username = (string)myReader["USER_USERNAME"],
Email = (string)myReader["USER_EMAIL"],
Country = (string)myReader["USER_COUNTRY"],
Gender = (string)myReader["USER_GENDER"],
GenderId = (Enums.Gender)Enums.Gender.Parse(typeof(Enums.Gender), ((string)myReader["USER_GENDER"])),
Photo = (string)myReader["USER_PHOTO"],
Level = (Enums.UserLevel)Enums.UserLevel.Parse(typeof(Enums.UserLevel), ((string)myReader["USER_LEVEL"])),
Status = (int)myReader[0],
CreatedDate = ((DateTime)myReader["USER_CREATED_DATE"]).ToString(),
LoginDate = (string)myReader["USER_LOGIN_DATE"],
TimeZoneOffset = (short)myReader[0],
IsGrounded = (bool)myReader["USER_GROUNDED"],
DOB = System.Math.Abs(DateTime.UtcNow.Year - ((DateTime)myReader["USER_DOB"]).Year).ToString(),
Age = (int)myReader["YEAR"]
});
} //while
} //using myReader
} //using cmd
});
return(users);
}
public void Retrieve(AnonymizeToken token)
{
IEnumerable <string> blobUrlss = _mySqlUtility.GetBlobUrls(token);
foreach (var blobUrl in blobUrlss)
{
CloudBlob blob = _blobUtility.RetrieveBlob(blobUrl);
blob.DownloadToFile(blob.Name, FileMode.Create);
}
;
FileStream fileStream = null;
try
{
fileStream = File.OpenWrite(String.Concat(Guid.NewGuid().ToString(), ".txt"));
using (TextWriter textWriter = new StreamWriter(fileStream))
{
var users = _mySqlUtility.RetrieveUser(token);
foreach (var user in users)
{
textWriter.WriteLine(user.ToString());
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
finally
{
fileStream?.Close();
}
}
public IEnumerable <string> GetBlobUrls(AnonymizeToken token)
{
return(Connect <string>((connection) =>
{
List <string> blobs = new List <string>();
using (MySqlCommand cmd = new MySqlCommand())
{
const string PARENT_ID_PARAM = "@IN_PARENT_ID";
const string CASCADE_PARAM = "@IN_CASCADE";
const string USER_PHOTO_ATTRIBUTE = "USER_PHOTO";
cmd.Connection = connection;
cmd.CommandText = "WEB_SPS_USER_BLOBS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(PARENT_ID_PARAM, (Int64)token.UserId);
cmd.Parameters[PARENT_ID_PARAM].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue(CASCADE_PARAM, (bool)token.CanCascade);
cmd.Parameters[CASCADE_PARAM].Direction = ParameterDirection.Input;
using (MySqlDataReader myReader = cmd.ExecuteReader())
{
while (myReader.Read())
{
if (!myReader.IsDBNull(myReader.GetOrdinal(USER_PHOTO_ATTRIBUTE)))
{
blobs.Add(myReader.GetString(USER_PHOTO_ATTRIBUTE));
}
}
} //using myReader
} //using cmd
return blobs.ToArray <string>();
}));
}