public static void T_AsyncSocket1()
{
var connStr = GetMySqlConnString();
var conn = new MySqlConnection(connStr);
conn.Open(() =>
{
conn.UpdateMaxAllowPacket();
});
//conn.Close();
}
public static void T_InsertBlobData()
{
var connStr = GetMySqlConnString();
var conn = new MySqlConnection(connStr);
conn.Open();
conn.UpdateMaxAllowPacket();
//DropIfExist(conn);
//CreateNewTable(conn);
//InsertMore(conn);
//if (ReadAll(conn))
//{
// return;
//}
{
string sql = "drop table if exists test001";
var cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
{
string sql = "create table test001(col_id int(10) unsigned not null auto_increment, mydata longblob,primary key(col_id)) ENGINE=MyISAM DEFAULT CHARSET=latin1";
var cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
//create sample blob
byte[] data = CreateTestData();
uint lastInsertId = 0;
//int testdata_crc32 = 0;
{
string sql = "insert into test001(mydata) values(?mydata)";
var cmd = new MySqlCommand(sql, conn);
cmd.Prepare();
//testdata_crc32 = SharpConnect.CRC32Calculator.CalculateCrc32(data);
cmd.Parameters.AddWithValue("?mydata", data);
for(int i = 0; i < 5; i++)
{
cmd.ExecuteNonQuery();
}
lastInsertId = cmd.LastInsertedId;
}
{
if (lastInsertId > 0)
{
//test download back
string sql = "select mydata from test001 where col_id<=?col_id";
var cmd = new MySqlCommand(sql, conn);
cmd.Prepare();
cmd.Parameters.AddWithValue("?col_id", lastInsertId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
byte[] dataBuffer = reader.GetBuffer(0);
if (Match(data, dataBuffer))
{
Console.WriteLine("All Matching!!!");
}
else
{
Console.WriteLine("Some byte not match!!");
}
}
reader.Close();
}
}
conn.Close();
Report.WriteLine("ok");
}