| public WriteWhitespace ( string ws ) : void | ||
| ws | string | The string of white space characters. |
| return | void | |
/// <summary>
/// Writes this token to a <see cref="JsonWriter"/>.
/// </summary>
/// <param name="writer">A <see cref="JsonWriter"/> into which this method will write.</param>
/// <param name="converters">A collection of <see cref="JsonConverter"/> which will be used when writing the token.</param>
public override void WriteTo(JsonWriter writer, params JsonConverter[] converters) {
writer.WriteStartObject();
if (this.WithComment) {
var lPath = writer.Path;
var lState = writer.WriteState;
StringBuilder lComments = new StringBuilder();
int lLevel = (lPath.Split('.').Length + 1) * 2;
if (lPath == "") lLevel = 2;
writer.WriteWhitespace("\r\n");
for (int lCount = 0; lCount < mComment.Count; lCount++) {
if (lLevel > 0) writer.WriteWhitespace(new string(' ', lLevel));
writer.WriteRaw("//" + mComment[lCount]);
if (lCount + 1 < mComment.Count) writer.WriteWhitespace("\r\n");
}
}
var _properties = base.Properties();
foreach (var lProperty in _properties) {
lProperty.WriteTo(writer, converters);
}
writer.WriteEndObject();
//base.WriteTo(writer, converters);
}
public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
{
//if (value is hAxis)
//{
// writer.WritePropertyName("hAxis");
//}
//else if (value is vAxis)
//{
// writer.WritePropertyName("hAxis");
//}
writer.WriteWhitespace(" ");
string json = ((Axis)value).ToString();
writer.WriteRawValue(json);
}
private List<TestResult> GetTestResultFromOpsDB(SqlCommand command, JsonWriter serializer, DateTime dateToDump)
{
var compName = Environment.GetEnvironmentVariable("COMPUTERNAME") ?? "";
var envName = Environment.GetEnvironmentVariable("AS_ENV") ?? "";
var startTime = Formator.FormatDateTime(dateToDump.AddMinutes(-ConfigUtil.JobDumpIntervalMinute));
var endTime = Formator.FormatDateTime(dateToDump);
ALogger.LogInfo("GetTestResultFromOpsDB: Start {0} to {1} - Input {2}", startTime, endTime, dateToDump.ToString("yyyy-MM-dd HH:mm:ss"));
if (command == null || serializer == null)
{
ALogger.LogError("Not allowed to pass null to this method");
throw new NoNullAllowedException("Not allowed to pass null to this method");
}
var limit = "";
if (_recordLimit != null && _recordLimit > 0)
{
limit = " TOP " + _recordLimit + " ";
}
command.CommandTimeout = ConfigUtil.DBQueryTimeout;
command.CommandText = string.Format(
//"WAITFOR DELAY '000:01:10';" +
"SELECT " + limit + " m.UUID as 'uuid', " +
"'SystemTestApp' AS 'capb.name', " +
"'1.0' AS 'capb.version', " +
"'" + compName + "' AS 'capb.server', " +
//"*** '62' **** AS 'prod.name', " +
//"*** '127EIKON' ***** AS 'prod.vers', " +
"'RST' AS 'prod.component.name', " +
//"*** '127ST' **** AS 'prod.component.vers', " +
//"'' AS 'testID', => null" +
"m.UUID AS 'userProfile.uuid', " +
/* UserProfileAccountDomain => null*/
// "*** 61 **** AS 'userProfile.userName', " +
//"*** UIS **** AS 'userProfile.email', " +
//UserProfileContactName = (string)record["userProfile.contactName"],
//UserProfileLocation = (string)record["userProfile.location"],
//UserProfileCID = (string)record["userProfile.CID"],
//"*** UIS **** AS 'userProfile.geoCountry', " +
"'SystemTestApp' AS 'server.name', " +
"'1.0' AS 'server.version', " +
"'" + compName + "' AS 'server.compName', " +
"'" + envName + "' AS 'server.dataCenter', " +
"s.LastSeen AS 'server.wasDateTime', " +
"s.LastSeen AS 'server.dbsDateTime', " +
"'RST' AS 'client.name', " +
//"*** '127ST' **** AS 'client.version', " +
"m.MachineGUID AS 'machineID', " +
"'' AS 'runningMode', " +
//"*** 73 **** AS 'localDateTime', " +
"s.StatCode AS 'testcase.id', " +
"'' AS 'testcase.group', " +
"'' AS 'testcase.title', " +
"'' AS 'testcase.valid', " +
"s.StatValue AS 'testcase.value', " +
"'' AS 'testcase.description', " +
"'' AS 'testcase.rphURL', " +
"'' AS 'testcase.resultID', " +
"'' AS 'testcase.recommendation' " +
"FROM UserStats s LEFT JOIN UserMachineInstallations m " +
"ON (s.UserMachineInstallationID = m.UserMachineInstallationID) " +
"WHERE m.Product = 'est' " +
"AND s.LastSeen >= convert(datetime, '" + startTime + "') " +
"AND s.LastSeen <= convert(datetime, '" + endTime + "') "
);
var numberOfTestID = 0;
List<TestResult> testResult = null;
using (var dataReader = command.ExecuteReader())
{
var previousTestReferenceID = new DateTime(0);
while (dataReader.Read())
{
var record = dataReader as IDataRecord;
var timeStamp = (DateTime)record["server.dbsDateTime"];
if (timeStamp != previousTestReferenceID)
{
if (testResult == null)
{
testResult = new List<TestResult>();
}
var userDetails = UserInfo.GetUserDetails((string) record["uuid"]);
testResult.Add(new TestResult
{
UUID = (string)record["uuid"],
CapbName = (string)record["capb.name"],
CapbVers = (string)record["capb.version"],
CapbServer = (string)record["capb.server"],
//ProdName = (string)record["prod.name"], // 62
//ProdVers = (string)record["prod.vers"], // 127EIKON
ProdComponentName = (string)record["prod.component.name"],
//ProdComponentVers = (string)record["prod.component.vers"], // 127ST
//TestID = Convert.ToInt32(record["testID"]), null
UserProfileUUID = (string)record["userProfile.uuid"],
//UserProfileAccountDomain = (string)record["userProfile.accountDomain"], null
UserProfileUserName = (userDetails != null) ? userDetails.UserID : "",// UIS
UserProfileEmail = (userDetails != null) ? userDetails.Email : "", // UIS
//UserProfileContactName = (string)record["userProfile.contactName"], => null
//UserProfileLocation = (string)record["userProfile.location"], => null
//UserProfileCID = (string)record["userProfile.CID"], => null
UserProfileGeoCountry = (userDetails != null) ? userDetails.Country : "", // UIS
ServerName = (string)record["server.name"],
ServerVersion = (string)record["server.version"],
ServerCompName = (string)record["server.compName"],
ServerDatacenter = (string)record["server.dataCenter"],
ServerWasDateTime = (DateTime)record["server.wasDateTime"],
ServerDbsDateTime = (DateTime)record["server.dbsDateTime"],
ClientName = (string)record["client.name"],
//ClientVersion = (string)record["client.version"], // 127ST
MachineID = record["machineID"].ToString(),
RunningMode = (string)record["runningMode"], // blank
//LocalDateTime = (DateTime)record["localDateTime"], // 73
TestCases = new List<TestCase>()
});
previousTestReferenceID = timeStamp;
numberOfTestID++;
}
var statCode = DataMapper.MapStatCode((string)record["testcase.id"]);
var statValue = (string)record["testcase.value"];
testResult[numberOfTestID - 1].TestCases.Add(
new TestCase
{
ID = statCode,
Title = (string)record["testcase.title"], // blank
Group = (string)record["testcase.group"], // blank
Valid = (string)record["testcase.valid"], // blank
Value = statValue,
Description = (string)record["testcase.description"], // blank
Recommendation = (string)record["testcase.recommendation"], // blank
RphURL = (string)record["testcase.rphURL"], // blank
ResultID = (string)record["testcase.resultID"] // blank
}
);
switch (statCode)
{
case "62":
testResult[numberOfTestID - 1].ProdName = statValue;
break;
case "127EIKON":
testResult[numberOfTestID - 1].ProdVers = statValue;
break;
case "127ST":
testResult[numberOfTestID - 1].ProdComponentVers = statValue;
testResult[numberOfTestID - 1].ClientVersion = statValue;
break;
case "27": // timezone
testResult[numberOfTestID - 1].LocalDateTime = GetLocalTestTime(testResult[numberOfTestID - 1].ServerWasDateTime, statValue);
break;
/*case "73": // local time
break;*/
}
}
if (numberOfTestID == 0)
{
ALogger.LogWarn("DataDumper.GetTestResultFromOpsDB(): no any test data in specific peroid [{0} until {1}]", startTime, endTime);
return testResult;
}
for (var i = 0; i < numberOfTestID; i++)
{
var json = JsonConvert.SerializeObject(testResult[i]);
serializer.WriteStartObject();
serializer.WriteRaw(json);
serializer.WriteEndObject();
serializer.WriteWhitespace(Environment.NewLine);
}
}
return testResult;
}
private List<TestResult> GetTestResultFromSTDB(SqlCommand command, JsonWriter serializer, DateTime dateToDump)
{
var startTime = Formator.FormatDateTime(dateToDump.AddMinutes(-ConfigUtil.JobDumpIntervalMinute));
var endTime = Formator.FormatDateTime(dateToDump);
ALogger.LogInfo("GetTestResultFromSTDB: Start {0} to {1} - Input {2}", startTime, endTime, dateToDump.ToString("yyyy-MM-dd HH:mm:ss"));
if (command == null || serializer == null)
{
ALogger.LogError("Not allowed to pass null to this method");
throw new NoNullAllowedException("Not allowed to pass null to this method");
}
var limit = "";
if (_recordLimit != null && _recordLimit > 0)
{
limit = " TOP " + _recordLimit + " ";
}
command.CommandTimeout = ConfigUtil.DBQueryTimeout;
command.CommandText = string.Format(
//"WAITFOR DELAY '000:01:10';" +
"SELECT "+ limit +" US.userID AS 'uuid', " +
"SE.serverName AS 'capb.name'," +
"SE.serverVersion AS 'capb.version', " +
"SE.serverCompName AS 'capb.server', " +
"(select case when PD.productName is null then '' else PD.productName end) AS 'prod.name', " +
"(select case when PD.productVersion is null then '' else PD.productVersion end) AS 'prod.vers', " +
"'RST' AS 'prod.component.name', " +
"((select case when CL.clientName is null then '' else CL.clientName end) + ' ' + (select case when " +
"CL.clientVersion is null then '' else CL.clientVersion end)) AS 'prod.component.vers', " +
"CONVERT(varchar(10),TR.testID) AS 'testID', " +
"US.userID AS 'userProfile.uuid', " +
"(select case when US.userName is null then '' else US.userName end) AS 'userProfile.userName', " +
"(select case when US.userName is null then '' else US.userName end) AS 'userProfile.email', " +
"(select case when GL.geoCountry is null then '' else GL.geoCountry end) AS 'userProfile.geoCountry', " +
"SE.serverName AS 'server.name', " +
"SE.serverVersion AS 'server.version', " +
"SE.serverCompName AS 'server.compName', " +
"DC.dcSite AS 'server.dataCenter', " +
"'RST' AS 'client.name', " +
"((select case when CL.clientName is null then '' else CL.clientName end) + ' ' + (select case when CL.clientVersion is null then '' else CL.clientVersion end)) AS 'client.version', " +
"(select case when CL.machineID is null then '' else CL.machineID end) AS 'machineID', " +
"(select case when RU.runMOdeKey is null then '' else RU.runMOdeDesc end) AS 'runningMode'," +
"(select case when TR.localDateTime is null then '' else TR.localDateTime end) AS 'localDateTime', " +
"(select case when TR.wasDateTime is null then '' else TR.wasDateTime end) AS 'server.wasDateTime', " +
"(select case when TR.dbsDateTime is null then '' else TR.dbsDateTime end) AS 'server.dbsDateTime', " +
"(select case when RU.runModeKey is null then '' else RU.runModeDesc end) AS 'runningMode', " +
"TC.testCaseID AS 'testcase.id', " +
"isnull(TG.testGroupID,'') AS 'testcase.group', " +
"isnull(TC.testCaseName,'') AS 'testcase.title', " +
"isnull(VL.validDesc,'') AS 'testcase.valid', " +
"isnull(TCS.tcValue,'') AS 'testcase.value', " +
"(select case when isnull(TCS.tcDesc,'') = '-' then TCS.tcValue else isnull(TCS.tcDesc,'') end) AS 'testcase.description', " +
"isnull(TC.rphURL,'') AS 'testcase.rphURL', " +
"isnull(TCS.resultID,'') AS 'testcase.resultID', " +
"isnull(TCS.tcRecom,'') AS 'testcase.recommendation' " +
"FROM master_dataCenter DC, " +
"rstTestResult TR, " +
"master_user US, " +
"master_geoLocation GL, " +
"master_product PD, " +
"master_client CL, " +
"master_runMode RU, " +
"master_server SE, " +
"rstTestCases TCS, " +
"master_testGroup TG, " +
"master_testCase TC, " +
"master_valid VL " +
"WHERE TR.dcKey = DC.dcKey " +
"AND TR.userKey = US.userKey " +
"AND TR.geoLocationKey = GL.geoLocationKey " +
"AND TR.productKey = PD.productKey " +
"AND TR.clientKey = CL.clientKey " +
"AND TR.runMOdeKey = RU.runMOdeKey " +
"AND TR.serverKey = SE.serverKey " +
"AND TR.testKey = TCS.testKey " +
"AND TCS.validKey = VL.validKey " +
"AND TCS.testGroupKey = TG.testGroupKey " +
"AND TCS.testCaseKey = TC.testCaseKey " +
"AND TR.dbsDateTime >= convert(datetime, '" + startTime + "') " +
"AND TR.dbsDateTime <= convert(datetime, '" + endTime + "') " +
"ORDER BY TR.testID,testCaseOrd,testCaseName "
);
int numberOfTestID = 0;
List<TestResult> testResult = null;
using (var dataReader = command.ExecuteReader())
{
var previousTestReferenceID = string.Empty;
while (dataReader.Read())
{
var record = dataReader as IDataRecord;
var testID = (string)record["testID"];
if (testID != previousTestReferenceID)
{
if (testResult == null)
{
testResult = new List<TestResult>();
}
testResult.Add(new TestResult
{
UUID = (string)record["uuid"],
CapbName = (string)record["capb.name"],
CapbVers = (string)record["capb.version"],
CapbServer = (string)record["capb.server"],
ProdName = (string)record["prod.name"],
ProdVers = (string)record["prod.vers"],
ProdComponentName = (string)record["prod.component.name"],
ProdComponentVers = (string)record["prod.component.vers"],
TestID = Convert.ToInt32(record["testID"]),
UserProfileUUID = (string)record["userProfile.uuid"],
//UserProfileAccountDomain = (string)record["userProfile.accountDomain"],
UserProfileUserName = (string)record["userProfile.userName"],
UserProfileEmail = (string)record["userProfile.email"],
//UserProfileContactName = (string)record["userProfile.contactName"],
//UserProfileLocation = (string)record["userProfile.location"],
//UserProfileCID = (string)record["userProfile.CID"],
UserProfileGeoCountry = (string)record["userProfile.geoCountry"],
ServerName = (string)record["server.name"],
ServerVersion = (string)record["server.version"],
ServerCompName = (string)record["server.compName"],
ServerDatacenter = (string)record["server.dataCenter"],
ServerWasDateTime = (DateTime)record["server.wasDateTime"],
ServerDbsDateTime = (DateTime)record["server.dbsDateTime"],
ClientName = (string)record["client.name"],
ClientVersion = (string)record["client.version"],
MachineID = (string)record["machineID"],
RunningMode = (string)record["runningMode"],
LocalDateTime = (DateTime)record["localDateTime"],
TestCases = new List<TestCase>()
});
previousTestReferenceID = testID;
numberOfTestID++;
}
testResult[numberOfTestID - 1].TestCases.Add(
new TestCase
{
ID = (string) record["testcase.id"],
Title = (string) record["testcase.title"],
Group = (string) record["testcase.group"],
Valid = (string) record["testcase.valid"],
Value = (string) record["testcase.value"],
Description = (string) record["testcase.description"],
Recommendation = (string) record["testcase.recommendation"],
RphURL = (string) record["testcase.rphURL"],
ResultID = (string) record["testcase.resultID"]
}
);
}
if (numberOfTestID != 0)
{
for (var i = 0; i < numberOfTestID; i++)
{
var json = JsonConvert.SerializeObject(testResult[i]);
serializer.WriteStartObject();
serializer.WriteRaw(json);
serializer.WriteEndObject();
serializer.WriteWhitespace(Environment.NewLine);
}
}
}
return testResult;
}