public void IdentifierSanitizationOfGraphqlName(GraphqlName s)
{
var sanitized = NameSanitizer.SanitizeCsharpName(s.Name, null);
Assert.True(SyntaxFacts.IsValidIdentifier(sanitized));
Assert.True(SyntaxFacts.IsValidIdentifier(s.Name));
Assert.Equal(sanitized, s.Name);
}
/// <inheritdoc />
protected override PatternTest CreateTest(PatternEvaluationScope containingScope, IMethodInfo method)
{
PatternTest test = base.CreateTest(containingScope, method);
test.Name = NameSanitizer.MakeNameFromIdentifier(test.Name);
test.Kind = NBehaveTestKinds.Specification;
return(test);
}
/// <inheritdoc />
protected override PatternTest CreateTest(PatternEvaluationScope constainingScope, ITypeInfo type)
{
PatternTest test = base.CreateTest(constainingScope, type);
test.Name = NameSanitizer.MakeNameFromIdentifier(test.Name);
test.Kind = NBehaveTestKinds.Concern;
return(test);
}
public void IdentifierSanitization(AnyString anyString)
{
var sanitized = NameSanitizer.SanitizeCsharpName(anyString.Val, null);
Assert.True(SyntaxFacts.IsValidIdentifier(sanitized));
if (SyntaxFacts.IsValidIdentifier(anyString.Val))
{
Assert.Equal(sanitized, anyString.Val);
}
}
private static bool TryGetLaunchProfile(FileInfo file, out JsonElement launchProfile)
{
var launchSettingsPath = Path.Combine(file.DirectoryName, "Properties", "launchSettings.json");
if (!File.Exists(launchSettingsPath))
{
launchProfile = default;
return(false);
}
// If there's a launchSettings.json, then use it to get addresses
var root = JsonSerializer.Deserialize <JsonElement>(File.ReadAllText(launchSettingsPath));
var key = NameSanitizer.SanitizeToIdentifier(Path.GetFileNameWithoutExtension(file.Name));
var profiles = root.GetProperty("profiles");
return(profiles.TryGetProperty(key, out launchProfile));
}
public void UpdateCombinedRecords()
{
Console.WriteLine("Update combined records.");
using (MobileDataLib.MobileDataContext context = new MobileDataLib.MobileDataContext())
{
//DivisionDevice
foreach (var divisionDevice in context.DivisionDevices.ToList())
{
var combinedRecordExisting = context.CombinedRecords.Where(e => e.MobileNumber == divisionDevice.MobileNumber).FirstOrDefault();
if (combinedRecordExisting == null)
{
CombinedRecord combinedRecord = new CombinedRecord()
{
MobileNumber = divisionDevice.MobileNumber,
IsDataSourceDivisionDevice = true,
UserName_DivisionData = NameSanitizer.SanitizedName(divisionDevice.RawUserName)
};
context.CombinedRecords.Add(combinedRecord);
context.SaveChanges();
}
else
{
combinedRecordExisting.IsDataSourceDivisionDevice = true;
combinedRecordExisting.UserName_DivisionData = NameSanitizer.SanitizedName(divisionDevice.RawUserName);
context.SaveChanges();
}
}
//BlitzData
foreach (var blitzData in context.BlitzRecords.ToList())
{
var combinedRecordExisting = context.CombinedRecords.Where(e => e.MobileNumber == blitzData.MobileNumber).FirstOrDefault();
if (combinedRecordExisting == null)
{
CombinedRecord combinedRecord = new CombinedRecord()
{
MobileNumber = blitzData.MobileNumber,
IsDataSourceBlitzData = true,
UserName_BlitzData = NameSanitizer.SanitizedName(blitzData.RawUserName)
};
context.CombinedRecords.Add(combinedRecord);
context.SaveChanges();
}
else
{
combinedRecordExisting.IsDataSourceBlitzData = true;
combinedRecordExisting.UserName_BlitzData = NameSanitizer.SanitizedName(blitzData.RawUserName);
context.SaveChanges();
}
}
//FrancisData
foreach (var francisData in context.FrancisData.ToList())
{
var combinedRecordExisting = context.CombinedRecords.Where(e => e.MobileNumber == francisData.MobileNumber).FirstOrDefault();
if (combinedRecordExisting == null)
{
CombinedRecord combinedRecord = new CombinedRecord()
{
MobileNumber = francisData.MobileNumber,
IsDataSourceFrancis = true,
UserName_FrancisData = NameSanitizer.SanitizedName(francisData.RawUserName)
};
context.CombinedRecords.Add(combinedRecord);
context.SaveChanges();
}
else
{
combinedRecordExisting.IsDataSourceFrancis = true;
combinedRecordExisting.UserName_FrancisData = NameSanitizer.SanitizedName(francisData.RawUserName);
context.SaveChanges();
}
}
//Now see if usernames are consistent
bool IsConsistent = true; //Initial value
foreach (var combinedRecord in context.CombinedRecords.ToList())
{
if (combinedRecord.IsDataSourceDivisionDevice && !String.IsNullOrWhiteSpace(combinedRecord.UserName_DivisionData))
{
if (combinedRecord.IsDataSourceBlitzData && !String.IsNullOrWhiteSpace(combinedRecord.UserName_BlitzData))
{
if (combinedRecord.IsDataSourceFrancis && !String.IsNullOrWhiteSpace(combinedRecord.UserName_FrancisData))
{
IsConsistent = combinedRecord.UserName_DivisionData == combinedRecord.UserName_FrancisData &&
combinedRecord.UserName_DivisionData == combinedRecord.UserName_BlitzData;
}
else
{
IsConsistent = combinedRecord.UserName_DivisionData == combinedRecord.UserName_BlitzData;
}
}
else
{
if (combinedRecord.IsDataSourceFrancis && !String.IsNullOrWhiteSpace(combinedRecord.UserName_FrancisData))
{
IsConsistent = combinedRecord.UserName_FrancisData == combinedRecord.UserName_DivisionData;
}
//else
//{
// IsConsistent = true;
//}
}
}
else
{
if (combinedRecord.IsDataSourceBlitzData && !String.IsNullOrWhiteSpace(combinedRecord.UserName_BlitzData))
{
if (combinedRecord.IsDataSourceFrancis && !String.IsNullOrWhiteSpace(combinedRecord.UserName_FrancisData))
{
IsConsistent = combinedRecord.UserName_BlitzData == combinedRecord.UserName_FrancisData;
}
//else
//{
// IsConsistent = true;
//}
}
//else
//{
// if (combinedRecord.IsDataSourceFrancis)
// {
// IsConsistent = true;
// }
// else
// {
// IsConsistent = true;
// }
//}
}
combinedRecord.IsNameConsistent = IsConsistent;
context.SaveChanges();
}
//Now do a second loop to clean up data even further
foreach (var combinedRecord in context.CombinedRecords.ToList())
{
int nameCount = 0;
if (String.IsNullOrWhiteSpace(combinedRecord.UserName_BlitzData))
{
combinedRecord.UserName_BlitzData = String.Empty;
}
else
{
nameCount++;
}
if (String.IsNullOrWhiteSpace(combinedRecord.UserName_DivisionData))
{
combinedRecord.UserName_DivisionData = String.Empty;
}
else
{
nameCount++;
}
if (String.IsNullOrWhiteSpace(combinedRecord.UserName_FrancisData))
{
combinedRecord.UserName_FrancisData = String.Empty;
}
else
{
nameCount++;
}
if (String.IsNullOrWhiteSpace(combinedRecord.UserName_BlitzData) &&
String.IsNullOrWhiteSpace(combinedRecord.UserName_DivisionData) &&
String.IsNullOrWhiteSpace(combinedRecord.UserName_FrancisData))
{
combinedRecord.IsNameConsistent = true;
}
if (nameCount == 1)
{
combinedRecord.IsNameConsistent = true;
}
context.SaveChanges();
}
}
}
