想学习一下集群的思想和思路，我在一台Windows机器下搭建了一个 Replica Sets + Sharding 测试集群环境。
Replica Set
副本集。简单的说集群中包含了多份数据，保证主节点挂掉了，备用节点继续提供数据服务。使用Replica Set来实现读写分离，通过在连接时指定或者在主库指定slaveOk，由Secondary来分担读的压力，Primary只承担写操作。
副本集使其组内的每个成员（member）在不同的mongod实例中具有相同的数据备份，这样可以将来自应用服务器的请求访问（request visit）得以均匀的分布在Replica Set的每一个成员所在的mongod实例上，用以减缓单台mongod服务器在请求负载上的压力。在一定时限内Replica Set能完成其组内成员数据的最终一致，这种备份机制是自动且对用户透明的。
详细请参考：Replication Introduction
Need to generate summary report:1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41public string GenerateSummarylHtmlReport(DataTable table)
{
int rowCount = table.Rows.Count;
int colCount = table.Columns.Count;
string summaryReport = " <html>";
summaryReport += "<h1 style='text-align:center'> Test Report</h1>";
summaryReport += "<body>";
summaryReport += "<table border = '1' cellspacing='0' cellpadding='2' width='100%'>";
summaryReport += "<tr style='background-color:#cccccc'><th>Select</th><th>Page Name</th><th>Repository</th><th>Status</th>" +
"<th>Detail</th><th>Start Time</th><th>End Time</th></tr>";
for (int i = 0; i < rowCount; i++)
{
summaryReport += "<tr>";
for (int j = 0; j < colCount; j++)
{
if (table.Rows[i][j].ToString() == "Failed")
{
summaryReport += "<td style='background-color:red'>" + table.Rows[i][j] + "</td>";
}
else if (table.Rows[i][j].ToString().IndexOf("Passed:") != -1)
{
string pageName = table.Rows[i][1].ToString();
string reportTime = table.Rows[i][5].ToString();
string startDate = reportTime.Split('-')[0].Trim();
string startTime = reportTime.Split('-')[1].Trim();
string formatStartDate = startDate.Split('/')[2] + startDate.Split('/')[0] + startDate.Split('/')[1];
string formatStartTime = startTime.Split(':')[0] + startTime.Split(':')[1] + startTime.Split(':')[2];
summaryReport += "<td><a href='" + formatStartDate + "/" + pageName + formatStartTime + ".html'>" + table.Rows[i][j] + "</td>";
}
else
{
summaryReport += "<td>" + table.Rows[i][j] + "</td>";
}
}
summaryReport += "</tr>";
}
summaryReport += "</table>";
summaryReport += "</body>";
summaryReport += "</html>";
return summaryReport;
}
When design selenium object management tool, need to generate html report from csv file, implement as below:1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29private static string ConvertCsvToHtml(string csvText)
{
//split the CSV, assume no commas or line breaks in text
List<List<string>> splitString = new List<List<string>>();
List<string> lineSplit = csvText.Split('\n').ToList();
foreach (string line in lineSplit)
{
splitString.Add(line.Split(',').ToList());
}
//encode text safely, and create table
string htmlReport = "<html>";
htmlReport += "<h1 style='text-align:center'> Test Report</h1>";
htmlReport += "<body>";
htmlReport += "<table border = '1' cellspacing='0' cellpadding='2' width='100%'>";
foreach(List<string> splitLine in splitString)
{
htmlReport += "<tr>";
foreach(string splitText in splitLine)
{
htmlReport += "<td>" + WebUtility.HtmlEncode(splitText) + "</td>";
}
htmlReport += "</tr>";
}
htmlReport += "</table>";
htmlReport += "</body>";
htmlReport += "</html>";
return htmlReport;
}
The script is as below:1
range = worksheet.get_Range(excelAPP.Cells[1, 1], excelAPP.Cells[1, colIndex]);
When i design this on VS 2010, it’s work fine, but i run on VS 2015, have an error:
Additional information: ‘object’ does not contain a definition for ‘get_Range’
Solution:1
range = worksheet.Range[worksheet.Cells[1, 1], worksheet.Cells[1, colIndex]];
In the previous blog, we introduced this article [Selenium Object Repository], or the detail info, please see Selenium Webdriver Object Repository and Object Recognition
We implement this tool with winform + c#, the below information just fyi, maybe not detail enough, include:
Just in case your’re looking for that feature - now it’s available :
If you want to run QuickTest in a minimized RDP (remote desktop protocol) session, and you are using an RDP 6.0 or later client, you can enable it by setting a registry value on the local computer:
QTP本身有就有很好的DataTable功能，所以我们可以利用以下方式来实现数据驱动：
1 | xls_Sheet_Index = 1 |
这里有一个问题就是QTP11及之前的版本不能支持Excel2007及发后的版本，如果我们用QTP11来做自动化，本身现在大家都是用的Excel2010，或者之后的版本，就会很麻烦。
最近做框架的时候，遇到一个问题，要把Array中的数据导出到Excel中去。
1 | dim arr(10,5) |
