Ejemplo n.º 1
0
        public void InsertSingle()
        {
            var json = "{ \"FirstName\":\"Mikael\", \"LastName\":\"Eliasson\",\"BirthDate\":\"1987-03-01\" }";

            var handler = new SisoDbManagementHandler();
            SetConfig();

            var adapter = new FakeContextAdapter()
            .WithPath("/insert")
            .WithEntityType<IPerson>()
            .WithJson(json);

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual("{ \"Success\" : true}", adapter.Response);
            Assert.AreEqual(200, adapter.StatusCode);

            var persons = Configuration.DB.UseOnceTo().Query<IPerson>().ToListOf<Person>();

            Assert.AreEqual(1, persons.Count);
            Assert.AreEqual("Mikael", persons[0].FirstName);
            Assert.AreEqual("Eliasson", persons[0].LastName);

        }
Ejemplo n.º 2
0
        public void DeleteSingle()
        {
            var handler = new SisoDbManagementHandler();
            var persons = new List<Person>
            {
                new Person{FirstName = "P1"},
                new Person{FirstName = "P2"},
                new Person{FirstName = "P3"}
            };
            SetConfig(session => session.InsertMany<IPerson>(persons));

            var adapter = new FakeContextAdapter()
            .WithPath("/delete")
            .WithEntityType<IPerson>()
            .WithId(persons[1].Id);

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual(200, adapter.StatusCode);

            var updatedPersons = Configuration.DB.UseOnceTo().Query<IPerson>().ToListOf<Person>();

            Assert.AreEqual(2, updatedPersons.Count);
            Assert.IsTrue(!updatedPersons.Any(p => p.FirstName == "P2"));
        }
        public void DeleteMatchingCriteria()
        {
            var handler = new SisoDbManagementHandler();
            var persons = new List<Person>
            {
                new Person{FirstName = "P1", Birthdate = DateTime.Parse("2012-01-02")},
                new Person{FirstName = "P2", Birthdate = DateTime.Parse("2011-01-02")},
                new Person{FirstName = "P3", Birthdate = DateTime.Parse("2010-01-02")},
            };
            SetConfig(session => session.InsertMany<IPerson>(persons));

            var adapter = new FakeContextAdapter()
            .WithPath("/deletebyquery")
            .WithEntityType<IPerson>()
            .WithPredicate("p => p.Birthdate < DateTime.Parse(\"2012-01-01\")");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual("2", adapter.Response);
            Assert.AreEqual(200, adapter.StatusCode);

            var updatedPersons = Configuration.DB.UseOnceTo().Query<IPerson>().ToListOf<Person>();

            Assert.AreEqual(1, updatedPersons.Count);
            Assert.IsTrue(updatedPersons[0].FirstName == "P1");
        }
        public void WithExistingDb_ShouldNotDestoryDb()
        {
            var handler = new SisoDbManagementHandler();

            var persons = new List<Person>
            {
                new Person{FirstName = "P1"},
                new Person{FirstName = "P2"},
                new Person{FirstName = "P3"}
            };
            SetConfig(session => session.InsertMany<IPerson>(persons));

            var adapter = new FakeContextAdapter()
            .WithPath("/initdb")
            .WithEntityType<IPerson>();

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual(200, adapter.StatusCode);

            var updatedPersons = Configuration.DB.UseOnceTo().Query<IPerson>().ToListOf<Person>();

            Assert.AreEqual(3, updatedPersons.Count);

        }
        public void AuthorizeReturnsFalse_Returns401()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/page");
            Configuration.Authorize = str => false;
            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual(401, adapter.StatusCode);

            Assert.IsTrue(!adapter.Response.Contains("<html"));
        }
        public void NoAuthorizeSet_Returns500()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/page");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual(500, adapter.StatusCode);

            Assert.IsTrue(!adapter.Response.Contains("<html"));
        }
Ejemplo n.º 7
0
        public void NoPredicate_NoOrderBy_ReturnsAll()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/query")
            .WithEntityType<IPerson>();

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            AssertThat(adapter)
            .IsSuccess()
            .HasEntityCount(501)
            .HasTotalMatches(501);
        }
        public void WithNoSchema_InsertsSchema()
        {
            var handler = new SisoDbManagementHandler();
            SetConfig();

            var adapter = new FakeContextAdapter()
            .WithPath("/insertschema")
            .WithEntityType<IPerson>();

            SisoDbManagementHandler.Context = adapter;

            Configuration.DB.Configure().ForProduction();
            handler.ProcessRequest(null);

            Assert.AreEqual(200, adapter.StatusCode);

            //Query persons to trigger exception if the schema wasn't already inserted
            var updatedPersons = Configuration.DB.UseOnceTo().Query<IPerson>().ToListOf<Person>();
        }
        public void WithoutStructures()
        {
            var handler = new SisoDbManagementHandler();

            Setup();

            var adapter = new FakeContextAdapter()
            .WithPath("/initdb")
            .WithEntityType<IPerson>();

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual(200, adapter.StatusCode);

            var db = "data source=.\\;initial catalog=SisoDb.Management.Tests;integrated security=SSPI;".CreateSql2008Db();
            Assert.IsTrue(db.Exists());
            
        }
