Python DateFilter.set Examples

Example #1

 def test_lte(self):
     filter = DateFilter(Person.due_date)
     filter.set('lte', '12/31/2010')
     self.assert_filter_query(filter, "WHERE persons.due_date <= '2010-12-31'")
     eq_(filter.description, 'up to 12/31/2010')
     with assert_raises(formencode.Invalid):
         filter.set('lte', '')

Example #2

File: test_filters.py Project: level12/webgrid

 def test_lte(self):
     filter = DateFilter(Person.due_date)
     filter.set('lte', '12/31/2010')
     self.assert_filter_query(filter, "WHERE persons.due_date <= '2010-12-31'")
     eq_(filter.description, 'up to 12/31/2010')
     with assert_raises(formencode.Invalid):
         filter.set('lte', '')

Example #3

 def test_not_empty(self):
     filter = DateFilter(Person.due_date)
     filter.set('!empty', None)
     self.assert_filter_query(filter, "WHERE persons.due_date IS NOT NULL")
     eq_(filter.description, 'any date')
     filter.set('!empty', '')
     self.assert_filter_query(filter, "WHERE persons.due_date IS NOT NULL")
     eq_(filter.description, 'any date')

Example #4

 def test_empty(self):
     filter = DateFilter(Person.due_date)
     filter.set('empty', None)
     self.assert_filter_query(filter, "WHERE persons.due_date IS NULL")
     eq_(filter.description, 'date not specified')
     filter.set('empty', '')
     self.assert_filter_query(filter, "WHERE persons.due_date IS NULL")
     eq_(filter.description, 'date not specified')

Example #5

 def test_not_between_missing_date(self):
     filter = DateFilter(Person.due_date)
     filter.set('!between', '12/31/2010', '')
     today = dt.date.today().strftime('%Y-%m-%d')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date NOT BETWEEN '2010-12-31' AND '{}'".format(today)
     )

Example #6

 def test_this_year_default(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 4), default_op='thisyear')
     filter.set(None, None)
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date BETWEEN '2012-01-01' AND '2012-12-31'"
     )
     eq_(filter.description, '01/01/2012 - 12/31/2012')

Example #7

File: test_filters.py Project: level12/webgrid

 def test_not_between_missing_date(self):
     filter = DateFilter(Person.due_date)
     filter.set('!between', '12/31/2010', '')
     today = dt.date.today().strftime('%Y-%m-%d')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date NOT BETWEEN '2010-12-31' AND '{}'".format(today)
     )

Example #8

File: test_filters.py Project: level12/webgrid

 def test_less_than_days_ago(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ltda', '10')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date > '2011-12-22' AND persons.due_date < '2012-01-01'"
     )
     eq_(filter.description, '12/22/2011 - 01/01/2012')

Example #9

 def test_not_between(self):
     filter = DateFilter(Person.due_date)
     filter.set('!between', '1/31/2010', '12/31/2010')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date NOT BETWEEN '2010-01-31' AND '2010-12-31'"
     )
     eq_(filter.description, 'excluding 01/31/2010 - 12/31/2010')

Example #10

File: test_filters.py Project: level12/webgrid

 def test_in_less_than_days(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('iltd', '10')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date >= '2012-01-01' AND persons.due_date < '2012-01-11'"
     )
     eq_(filter.description, '01/01/2012 - 01/11/2012')

Example #11

File: test_filters.py Project: level12/webgrid

 def test_empty(self):
     filter = DateFilter(Person.due_date)
     filter.set('empty', None)
     self.assert_filter_query(filter, "WHERE persons.due_date IS NULL")
     eq_(filter.description, 'date not specified')
     filter.set('empty', '')
     self.assert_filter_query(filter, "WHERE persons.due_date IS NULL")
     eq_(filter.description, 'date not specified')

Example #12

File: test_filters.py Project: level12/webgrid

 def test_this_year_default(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 4), default_op='thisyear')
     filter.set(None, None)
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date BETWEEN '2012-01-01' AND '2012-12-31'"
     )
     eq_(filter.description, '01/01/2012 - 12/31/2012')

Example #13

 def test_in_less_than_days(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('iltd', '10')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date >= '2012-01-01' AND persons.due_date < '2012-01-11'"
     )
     eq_(filter.description, '01/01/2012 - 01/11/2012')

Example #14

File: test_filters.py Project: level12/webgrid

 def test_not_empty(self):
     filter = DateFilter(Person.due_date)
     filter.set('!empty', None)
     self.assert_filter_query(filter, "WHERE persons.due_date IS NOT NULL")
     eq_(filter.description, 'any date')
     filter.set('!empty', '')
     self.assert_filter_query(filter, "WHERE persons.due_date IS NOT NULL")
     eq_(filter.description, 'any date')

Example #15

 def test_less_than_days_ago(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ltda', '10')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date > '2011-12-22' AND persons.due_date < '2012-01-01'"
     )
     eq_(filter.description, '12/22/2011 - 01/01/2012')

Example #16

File: test_filters.py Project: level12/webgrid

 def test_not_between(self):
     filter = DateFilter(Person.due_date)
     filter.set('!between', '1/31/2010', '12/31/2010')
     self.assert_filter_query(
         filter,
         "WHERE persons.due_date NOT BETWEEN '2010-01-31' AND '2010-12-31'"
     )
     eq_(filter.description, 'excluding 01/31/2010 - 12/31/2010')

Example #17

File: test_filters.py Project: level12/webgrid

    def test_not_between_none_date(self):
        filter = DateFilter(Person.due_date)
        filter.set('!between', '12/31/2010')
        today = dt.date.today().strftime('%Y-%m-%d')
        self.assert_filter_query(
            filter,
            "WHERE persons.due_date NOT BETWEEN '2010-12-31' AND '{}'".format(today)
        )

        with assert_raises(formencode.Invalid):
            filter.set('!between', None)
        eq_(filter.error, True)
        eq_(filter.description, 'invalid')

Example #18

    def test_not_between_none_date(self):
        filter = DateFilter(Person.due_date)
        filter.set('!between', '12/31/2010')
        today = dt.date.today().strftime('%Y-%m-%d')
        self.assert_filter_query(
            filter,
            "WHERE persons.due_date NOT BETWEEN '2010-12-31' AND '{}'".format(today)
        )

        with assert_raises(formencode.Invalid):
            filter.set('!between', None)
        eq_(filter.error, True)
        eq_(filter.description, 'invalid')

Example #19

