Skip to content

Instantly share code, notes, and snippets.

@lynsei

lynsei/1-o7l.expect.behavior.sql

Created January 30, 2021 13:50
Show Gist options
  • Save lynsei/ae537c79dc5a1cf6aa6fad08dff35a74 to your computer and use it in GitHub Desktop.
Save lynsei/ae537c79dc5a1cf6aa6fad08dff35a74 to your computer and use it in GitHub Desktop.
Download ZIP
07l .openful .stack .expect [ behavior ] .graphql
Raw
1-o7l.expect.behavior.sql
SELECT
json_build_object(
'aggregate',
json_build_object('count', COUNT(*)),
'nodes',
coalesce(json_agg("nodes"), '[]')
) AS "root"
FROM
(
SELECT
row_to_json(
(
SELECT
"_11_e"
FROM
(
SELECT
"_0_root.base"."business_reason" AS "business_reason",
"_0_root.base"."business_requirement" AS "business_requirement",
"_0_root.base"."detailed_description" AS "detailed_description",
"_0_root.base"."encrypted_stack_file_location" AS "encrypted_stack_file_location",
"_10_root.or.for_language"."for_language" AS "for_language",
"_0_root.base"."github_release_uri" AS "github_release_uri",
"_0_root.base"."github_repo_uri" AS "github_repo_uri",
"_0_root.base"."gpg_public_key" AS "gpg_public_key",
"_0_root.base"."gpg_signature" AS "gpg_signature",
"_0_root.base"."gradle_uri" AS "gradle_uri",
"_0_root.base"."id" AS "id",
"_0_root.base"."language" AS "language",
"_0_root.base"."maven_uri" AS "maven_uri",
"_0_root.base"."s3_download_uri" AS "s3_download_uri",
"_0_root.base"."shortname" AS "shortname",
"_0_root.base"."stack_standard_certified" AS "stack_standard_certified",
"_0_root.base"."npm_uri" AS "npm_uri"
) AS "_11_e"
)
) AS "nodes"
FROM
(
SELECT
*
FROM
"public"."expect_behavior"
WHERE
(
(
("public"."expect_behavior"."business_reason") = (('auth.basic') :: bpchar)
)
AND (
(
"public"."expect_behavior"."business_requirement"
) = (('auth.basic') :: bpchar)
)
)
) AS "_0_root.base"
LEFT OUTER JOIN LATERAL (
SELECT
row_to_json(
(
SELECT
"_9_e"
FROM
(
SELECT
"_1_root.or.for_language.base"."cli_documentation_uri" AS "cli_documentation_uri",
"_1_root.or.for_language.base"."cli_plugin_uri" AS "cli_plugin_uri",
"_1_root.or.for_language.base"."created_at" AS "created_at",
"_1_root.or.for_language.base"."description" AS "description",
"_1_root.or.for_language.base"."enterprise_support_uri" AS "enterprise_support_uri",
"_1_root.or.for_language.base"."github_uri" AS "github_uri",
"_1_root.or.for_language.base"."id" AS "id",
"_1_root.or.for_language.base"."installation_instructions_uri" AS "installation_instructions_uri",
"_1_root.or.for_language.base"."lang" AS "lang",
"_8_root.or.for_language.ar.for_language.on_conditions_aggregate"."on_conditions_aggregate" AS "on_conditions_aggregate",
"_1_root.or.for_language.base"."package_manager_download_uri" AS "package_manager_download_uri",
"_1_root.or.for_language.base"."package_manager_uri" AS "package_manager_uri",
"_1_root.or.for_language.base"."relevant_apis" AS "relevant_apis",
"_1_root.or.for_language.base"."sandbox_uri" AS "sandbox_uri",
"_1_root.or.for_language.base"."sdk_uri" AS "sdk_uri",
"_1_root.or.for_language.base"."title" AS "title"
) AS "_9_e"
)
) AS "for_language"
FROM
(
SELECT
*
FROM
"public"."for_language"
WHERE
(("_0_root.base"."language") = ("title"))
) AS "_1_root.or.for_language.base"
LEFT OUTER JOIN LATERAL (
SELECT
json_build_object(
'aggregate',
json_build_object('count', COUNT(*)),
'nodes',
coalesce(json_agg("nodes"), '[]')
) AS "on_conditions_aggregate"
FROM
(
SELECT
row_to_json(
(
SELECT
"_6_e"
FROM
(
SELECT
"_2_root.or.for_language.ar.for_language.on_conditions_aggregate.base"."created_at" AS "created_at",
"_2_root.or.for_language.ar.for_language.on_conditions_aggregate.base"."event_graph" AS "event_graph",
"_5_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language"."for_language" AS "for_language",
"_2_root.or.for_language.ar.for_language.on_conditions_aggregate.base"."required_condition" AS "required_condition",
"_2_root.or.for_language.ar.for_language.on_conditions_aggregate.base"."language" AS "language",
"_2_root.or.for_language.ar.for_language.on_conditions_aggregate.base"."run_behavior" AS "run_behavior"
) AS "_6_e"
)
) AS "nodes"
FROM
(
SELECT
*
FROM
"public"."on_condition"
WHERE
(
("_1_root.or.for_language.base"."title") = ("language")
)
) AS "_2_root.or.for_language.ar.for_language.on_conditions_aggregate.base"
LEFT OUTER JOIN LATERAL (
SELECT
row_to_json(
(
SELECT
"_4_e"
FROM
(
SELECT
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."cli_documentation_uri" AS "cli_documentation_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."cli_plugin_uri" AS "cli_plugin_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."created_at" AS "created_at",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."description" AS "description",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."enterprise_support_uri" AS "enterprise_support_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."github_uri" AS "github_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."installation_instructions_uri" AS "installation_instructions_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."lang" AS "lang",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."package_manager_download_uri" AS "package_manager_download_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."id" AS "id",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."package_manager_uri" AS "package_manager_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."relevant_apis" AS "relevant_apis",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."sandbox_uri" AS "sandbox_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."sdk_uri" AS "sdk_uri",
"_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"."title" AS "title"
) AS "_4_e"
)
) AS "for_language"
FROM
(
SELECT
*
FROM
"public"."for_language"
WHERE
(
(
"_2_root.or.for_language.ar.for_language.on_conditions_aggregate.base"."language"
) = ("title")
)
) AS "_3_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language.base"
) AS "_5_root.or.for_language.ar.for_language.on_conditions_aggregate.or.for_language" ON ('true')
) AS "_7_root.or.for_language.ar.for_language.on_conditions_aggregate"
) AS "_8_root.or.for_language.ar.for_language.on_conditions_aggregate" ON ('true')
) AS "_10_root.or.for_language" ON ('true')
) AS "_12_root"
Raw
2-o7l.expect.behavior.graphql
query MyQuery($_eq: bpchar = "", $_eq1: bpchar = "") {
expect_behavior_aggregate(where: {business_reason: {_eq: $_eq}, business_requirement: {_eq: $_eq1}}) {
aggregate {
count
}
nodes {
business_reason
business_requirement
detailed_description
encrypted_stack_file_location
for_language {
cli_documentation_uri
cli_plugin_uri
created_at
description
enterprise_support_uri
github_uri
id
installation_instructions_uri
lang
on_conditions_aggregate {
aggregate {
count
}
nodes {
created_at
event_graph
for_language {
cli_documentation_uri
cli_plugin_uri
created_at
description
enterprise_support_uri
github_uri
installation_instructions_uri
lang
package_manager_download_uri
id
package_manager_uri
relevant_apis
sandbox_uri
sdk_uri
title
}
required_condition
language
run_behavior
}
}
package_manager_download_uri
package_manager_uri
relevant_apis
sandbox_uri
sdk_uri
title
}
github_release_uri
github_repo_uri
gpg_public_key
gpg_signature
gradle_uri
id
language
maven_uri
s3_download_uri
shortname
stack_standard_certified
npm_uri
}
}
}
Raw
3-o7l.expect.behavior.graphql
{
"_eq":"auth.basic",
"_eq1":"auth.basic"
}
Raw
4-o7l.server.response.graphql
{
"data": {
"expect_behavior_aggregate": {
"aggregate": {
"count": 1
},
"nodes": [
{
"business_reason": "auth.basic ",
"business_requirement": "auth.basic ",
"detailed_description": "installs a node module for version 14.15.4 using Yarn",
"encrypted_stack_file_location": "https://releases.github.com/GlobalDeveloperNetwork/",
"for_language": {
"cli_documentation_uri": "",
"cli_plugin_uri": "",
"created_at": "2021-01-05T01:29:41.248737+00:00",
"description": "ECMA2020",
"enterprise_support_uri": "",
"github_uri": "",
"id": 1,
"installation_instructions_uri": "https://classic.yarnpkg.com/en/docs/install/",
"lang": "es.2020_nodejs.14.15.4",
"on_conditions_aggregate": {
"aggregate": {
"count": 1
},
"nodes": [
{
"created_at": "2021-01-05T03:04:43.942682+00:00",
"event_graph": {
"requirePackages": {
"babelFinish": {
"waitForDistFiles": {
"required": "dockerode"
}
}
}
},
"for_language": {
"cli_documentation_uri": "",
"cli_plugin_uri": "",
"created_at": "2021-01-05T01:29:41.248737+00:00",
"description": "ECMA2020",
"enterprise_support_uri": "",
"github_uri": "",
"installation_instructions_uri": "https://classic.yarnpkg.com/en/docs/install/",
"lang": "es.2020_nodejs.14.15.4",
"package_manager_download_uri": "https://classic.yarnpkg.com/en/docs/install/",
"id": 1,
"package_manager_uri": "https://github.com/fsdl/loader",
"relevant_apis": "https://graphql-api.stackstandard.com/v1/graphql",
"sandbox_uri": "https://sandbox-api.stackstandard.com/v1/graphql",
"sdk_uri": "https://github.com/tc39/ecma262",
"title": "nodejs_14.15.4 "
},
"required_condition": "yarn.build.complete",
"language": "nodejs_14.15.4 ",
"run_behavior": "before_graph "
}
]
},
"package_manager_download_uri": "https://classic.yarnpkg.com/en/docs/install/",
"package_manager_uri": "https://npmjs.com/@fsdl/yarn",
"relevant_apis": "https://graphql-api.stackstandard.com/v1/graphql",
"sandbox_uri": "https://sandbox-api.stackstandard.com/v1/graphql",
"sdk_uri": "https://github.com/tc39/ecma262",
"title": "nodejs_14.15.4 "
},
"github_release_uri": null,
"github_repo_uri": "https://github.com/fsdl/yarn",
"gpg_public_key": "",
"gpg_signature": "",
"gradle_uri": null,
"id": "5a19b6f3-d54a-4b6b-9c10-cd093243ecfb",
"language": "nodejs_14.15.4 ",
"maven_uri": null,
"s3_download_uri": null,
"shortname": "install.module.yarn",
"stack_standard_certified": true,
"npm_uri": "https://npmjs.com/@fsdl/yarn"
}
]
}
}
}
@lynsei
Copy link
Author

lynsei commented Jan 30, 2021

Ah GraphQL I <3 You

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment