public void TestMethod1()
{
Console.WriteLine("The UnitTest of Database Connection ! \n");
// ==DB Connection==
// Arrange
bool value = true;
List<string> dbTestInfo = new List<string>();
dbTestInfo.Clear();
dbTestInfo.Add("localhost");
dbTestInfo.Add("enricolu");
dbTestInfo.Add("111platform!");
dbTestInfo.Add("test");
// Act
DBConnection db = new DBConnection(dbTestInfo);
value = db.checkDBExist();
// Assert
Assert.AreEqual(value, true);
}
private void dbConnect_Click(object sender, EventArgs e)
{
if (dbServerBox.Text.Length * dbAcoountBox.Text.Length * dbPasswordBox.Text.Length * dbTableBox.Text.Length == 0)
{
MessageBox.Show("資料庫資訊不得為空！");
return;
}
dbInfo.Clear();
dbInfo.Add(dbServerBox.Text);
dbInfo.Add(dbAcoountBox.Text);
dbInfo.Add(dbPasswordBox.Text);
dbInfo.Add(dbTableBox.Text);
string errorMessage = "";
DBConnection conn = new DBConnection(dbInfo);
if (!conn.checkDBExist())
{
MessageBox.Show("資料庫連線資訊錯誤!!");
return;
}
errorMessage = conn.MySqlConnect();
if (errorMessage.Length > 0)
{
MessageBox.Show(errorMessage);
return;
}
else
{
accessTokenGroup.Enabled = true;
string sql = "select count(*) from access_token where 1";
MySqlDataReader res = conn.mysql_query(sql);
res.Read();
if (res.GetInt32(0) > 0)
{
res.Close();
sql = "select access_token from access_token where 1";
res = conn.mysql_query(sql);
res.Read();
accessTokenBox.Text = res.GetString(0);
pagesEditGroup.Enabled = true;
res.Close();
checkCanUpdate();
init_Timer();
}
else
{
res.Close();
MessageBox.Show("請先指定Access Token");
}
}
FileStream stream = new FileStream(dbInfoFileName, FileMode.OpenOrCreate);
StreamWriter writer = new StreamWriter(stream);
string baseServer = Convert.ToBase64String(System.Text.Encoding.Default.GetBytes(dbServerBox.Text));
string baseAccount = Convert.ToBase64String(System.Text.Encoding.Default.GetBytes(dbAcoountBox.Text));
string basePWD = Convert.ToBase64String(System.Text.Encoding.Default.GetBytes(dbPasswordBox.Text));
string baseTable = Convert.ToBase64String(System.Text.Encoding.Default.GetBytes(dbTableBox.Text));
writer.WriteLine(baseServer + ":" + baseAccount + ":" + basePWD + ":" + baseTable);
writer.Close();
stream.Close();
updatePageIDList();
conn.closeMySqlConnection();
dbConnInfo.Enabled = false;
}
