Data.Doublets.Gql

If you need any help, you can ged it real-time on our official discord server: https://discord.gg/eEXJyjWv5e

Comparison of theories:

Online demo

If you are lucky (our server is up) you can test our GraphQL server online using these urls:

• http://linksplatform.ddns.net:29018/ui/playground
• http://linksplatform.ddns.net:29018/ui/graphiql
• http://linksplatform.ddns.net:29018/ui/altair
• http://linksplatform.ddns.net:29018/ui/voyager

You can use this URL to access the GraphQL server directly from code, browser or any GraphQL client like Insomnia.

http://linksplatform.ddns.net:29018/graphql

Start locally

Execute:

cd csharp/Platform.Data.Doublets.Gql.Server

By default Gql server uses db.links as a name of the database:

dotnet run

You can set any path to a database file:

dotnet run path/to/db.links

Navigate to:

• http://localhost:60341/ui/playground
• http://localhost:60341/ui/graphiql
• http://localhost:60341/ui/altair
• http://localhost:60341/ui/voyager

You can change the port like this:

dotnet run -f net5 -c Release db.links --urls http://0.0.0.0:29018

Supported query examples:

{
  links {
    id
  }
}

{
  links(
    where: { id: { _eq: 1 }, from_id: { _eq: 1 }, to_id: { _eq: 1 } }
    distinct_on: [FROM_ID]
    order_by: { id: ASC }
    offset: 0
    limit: 1
  ) {
    id
    from_id
    from {
      id
      from_id
      to_id
    }
    out {
      id
      from_id
      to_id
    }
    to_id
    to {
      id
      from_id
      to_id
    }
    in {
      id
      from_id
      to_id
    }
  }
}

{
  links(
    where: { id: { _eq: 1 }, from_id: { _eq: 1 }, to_id: { _eq: 1 } }
    distinct_on: [FROM_ID]
    order_by: { id: ASC }
    offset: 0
    limit: 1
  ) {
    id
    from_id
    from {
      id
      from_id
      to_id
    }
    out(
      where: { from_id: { _eq: 1 }, to_id: { _eq: 1 } }
      distinct_on: [FROM_ID]
      order_by: { id: ASC }
      offset: 0
      limit: 1
    ) {
      id
      from_id
      to_id
    }
    to_id
    to {
      id
      from_id
      to_id
    }
    in(
      where: { from_id: { _eq: 1 }, to_id: { _eq: 1 } }
      distinct_on: [FROM_ID]
      order_by: { id: ASC }
      offset: 0
      limit: 1
    ) {
      id
      from_id
      to_id
    }
  }
}

Supported mutation examples:

mutation {
  insert_links_one(object: {from_id: 1, to_id: 1}) {
    id
    from_id
    to_id
  }
}

mutation {
  insert_links(objects: [{ from_id: 1, to_id: 1 }, { from_id: 2, to_id: 2 }]) {
    returning {
      id
      from_id
      to_id
    }
  }
}

mutation {
  update_links(_set: { from_id: 1, to_id: 2 }, where: { from_id: { _eq: 2 }, to_id: { _eq: 2 } }) {
    returning {
      id
      from_id
      to_id
    }
  }
}

mutation {
  delete_links(where: { from_id: { _eq: 1 }, to_id: { _eq: 1 } }) {
    returning {
      id
      from_id
      to_id
    }
  }
}