private void btnStart_Click(object sender, EventArgs e)
{
while (true)
{
try{
//test connection
lblStatus.Text = String.Format("DB Server : [{0}]", DBConfig.getDBUrl());
lblStatus.Refresh();
if (m_tu.conn.State == ConnectionState.Closed)
{
m_tu.conn.Open();
}
GrabAgent.trace_log("Mysql connection established.");
break;
}catch (Exception ex) {
DialogResult dr = MessageBox.Show(ex.Message + "\r\nPlease check config.xml file or contact DB Admin.\r\n Exit and reconfigure.",
"Mysql connection error.", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
if (dr == DialogResult.Abort)
{
Application.Exit(); return;
}
else if (dr == DialogResult.Ignore)
{
break;
}
else
{
continue;
}
}
}
try
{
retryInterval = Convert.ToInt32(txtInterval.Text);
}
catch (Exception)
{
txtInterval.Text = "10";
retryInterval = 10;
}
try
{
connectionTimeout = Convert.ToInt32(txtTimeout.Text);
}
catch (Exception)
{
txtTimeout.Text = "3";
connectionTimeout = 3;
}
btnStart.Enabled = false;
btnStop.Enabled = true;
groupBox1.Enabled = false;
m_tu.start();
}
public void start()
{
if (!bFirst)
{
url_construct();
GrabAgent.trace_log("Grab Started.");
theThread.Start();
return;
}
theThread.Resume();
GrabAgent.trace_log("Updating is running");
}
protected bool openConnection()
{
try
{
if (conn.State == ConnectionState.Open)
{
return(true);
}
conn.Open();
return(true);
}
catch (Exception ex)
{
GrabAgent.trace_err("Mysql connection failed.");
return(false);
}
}
public virtual bool grab_data(DateTime?theDay)
{
if (theDay == null)
{
this.iNow = SiteHelper.getFSSiteTime();
}
else
{
this.iNow = SiteHelper.toSecond(theDay);
}
GrabAgent.trace_log("Register data for time: " + iNow + "{");
String urlScore = String.Format(this.urlScoreT, iNow);
String gameData = SiteHelper.getSiteData(urlScore);
if (gameData == "")
{
this.iNow = 0; return(false);
}
deleteNowDayLog(iNow, this.GAME_TYPE);
return(_registerData(gameData));
GrabAgent.trace_log("\tFinish register for time: " + iNow + "}");
}
protected void deleteNowDayLog(int nowTime, int gtype)
{
int now = nowTime - (nowTime % (3600 * 24));
int next = now + 3600 * 24;
String sql = "delete from game_log where g_type=@1 and g_time>=@2 and g_time < @3";
MySqlCommand cmd = new MySqlCommand(sql, this.conn);
if (!openConnection())
{
return;
}
try{
cmd.Parameters.AddWithValue("@1", gtype);
cmd.Parameters.AddWithValue("@2", now);
cmd.Parameters.AddWithValue("@3", next);
cmd.ExecuteNonQuery();
}catch (Exception e) {
GrabAgent.trace_log(e.StackTrace);
}finally{
//closeConnection();
}
}
public void runUpdate()
{
bFirst = true;
DateTime dxT = SiteHelper.GetNISTDate();
for (int idx = -3; idx < 4; idx++) // today, 3 days before, 3 days future
{
grab_data(dxT.AddDays(idx));
}
int i = 0;
string szDecorate = "++++++++++++++++++++++";
Stopwatch sw = Stopwatch.StartNew();
long x = 0;
long preX = 0;
int retryInterval = Form1.retryInterval;
int a1 = 0, a2 = 0, a3 = 0;
while (true)
{
i %= 10;
i++;
Thread.Sleep(updateInterval);
syncData();
//GrabAgent.trace_log(this.AgentName +"\t" +szDecorate.Substring(i*2));
GrabAgent.trace_log(szDecorate.Substring(i * 2));
if (m_bRefresh == true)
{
GrabAgent.trace_log("============ Manual Refresh : " + DateTime.Now.ToString("yyyy/MM/dd") + "============");
grab_data();
m_bRefresh = false;
}
x = 1 + sw.ElapsedMilliseconds / 1000 / 60; //minutes
if (preX == x)
{
continue;
}
preX = x;
a1++;
a2++;
a3++;
if (a2 > Form1.retryInterval)
{
a2 = 0;
GrabAgent.trace_log("****** Now, retrying pre-failed game score refesh. ******");
regQueCheck();
}
if (a1 > 60) //1 hours : re_register
{
a1 = 0;
//refresh_sync
DateTime dt = SiteHelper.GetNISTDate();
GrabAgent.trace_log("============ Auto Refresh(interval 1 hr): " + dt.ToString("yyyy/MM/dd") + "============");
//dt = dt.add
grab_data(dt.AddDays(-1));
grab_data(dt);
grab_data(dt.AddDays(1));
}
if (x > 1440)
{ // a day after
sw.Reset();
DateTime dt = SiteHelper.GetNISTDate();
GrabAgent.trace_log("============ Auto Refresh(interval 1 day): " + dt.ToString("yyyy/MM/dd") + "============");
dt = dt.AddDays(-1);
for (int k = 0; k < 2; k++)
{
//continue;
dt = dt.AddDays(1);
grab_data(dt);
}
}
}
}
public void pause()
{
theThread.Suspend();
GrabAgent.trace_log("Updating is paused");
}
public static void mysqltest()
{
string MyConString = "SERVER=localhost;" +
"DATABASE=ssc;" +
"UID=root;" +
"PASSWORD=root;";
MySqlConnection connection = new MySqlConnection(MyConString);
//connection.ConnectionTimeout = 1000 * 10;
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select * from fl_area where fl_code = 'fl_1'";
MySqlDataAdapter da = new MySqlDataAdapter(command);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
da.Fill(ds);
dt = ds.Tables[0];
dt.Rows[0]["name"] = "Africa-africa";
//da.(dt);
//dt.AcceptChanges();
da.UpdateCommand = new MySqlCommand("update fl_area set name=@name where fl_code = 'fl_1'", connection);
da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 45, "name");
//da.UpdateCommand.Parameters.AddWithValue("@name", "Hello world");
da.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
try
{
da.Update(ds.Tables[0]);
}
catch (Exception e) {
e.ToString();
}
MySqlCommand cmd = new MySqlCommand("update fl_area set name=@name where fl_code = 'fl_1'", connection);
da.Fill(ds);
string ss;
for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
{
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
ss = ds.Tables[0].Rows[k]["g_time"].ToString();
}
}
da.SelectCommand.CommandText = "select * from fl_area f";
da.Fill(ds);
ss = ds.Tables[0].Rows[1][1].GetType().ToString();
try
{
connection.Open();
Reader = command.ExecuteReader();
command.CommandText = "select * from fl_area fa";
Reader = command.ExecuteReader();
while (Reader.Read())
{
string thisrow = "";
for (int i = 0; i < Reader.FieldCount; i++)
{
thisrow += Reader.GetValue(i).ToString() + ",";
}
}
Reader.Close();
connection.Close();
}
catch (Exception e)
{
GrabAgent.trace_log(e.Message);
}
}
private void Form1_Load(object sender, EventArgs e)
{
GrabAgent.setTraceHandle(this);
}
