SQL or MongoDB<\/a>. The reason for not choosing an actual one is to remove the setup complexity and keep focusing on creating an API.<\/p>\n\n\n\nTo create a dummy database, go through the following steps:<\/p>\n\n\n\n
Run the following command:<\/p>\n\n\n\n
npm install notarealdb<\/code><\/pre>\n\n\n\nCreate a new folder in your c.urrent directory, and then inside this folder, create a new json file name database.json. Now, create fake data using JSON objects. An example is written below:<\/p>\n\n\n\n
{\n \"id\": \"1234\",\n \"name\": \"James\",\n \"age\": 34\n },...\n<\/code><\/pre>\n\n\n\nThe data provided above is in a JSON object format. Therefore, all your data will be inside an array of JSON Objects, each array member being of type Student. GraphQL itself maps the JSON objects to the schema you provided. Below is the complete data set we will be using for this guide:<\/p>\n\n\n\n
[\n{\n\"id\": \"1234\",\n\"name\": \"James\",\n\"age\": 34\n},\n{\n\"id\": \"1235\",\n\"name\": \"Susan\",\n\"age\" : 28\n\n},\n{\n\"id\": \"1236\",\n\"name\": \"Alex\",\n\"age\": 27\n}\n]\n\n<\/code><\/pre>\n\n\n\n<\/span>Create an index.js file<\/span><\/h3>\n\n\n\nYou will need to create an index.js file which will act as your main file in which you will write your queries and resolve all the resolvers present in the schema. <\/p>\n\n\n\n
<\/span>Adding Relevant Libraries<\/span><\/h4>\n\n\n\nInside your index.js file, you will need to add libraries. These libraries will allow you to take advantage of the functions to build your API.<\/p>\n\n\n\n
Write the following into your index.js file:<\/p>\n\n\n\n
\/\/importing relevant libraries\n\nconst express = require('express'); \nconst { graphqlHTTP } = require('express-graphql');\nconst { buildSchema } = require('graphql');\nconst fs = require(\"fs\");\nconst { DataStore } = require('notarealdb');\nconst { report } = require('process');\n\n<\/code><\/pre>\n\n\n\nOne thing to note here is how the libraries are imported. The syntax:<\/p>\n\n\n\n
const{ <<function name>> } = require ('<<library name>>');<\/code><\/pre>\n\n\n\nThe above is used to just import a particular function or a class from the library instead of the entire library.<\/p>\n\n\n\n
<\/span>Creating GraphQL webpage for query testing<\/span><\/h4>\n\n\n\nCreate an index.js file inside your node package. Inside this file, for now, add the following block of code:<\/p>\n\n\n\n
\/\/Creating a GraphQL API Server\n\nconst app = express();\napp.use('\/graphql', graphqlHTTP({\n schema: schema,\n rootValue: root,\n graphiql: true,\n}));\napp.listen(4000);\nconsole.log('Running a GraphQL API server at http:\/\/localhost:4000\/graphql');\n<\/code><\/pre>\n\n\n\nThe above piece of code allows you to create a GraphQL API server. Through this URL, you can test your queries and mutations and will be able to see the data they are returning.<\/p>\n\n\n\n
<\/span>Initializing the Dummy Database (Optional)<\/span><\/h4>\n\n\n\nIf you have created a dummy database using the module notarealdb<\/code>, you will need to initialize it.<\/p>\n\n\n\nAfter creating the database file and placing some fake data, you will need to add the following lines to your index.js<\/code> file:<\/p>\n\n\n\n\/\/initialize the database\nconst db = new DataStore('<folder containing database>');\nconst studentDB = db.collection('<filename>');\n<\/code><\/pre>\n\n\n\nNote<\/strong>! Make sure to update '<folder containing database>'<\/code> and '<filename>'<\/code> from the previous snippet of code.<\/p>\n\n\n\n<\/span>Create a schema.graphql<\/code> File To Define Schema<\/span><\/h3>\n\n\n\nNow, create a schema.graphql<\/code> file. This file will contain all the information to define the database and its entities and the queries you will require.<\/p>\n\n\n\nBefore getting into how to write the file, it is important to distinguish exactly what you will be requiring. As explained above, CRUD APIs should have the create, read, update and delete functionalities. To add these functionalities, you need to structure the function based on the GrapQL query type.<\/p>\n\n\n\n
GraphQL has three major types: Query, Mutation, and Subscription. For this guide, we will be using Query and Mutation.<\/p>\n\n\n\n
For all read functions, you will require a resolver of type Query. This will include the read functionality. <\/p>\n\n\n\n
Also, you will require a resolver of type Mutation for all the write functions. This will include our Create, Delete, and Update functionalities.<\/p>\n\n\n\n
To create a schema.graphql<\/code> file, create a new file with a .graphql<\/code> extension in the same directory as the index.js<\/code> file.<\/p>\n\n\n\nIn this file, first, define the entities. In our case, we have only one entity, Student:<\/p>\n\n\n\n
type Student {\n id: ID! #! means it cannot be null and is its identifier \n name: String\n age: Int\n}\n\n<\/code><\/pre>\n\n\n\nAfter defining the entity, list all the queries and mutations and the arguments required to execute them successfully. Since we are making a CRUD API, the following are the resolvers and their arguments written in GraphQL:<\/p>\n\n\n\n
type Query {\n listStudents: [Student]\n getStudent(id: ID!): Student #Student does not have ! as it can be return as null\n}\n\ntype Mutation {\n createStudent(name: String, age: Int): Student!, \n deleteStudent(id: ID!): Student,\n updateStudent(id: ID!, name: String, age: Int): Student\n}\n\n<\/code><\/pre>\n\n\n\n<\/span>Create Resolver<\/span><\/h4>\n\n\n\nIn the previous code, the mutation createStudent(name: String, age: Int)<\/code> allows you to add an entry to your database. It returns a Student object to confirm that you have added a student to your database.<\/p>\n\n\n\n<\/span>Read Resolver<\/span><\/h4>\n\n\n\nTo read data, the code uses two queries getStudent(id: ID!)<\/code> and listStudent[Student]<\/code>. Both of these queries allow you to read the data individually by providing an id or accessing all records respectively.<\/p>\n\n\n\n<\/span>Update Resolver<\/span><\/h4>\n\n\n\nTo update data, the code uses the mutation updateStudent(id: ID!, name: String, age: Int)<\/code>. The id is used to identify the entry to be updated, and then the information such as name and age is changed. It then returns the updated student information.<\/p>\n\n\n\n<\/span>Delete Resolver<\/span><\/h4>\n\n\n\nTo delete an entry, the code uses the mutation deleteStudent(id: ID!)<\/code> to find the entry using the id and delete the record associated. The deleted entry is then returned.<\/p>\n\n\n\nAfter adding every type, your schema.graphql<\/code> file should look something like this:<\/p>\n\n\n\ntype Query {\n listStudents: [Student]\n getStudent(id: ID!): Student #Student does not have ! as it can be return as null\n}\n\ntype Mutation {\n createStudent(name: String, age: Int): Student!, \n deleteStudent(id: ID!): Student,\n updateStudent(id: ID!, name: String, age: Int): Student\n}\n\ntype Student {\n id: ID! #! means it cannot be null and it's its identifier \n name: String\n age: Int\n}\n\n<\/code><\/pre>\n\n\n\nAfter creating the schema file, you will need to build a schema for this inside the index.js file. You can use the fs.readFileSync<\/code> function to read the file and use the same function as an argument to the buildSchema<\/strong>()<\/code> method.<\/p>\n\n\n\nOne thing to note is that since buildSchema<\/strong>()<\/code> takes a string as an argument, you will need to convert the stream generated when using fs.readFileSync<\/code> into a string using the toString<\/strong>()<\/code> method.<\/p>\n\n\n\nAdd this line to your index.js file:<\/p>\n\n\n\n
\/\/ Construct a schema, using GraphQL schema language\nvar schema = buildSchema(fs.readFileSync(\"schema.graphql\").toString());<\/code><\/pre>\n\n\n\n<\/span>Define Resolvers in the index.js file<\/span><\/h3>\n\n\n\nThe resolvers that you listed in the schema.graphql<\/code> will have to be defined for them to work as intended. Defining these resolvers can be thought of as writing a query for the particular database the API is connected to.<\/p>\n\n\n\nIt’s important to know that since one query or mutation maps to exactly one resolver, you should name your resolver and the query or mutation the same. Add the following piece of code to your index.js file:<\/p>\n\n\n\n
\/\/ root provides a resolver function for each API endpoint or CRUD functionality\nvar root = {\n\nlistStudents: () => {\n return studentDB.list()\n},\ngetStudent: (argument) => {\n return studentDB.get(argument.id)\n},\ncreateStudent: (argument) => {\n const studentStuff = {\n id: argument.id,\n name: argument.name,\n age: argument.age \n }\n return studentDB.create(studentStuff);\n},\ndeleteStudent: (argument) => {\n const studentObj = studentDB.get(argument.id);\n studentDB.delete(argument.id);\n \n return studentObj;\n},\nupdateStudent: (argument) => {\n const studentStuff = {\n id: argument.id,\n name: argument.name,\n age: argument.age \n }\n studentDB.update(studentStuff);\n const studentObj = studentDB.get(argument.id);\n \n return studentObj;\n}\n};\n<\/code><\/pre>\n\n\n\nThe root<\/code> variable acts as a defining function for all the CRUD functionalities or API endpoints. Inside root, you can define each endpoint and consider them as methods. For example, suppose deleteStudent()<\/code> is called. In that case, the code written inside the root for deleteStudent()<\/code> will be executed, which will then make changes to your database as defined by the schema.<\/p>\n\n\n\nSince we are using a dummy database, it is important to specify that all the code written above inside root<\/code> is only pertinent to the dummy database. Write queries inside root<\/code> for databases made with SQL, MongoDB, or any other query language.<\/p>\n\n\n\nAfter adding all the code explained above, your index.js file should look like this:<\/p>\n\n\n\n
\/\/importing relevant libraries\n\nconst express = require('express'); \nconst { graphqlHTTP } = require('express-graphql');\nconst { buildSchema } = require('graphql');\nconst fs = require(\"fs\");\nconst { DataStore } = require('notarealdb');\nconst { report } = require('process');\n\n\/\/initialize the database\nconst db = new DataStore('database');\nconst studentDB = db.collection('studentData');\n\n\/\/ Construct a schema, using GraphQL schema language\nconst schema = buildSchema(fs.readFileSync(\"schema.graphql\").toString()); \/\/returns a buffer but buildschema needs string so we convert to string\n\n\n\/\/ root provides a resolver function for each API endpoint or CRUD functionality\nconst root = {\nlistStudents: () => {\n return studentDB.list()\n},\ngetStudent: (argument) => {\n return studentDB.get(argument.id)\n},\ncreateStudent: (argument) => {\n const studentStuff = {\n id: argument.id,\n name: argument.name,\n age: argument.age \n }\n return studentDB.create(studentStuff); \n},\ndeleteStudent: (argument) => {\n const studentObj = studentDB.get(argument.id);\n studentDB.delete(argument.id);\n \n return studentObj; \n},\nupdateStudent: (argument) => {\n const studentStuff = {\n id: argument.id,\n name: argument.name,\n age: argument.age \n }\n studentDB.update(studentStuff);\n const studentObj = studentDB.get(argument.id);\n \n return studentObj;\n}\n};\n\n\/\/Creating a GraphQL API Server\n\nconst app = express();\napp.use('\/graphql', graphqlHTTP({\n schema: schema,\n rootValue: root,\n graphiql: true,\n}));\napp.listen(4000);\nconsole.log('Running a GraphQL API server at http:\/\/localhost:4000\/graphql');<\/code><\/pre>\n\n\n\n<\/span>Test the CRUD API<\/span><\/h2>\n\n\n\nNow, your API should be ready for testing!<\/p>\n\n\n\n
To test your API, first, run your Node.js application by running the following command:<\/p>\n\n\n\n
node index.js<\/code><\/pre>\n\n\n\nAfter running the above command, you will see a localhost URL in the terminal, which will take you to a GraphiQL page. The GraphiQL page allows you to run your queries and mutations. You will see live changes to your data by opening the database.js file you created (if you created a dummy database) or by checking the database you connected.\u00a0<\/p>\n\n\n\n
It is important to note that you can only run a single query or a single mutation at a time on the GraphiQL page. <\/p>\n\n\n\n
<\/span>Wrapping Up<\/span><\/h2>\n\n\n\nCongratulations! You created a CRUD API using Node.js and GraphQL. You learned how to create and define resolvers. You also learned how to create a dummy database, allowing you to practice your skills before using a real database.<\/p>\n\n\n\n
Was this post helpful? <\/strong><\/p>\n\n\n\nPlease, let us know your opinions by replying on Twitter of Become A Better Programmer.<\/a><\/p>\n\n\n\n\n