In the last series we have created our first server but we have not tested it in our machine locally. so in this series we will work more on creating better project structure and much more with prisma
open the prisma/schema.prisma
file and now lets create our User model which will represent our readers , admin and moderators of our platform
devblog_server/prisma/schema.prisma
model User {
id Int @id @default(autoincrement())
email String @unique
name String?
username String @unique
password String
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
avatar String?
bio String?
displayEmailOnProfile Boolean @default(false)
location Decimal[]
role UserRole @default(USER)
}
enum UserRole {
USER // normal reader
MODERTOR // handle and verify posts
ADMIN // handle USER and MODERATOR
}
Explanation
Above id
is our unique field and it will auto increment when a new row will be added hence we provided @id
which tells it a id field. @default
is used to add default data during row creation we provided autoincrement()
which will increment by one when new row will be created.You can use cuid()
and uuid()
for unique id creation. You can can learn more the difference between uuid()
and cuid()
here.
@unique()
provide a constraint validation for our schema that the no two row will have same data in field. In the above we provided email
and username
should be unique.
now()
function return current DateTime hence we used this in createdAt field so that it will automatically populated with the DateTime when a new user will register in our platform
@updatedAt
attribute will automatically provide the timestamp when our model will updated . In this way we can track the user when they have updated their profile.
Int
, String
, Boolean
, DateTime
, Decimal
are data types provided by prisma it map with data type of databases in background . Recent version of prisma provide capability to map native data type directly in prisma schema like @db.VarChar(255).
?
it make the fields optional by default all fields are required.
Decimal[]
here we have stored coordinate of user lat and lng so that we can easily show user location on map.
At last i have created role
field which will be an enum.
you can read more about enum in prism here.
Now we will apply migrations for our user model.
npx prisma migrate dev --name user_model
dev
is compulsory if you are in development environment.
It will create new migration
directory inside prisma
directory and there it will generate migration file and suffix with the user_model.
We have completed most of the stuff with prisma but the last things is we have not generated prisma client yet. When we will generate prisma client it will provide type for our model which helps to improve our development fast.
npx prisma generate
Now we will start our development server and will test both REST endpoint and GraphQL endpoints
If you have remembered we have imported prisma in context from prisma.js
but we have not created this file yet. Lets create this and import @prisma/client
here.
prisma.js
const { PrismaClient } = require("@prisma/client");
const prisma = new PrismaClient();
module.exports = prisma;
Above i have imported @prisma/client and created their install and export from this file so that our application can use only one instance of prisma client.
I have talk about the downside of initialize more than one prisma client instance in previous post.Here we are safe because we have only one instance of prisma client which we will provide to context so that all resolvers will use this instance for db stuff.
Start development server
To start development server we will setup nodemon in package.json
so that we have not headed to start dev server again again on every change. Nodemon will do for us
package.json
{
"name": "devblog_server",
"version": "1.0.0",
"main": "src/server.js",
"license": "MIT",
"scripts": {
"start": "node src/server.js",
"dev": "nodemon src/server.js"
},
...
}
Now start server
pnpm run dev
Open your favourite browser and browse http://localhost:3000
will give you json response from express server and http://localhost:3000/graphql
will open graphql playground provided by apollo server
write first query
{
hello
}
this will resolve hello query and you will get results in right section.
In our next post we will implement authentication in graphql server and we will see how we will secure our api with JWT token authentication
Top comments (0)