Skip to content

Instantly share code, notes, and snippets.

@dtoebe
Created October 8, 2017 15:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dtoebe/4dc6f115c100ebf2b6738e4f06a04d2a to your computer and use it in GitHub Desktop.
Save dtoebe/4dc6f115c100ebf2b6738e4f06a04d2a to your computer and use it in GitHub Desktop.
trying to find the person with the most paths
{
var(func: anyofterms(title, "first")) {
ticket as _uid_
}
tickets(func: uid(ticket)) {
title
desc
tag {
~can_do {
name
}
}
}
}
mutation {
  schema {
    name: string @index(exact, term) .
    can_do: uid @reverse @count .
    title: string @index(exact, term) .
    desc: string .
    tag: uid @reverse @count .
  }
  set {
    _:javascript <name> "javascript" .
    _:sql <name> "sql" .
    _:go <name> "go" .
    _:ruby <name> "ruby" .
    _:db <name> "db" .
    _:linux <name> "linux" .
    _:architecture <name> "architecture" .
    _:php <name> "php" .
    _:mongo <name> "mongo" .
    _:windows <name> "windows" .
    _:networking <name> "networking" .
    _:docker <name> "docker" .
    _:kubernetes <name> "kubernetes" .
    _:aws <name> "aws" .
    _:azure <name> "azure" .
   
    _:first_ticket <title> "First Ticket" .
    _:first_ticket <desc> "This is the first ticket..." .
    _:first_ticket <tag> _:go .
    _:first_ticket <tag> _:db .
    _:first_ticket <tag> _:sql .
   
    _:second_ticket <title> "Second Ticket" .
    _:second_ticket <desc> "This is the second ticket..." .
    _:second_ticket <tag> _:javascript .
    _:second_ticket <tag> _:mongo .
    _:second_ticket <tag> _:linux .
 
 
    _:john <name> "john" .
    _:john <can_do> _:sql .
    _:john <can_do> _:javascript .
    _:john <can_do> _:go .
    _:john <can_do> _:ruby .
    _:john <can_do> _:db .
    _:john <can_do> _:linux .
   
    _:jeremy <name> "jeremy" .
    _:jeremy <can_do> _:architecture .
    _:jeremy <can_do> _:php .
    _:jeremy <can_do> _:go .
    _:jeremy <can_do> _:mongo .
    _:jeremy <can_do> _:windows .
    _:jeremy <can_do> _:bash .
 
    _:thomas <name> "thomas" .
    _:thomas <can_do> _:linux .
    _:thomas <can_do> _:sql .
    _:thomas <can_do> _:javascript .
    _:thomas <can_do> _:windows .
    _:thomas <can_do> _:db .
    _:thomas <can_do> _:networking .
   
    _:chris <name> "chris" .
    _:chris <can_do> _:docker .
    _:chris <can_do> _:kubernetes .
    _:chris <can_do> _:aws .
    _:chris <can_do> _:azure .
    _:chris <can_do> _:architecture .
   
    _:alex <name> "alex" .
    _:alex <can_do> _:mongo .
    _:alex <can_do> _:javascript .
    _:alex <can_do> _:ruby .
    _:alex <can_do> _:php .
  }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment