model.js

const db = require("./db/connection");

function getRepo() {
  return db.query(
    `
    SELECT * FROM projects;
    `
  );
}

function saveRepo(repo) {
  console.log(repo.project_name);
  return db.query(
    "INSERT INTO  projects( week, project_name, project_screenshot, collaborators, project_link) VALUES($1, $2, $3, $4, $5)",
    [
      repo.project_week,
      repo.project_name,
      repo.project_screenshot,
      repo.project_collaborators,
      repo.github_link,
    ]
  );
}

function getUser(user) {
  return db
    .query("SELECT * FROM users WHERE username = ($1);", [user])
    .then((res) => res.rows[0]);
}

function deleteRepo(id) {
  console.log(id);
  return db.query("DELETE FROM projects WHERE ($1)=id", [id]);
}

module.exports = { saveRepo, getRepo, getUser, deleteRepo };

// return db.query("DELETE FROM img_posts WHERE ($1)=id", [postId])