Exemplos de PostGISCoreBordersRepository em C# (CSharp)

Exemplo n.º 1

        public void GetSQLQueryWithIDExpectSelectWithWhereClause()
        {
            PostGISCoreBordersRepository repo = new PostGISCoreBordersRepository(null, new HRPaginer <HRBorder>());
            String sql = repo.GetSQLQuery(true, "XX");

            Assert.NotNull(sql);
            Assert.Equal(sql, PostGISCoreBordersRepository.SQLQUERYFORDAPPER + "WHERE FIPS = 'XX'");
        }

Exemplo n.º 2

        public void GetSQLQueryWithNoIDExpectSelectOnly()
        {
            PostGISCoreBordersRepository repo = new PostGISCoreBordersRepository(null, new HRPaginer <HRBorder>());
            String sql = repo.GetSQLQuery(true);

            Assert.NotNull(sql);
            Assert.Equal(sql, PostGISCoreBordersRepository.SQLQUERYFORDAPPER);
        }

Exemplo n.º 3

        public void GetSQLQueryWithValidOrderByExpectSelectWithOrderByClause()
        {
            PostGISCoreBordersRepository repo = new PostGISCoreBordersRepository(null, new HRPaginer <HRBorder>());
            String sql = repo.GetSQLQuery(true, null, new HRCommonModels.HRSortingParamModel()
            {
                SortingParamsQuery = "name;asc"
            }, null);

            Assert.NotNull(sql);
            Assert.Equal(sql, PostGISCoreBordersRepository.SQLQUERYFORDAPPER + " ORDER BY name ASC ");
        }

Exemplo n.º 4

        public void GetSQLQueryWithValidOrderByExpectSelectWithPaginationClause()
        {
            PostGISCoreBordersRepository repo = new PostGISCoreBordersRepository(null, new HRPaginer <HRBorder>());
            String sql = repo.GetSQLQuery(true,
                                          null,
                                          null,
                                          new PagingParameterInModel()
            {
                PageNumber = 0, PageSize = 20
            });

            Assert.NotNull(sql);
            Assert.Equal(sql, PostGISCoreBordersRepository.SQLQUERYFORDAPPER + " ORDER BY FIPS ASC  LIMIT 20 OFFSET 0 ");
        }

Exemplo n.º 5

        public void GetSQLQueryWithInValidOrderByThrowInvalidOperationException()
        {
            PostGISCoreBordersRepository repo = new PostGISCoreBordersRepository(null, new HRPaginer <HRBorder>());

            Assert.Throws <InvalidOperationException>(() =>
                                                      repo.GetSQLQuery(
                                                          true,
                                                          null,
                                                          new HRSortingParamModel()
            {
                OrderBy = "nameXXXX;ASC"
            },
                                                          new PagingParameterInModel()
            {
                PageNumber = 0, PageSize = 20
            }));
        }

Exemplo n.º 6

Arquivo: HRCoreBordersRepositoryTest.cs Projeto: jeanecard/HRCoreCountriesServices

 public HRCoreBordersRepositoryTest()
 {
     _repo = new PostGISCoreBordersRepository(null, new HRPaginer <HRBorder>());
 }