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(); }