Validation

# Stands in for a record that is already invalid, as older data often is: validation-level=254
# (SKIP_ALL, every skip bit from 2 to 128) lets the invalid e-mail address in. Do not do this
# in your own code.
account=$(curl -sS --fail-with-body "$COEVERA_BASE/entities/Accounts?validation-level=254" \
  -u "$COEVERA_API_KEY:$COEVERA_API_SECRET" \
  -H "Content-Type: application/json" \
  -d @- <<JSON
{ "name": "Northwind Analytics", "owner_id": "$OWNER_ID", "email1": "not-an-email" }
JSON
)
ACCOUNT_ID=$(jq -er '.data.id' <<<"$account")

// Stands in for a record that is already invalid, as older data often is: validation-level=254
// (SKIP_ALL, every skip bit from 2 to 128) lets the invalid e-mail address in. Do not do this
// in your own code.
const created = await call("/entities/Accounts?validation-level=254", {
  name: "Northwind Analytics",
  owner_id: ownerId,
  email1: "not-an-email",
});
if (created.status >= 300) throw new Error(`HTTP ${created.status} ${created.body.name}: ${created.body.message}`);
const accountId: string = created.body.data.id;

# Stands in for a record that is already invalid, as older data often is: validation-level=254
# (SKIP_ALL, every skip bit from 2 to 128) lets the invalid e-mail address in. Do not do this
# in your own code.
created = session.post(
    f"{BASE}/entities/Accounts",
    params={"validation-level": 254},
    json={"name": "Northwind Analytics", "owner_id": owner_id, "email1": "not-an-email"},
    timeout=60,
)
if not created.ok:
    sys.exit(f"HTTP {created.status_code}: {created.text}")
account_id = created.json()["data"]["id"]

# Stands in for a record that is already invalid, as older data often is: SKIP_ALL lets the
# invalid e-mail address in. Do not do this in your own code.
ACCOUNT_ID=$(jq -n --arg owner "$OWNER_ID" '{
  query: "mutation Existing($input: CreateAccountInput!) { createAccount(input: $input, validationLevel: [SKIP_ALL]) { account { id } } }",
  variables: { input: { name: "Northwind Analytics", ownerId: $owner, email1: "not-an-email" } }
}' | gql | jq -er '.data.createAccount.account.id')

// Stands in for a record that is already invalid, as older data often is: SKIP_ALL lets the
// invalid e-mail address in. Do not do this in your own code.
const created = await gql(
  `mutation Existing($input: CreateAccountInput!) {
  createAccount(input: $input, validationLevel: [SKIP_ALL]) { account { id } }
}`,
  { input: { name: "Northwind Analytics", ownerId, email1: "not-an-email" } },
);
if (created.errors) throw new Error(`Unexpected GraphQL errors: ${JSON.stringify(created.errors)}`);
const accountId: string = created.data.createAccount.account.id;

# Stands in for a record that is already invalid, as older data often is: SKIP_ALL lets the
# invalid e-mail address in. Do not do this in your own code.
created = gql(
    """
mutation Existing($input: CreateAccountInput!) {
  createAccount(input: $input, validationLevel: [SKIP_ALL]) { account { id } }
}
""",
    {"input": {"name": "Northwind Analytics", "ownerId": owner_id, "email1": "not-an-email"}},
)
if created.get("errors"):
    sys.exit(f"Unexpected GraphQL errors: {json.dumps(created['errors'])}")
account_id = created["data"]["createAccount"]["account"]["id"]

# The sync sends the whole record back with one change, the city. The unchanged, invalid
# e-mail address fails the update: HTTP 422, and nothing is written. No --fail-with-body:
# the 422 is the expected answer here.
UPDATE="[{ \"id\": \"$ACCOUNT_ID\", \"email1\": \"not-an-email\", \"city\": \"Seattle\" }]"
curl -sS -w '\nHTTP %{http_code}\n' "$COEVERA_BASE/entities/Accounts/batch-modify" \
  -u "$COEVERA_API_KEY:$COEVERA_API_SECRET" \
  -H "Content-Type: application/json" \
  -d "$UPDATE"

// The sync sends the whole record back with one change, the city. The unchanged, invalid
// e-mail address fails the update: HTTP 422, and nothing is written.
const update = [{ id: accountId, email1: "not-an-email", city: "Seattle" }];
const strict = await call("/entities/Accounts/batch-modify", update);
console.log(`Full validation: HTTP ${strict.status}`, JSON.stringify(strict.body, null, 2));

# The sync sends the whole record back with one change, the city. The unchanged, invalid
# e-mail address fails the update: HTTP 422, and nothing is written.
update = [{"id": account_id, "email1": "not-an-email", "city": "Seattle"}]
strict = session.post(f"{BASE}/entities/Accounts/batch-modify", json=update, timeout=60)
print(f"Full validation: HTTP {strict.status_code}", json.dumps(strict.json(), indent=2))

