public void TestCreatePlayer() { User user = new User(Guid.NewGuid(), "testuser", "user"); IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Assert.IsTrue(db.CreatePlayer(user)); User us = db.ReadPlayer(user.ID); Assert.IsNotNull(us); Assert.AreEqual(us.ID, user.ID); }
public void TestCreateCard() { Card c1 = new Card(Guid.NewGuid(), Element.Fire, "FireElf", 10); IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Assert.IsTrue(db.CreateCard(c1)); Card c2 = db.ReadCard(c1.id); Assert.IsNotNull(c2); Assert.AreEqual(c1, c2); }
public void TestRegister() { User user = new User(Guid.NewGuid(), "testuser", "user"); IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Server s = new Server(db); Assert.IsTrue(s.Register(user));//only true if db empty Assert.AreEqual(user, db.ReadPlayer(user.Username)); Assert.AreEqual(user, db.ReadPlayer(user.ID)); }
public void TestCheckAuthorization() { Dictionary <string, string> header = new Dictionary <string, string>(); header.Add("Authorization", "Basic altenhof-mtcgToken"); RequestContext rc = new RequestContext("demo", "egal", "http", header, "", 0); IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Server s = new Server(db); Assert.NotNull(s.CheckAuthorization(rc)); }
/// <summary> /// SelectSQL発行サンプル:Postgres /// </summary> /// <returns>ユーザー名</returns> private static string selectSqlByPostgres() { // 接続文字列作成 var connectionString = string.Format("Server={0};Port=5432;User Id={1};Password={2};Database={3}", "localhost", "test", "test", "test"); // SQL実行 using (var db = new PostgreSQLDB(connectionString)) { return(getUserName(db)); } }
public void TestCreateTrade() { User user = new User(Guid.NewGuid(), "User1", "test"); Card c1 = new Card(Guid.NewGuid(), Element.Fire, "FireElf", 10); Trade trade = new Trade(user, Guid.NewGuid(), c1, Cardtype.Spell, 1000); IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Assert.IsTrue(db.CreateTrade(trade)); Trade trade2 = db.ReadTrades().Where(v => v.id == trade.id).FirstOrDefault(); Assert.AreEqual(trade.id, trade2.id); }
public void TestLogin() { User user = new User(Guid.NewGuid(), "testuser", "user"); IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Assert.IsTrue(db.CreatePlayer(user)); Server s = new Server(db); Server.UserDes us = new Server.UserDes(); us.Username = "******"; us.Password = "******"; Assert.IsTrue(s.Login(us)); }
public void TestCreateStack() { User user = new User(Guid.NewGuid(), "User1", "test"); List <Card> stack = new List <Card>(); user.Stack = stack; IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Assert.IsTrue(db.CreateStack(user)); List <Card> stack2 = db.ReadStack(user.ID); Assert.IsNotNull(stack2); Assert.AreEqual(stack2, user.Stack); }
public void TestCreateDeck() { User user = new User(Guid.NewGuid(), "User1", "test"); Card c1 = new Card(Guid.NewGuid(), Element.Fire, "FireElf", 10); Card c2 = new Card(Guid.NewGuid(), Element.Water, "Goblin", 20); Card c3 = new Card(Guid.NewGuid(), Element.Normal, "Ork", 100); Card c4 = new Card(Guid.NewGuid(), Element.Fire, "Dragon", 10); List <Card> deck = new List <Card>(); user.Deck = deck; IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Assert.IsTrue(db.CreateDeck(user)); List <Card> deck2 = db.ReadDeck(user.ID); Assert.IsNotNull(deck2); Assert.AreEqual(deck2, user.Deck); }
public void TestCreatePackage() { Card c1 = new Card(Guid.NewGuid(), Element.Fire, "FireElf", 10); Card c2 = new Card(Guid.NewGuid(), Element.Water, "Goblin", 20); Card c3 = new Card(Guid.NewGuid(), Element.Normal, "Ork", 100); Card c4 = new Card(Guid.NewGuid(), Element.Fire, "Dragon", 10); Card c5 = new Card(Guid.NewGuid(), Element.Normal, "Ork", 100); Package package = new Package(Guid.NewGuid(), new List <Card>() { c1, c2, c3, c4, c5 }); IDatabase db = new PostgreSQLDB("Mtcg", "mtcg"); Assert.IsTrue(db.CreatePackage(package)); Package pack = db.ReadPackages().Where(v => v.id == package.id).FirstOrDefault(); Assert.AreEqual(package.id, pack.id); }
/// <summary> /// DBインスタンス取得 /// </summary> /// <returns>IDatabasインスタンス</returns> public static IDatabase Create(DatabaseConfigModel config) { IDatabase result = null; // DB種類で作成するインスタンスを変える switch (config.Type.ToLower()) { case "sqlite": result = new SQLiteDB(config.connectionString); break; case "postgres": result = new PostgreSQLDB(config.connectionString); break; default: result = new SQLiteDB(config.connectionString); break; } return(result); }