Komplexe Datensatz-Abonnements

In den folgenden Beispielen haben wir eine Tabelle namens students, die Felder und Beziehungen wie id, firstName, email, age enthält.

Abonnements mit Filtern

Sie können einzelne und verwandte Datensätze, die erstellt, aktualisiert und gelöscht werden, abonnieren, indem Sie die automatisch generierte GraphQL-Abonnementoperation von Archie Core verwenden.

Verfügbare Operatoren

Operator	Anwendungsbeispiel
eq	status = "active"
neq	type != "admin"
gt	age > 18
lt	price < 100
gte	score >= 80
lte	attempts <= 3
contains	name contains "john"
startsWith	email startsWith "admin"
endsWith	domain endsWith ".com"

Mehrere Bedingungen (Logisches UND)

GraphQL-Mutation

mutation createNewSubscription($input: SubscriptionInput!) {
  system {
    createSubscription(input: $input) {
      id
      active
      name
    }
  }
}

Variablen

{
  "input": {
    "name": "students_create_gte_lte",
    "description": "Subscription - students table - create - gte lte",
    "active": true,
    "tables": [
      {
        "table": "students",
        "operations": ["CREATE"],
        "fields": ["id", "first_name", "email", "age"],
        "conditions": [
          {
            "field": "age",
            "operator": "GTE",
            "value": "25"
          },
          {
            "field": "age",
            "operator": "LTE",
            "value": "50"
          }
        ]
      }
    ]
  }
}

Antwort

{
    "data": {
        "system": {
            "createSubscription": {
                "id": "id_subscription",
                "active": true,
                "name": "students_create_gte_lte"
            }
        }
    }
}

Mehrere Tabellen

GraphQL-Mutation

mutation createNewSubscription($input: SubscriptionInput!) {
  system {
    createSubscription(input: $input) {
      id
      active
      name
    }
  }
}

Variablen

{
  "input": {
    "name": "multiple_tables",
    "description": "Subscription multiple tables",
    "active": true,
    "tables": [
      {
        "table": "students",
        "operations": ["CREATE"],
        "fields": ["id", "first_name", "email", "age"],
        "conditions": [
          {
            "field": "age",
            "operator": "GTE",
            "value": "30"
          },
          {
            "field": "age",
            "operator": "LTE",
            "value": "60"
          }
        ]
      },
      {
        "table": "courses",
        "operations": ["UPDATE"],
        "fields": ["id", "code", "name_course", "price"],
        "conditions": [
          {
            "field": "price",
            "operator": "LTE",
            "value": "500"
          }
        ]
      }
    ]
  }
}

Antwort

{
    "data": {
        "system": {
            "createSubscription": {
                "id": "id_subscription",
                "active": true,
                "name": "multiple_tables"
            }
        }
    }
}