static void Test1()
{
//new AgentService().Main();
//var wc = new WebClientX
//{
// Log = XTrace.Log
//};
//var url = wc.DownloadLink("http://x.newlifex.com/", "Oracle.ManagedDataAccess.st", ".");
//XTrace.WriteLine(url);
//url = wc.DownloadLink("http://x.newlifex.com/", "MySql.Data.st", ".");
//XTrace.WriteLine(url);
//url = wc.DownloadLink("http://x.newlifex.com/", "MySql.Data64Fx40,MySql.Data", ".");
//XTrace.WriteLine(url);
//url = wc.DownloadLink("http://x.newlifex.com/", "System.Data.SqlClient.st", ".");
//XTrace.WriteLine(url);
//VisitStat.Meta.Session.Dal.Db.ShowSQL = true;
//var vs = VisitStat.FindByID(1) ?? new VisitStat();
//vs.Times += 123;
//vs.Users++;
//vs.IPs++;
//vs.Save();
XTrace.Log.Level = LogLevel.All;
using (var tran = UserX.Meta.CreateTrans())
{
var user = UserX.FindByKey(1);
XTrace.WriteLine(user.Logins + "");
user.Logins++;
user.Save();
//tran.Commit();
}
{
var user = UserX.FindByKey(1);
XTrace.WriteLine(user.Logins + "");
}
}
static void Test1()
{
var user = UserX.FindByKey(1);
Console.WriteLine(user.Logins);
using (var tran = UserX.Meta.CreateTrans())
{
user.Logins++;
user.Save();
Console.WriteLine(user.Logins);
throw new Exception("xxx");
tran.Commit();
}
}
static void Test7()
{
var dal = UserX.Meta.Session.Dal;
dal.Db.DataCache = 3;
var list = UserX.FindAll();
var u = UserX.FindByID(1);
var n = UserX.FindCount();
var sql = "select * from user";
var ds = dal.Select(sql);
ds = dal.Select(sql, CommandType.Text);
ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>());
var dt = dal.Query(sql, new Dictionary <String, Object>());
n = dal.SelectCount(sql, CommandType.Text);
var sb = SelectBuilder.Create("select roleid,count(*) from user group by roleid order by count(*) desc");
ds = dal.Select(sb, 3, 5);
dt = dal.Query(sb, 4, 6);
n = dal.SelectCount(sb);
for (var i = 0; i < 10; i++)
{
Console.WriteLine(i);
list = UserX.FindAll();
u = UserX.FindByKey(1);
n = UserX.FindCount();
ds = dal.Select(sql);
ds = dal.Select(sql, CommandType.Text);
ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>());
dt = dal.Query(sql, new Dictionary <String, Object>());
n = dal.SelectCount(sql, CommandType.Text);
ds = dal.Select(sb, 3, 5);
dt = dal.Query(sb, 4, 6);
n = dal.SelectCount(sb);
Thread.Sleep(1000);
}
}
static void Test7()
{
var set = XCode.Setting.Current;
//set.Debug = true;
set.ShowSQL = false;
//XCode.Cache.CacheBase.Debug = true;
var dal = UserX.Meta.Session.Dal;
dal.Db.DataCache = 3;
var list = UserX.FindAll(null, null, null, 1, 20);
var u = UserX.FindByKey(1);
var n = UserX.FindCount();
Console.WriteLine("总数据：{0:n0}", n);
//using (var tr = UserX.Meta.CreateTrans())
//{
// u = new UserX
// {
// Name = Rand.NextString(8),
// DisplayName = Rand.NextString(16)
// };
// u.Insert();
// if (Rand.Next(2) == 1) tr.Commit();
//}
Task.Run(() =>
{
var us = new List <UserX>();
for (var i = 0; i < 1_000_000; i++)
{
var entity = new UserX
{
Name = Rand.NextString(8),
DisplayName = Rand.NextString(16)
};
us.Add(entity);
}
us.Insert(true);
});
var sql = "select * from user limit 20";
var ds = dal.Select(sql);
ds = dal.Select(sql, CommandType.Text);
ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>());
var dt = dal.Query(sql, new Dictionary <String, Object>());
n = dal.SelectCount(sql, CommandType.Text);
var sb = SelectBuilder.Create("select roleid,count(*) from user group by roleid order by count(*) desc");
ds = dal.Select(sb, 3, 5);
dt = dal.Query(sb, 4, 6);
n = dal.SelectCount(sb);
for (var i = 0; i < 20; i++)
{
//Console.WriteLine(i);
var sw = Stopwatch.StartNew();
list = UserX.FindAll(null, null, null, 1, 20);
u = UserX.FindByKey(1);
n = UserX.FindCount();
ds = dal.Select(sql);
ds = dal.Select(sql, CommandType.Text);
ds = dal.Select(sql, CommandType.Text, new Dictionary <String, Object>());
dt = dal.Query(sql, new Dictionary <String, Object>());
n = dal.SelectCount(sql, CommandType.Text);
ds = dal.Select(sb, 3, 5);
dt = dal.Query(sb, 4, 6);
n = dal.SelectCount(sb);
sw.Stop();
XTrace.WriteLine("{0} {1:n0}us", i, sw.Elapsed.TotalMilliseconds * 1000);
Thread.Sleep(1000);
}
}
