19
19
from google .api_core .client_options import ClientOptions
20
20
import google .cloud .exceptions
21
21
from google .cloud import datastore # noqa: I100
22
+ from google .cloud .datastore .query import PropertyFilter
22
23
23
24
24
25
def _preamble ():
@@ -385,7 +386,7 @@ def unindexed_property_query(client):
385
386
386
387
# [START datastore_unindexed_property_query]
387
388
query = client .query (kind = "Task" )
388
- query .add_filter ("description" , "=" , "Learn Cloud Datastore" )
389
+ query .add_filter (filter = PropertyFilter ( "description" , "=" , "Learn Cloud Datastore" ) )
389
390
# [END datastore_unindexed_property_query]
390
391
391
392
return list (query .fetch ())
@@ -397,8 +398,8 @@ def basic_query(client):
397
398
398
399
# [START datastore_basic_query]
399
400
query = client .query (kind = "Task" )
400
- query .add_filter ("done" , "=" , False )
401
- query .add_filter ("priority" , ">=" , 4 )
401
+ query .add_filter (filter = PropertyFilter ( "done" , "=" , False ) )
402
+ query .add_filter (filter = PropertyFilter ( "priority" , ">=" , 4 ) )
402
403
query .order = ["-priority" ]
403
404
# [END datastore_basic_query]
404
405
@@ -502,7 +503,7 @@ def property_filter(client):
502
503
503
504
# [START datastore_property_filter]
504
505
query = client .query (kind = "Task" )
505
- query .add_filter ("done" , "=" , False )
506
+ query .add_filter (filter = PropertyFilter ( "done" , "=" , False ) )
506
507
# [END datastore_property_filter]
507
508
508
509
return list (query .fetch ())
@@ -514,8 +515,8 @@ def composite_filter(client):
514
515
515
516
# [START datastore_composite_filter]
516
517
query = client .query (kind = "Task" )
517
- query .add_filter ("done" , "=" , False )
518
- query .add_filter ("priority" , "=" , 4 )
518
+ query .add_filter (filter = PropertyFilter ( "done" , "=" , False ) )
519
+ query .add_filter (filter = PropertyFilter ( "priority" , "=" , 4 ) )
519
520
# [END datastore_composite_filter]
520
521
521
522
return list (query .fetch ())
@@ -622,8 +623,8 @@ def inequality_range(client):
622
623
start_date = datetime .datetime (1990 , 1 , 1 )
623
624
end_date = datetime .datetime (2000 , 1 , 1 )
624
625
query = client .query (kind = "Task" )
625
- query .add_filter ("created" , ">" , start_date )
626
- query .add_filter ("created" , "<" , end_date )
626
+ query .add_filter (filter = PropertyFilter ( "created" , ">" , start_date ) )
627
+ query .add_filter (filter = PropertyFilter ( "created" , "<" , end_date ) )
627
628
# [END datastore_inequality_range]
628
629
629
630
return list (query .fetch ())
@@ -634,8 +635,8 @@ def inequality_invalid(client):
634
635
# [START datastore_inequality_invalid]
635
636
start_date = datetime .datetime (1990 , 1 , 1 )
636
637
query = client .query (kind = "Task" )
637
- query .add_filter ("created" , ">" , start_date )
638
- query .add_filter ("priority" , ">" , 3 )
638
+ query .add_filter (filter = PropertyFilter ( "created" , ">" , start_date ) )
639
+ query .add_filter (filter = PropertyFilter ( "priority" , ">" , 3 ) )
639
640
# [END datastore_inequality_invalid]
640
641
641
642
return list (query .fetch ())
@@ -649,10 +650,10 @@ def equal_and_inequality_range(client):
649
650
start_date = datetime .datetime (1990 , 1 , 1 )
650
651
end_date = datetime .datetime (2000 , 12 , 31 , 23 , 59 , 59 )
651
652
query = client .query (kind = "Task" )
652
- query .add_filter ("priority" , "=" , 4 )
653
- query .add_filter ("done" , "=" , False )
654
- query .add_filter ("created" , ">" , start_date )
655
- query .add_filter ("created" , "<" , end_date )
653
+ query .add_filter (filter = PropertyFilter ( "priority" , "=" , 4 ) )
654
+ query .add_filter (filter = PropertyFilter ( "done" , "=" , False ) )
655
+ query .add_filter (filter = PropertyFilter ( "created" , ">" , start_date ) )
656
+ query .add_filter (filter = PropertyFilter ( "created" , "<" , end_date ) )
656
657
# [END datastore_equal_and_inequality_range]
657
658
658
659
return list (query .fetch ())
@@ -661,7 +662,7 @@ def equal_and_inequality_range(client):
661
662
def inequality_sort (client ):
662
663
# [START datastore_inequality_sort]
663
664
query = client .query (kind = "Task" )
664
- query .add_filter ("priority" , ">" , 3 )
665
+ query .add_filter (filter = PropertyFilter ( "priority" , ">" , 3 ) )
665
666
query .order = ["priority" , "created" ]
666
667
# [END datastore_inequality_sort]
667
668
@@ -672,7 +673,7 @@ def inequality_sort_invalid_not_same(client):
672
673
try :
673
674
# [START datastore_inequality_sort_invalid_not_same]
674
675
query = client .query (kind = "Task" )
675
- query .add_filter ("priority" , ">" , 3 )
676
+ query .add_filter (filter = PropertyFilter ( "priority" , ">" , 3 ) )
676
677
query .order = ["created" ]
677
678
# [END datastore_inequality_sort_invalid_not_same]
678
679
@@ -686,7 +687,7 @@ def inequality_sort_invalid_not_first(client):
686
687
try :
687
688
# [START datastore_inequality_sort_invalid_not_first]
688
689
query = client .query (kind = "Task" )
689
- query .add_filter ("priority" , ">" , 3 )
690
+ query .add_filter (filter = PropertyFilter ( "priority" , ">" , 3 ) )
690
691
query .order = ["created" , "priority" ]
691
692
# [END datastore_inequality_sort_invalid_not_first]
692
693
@@ -699,8 +700,8 @@ def inequality_sort_invalid_not_first(client):
699
700
def array_value_inequality_range (client ):
700
701
# [START datastore_array_value_inequality_range]
701
702
query = client .query (kind = "Task" )
702
- query .add_filter ("tag" , ">" , "learn" )
703
- query .add_filter ("tag" , "<" , "math" )
703
+ query .add_filter (filter = PropertyFilter ( "tag" , ">" , "learn" ) )
704
+ query .add_filter (filter = PropertyFilter ( "tag" , "<" , "math" ) )
704
705
# [END datastore_array_value_inequality_range]
705
706
706
707
return list (query .fetch ())
@@ -709,8 +710,8 @@ def array_value_inequality_range(client):
709
710
def array_value_equality (client ):
710
711
# [START datastore_array_value_equality]
711
712
query = client .query (kind = "Task" )
712
- query .add_filter ("tag" , "=" , "fun" )
713
- query .add_filter ("tag" , "=" , "programming" )
713
+ query .add_filter (filter = PropertyFilter ( "tag" , "=" , "fun" ) )
714
+ query .add_filter (filter = PropertyFilter ( "tag" , "=" , "programming" ) )
714
715
# [END datastore_array_value_equality]
715
716
716
717
return list (query .fetch ())
0 commit comments