public void TestItemsToJsonSpeed()
{
Log("-----------开始测试数据Json格式化速度----------------");
int count = 100000;
IDataItems items = new DataItems <MessageCore>(@"C:\Users\fhjun\Desktop\123.db");
for (int i = 0; i < count; i++)
{
items.Add(new MessageCore()
{
Content = "发送的消息的内容是的俄日文2342！32<>^*", Date = DateTime.Now.AddDays(i), SenderName = "张三", MessageType = "文本"
});
}
items.Commit();
items.Filter();
Stopwatch t = new Stopwatch();
t.Start();
using (StreamWriter sw = new StreamWriter(@"C:\Users\fhjun\Desktop\123.js", false, Encoding.UTF8))
{
sw.Write("var __data = [");
int r = 0;
foreach (var c in items.View)
{
if (r != 0)
{
sw.Write(",");
}
sw.Write(Serializer.JsonSerilize(c));
r++;
}
sw.Write("];");
}
Log($"执行时间：{t.ElapsedMilliseconds}ms");//6.5s--100000数据
}
public void TestDataItemPropertyModify()
{
Log("-----------开始测试数据修改后更新数据库----------------");
string db = @"C:\Users\fhjun\Desktop\TestDataItemPropertyModify.db";
string db2 = db.Insert(db.LastIndexOf('.'), "_bmk");
if (File.Exists(db))
{
File.Delete(db);
}
if (File.Exists(db2))
{
File.Delete(db2);
}
IDataItems items = new DataItems <MessageCore>(db);
//MessageCore mm3 = null;
//for (int i = 0; i < 1; i++)
//{
// MessageCore mm = new MessageCore() { Content = "正常消息", Date = DateTime.Now.AddDays(i), SenderName = "张三", MessageType = "文本" };
// mm.Content = "正常消息1";
// items.Add(mm);
// if (i == 3)
// mm.Content = "这是修改Content后的数据";
// if (i % 3 == 0)
// mm.BookMarkId = 2;
// if (i == 0)
// mm3 = mm;
//}
MessageCore mm = new MessageCore()
{
Content = "正常消息", Date = DateTime.Now.AddDays(0), SenderName = "张三", MessageType = "文本"
};
mm.Content = "正常消息1";
items.Add(mm);
mm.Content = "这是修改Content后的数据";
mm.Content = "这是修改Content后的数据2222";
items.Commit();
items.Filter();
mm.BookMarkId = 3;
mm.BookMarkId = -1;
}
