danielwright1207 · danielwright1207 · Mar 25, 2021
diff --git a/api/project/model.js b/api/project/model.js
@@ -0,0 +1,54 @@
+const db = require("../../data/dbConfig");
+const helpers = require("./project-middleware");
+
+function find() {
+  const getProject = db("projects as pr").select(
+    "pr.project_name",
+    "pr.project_description",
+    "pr.project_completed"
+  );
+  return getProject.then((projects) => {
+    return projects.map((project) => helpers.projectToBody(project));
+  });
+}
+
+const getProjects = async () => {
+  try {
+    const projects = await db("projects");
+    return projects.map((project) => {
+      project.project_completed === 0
+        ? { ...project, project_completed: false }
+        : { ...project, project_completed: true };
+    });
+  } catch (err) {
+    return { err: "not getting projects" };
+  }
+};
+
+const create = async (project) => {
+  const [id] = await db("projects").insert(project, [
+    "project_id",
+    "project_name",
+    "project_description",
+  ]);
+  return getById(id);
+};
+
+const getById = async (project_id) => {
+  try {
+    const project = await db("projects").where({ project_id }).first();
+    return {
+      ...project,
+      project_completed: project.project_completed === 0 ? false : true,
+    };
+  } catch (err) {
+    return { err: "not getting project" };
+  }
+};
+
+module.exports = {
+  find,
+  getById,
+  create,
+  getProjects,
+};
diff --git a/api/project/project-middleware.js b/api/project/project-middleware.js
@@ -0,0 +1,18 @@
+function intToBool(int) {
+  return int === 1 ? true : false;
+}
+function projectToBody(project) {
+  const result = {
+    ...project,
+    project_completed: intToBool(project.project_completed),
+  };
+  return result;
+}
+function taskToBody(task) {
+  const result = {
+    ...task,
+    task_completed: intToBool(task.task_completed),
+  };
+  return result;
+}
+module.exports = { projectToBody, taskToBody };
diff --git a/api/project/router.js b/api/project/router.js
@@ -0,0 +1,35 @@
+// build your `/api/projects` router here
+const express = require("express");
+const Projects = require("./model");
+
+const router = express.Router();
+
+router.get("/", async (req, res, next) => {
+  try {
+    const allProjects = await Projects.find();
+    res.status(200).json(allProjects);
+    console.log(res.body, "here");
+  } catch (err) {
+    next(err);
+  }
+});
+
+router.get("/:id", async (req, res, next) => {
+  try {
+    const data = await Projects.getById(req.params.id);
+    res.json(data);
+  } catch (err) {
+    next(err);
+  }
+});
+
+router.post("/", async (req, res, next) => {
+  try {
+    const data = await Projects.create(req.body);
+    res.status(201).json(data);
+  } catch (err) {
+    next(err);
+  }
+});
+
+module.exports = router;
diff --git a/knex.js b/knex.js
@@ -0,0 +1,19 @@
+const sharedConfig = {
+  client: "sqlite3",
+  useNullAsDefault: true,
+  migrations: { directory: "./data/migrations" },
+  pool: {
+    afterCreate: (conn, done) => conn.run("PRAGMA foreign_keys = ON", done),
+  },
+};
+
+module.exports = {
+  development: {
+    ...sharedConfig,
+    connection: { filename: "./data/lambda.db3" },
+  },
+  testing: {
+    ...sharedConfig,
+    connection: { filename: "./data/test.db3" },
+  },
+};
diff --git a/migrations/dbConfig.js b/migrations/dbConfig.js
@@ -0,0 +1,5 @@
+const knex = require("knex");
+const configurations = require("../knexfile.js");
+const environment = process.env.NODE_ENV || "development";
+
+module.exports = knex(configurations[environment]);
diff --git a/migrations/index.js b/migrations/index.js
@@ -0,0 +1,7 @@
+const server = require("./api/server.js");
+
+const PORT = process.env.PORT || 8000;
+
+server.listen(PORT, () => {
+  console.log(`Listening on port ${PORT}...`);
+});