public void DatabaseCreatedTest()
{
using (var db = new VrLifeDbContext())
{
Assert.True((db.Database.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists());
}
}
public void ConnectionTest()
{
using (var db = new VrLifeDbContext())
{
Assert.True(db.Database.CanConnect());
}
}
public void Clear()
{
using (var db = new VrLifeDbContext())
{
db.AppData.RemoveRange(db.AppData.Where(x => x.AppId == _appId));
db.SaveChanges();
}
}
public List <DataValue> List(string field)
{
using (var db = new VrLifeDbContext())
{
return(db.AppData.Where(x => x.AppId == _appId && x.FieldName == field)
.Select(x => new DataValue(field, x.StringValue, x.NumericValue, x.DecimalValue)).ToList());
}
}
public void Delete(string field, ulong id)
{
using (var db = new VrLifeDbContext())
{
var toRemove = db.AppData.Where(x => x.AppId == _appId && x.FieldName == field && x.FieldId == id);
db.AppData.RemoveRange(toRemove);
db.SaveChanges();
}
}
public DataValue Get(string field, ulong id)
{
using (var db = new VrLifeDbContext())
{
AppData data = db.AppData.SingleOrDefault(x => x.AppId == _appId && x.FieldName == field && x.FieldId == id);
if (data == null)
{
return(new DataValue(field));
}
return(new DataValue(field, data.StringValue, data.NumericValue, data.DecimalValue));
}
}
public void Insert(ulong id, DataValue val)
{
using (var db = new VrLifeDbContext())
{
AppData data = new AppData();
data.AppId = _appId;
data.FieldName = val.Field;
data.FieldId = id;
SetValues(data, val);
db.AppData.Add(data);
db.SaveChanges();
}
}
public static void Init()
{
try
{
conf = LoadConf();
}
catch (FormatException ex)
{
Console.Error.WriteLine(ex.Message);
Environment.Exit(1);
}
VrLifeDbContext.SetConfig(conf);
}
public void UpdateOrInsert(ulong id, DataValue val)
{
using (var db = new VrLifeDbContext())
{
AppData data = db.AppData.SingleOrDefault(x => x.AppId == _appId && x.FieldName == val.Field && x.FieldId == id);
if (data != null)
{
SetValues(data, val);
db.SaveChanges();
return;
}
}
Insert(id, val);
}
private void PrepareDatabase()
{
using (var db = new VrLifeDbContext())
{
if (!db.Database.CanConnect())
{
throw new DatabaseException("Cannot connect to database.");
}
if (!(db.Database.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
{
throw new DatabaseException("Database does not exists or does not have required tables. Please make migration before starting the server.");
}
}
}
public void GetTest()
{
var user = new VrLifeServer.Database.DbModels.User();
using (var db = new VrLifeDbContext())
{
user.Username = "******";
user.Passphrase = "password";
db.Users.Add(user);
db.SaveChanges();
}
User obj = User.Get(user.UserId);
Assert.NotNull(obj);
obj.Delete();
}
public void DeleteTest()
{
var user = new VrLifeServer.Database.DbModels.User();
using (var db = new VrLifeDbContext())
{
user.Username = "******";
user.Passphrase = "password";
db.Users.Add(user);
db.SaveChanges();
}
ulong userId = user.UserId;
User obj = new User(user);
obj.Delete();
using (var db = new VrLifeDbContext())
{
Assert.Null(db.Users.SingleOrDefault(x => x.UserId == userId));
}
}
private static void OnDebug()
{
JObject consoleLog = new JObject();
consoleLog["type"] = "console";
JObject mainConf = new JObject();
mainConf["debug"] = true;
mainConf["listen"] = "0.0.0.0";
mainConf["serverAddress"] = "127.0.0.1";
mainConf["tcp-port"] = 8765;
mainConf["udp-port"] = 8766;
mainConf["main"] = true;
JObject database = new JObject();
database["type"] = "mysql";
database["host"] = "localhost";
database["port"] = 3306;
database["username"] = "******";
database["password"] = "******";
database["database"] = "dev";
mainConf["database"] = database;
JArray mainLogs = new JArray();
JObject mainLog = new JObject();
mainLog["type"] = "file";
mainLog["path"] = "./vrlife-main-server.log";
mainLogs.Add(mainLog);
mainLogs.Add(consoleLog);
mainConf["log"] = mainLogs;
JObject compConf = new JObject();
compConf["debug"] = true;
compConf["listen"] = "0.0.0.0";
compConf["serverAddress"] = "127.0.0.1";
compConf["tcp-port"] = 8865;
compConf["udp-port"] = 8866;
compConf["main"] = false;
compConf["mainServer"] = "127.0.0.1:8766";
JArray compLogs = new JArray();
JObject compLog = new JObject();
compLog["type"] = "file";
compLog["path"] = "./vrlife-comp-server.log";
compLogs.Add(compLog);
compLogs.Add(consoleLog);
compConf["log"] = compLogs;
Config mainConfig = Config.Parse(mainConf);
Config compConfig = Config.Parse(compConf);
VrLifeDbContext.SetConfig(mainConfig);
ProviderServer providerServer = new ProviderServer();
providerServer.Init(mainConfig);
providerServer.Start();
ForwarderServer forwarderServer = new ForwarderServer();
forwarderServer.Init(compConfig);
forwarderServer.Start();
}
