refactor db file

3 files changed, 14 insertions, 14 deletions

diff --git a/backend/src/createServer.js b/backend/src/createServer.js
index 4aca55f..036d15a 100644
--- a/backend/src/createServer.js
+++ b/backend/src/createServer.js
@@ -1,8 +1,7 @@
 const { GraphQLServer } = require('graphql-yoga');
-const { Prisma } = require('prisma-binding');
-
 const Mutation = require('./resolvers/Mutation');
 const Query = require('./resolvers/Query');
+const db = require('./db');
 
 function createServer() {
   return new GraphQLServer({
@@ -14,15 +13,7 @@ function createServer() {
       Mutation,
       Query,
     },
-    context: req => ({
-      ...req,
-      db: new Prisma({
-        typeDefs: 'src/generated/prisma.graphql',
-        endpoint: process.env.PRISMA_ENDPOINT, // the endpoint of the Prisma DB service (value is set in variables.env)
-        secret: process.env.PRISMA_SECRET, // taken from prisma/prisma.yml (value is set in .env)
-        debug: false, // log all GraphQL queries & mutations
-      }),
-    }),
+    context: req => ({ ...req, db }),
   });
 }
 
diff --git a/backend/src/db.js b/backend/src/db.js
new file mode 100644
index 0000000..e8caa14
--- /dev/null
+++ b/backend/src/db.js
@@ -0,0 +1,10 @@
+const { Prisma } = require('prisma-binding');
+
+const db = new Prisma({
+  typeDefs: 'src/generated/prisma.graphql',
+  endpoint: process.env.PRISMA_ENDPOINT, // the endpoint of the Prisma DB service (value is set in variables.env)
+  secret: process.env.PRISMA_SECRET, // taken from prisma/prisma.yml (value is set in .env)
+  debug: false, // log all GraphQL queries & mutations
+});
+
+module.exports = db;
\ No newline at end of file
diff --git a/backend/src/index.js b/backend/src/index.js
index 86bba16..94911ec 100644
--- a/backend/src/index.js
+++ b/backend/src/index.js
@@ -3,6 +3,7 @@ require('dotenv').config({ path: 'variables.env' });
 /* eslint-enable */
 const jwt = require('jsonwebtoken');
 const createServer = require('./createServer');
+const db = require('./db');
 const cookieParser = require('cookie-parser');
 
 const server = createServer();
@@ -21,9 +22,7 @@ server.express.use((req, res, next) => {
 // 2. Get User from their ID
 server.express.use(async (req, res, next) => {
   if (!req.userId) return next();
-  const user = await server
-    .context()
-    .db.query.user({ where: { id: req.userId } }, `{ id, permissions, email, name }`);
+  const user = await db.query.user({ where: { id: req.userId } }, `{ id, permissions, email, name }`);
   req.user = user;
   next();
 });