Python query_attr_where Examples

Example #1

File: test_pysal_utils.py Project: oss-spanish-geoserver/crankshaft

    def test_query_attr_where(self):
        """Test pu.query_attr_where"""

        ans1 = ("idx_replace.\"andy\" IS NOT NULL AND "
                "idx_replace.\"jay_z\" IS NOT NULL")

        ans_array = ("idx_replace.\"_2013_dec\" IS NOT NULL AND "
                     "idx_replace.\"_2014_jan\" IS NOT NULL AND "
                     "idx_replace.\"_2014_feb\" IS NOT NULL")

        self.assertEqual(pu.query_attr_where(self.params1), ans1)
        self.assertEqual(pu.query_attr_where(self.params_array), ans_array)

Example #2

File: test_pysal_utils.py Project: CartoDB/crankshaft

    def test_query_attr_where(self):
        """Test pu.query_attr_where"""

        ans1 = ("idx_replace.\"andy\" IS NOT NULL AND "
                "idx_replace.\"jay_z\" IS NOT NULL")

        ans_array = ("idx_replace.\"_2013_dec\" IS NOT NULL AND "
                     "idx_replace.\"_2014_jan\" IS NOT NULL AND "
                     "idx_replace.\"_2014_feb\" IS NOT NULL")

        self.assertEqual(pu.query_attr_where(self.params1), ans1)
        self.assertEqual(pu.query_attr_where(self.params_array), ans_array)

Example #3

File: test_pysal_utils.py Project: uekeueke/crankshaft

    def test_query_attr_where(self):
        """Test pu.query_attr_where"""

        ans = "idx_replace.\"{attr1}\" IS NOT NULL AND " \
              "idx_replace.\"{attr2}\" IS NOT NULL AND " \
              "idx_replace.\"{attr2}\" <> 0"

        self.assertEqual(pu.query_attr_where(self.params), ans)

Example #4

File: test_pysal_utils.py Project: CartoDB/crankshaft

    def test_query_attr_where(self):
        """Test pu.query_attr_where"""

        ans = (
            'idx_replace."{attr1}" IS NOT NULL AND '
            'idx_replace."{attr2}" IS NOT NULL AND '
            'idx_replace."{attr2}" <> 0'
        )

        self.assertEqual(pu.query_attr_where(self.params), ans)