Ejemplo n.º 10
0
        public void OrderByBirthdate_NoPage_NoSortorder_ReturnsAllOrderedAsc()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/query")
            .WithEntityType<IPerson>()
            .WithOrderBy("x => x.Birthdate");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            AssertThat(adapter)
                .IsSuccess()
                .HasEntityCount(501)
                .HasTotalMatches(501)
                .FirstEntityShould(p => Assert.AreEqual(DateTime.Parse("1987-03-01"), p.Birthdate))
                .LastEntityShould(p => Assert.AreEqual(lastDate, p.Birthdate));
        }
        public void WithStructures()
        {
            var handler = new SisoDbManagementHandler();

            Setup();

            var adapter = new FakeContextAdapter()
            .WithPath("/initdbandstructures")
            .WithEntityType<IPerson>();

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual(200, adapter.StatusCode);

            var db = "data source=.\\;initial catalog=SisoDb.Management.Tests;integrated security=SSPI;".CreateSql2008Db();
            db.Configure().ForProduction();
            Assert.IsTrue(db.Exists());
            //Force exception if tables aren't already created
            var persons = db.UseOnceTo().Query<IPerson>().ToList();

        }
        public void DoesNotAlterEnabledUpsert()
        {
            var handler = new SisoDbManagementHandler();
            var persons = new List<Person>
            {
                new Person{FirstName = "P1"},
                new Person{FirstName = "P2"},
                new Person{FirstName = "P3"}
            };
            SetConfig(session => session.InsertMany<IPerson>(persons));

            var adapter = new FakeContextAdapter()
            .WithPath("/insertschema")
            .WithEntityType<IPerson>();

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            Assert.AreEqual(200, adapter.StatusCode);

            Assert.IsTrue(Configuration.DB.Settings.AllowDynamicSchemaCreation);
            Assert.IsTrue(Configuration.DB.Settings.AllowDynamicSchemaUpdates);
        }
Ejemplo n.º 13
0
        public void FilterWithBadPredicate_ShouldReturnErrorAndMessageAboutThePredicateBeingBad()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/query")
            .WithEntityType<IPerson>()
            .WithPredicate("p => p.SomeNameThatDoesNotExist == 2");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            AssertThat(adapter).FailedWithMessage("Mono could not parse the predicate");
        }
Ejemplo n.º 14
0
        public void SortAndPredicateWorksToghether()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/query")
            .WithEntityType<IPerson>()
            .WithOrderBy("x => x.Birthdate")
            .WithPageSize(100)
            .WithPredicate("p => p.FirstName.QxStartsWith(\"Mik\")");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            AssertThat(adapter)
                .IsSuccess()
                .HasEntityCount(1)
                .HasTotalMatches(1)
                .FirstEntityShould(p => Assert.AreEqual("Mikael", p.FirstName));
        }
Ejemplo n.º 15
0
        public void FilterUsingASisoMethods()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/query")
            .WithEntityType<IPerson>()
            .WithPredicate("p => p.FirstName.QxStartsWith(\"Mik\")");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            AssertThat(adapter)
                .IsSuccess()
                .HasEntityCount(1)
                .HasTotalMatches(1)
                .FirstEntityShould(p => Assert.AreEqual("Mikael", p.FirstName));
        }
Ejemplo n.º 16
0
        public void FilterOnDateWithSetup()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/query")
            .WithEntityType<IPerson>()
            .WithSetup("var date = DateTime.Parse(\"1987-03-01\");")
            .WithPredicate("p => p.Birthdate == date");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            AssertThat(adapter)
                .IsSuccess()
                .HasEntityCount(1)
                .HasTotalMatches(1)
                .FirstEntityShould(p => Assert.AreEqual("Mikael", p.FirstName));
        }
Ejemplo n.º 17
0
        public void OrderByBirthdate_PageSize100_Page1_Asc_Returns101To200()
        {
            var handler = new SisoDbManagementHandler();

            var adapter = new FakeContextAdapter()
            .WithPath("/query")
            .WithEntityType<IPerson>()
            .WithOrderBy("x => x.Birthdate")
            .WithPageSize(100)
            .WithPage(1)
            .WithSortOrder("asc");

            SisoDbManagementHandler.Context = adapter;

            handler.ProcessRequest(null);

            AssertThat(adapter)
                .IsSuccess()
                .HasEntityCount(100)
                .HasTotalMatches(501)
                .FirstEntityShould(p => Assert.AreEqual("F99", p.FirstName))
                .LastEntityShould(p => Assert.AreEqual("F198", p.FirstName));
        }