The types used in these queries are defined here.
In order to set up GraphQL access to the database add the following to the schema:
using extension graphql;Then create a new migration and apply it using edgedb create-migration and edgedb migrate, respectively.
Select all users in the system:
{
User {
id
name
image
}
}Select a movie by title and release year with associated actors ordered by last name:
{
Movie(
filter: {
title: {eq: "Dune"},
year: {eq: 2020}
}
) {
id
title
year
description
directors {
id
full_name
}
actors(order: {last_name: {dir: ASC}}) {
id
full_name
}
}
}Select movies with Keanu Reeves:
{
Movie(
filter: {
actors: {full_name: {eq: "Keanu Reeves"}}
}
) {
id
title
year
description
}
}Select a movie by title and year with top 3 most recent reviews (this uses MovieAlias in order to access reviews):
{
MovieAlias(
filter: {
title: {eq: "Dune"},
year: {eq: 2020}
}
) {
id
title
year
description
reviews(
order: {creation_time: {dir: DESC}},
first: 3
) {
id
body
rating
creation_time
author {
id
name
}
}
}
}Use MovieAlias in order to find movies that have no reviews:
{
MovieAlias(
filter: {
reviews: {exists: false},
}
) {
id
title
year
description
}
}Use a GraphQL mutation to add a user:
mutation add_user {
insert_User(
data: {name: "Atreides", image: "atreides.jpg"}
) {
id
}
}Use a GraphQL mutation to add a review by an existing user:
mutation add_review {
insert_Review(
data: {
# Since the movie already exists,
# we select it using the same filter
# mechanism as for queries.
movie: {
filter: {title: {eq: "Dune"}, year: {eq: 2020}},
first: 1
},
body: "Yay!",
rating: 5,
# Similarly to the movie we select
# the existing user.
author: {
filter: {name: {eq: "Atreides"}},
first: 1
}
}
) {
id
body
}
}Use a GraphQL mutation to add an actress to a movie:
mutation add_actor {
update_Movie(
# Specify which movie needs to be updated.
filter: {title: {eq: "Dune"}, year: {eq: 2020}},
# Specify the movie data to be updated.
data: {
actors: {
add: [{
filter: {
full_name: {eq: "Charlotte Rampling"}
}
}]
}
}
) {
id
actors {
id
}
}
}