public static MySqlConnector Instance()
{
if (_instance == null)
{
_instance = new MySqlConnector();
}
return(_instance);
}
private void GetData()
{
var dbCon = MySqlConnector.Instance();
if (dbCon.IsConnect())
{
//suppose col0 and col1 are defined as VARCHAR in the DB
string query = @"SELECT post_id, message FROM xf_post where message like '%[img]http://test.suineg.org%';";
var cmd = new MySqlCommand(query, dbCon.Connection);
MySqlDataReader reader = cmd.ExecuteReader();
messages = ConvertData(reader).ToList();
}
}
private void SaveData()
{
var dbCon = MySqlConnector.Instance();
dbCon.Connection.Close();
foreach (PostData postD in messages)
{
if (dbCon.IsConnect())
{
MySqlCommand command = dbCon.Connection.CreateCommand();
command.CommandText = $"UPDATE XF_POST SET message = @data WHERE Post_Id =@id";
command.Parameters.AddWithValue("@data", postD.Message);
command.Parameters.AddWithValue("@id", postD.PostId);
command.ExecuteNonQuery();
}
//dbCon.Connection.Close();
}
}
