From 632781d1adf54287ecfe7cbcbc17074e14a769b2 Mon Sep 17 00:00:00 2001 From: TrueDoctor Date: Sat, 29 Sep 2018 23:59:42 +0200 Subject: added database methods --- DSACore/FireBase/Database.cs | 212 ++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 210 insertions(+), 2 deletions(-) (limited to 'DSACore/FireBase/Database.cs') diff --git a/DSACore/FireBase/Database.cs b/DSACore/FireBase/Database.cs index fd8aa4c..de7d540 100644 --- a/DSACore/FireBase/Database.cs +++ b/DSACore/FireBase/Database.cs @@ -3,6 +3,9 @@ using System.Collections.Generic; using System.IO; using System.Linq; using System.Threading.Tasks; +using DSACore.DSA_Game.Characters; +using DSACore.Models.Database; +using DSACore.Models; using Firebase.Database; using Firebase.Database.Query; @@ -11,17 +14,222 @@ namespace DSACore.FireBase { public static class Database { + public static FirebaseClient firebase; + static Database() { var auth = File.ReadAllText(DSACore.DSA_Game.Dsa.rootPath+"Token"); ; // your app secret - var firebaseClient = new FirebaseClient( + firebase = new FirebaseClient( "https://heldenonline-4d828.firebaseio.com/", new FirebaseOptions { AuthTokenAsyncFactory = () => Task.FromResult(auth) }); } + + + public static async Task AddChar(Character file, Models.Network.Group group) + { + DatabaseChar.LoadChar(file, out GroupChar groupChar, out DatabaseChar data); + + var lastChar = await firebase + .Child("Chars") + .OrderBy("id") + .LimitToLast(1) + .OnceSingleAsync(); + int id = groupChar.Id = data.Id = lastChar.Id + 1; + + await firebase + .Child("Groups") + .Child("Char" + id) + .PutAsync(data); + + await firebase + .Child("Chars") + .Child("Char" + id) + .PutAsync(data); + + await firebase + .Child("Inventories") + .Child("Inventory" + id) + .PutAsync(new Inventory()); + + return id + 1; + } + + public static async Task RemoveChar(int id) + { + + await firebase + .Child("Groups") + .Child("Char" + id) + .DeleteAsync(); + + await firebase + .Child("Chars") + .Child("Char" + id) + .DeleteAsync(); + + await firebase + .Child("Inventories") + .Child("Inventory" + id) + .DeleteAsync(); + + } + + public static async Task GetChar(int id) + { + var chr = await firebase + .Child("Chars") + .Child("Char" + id) + .OnceSingleAsync(); + return chr; + } + + public static async Task GetInventory(int id) + { + var inv = await firebase + .Child("Inventories") + .Child("Inventory"+id) + .OnceSingleAsync(); + return inv; + } + + public static async Task SetInventory(int id, Inventory inv) + { + await firebase + .Child("Inventories") + .Child("Inventory" + id) + .PutAsync(inv); + } + + public static async Task AddTalent(Talent tal) + { + await firebase + .Child("Talents") + .Child(tal.Name) + .PutAsync(tal); + } + + public static async Task RemoveTalent(string talent) + { + await firebase + .Child("Talents") + .Child(talent) + .DeleteAsync(); + } + + public static async Task GetTalent(string talent) + { + return await firebase + .Child("Talents") + .Child(talent) + .OnceSingleAsync(); + } + + public static async Task AddSpell(GeneralSpell tal) + { + await firebase + .Child("Spells") + .Child(tal.Name) + .PutAsync(tal); + } - public static void DoStuff(){} + public static async Task RemoveSpell(string spell) + { + await firebase + .Child("Spells") + .Child(spell) + .DeleteAsync(); + } + + public static async Task GetSpell(string spell) + { + return await firebase + .Child("Spells") + .Child(spell) + .OnceSingleAsync(); + } + + + public static async Task AddWeapon(Weapon wep) + { + await firebase + .Child("Weapons") + .Child(wep.Name) + .PutAsync(wep); + } + + public static async Task RemoveWeapon(string weapon) + { + await firebase + .Child("Weapons") + .Child(weapon) + .DeleteAsync(); + } + + public static async Task< Weapon> GetWeapon(string weapon) + { + return await firebase + .Child("Weapons") + .Child(weapon) + .OnceSingleAsync(); + } + + public static async Task> GetGroups() + { + var groups = await firebase + .Child("Groups") + .OrderBy("id") + .OnceAsync(); + var ret = new List(); + + foreach (var firebaseObject in groups) + { + ret.Add(new Models.Network.Group(firebaseObject.Object.Name, firebaseObject.Object.Password)); + } + + return ret; + } + + public static async Task GetGroup(int id) + { + var group = await firebase + .Child("Groups") + .Child("Group"+id) + .OnceSingleAsync(); + return group; + } + + public static async void AddGroup(Group group) + { + var lastChar = await firebase + .Child("Groups") + .OrderBy("id") + .LimitToLast(1) + .OnceSingleAsync(); + int id = group.Id = lastChar.Id + 1; + + await firebase + .Child("Groups") + .Child("Group"+id) + .PutAsync(group); + } + + public static async void SetGroup(Group group) + { + await firebase + .Child("Groups") + .Child("Group" + group.Id) + .PutAsync(group); + } + + public static async void DeleteGroup(int id) + { + await firebase + .Child("Groups") + .Child("Group" + id) + .DeleteAsync(); + } } } -- cgit v1.2.3-54-g00ecf From 560f454c9beb2f691730b126fc6b3e23d68d6681 Mon Sep 17 00:00:00 2001 From: TrueDoctor Date: Sun, 30 Sep 2018 02:06:02 +0200 Subject: added mot of the database infrastructure --- DSACore/DSA_Game/Characters/Character.cs | 15 ++++++--- DSACore/DSA_Game/Dsa.cs | 18 ++++++++++ DSACore/FireBase/Database.cs | 16 ++++----- DSACore/Hubs/ChatHub.cs | 57 +++++++++++++++++++++++++------- DSACore/Models/Database/GeneralSpell.cs | 11 +++++- DSACore/Models/Database/Roll.cs | 12 ------- DSACore/Models/Database/Talent.cs | 8 ++++- DSACore/Models/Network/User.cs | 1 + 8 files changed, 100 insertions(+), 38 deletions(-) delete mode 100644 DSACore/Models/Database/Roll.cs (limited to 'DSACore/FireBase/Database.cs') diff --git a/DSACore/DSA_Game/Characters/Character.cs b/DSACore/DSA_Game/Characters/Character.cs index 8fad2ef..247fc58 100644 --- a/DSACore/DSA_Game/Characters/Character.cs +++ b/DSACore/DSA_Game/Characters/Character.cs @@ -1,4 +1,5 @@ -using DSACore.Auxiliary; +using System.IO; +using DSACore.Auxiliary; using DSALib; using DSALib.Characters; @@ -28,7 +29,12 @@ namespace DSACore.DSA_Game.Characters public Character(string path) : this() { - this.Load(path); // load + this.Load(new MemoryStream(File.ReadAllBytes(path))); // load + this.Post_process(); // calculate derived values + } + public Character(MemoryStream stream) : this() + { + this.Load(stream); // load this.Post_process(); // calculate derived values } @@ -198,10 +204,11 @@ namespace DSACore.DSA_Game.Characters } + - private void Load(string path) + private void Load(MemoryStream stream) { - var reader = new XmlTextReader(path); + var reader = new XmlTextReader(stream); while (reader.Read()) { // read until he hits keywords diff --git a/DSACore/DSA_Game/Dsa.cs b/DSACore/DSA_Game/Dsa.cs index d47c5b6..824872c 100644 --- a/DSACore/DSA_Game/Dsa.cs +++ b/DSACore/DSA_Game/Dsa.cs @@ -1,4 +1,5 @@ using System; +using DSACore.FireBase; using DSALib; using DSALib.Characters; using Microsoft.EntityFrameworkCore.Design; @@ -21,6 +22,8 @@ namespace DSACore.DSA_Game public static List Talente { get; set; } = new List(); + public static List Zauber { get; set; } = new List(); + public static Session Session { get @@ -51,12 +54,27 @@ namespace DSACore.DSA_Game Chars.Add(new Character(filename)); (Chars.Last() as Character)?.Talente.Select(x => new Talent(x.Name, x.Probe, 0)) .Where(c => !Talente.Exists(v => v.Name.Equals(c.Name))).ToList().ForEach(v => Talente.Add(v)); + (Chars.Last() as Character)?.Zauber.Select(x => new Zauber(x.Name, x.Probe, 0, x.Complexity)) + .Where(c => !Zauber.Exists(v => v.Name.Equals(c.Name))).ToList().ForEach(v => Zauber.Add(v)); } Properties.Deserialize(rootPath+"Properties"); Properties.Serialize(rootPath + "Properties"); Talente = Talente.OrderBy(x => x.Name).ToList(); + Zauber = Zauber.OrderBy(x => x.Name).ToList(); + + /*foreach (var talent in Talente) + { + Database.AddTalent(new Models.Database.Talent(talent.Name, talent.Probe)); + } + + foreach (var talent in Zauber) + { + Database.AddSpell(new Models.Database.GeneralSpell(talent.Name, talent.Probe, talent.Complexity)); + }*/ + + Session = new Session { Chars = Chars.Select(x => SaveChar.FromICharacter(x)).ToList() diff --git a/DSACore/FireBase/Database.cs b/DSACore/FireBase/Database.cs index de7d540..02a4741 100644 --- a/DSACore/FireBase/Database.cs +++ b/DSACore/FireBase/Database.cs @@ -34,10 +34,10 @@ namespace DSACore.FireBase var lastChar = await firebase .Child("Chars") - .OrderBy("id") + .OrderByKey() .LimitToLast(1) - .OnceSingleAsync(); - int id = groupChar.Id = data.Id = lastChar.Id + 1; + .OnceAsync(); + int id = groupChar.Id = data.Id = lastChar.First().Object.Id + 1; await firebase .Child("Groups") @@ -180,7 +180,7 @@ namespace DSACore.FireBase { var groups = await firebase .Child("Groups") - .OrderBy("id") + .OrderByKey() .OnceAsync(); var ret = new List(); @@ -201,14 +201,14 @@ namespace DSACore.FireBase return group; } - public static async void AddGroup(Group group) + public static async Task AddGroup(Group group) { var lastChar = await firebase .Child("Groups") - .OrderBy("id") + .OrderByKey() .LimitToLast(1) - .OnceSingleAsync(); - int id = group.Id = lastChar.Id + 1; + .OnceAsync(); + int id = group.Id = lastChar.First().Object.Id + 1; await firebase .Child("Groups") diff --git a/DSACore/Hubs/ChatHub.cs b/DSACore/Hubs/ChatHub.cs index e489b2e..46fde08 100644 --- a/DSACore/Hubs/ChatHub.cs +++ b/DSACore/Hubs/ChatHub.cs @@ -1,7 +1,10 @@ using System; using System.Collections.Generic; +using System.IO; using System.Linq; +using System.Text; using System.Threading.Tasks; +using DSACore.DSA_Game.Characters; using DSACore.FireBase; using DSACore.Models; using DSACore.Models.Network; @@ -18,11 +21,15 @@ namespace DSACore.Hubs static ChatHub() { DSAGroups = Database.GetGroups().Result; - DSAGroups.Add(new Group("TheCrew", "valid")); - DSAGroups.Add(new Group("HalloWelt", "valid")); - DSAGroups.Add(new Group("DieKrassenGamer", "valid")); - DSAGroups.Add(new Group("DSA", "valid")); - DSAGroups.Add(new Group("DieÜberhelden", "valid")); + //AddGroups(); + } + + private static async void AddGroups() + { + await Database.AddGroup(new Models.Database.Group { Name = "HalloWelt", Password = "valid" }); + await Database.AddGroup(new Models.Database.Group { Name = "Die Krassen Gamer", Password = "valid" }); + await Database.AddGroup(new Models.Database.Group { Name = "DSA", Password = "valid" }); + await Database.AddGroup(new Models.Database.Group { Name = "Die Überhelden", Password = "valid" }); } public async Task SendMessage(string user, string message) @@ -34,7 +41,7 @@ namespace DSACore.Hubs try { string group = getGroup(Context.ConnectionId).Name; - await SendToGroup(group, user, Commands.CommandHandler.ExecuteCommand(new Command { CharId = 0, CmdIdentifier = ident, CmdTexts = args, Name = user })); + await SendToGroup(Commands.CommandHandler.ExecuteCommand(new Command { CharId = 0, CmdIdentifier = ident, CmdTexts = args, Name = user })); } catch(InvalidOperationException e) { @@ -43,9 +50,10 @@ namespace DSACore.Hubs } - private Task SendToGroup(string group, string user, string message) + private Task SendToGroup(string message) { - return Clients.Group(group).SendCoreAsync("ReceiveMessage", new object[] { user, message }); + string group = getGroup(Context.ConnectionId).Name; + return Clients.Group(group).SendCoreAsync("ReceiveMessage", new object[] { getUser(Context.ConnectionId), message }); } private Models.Network.Group getGroup(string id) @@ -53,8 +61,23 @@ namespace DSACore.Hubs return DSAGroups.First(x => x.Users.Exists(y => y.ConnectionId.Equals(id))); } + private User getUser(string id) + { + return DSAGroups.First(x => x.Users.Exists(y => y.ConnectionId.Equals(id))).Users.First(z => z.ConnectionId.Equals(id)); + } + public async Task GetGroups() { + var test = Database.GetGroups(); + test.Wait(); + foreach (var group in test.Result) + { + if (!DSAGroups.Exists(x => x.Name.Equals(group.Name))) + { + DSAGroups.Add(group); + } + } + await Clients.Caller.SendCoreAsync("ListGroups", new object[] { DSAGroups }); //throw new NotImplementedException("add database call to get groups"); } @@ -63,11 +86,19 @@ namespace DSACore.Hubs { DSAGroups.Add(new Group(group, password)); var Dgroup = new DSACore.Models.Database.Group{Name = group, Id = DSAGroups.Count-1}; - Database.CreateGroup(Dgroup); + //Database.AddGroup(Dgroup); await Clients.Caller.SendCoreAsync("ReceiveMessage", new[] {$"group {@group} sucessfully added"}); //throw new NotImplementedException("add database call to add groups"); } + public async Task UploadChar(string xml) + { + var group = getGroup(Context.ConnectionId); + + Database.AddChar(new Character(new MemoryStream(Encoding.UTF8.GetBytes(xml))), group); + //throw new NotImplementedException("add database call to add groups"); + } + public async Task Login(string group, string user, string password) { if (password == DSAGroups.First(x=>x.Name == group).Password) @@ -76,17 +107,19 @@ namespace DSACore.Hubs await Groups.AddToGroupAsync(Context.ConnectionId, group); } - await SendToGroup(group, user, "Ein neuer Nutzer hat die Gruppe betreten"); + await SendToGroup("Ein neuer Nutzer hat die Gruppe betreten"); } public async Task Disconnect() { var group = getGroup(Context.ConnectionId); - var user = group.Users.First(x => x.ConnectionId.Equals(Context.ConnectionId)); + + await SendToGroup("Connection lost"); + + var user = getUser(Context.ConnectionId); group.Users.Remove(user); await Groups.RemoveFromGroupAsync(Context.ConnectionId, group.Name); - await SendToGroup(group.Name, user.Name, "Connection lost"); } } diff --git a/DSACore/Models/Database/GeneralSpell.cs b/DSACore/Models/Database/GeneralSpell.cs index 807a09b..6a6e94c 100644 --- a/DSACore/Models/Database/GeneralSpell.cs +++ b/DSACore/Models/Database/GeneralSpell.cs @@ -7,6 +7,15 @@ namespace DSACore.Models.Database { public class GeneralSpell : Talent { - public string Comlexity = "A"; + public char Comlexity = 'A'; + + public GeneralSpell(string name, string roll, char comlexity = 'A') :base(name, roll) + { + Comlexity = comlexity; + } + + public GeneralSpell(string name, string roll) : base(name, roll) + { + } } } diff --git a/DSACore/Models/Database/Roll.cs b/DSACore/Models/Database/Roll.cs deleted file mode 100644 index 547fde4..0000000 --- a/DSACore/Models/Database/Roll.cs +++ /dev/null @@ -1,12 +0,0 @@ -using System; -using System.Collections.Generic; -using System.Linq; -using System.Threading.Tasks; - -namespace DSACore.Models.Database -{ - public class Roll - { - public string[] Skills { get; set; } = new string[3]; - } -} diff --git a/DSACore/Models/Database/Talent.cs b/DSACore/Models/Database/Talent.cs index 6bd8cba..117d0f7 100644 --- a/DSACore/Models/Database/Talent.cs +++ b/DSACore/Models/Database/Talent.cs @@ -7,8 +7,14 @@ namespace DSACore.Models.Database { public class Talent { + public Talent(string name, String roll) + { + Name = name ?? throw new ArgumentNullException(nameof(name)); + Roll = roll.Split('/'); + } + public string Name { get; set; } - public Roll Roll { get; set; } = new Roll(); + public string[] Roll { get; set; } = new string[3]; } } diff --git a/DSACore/Models/Network/User.cs b/DSACore/Models/Network/User.cs index b207a19..04ef0a9 100644 --- a/DSACore/Models/Network/User.cs +++ b/DSACore/Models/Network/User.cs @@ -9,5 +9,6 @@ namespace DSACore.Models.Network { public string Name { get; set; } public string ConnectionId { get; set; } + public int Char { get; set; } } } -- cgit v1.2.3-54-g00ecf