Riferimento alle funzioni di confronto

Riferimento alle funzioni di confronto

Anteprima — Firestore in Native mode (with Pipeline Operations) for Enterprise Edition

Questa funzionalità è soggetta ai "Termini delle Offerte pre-GA" nella sezione Termini di servizio generali dei Termini di servizio specifici. Puoi trattare i dati personali per questa funzionalità come indicato nell' Addendum per il trattamento dei dati Cloud, fatti salvi gli obblighi e le restrizioni all'interno dell'accordo che regola l'accesso a Google Cloud. Le funzionalità pre-GA sono disponibili "così come sono" e potrebbero avere un supporto limitato. Per ulteriori informazioni, consulta le descrizioni delle fasi di lancio.

Funzioni di confronto

Nome	Descrizione
EQUAL	Confronto di uguaglianza
GREATER_THAN	Confronto maggiore di
GREATER_THAN_OR_EQUAL	Confronto maggiore o uguale a
LESS_THAN	Confronto con il segno "minore di"
LESS_THAN_OR_EQUAL	Confronto minore o uguale
NOT_EQUAL	Confronto diverso da

EQUAL

Sintassi:

equal(x: ANY, y: ANY) -> BOOLEAN

Esempi:

x	y	equal(x, y)
1L	1L	TRUE
1,0	1L	TRUE
-1.0	1L	FALSE
NaN	NaN	TRUE
NULL	NULL	TRUE
NULL	ABSENT	FALSE

Descrizione:

Restituisce TRUE se x e y sono uguali, altrimenti restituisce FALSE.

Node.js

