Abonnements à des Enregistrements Complexes

Dans les exemples suivants, nous avons une table appelée students, qui contient des champs et des relations comme id, firstName, email, age.

Abonnements utilisant des filtres

Vous pouvez vous abonner à la création, la mise à jour et la suppression d’enregistrements individuels et liés en utilisant l’opération d’abonnement GraphQL générée automatiquement par Archie Core.

Opérateurs Disponibles

Opérateur	Exemple d’Utilisation
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"

Conditions Multiples (ET Logique)

Mutation GraphQL

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

Variables

{
  "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"
          }
        ]
      }
    ]
  }
}

Réponse

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

Tables Multiples

Mutation GraphQL

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

Variables

{
  "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"
          }
        ]
      }
    ]
  }
}

Réponse

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