FastAPI + Orator + PostgreSQL + GraphQL Demo

Database

• Users
  • id
  • name
  • address
  • phone_number
  • sex
  • timestamps
• Posts
  • id
  • user_id
  • title
  • body
  • timestamps
• Comments
  • id
  • user_id
  • post_id
  • body
  • timestamps

Setup

Update Database information in db.py

pip install -r requirements.txt
orator migrate -c db.py

Run

uvicorn main:app --reload

GraphQL

Create user

mutation createUser {
  createUser(userDetails: {
    name: "Care",
    address: "Test Address",
    phoneNumber: "1234",
    sex: "male"
  })
  {
    id
    name
    posts {
      body
      comments {
        body
      }
    }
  }
}

Create Post

mutation createPost {
  createPost(postDetails: {
    userId: 1,
    title: "My first Post",
    body: "This is a Post"
  })
  {
    id
  }
}

Create Post Comment

mutation createComment {
  createComment(commentDetails: {
    userId: 1,
    postId: 1,
    body: "First Comment"
  })
  {
    id
    body
  }
}

Get All Users

query getAllUsers {
  listUsers {
    id
    name
    posts {
      title
    }
  }
}

Get user

query getUser {
  getSingleUser(userId: 1) {
    name
    posts {
      title
      comments {
        body
      }
    }
    comments {
      body
    }
  }
}