コード例 #1
0
 def test_string_comparison(self, table_):
     filter_ = Filter(table_, "name = parrot")
     assert filter_.table == [
         {
             "id": 1,
             "owner_id": 2,
             "name": "parrot"
         },
     ]
コード例 #2
0
 def test_string_contains(self, table_):
     filter_ = Filter(table_, "name LIKE par")
     assert filter_.table == [
         {
             "id": 1,
             "owner_id": 2,
             "name": "parrot"
         },
     ]
コード例 #3
0
 def test_double_logical_filtering(self, table_):
     filter_ = Filter(table_, "id = 3 OR owner_id = 2")
     assert filter_.table == [
         {
             "id": 1,
             "owner_id": 2,
             "name": "parrot"
         },
         {
             "id": 3,
             "owner_id": 1,
             "name": "cat"
         },
     ]
コード例 #4
0
 def test_simple_filtering(self, table_):
     filter_ = Filter(table_, "id > 1 AND owner_id = 1")
     assert filter_.table == [
         {
             "id": 2,
             "owner_id": 1,
             "name": "dog"
         },
         {
             "id": 3,
             "owner_id": 1,
             "name": "cat"
         },
     ]
コード例 #5
0
ファイル: db.py プロジェクト: sysconfdb/sysconfdb
def recent(tags = []):
	query = Select(
			filter = Filter.recent() & Filter.tags(tags),
			order = Order.start_date(reverse = True))
	return query.execute(cursor())
コード例 #6
0
ファイル: db.py プロジェクト: sysconfdb/sysconfdb
def upcoming(tags = []):
	query = Select(
			filter = Filter.upcoming() & Filter.tags(tags),
			order = Order.start_date())
	return query.execute(cursor())
コード例 #7
0
ファイル: db.py プロジェクト: sysconfdb/sysconfdb
def deadlines(tags = []):
	query = Select(
			filter = Filter.upcomingDeadlines() & Filter.tags(tags),
			order = Order.deadline())
	return query.execute(cursor())