# sync [LEVEL]: the update request, the whole record with one change, the city. LEVEL is a JSON
# list of validation levels; without it, full validation. Leave validationLevel out rather than
# sending null: an explicit null is answered with an unexpected error (code 1000).
sync() {
  jq -n --arg id "$ACCOUNT_ID" --argjson level "${1:-null}" '{
    query: "mutation Sync($input: [CreateOrUpdateAccountInput!]!, $validationLevel: [ValidationLevel!]) { bulkUpdateAccount(input: $input, validationLevel: $validationLevel) { result { updated errors { index code message } } } }",
    variables: ({ input: [{ id: $id, email1: "not-an-email", city: "Seattle" }] }
      + if $level then { validationLevel: $level } else {} end)
  }'
}
# The unchanged, invalid e-mail address fails the update: HTTP 200 with errors and no result,
# and nothing is written.
sync | gql
echo

// The sync sends the whole record back with one change, the city. The unchanged, invalid
// e-mail address fails the update: HTTP 200 with errors and no result, and nothing is written.
const UPDATE = `mutation Sync($input: [CreateOrUpdateAccountInput!]!, $validationLevel: [ValidationLevel!]) {
  bulkUpdateAccount(input: $input, validationLevel: $validationLevel) {
    result {
      updated
      errors { index code message }
    }
  }
}`;
const update = [{ id: accountId, email1: "not-an-email", city: "Seattle" }];
const strict = await gql(UPDATE, { input: update });
console.log("Full validation:", JSON.stringify(strict, null, 2));

# The sync sends the whole record back with one change, the city. The unchanged, invalid
# e-mail address fails the update: HTTP 200 with errors and no result, and nothing is written.
UPDATE = """
mutation Sync($input: [CreateOrUpdateAccountInput!]!, $validationLevel: [ValidationLevel!]) {
  bulkUpdateAccount(input: $input, validationLevel: $validationLevel) {
    result {
      updated
      errors { index code message }
    }
  }
}
"""
update = [{"id": account_id, "email1": "not-an-email", "city": "Seattle"}]
strict = gql(UPDATE, {"input": update})
print("Full validation:", json.dumps(strict, indent=2))

# The same update with validation-level=2 (SKIP_UNCHANGED_FIELDS): only the city is validated.
curl -sS --fail-with-body "$COEVERA_BASE/entities/Accounts/batch-modify?validation-level=2" \
  -u "$COEVERA_API_KEY:$COEVERA_API_SECRET" \
  -H "Content-Type: application/json" \
  -d "$UPDATE"
echo

// The same update with validation-level=2 (SKIP_UNCHANGED_FIELDS): only the city is validated.
const relaxed = await call("/entities/Accounts/batch-modify?validation-level=2", update);
console.log(`validation-level=2: HTTP ${relaxed.status}`, JSON.stringify(relaxed.body, null, 2));
if (relaxed.status !== 200) throw new Error(`Expected HTTP 200, got ${relaxed.status}`);

# The same update with validation-level=2 (SKIP_UNCHANGED_FIELDS): only the city is validated.
relaxed = session.post(
    f"{BASE}/entities/Accounts/batch-modify",
    params={"validation-level": 2},
    json=update,
    timeout=60,
)
print(f"validation-level=2: HTTP {relaxed.status_code}", json.dumps(relaxed.json(), indent=2))
if relaxed.status_code != 200:
    sys.exit(f"Expected HTTP 200, got {relaxed.status_code}")

# The same update with SKIP_UNCHANGED_FIELDS: only the city is validated.
relaxed=$(sync '["SKIP_UNCHANGED_FIELDS"]' | gql)
echo "$relaxed"
if jq -e '.errors' <<<"$relaxed" >/dev/null; then
  echo "Unexpected GraphQL errors" >&2
  exit 1
fi

// The same update with SKIP_UNCHANGED_FIELDS: only the city is validated.
const relaxed = await gql(UPDATE, { input: update, validationLevel: ["SKIP_UNCHANGED_FIELDS"] });
console.log("SKIP_UNCHANGED_FIELDS:", JSON.stringify(relaxed, null, 2));
if (relaxed.errors) throw new Error(`Unexpected GraphQL errors: ${JSON.stringify(relaxed.errors)}`);

# The same update with SKIP_UNCHANGED_FIELDS: only the city is validated.
relaxed = gql(UPDATE, {"input": update, "validationLevel": ["SKIP_UNCHANGED_FIELDS"]})
print("SKIP_UNCHANGED_FIELDS:", json.dumps(relaxed, indent=2))
if relaxed.get("errors"):
    sys.exit(f"Unexpected GraphQL errors: {json.dumps(relaxed['errors'])}")