File: test_filters.py Project: level12/webgrid

 def test_today(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('today', None)
     self.assert_filter_query(filter, "WHERE persons.due_date = '2012-01-01'")
     eq_(filter.description, '01/01/2012')

Example #20

 def test_more_than_days_ago(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('mtda', '10')
     self.assert_filter_query(filter, "WHERE persons.due_date < '2011-12-22'")
     eq_(filter.description, 'before 12/22/2011')

Example #21

File: test_filters.py Project: level12/webgrid

 def test_between_blank(self):
     filter = DateFilter(Person.due_date)
     with assert_raises(formencode.Invalid):
         filter.set('between', '', '')
     eq_(filter.error, True)
     eq_(filter.description, 'invalid')

Example #22

File: test_filters.py Project: level12/webgrid

 def test_gte(self):
     filter = DateFilter(Person.due_date)
     filter.set('gte', '12/31/2010')
     self.assert_filter_query(filter, "WHERE persons.due_date >= '2010-12-31'")
     eq_(filter.description, 'beginning 12/31/2010')

Example #23

 def test_in_more_than_days(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('imtd', '10')
     self.assert_filter_query(filter, "WHERE persons.due_date > '2012-01-11'")
     eq_(filter.description, 'after 01/11/2012')

Example #24

 def test_between_blank(self):
     filter = DateFilter(Person.due_date)
     with assert_raises(formencode.Invalid):
         filter.set('between', '', '')
     eq_(filter.error, True)
     eq_(filter.description, 'invalid')

Example #25

 def test_gte(self):
     filter = DateFilter(Person.due_date)
     filter.set('gte', '12/31/2010')
     self.assert_filter_query(filter, "WHERE persons.due_date >= '2010-12-31'")
     eq_(filter.description, 'beginning 12/31/2010')

Example #26

File: test_filters.py Project: level12/webgrid

 def test_in_days_empty_value2(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ind', '10', '')
     self.assert_filter_query(filter, "WHERE persons.due_date = '2012-01-11'")

Example #27

File: test_filters.py Project: level12/webgrid

 def test_days_operator_with_invalid_value(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ind', 'a')

Example #28

File: test_filters.py Project: level12/webgrid

 def test_int_filter_process(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 29))
     filter.set('ltda', '1', '')
     eq_(filter.error, False)

Example #29

File: test_filters.py Project: level12/webgrid

 def test_days_ago_overflow(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('da', '10142015')

Example #30

 def test_today(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('today', None)
     self.assert_filter_query(filter, "WHERE persons.due_date = '2012-01-01'")
     eq_(filter.description, '01/01/2012')

Example #31

File: test_filters.py Project: level12/webgrid

 def test_this_month_left_edge(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('thismonth', None)
     self.assert_filter_query(filter, self.between_sql)
     eq_(filter.description, '01/01/2012 - 01/31/2012')

Example #32

 def test_this_week_right_edge(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 7))
     filter.set('thisweek', None)
     self.assert_filter_query(filter, self.between_week_sql)
     eq_(filter.description, '01/01/2012 - 01/07/2012')

Example #33

 def test_this_month_left_edge(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('thismonth', None)
     self.assert_filter_query(filter, self.between_sql)
     eq_(filter.description, '01/01/2012 - 01/31/2012')

Example #34

 def test_last_month_right_edge(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 29))
     filter.set('lastmonth', None)
     self.assert_filter_query(filter, self.between_sql)
     eq_(filter.description, '01/01/2012 - 01/31/2012')

Example #35

 def test_selmonth(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 4))
     filter.set('selmonth', 1, 2012)
     self.assert_filter_query(filter, self.between_sql)
     eq_(filter.description, 'Jan 2012')

Example #36

 def test_int_filter_process(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 29))
     filter.set('ltda', '1', '')
     eq_(filter.error, False)

Example #37

File: test_filters.py Project: level12/webgrid

 def test_more_than_days_ago(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('mtda', '10')
     self.assert_filter_query(filter, "WHERE persons.due_date < '2011-12-22'")
     eq_(filter.description, 'before 12/22/2011')

Example #38

 def test_bad_date(self):
     filter = DateFilter(Person.due_date)
     with assert_raises(formencode.Invalid):
         filter.set('eq', '1/1/2015 - 8/31/2015')
     eq_(filter.error, True)
     eq_(filter.description, 'invalid')

Example #39

File: test_filters.py Project: level12/webgrid

 def test_in_more_than_days(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('imtd', '10')
     self.assert_filter_query(filter, "WHERE persons.due_date > '2012-01-11'")
     eq_(filter.description, 'after 01/11/2012')

Example #40

 def test_days_ago_overflow(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('da', '10142015')

Example #41

File: test_filters.py Project: level12/webgrid

 def test_this_week_right_edge(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 7))
     filter.set('thisweek', None)
     self.assert_filter_query(filter, self.between_week_sql)
     eq_(filter.description, '01/01/2012 - 01/07/2012')

Example #42

 def test_in_days_overflow(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ind', '10000000')

Example #43

File: test_filters.py Project: level12/webgrid

 def test_last_month_right_edge(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 29))
     filter.set('lastmonth', None)
     self.assert_filter_query(filter, self.between_sql)
     eq_(filter.description, '01/01/2012 - 01/31/2012')

Example #44

 def test_in_days_empty_value2(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ind', '10', '')
     self.assert_filter_query(filter, "WHERE persons.due_date = '2012-01-11'")

Example #45

File: test_filters.py Project: level12/webgrid

 def test_selmonth(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 2, 4))
     filter.set('selmonth', 1, 2012)
     self.assert_filter_query(filter, self.between_sql)
     eq_(filter.description, 'Jan 2012')

Example #46

 def test_invalid_date(self):
     filter = DateFilter(Person.due_date)
     filter.set('eq', '7/45/2007')

Example #47

File: test_filters.py Project: level12/webgrid

 def test_bad_date(self):
     filter = DateFilter(Person.due_date)
     with assert_raises(formencode.Invalid):
         filter.set('eq', '1/1/2015 - 8/31/2015')
     eq_(filter.error, True)
     eq_(filter.description, 'invalid')

Example #48

 def test_days_operator_with_invalid_value(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ind', 'a')

Example #49

File: test_filters.py Project: level12/webgrid

 def test_in_days_overflow(self):
     filter = DateFilter(Person.due_date, _now=dt.date(2012, 1, 1))
     filter.set('ind', '10000000')

Example #50

 def test_default(self):
     filter = DateFilter(Person.due_date, default_op='between', default_value1='1/31/2010',
                         default_value2='12/31/2010')
     filter.set(None, None)
     self.assert_filter_query(filter,
                              "WHERE persons.due_date BETWEEN '2010-01-31' AND '2010-12-31'")

Example #51

File: test_filters.py Project: level12/webgrid

 def test_invalid_date(self):
     filter = DateFilter(Person.due_date)
     filter.set('eq', '7/45/2007')

Example #52

File: test_filters.py Project: level12/webgrid

 def test_not_eq(self):
     filter = DateFilter(Person.due_date)
     filter.set('!eq', '12/31/2010')
     self.assert_filter_query(filter, "WHERE persons.due_date != '2010-12-31'")
     eq_(filter.description, 'excluding 12/31/2010')

Example #53

File: test_filters.py Project: level12/webgrid

 def test_default(self):
     filter = DateFilter(Person.due_date, default_op='between', default_value1='1/31/2010',
                         default_value2='12/31/2010')
     filter.set(None, None)
     self.assert_filter_query(filter,
                              "WHERE persons.due_date BETWEEN '2010-01-31' AND '2010-12-31'")

Example #54

 def test_not_eq(self):
     filter = DateFilter(Person.due_date)
     filter.set('!eq', '12/31/2010')
     self.assert_filter_query(filter, "WHERE persons.due_date != '2010-12-31'")
     eq_(filter.description, 'excluding 12/31/2010')