public UserHandler(Orion orion)
{
database = orion.Database;
SqlTable table = new SqlTable("Users",
new SqlColumn("ID", MySqlDbType.Int32)
{
Primary = true, AutoIncrement = true
},
new SqlColumn("Username", MySqlDbType.VarChar, 32)
{
Unique = true
},
new SqlColumn("Password", MySqlDbType.VarChar, 128),
new SqlColumn("UUID", MySqlDbType.VarChar, 128),
new SqlColumn("Usergroup", MySqlDbType.Text),
new SqlColumn("Registered", MySqlDbType.Text),
new SqlColumn("LastAccessed", MySqlDbType.Text),
new SqlColumn("KnownIPs", MySqlDbType.Text)
);
SqlTableCreator creator = new SqlTableCreator(database,
database.GetSqlType() == SqlType.Sqlite
? (IQueryBuilder) new SqliteQueryCreator()
: new MysqlQueryCreator());
creator.EnsureTableStructure(table);
UserCache = new OrderedCache <User>(orion.Config.MaxUserCacheSize);
UserCache.FlushEvent += OnFlush;
}
public void TestMethod2()
{
classCache = new OrderedCache <User>(10)
{
FlushInterval = 5000,
ClearCount = 1
};
classCache.FlushEvent += FlushCallback;
List <User> classes = new List <User>(10);
for (int i = 0; i < 10; i++)
{
User u = new User
{
Name = r.NextString(10),
Group = r.NextString(7),
ID = i
};
classes.Add(u);
}
classCache.PushMany(classes);
classCache.Sort();
classCache.Push(new User {
Name = "name"
});
var user = classCache[0];
classCache.Push(new User {
Name = "name2"
});
user = classCache[0];
classCache.Push(new User {
Name = "name3"
});
user = classCache[0];
var newuser = classCache.FirstOrDefault(u => u == user);
var user2 = classCache.Pop();
var users = classCache.Where(u => u.Name.Length > 1).Select(u => u.Name);
Console.WriteLine(string.Join(", ", users));
Thread.Sleep(7000);
}
public void TestMethod1()
{
total.Start();
for (var j = 0; j < 10; j++)
{
classCache = new OrderedCache <User>(100000)
{
FlushInterval = 10000,
ClearCount = 1
};
classCache.FlushEvent += FlushCallback;
List <User> classes = new List <User>(100000);
for (int i = 0; i < 100000; i++)
{
User u = new User
{
Name = r.NextString(10),
Group = r.NextString(5),
ID = i
};
classes.Add(u);
}
classCache.PushMany(classes);
classCache.Pop();
classCache.Push(new User {
Name = "name", Group = "group", ID = 100000
});
var obj2 = classCache[0];
classCache.Push(new User {
Name = "name2", Group = "group2", ID = 100001
});
var obj3 = classCache[0];
var users = classCache.Where(u => u.Name.Length > 1).Select(u => u.Name);
classCache.Pop();
}
total.Stop();
Console.WriteLine("Total elasped (s): {0}", total.ElapsedMilliseconds / 1000);
Console.WriteLine("Average (ms): {0}", total.ElapsedMilliseconds / 10);
}