const result = await db.pipeline()
  .collection("books")
  .select(field("rating").equal(5).as("hasPerfe
ctRating"))
  .execute();test.firestore.js

Web

const result = await execute(db.pipeline()
  .collection("books")
  .select(field("rating").equal(5).as(&qu
ot;hasPerfectRati
ng"))
);test.firestore.js

Swift

let result = try await db.pipeline()
  .collection("books")
  .select([Field("rating").equal(5).as("hasPerfe
ctRating")])
  .e
xecute()PipelineSnippets.swift

Kotlin
Android

val result = db.pipeline()
    .collection("books")
    .select(field("rating").equal(5).alias("hasPerfec
tRating")
)
    .execute()DocSnippets.kt

Java
Android

Task<Pipeline.Snapshot> result = db.pipeline()
    .collection("books")
    .select(field("rating").equal(5).alias("hasPerfect
Rating"))
 
   .execute();DocSnippets.java

Python

from google.cloud.firestore_v1.pipeline_expressions import Field

result = (
    client.pipeline()
    .collection("books")
    .select(Field.of("rating").equal(5).as_("hasPerfectR
ating"))
    .exe
cute()
)firestore_pipelines.py

Java

Pipeline.Snapshot result =
    firestore
        .pipeline()
        .collection("books")
        .select(equal(field("rating"), 5).as("hasPerfectRating"))
    
    .execute()
      
  .get();PipelineSnippets.java

MAGGIORE_DI

Sintassi:

greater_than(x: ANY, y: ANY) -> BOOLEAN

Descrizione:

Restituisce TRUE se x è maggiore di y, altrimenti restituisce FALSE.

Se x e y non sono comparabili, restituisce FALSE.

Esempi:

x	y	greater_than(x, y)
1L	0.0	TRUE
1L	1L	FALSE
1L	2L	FALSE
"foo"	0L	FALSE
0L	"foo"	FALSE
NaN	0L	FALSE
0L	NaN	FALSE
NULL	NULL	FALSE

Node.js

const result = await db.pipeline()
  .collection("books")
  .select(field("rating").greaterThan(4).as("hasHi
ghRating"))
  .execute();test.firestore.js

Web

const result = await execute(db.pipeline()
  .collection("books")
  .select(field("rating").greaterThan(4).as(
"hasHighRati
ng"))
);test.firestore.js

Swift

let result = try await db.pipeline()
  .collection("books")
  .select([Field("rating").greaterThan(4).as("hasHi
ghRating")])
  .e
xecute()PipelineSnippets.swift

Kotlin
Android

val result = db.pipeline()
    .collection("books")
    .select(field("rating").greaterThan(4).alias("hasHig
hRating")
)
    .execute()DocSnippets.kt

Java
Android

Task<Pipeline.Snapshot> result = db.pipeline()
    .collection("books")
    .select(field("rating").greaterThan(4).alias("hasHigh
Rating"))
 
   .execute();DocSnippets.java

Python

from google.cloud.firestore_v1.pipeline_expressions import Field

result = (
    client.pipeline()
    .collection("books")
    .select(Field.of("rating").greater_than(4).as_("hasHighR
ating"))
    .exe
cute()
)firestore_pipelines.py

Java

Pipeline.Snapshot result =
    firestore
        .pipeline()
        .collection("books")
        .select(greaterThan(field("rating"), 4).as("hasHighRating"))
    
    .execute()
      
  .get();PipelineSnippets.java

MAGGIORE_UGUALE

Sintassi:

greater_than_or_equal(x: ANY, y: ANY) -> BOOLEAN

Descrizione:

Restituisce TRUE se x è maggiore o uguale a y, altrimenti restituisce FALSE.

Se x e y non sono comparabili, restituisce FALSE.

Esempi:

x	y	greater_than_or_equal(x, y)
1L	0.0	TRUE
1L	1L	TRUE
1L	2L	FALSE
"foo"	0L	FALSE
0L	"foo"	FALSE
NaN	0L	FALSE
0L	NaN	FALSE
NULL	NULL	TRUE

Node.js

const result = await db.pipeline()
  .collection("books")
  .select(field("published").greaterThanOrEqual(1900).as("publishedIn20t
hCentury"))
  .execute();test.firestore.js

Web

const result = await execute(db.pipeline()
  .collection("books")
  .select(field("published").greaterThanOrEqual(1900).as("pub
lishedIn20thCentu
ry"))
);test.firestore.js

Swift

let result = try await db.pipeline()
  .collection("books")
  .select([Field("published").greaterThanOrEqual(1900).as("publishedIn20t
hCentury")])
  .e
xecute()PipelineSnippets.swift

Kotlin
Android

val result = db.pipeline()
    .collection("books")
    .select(field("published").greaterThanOrEqual(1900).alias("publishedIn20th
Century")
)
    .execute()DocSnippets.kt

Java
Android

Task<Pipeline.Snapshot> result = db.pipeline()
    .collection("books")
    .select(field("published").greaterThanOrEqual(1900).alias("publishedIn20thC
entury"))
 
   .execute();DocSnippets.java

Python

from google.cloud.firestore_v1.pipeline_expressions import Field

result = (
    client.pipeline()
    .collection("books")
    .select(
        Field.of("published")
        .greater_than_or_equal(1900)
        .as_("publishedIn20thCentury
")
    )
    .exe
cute()
)firestore_pipelines.py

Java

Pipeline.Snapshot result =
    firestore
        .pipeline()
        .collection("books")
        .select(greaterThanOrEqual(field("published"), 1900).as("publishedIn20thCentury"))
    
    .execute()
      
  .get();PipelineSnippets.java

LESS_THAN

Sintassi:

less_than(x: ANY, y: ANY) -> BOOLEAN

Descrizione:

Restituisce TRUE se x è minore di y, altrimenti restituisce FALSE.

Se x e y non sono comparabili, restituisce FALSE.

Esempi:

x	y	less_than(x, y)
1L	0.0	FALSE
1L	1L	FALSE
1L	2L	TRUE
"foo"	0L	FALSE
0L	"foo"	FALSE
NaN	0L	FALSE
0L	NaN	FALSE
NULL	NULL	FALSE

Node.js

const result = await db.pipeline()
  .collection("books")
  .select(field("published").lessThan(1923).as("isPublicDomain
Probably"))
  .execute();test.firestore.js

Web

const result = await execute(db.pipeline()
  .collection("books")
  .select(field("published").lessThan(1923).as("isP
ublicDomainProbab
ly"))
);test.firestore.js

Swift

let result = try await db.pipeline()
  .collection("books")
  .select([Field("published").lessThan(1923).as("isPublicDomain
Probably")])
  .e
xecute()PipelineSnippets.swift

Kotlin
Android

val result = db.pipeline()
    .collection("books")
    .select(field("published").lessThan(1923).alias("isPublicDomainP
robably")
)
    .execute()DocSnippets.kt

Java
Android

Task<Pipeline.Snapshot> result = db.pipeline()
    .collection("books")
    .select(field("published").lessThan(1923).alias("isPublicDomainPr
obably"))
 
   .execute();DocSnippets.java

Python

from google.cloud.firestore_v1.pipeline_expressions import Field

result = (
    client.pipeline()
    .collection("books")
    .select(Field.of("published").less_than(1923).as_("isPublicDomainPro
bably"))
    .exe
cute()
)firestore_pipelines.py

Java

Pipeline.Snapshot result =
    firestore
        .pipeline()
        .collection("books")
        .select(lessThan(field("published"), 1923).as("isPublicDomainProbably"))
    
    .execute()
      
  .get();PipelineSnippets.java

LESS_THAN_OR_EQUAL

Sintassi:

less_than_or_equal(x: ANY, y: ANY) -> BOOLEAN

Descrizione:

Restituisce TRUE se x è minore o uguale a y, altrimenti restituisce FALSE.

Se x e y non sono comparabili, restituisce FALSE.

Esempi:

x	y	less_than(x, y)
1L	0.0	FALSE
1L	1L	TRUE
1L	2L	TRUE
"foo"	0L	FALSE
0L	"foo"	FALSE
NaN	0L	FALSE
0L	NaN	FALSE
NULL	NULL	TRUE

Node.js

const result = await db.pipeline()
  .collection("books")
  .select(field("rating").lessThanOrEqual(2).as("hasB
adRating"))
  .execute();test.firestore.js

Web

const result = await execute(db.pipeline()
  .collection("books")
  .select(field("rating").lessThanOrEqual(2).as
("hasBadRati
ng"))
);test.firestore.js

Swift

let result = try await db.pipeline()
  .collection("books")
  .select([Field("rating").lessThanOrEqual(2).as("hasB
adRating")])
  .e
xecute()PipelineSnippets.swift

Kotlin
Android

val result = db.pipeline()
    .collection("books")
    .select(field("rating").lessThanOrEqual(2).alias("hasBa
dRating")
)
    .execute()DocSnippets.kt

Java
Android

Task<Pipeline.Snapshot> result = db.pipeline()
    .collection("books")
    .select(field("rating").lessThanOrEqual(2).alias("hasBad
Rating"))
 
   .execute();DocSnippets.java

Python

from google.cloud.firestore_v1.pipeline_expressions import Field

result = (
    client.pipeline()
    .collection("books")
    .select(Field.of("rating").less_than_or_equal(2).as_("hasBadR
ating"))
    .exe
cute()
)firestore_pipelines.py

Java

Pipeline.Snapshot result =
    firestore
        .pipeline()
        .collection("books")
        .select(lessThanOrEqual(field("rating"), 2).as("hasBadRating"))
    
    .execute()
      
  .get();PipelineSnippets.java

NOT_EQUAL

Sintassi:

not_equal(x: ANY, y: ANY) -> BOOLEAN

Descrizione:

Restituisce TRUE se x non è uguale a y, altrimenti restituisce FALSE.

Esempi:

x	y	not_equal(x, y)
1L	1L	FALSE
1,0	1L	FALSE
-1.0	1L	TRUE
NaN	0L	TRUE
NaN	NaN	FALSE
NULL	NULL	FALSE
NULL	ABSENT	TRUE

Node.js

const result = await db.pipeline()
  .collection("books")
  .select(field("title").notEqual("1984"
).as("not198
4"))
  .execute();test.firestore.js

Web

const result = await execute(db.pipeline()
  .collection("books")
  .select(field("title").notEqual("
;1984").as(&
quot;not1984"))
);test.firestore.js

Swift

let result = try await db.pipeline()
  .collection("books")
  .select([Field("title").notEqual("1984"
).as("not1984&quo
t;)])
  .execute()PipelineSnippets.swift

Kotlin
Android

val result = db.pipeline()
    .collection("books")
    .select(field("title").notEqual("1984").al
ias("not1
984"))
    .execute()DocSnippets.kt

Java
Android

Task<Pipeline.Snapshot> result = db.pipeline()
    .collection("books")
    .select(field("title").notEqual("1984").ali
as("not1984
"))
    .execute();DocSnippets.java

Python

from google.cloud.firestore_v1.pipeline_expressions import Field

result = (
    client.pipeline()
    .collection("books")
    .select(Field.of("title").not_equal("1984").as
_("not1984")
)
    .execute()
)firestore_pipelines.py

Java

Pipeline.Snapshot result =
    firestore
        .pipeline()
        .collection("books")
        .select(notEqual(field("title"), "1984").as("not1984&qu
ot;))
        .execut
e()
        .get();PipelineSnippets.java

Passaggi successivi

• Consulta la panoramica delle query di pipeline.