flashcards

version-1.js

const db = require('../db/config');

const Flashcard = {};

Flashcard.findAll = () => {
  return db.manyOrNone('SELECT * FROM flashcards');
};

Flashcard.findById = id => {
  return db.one(
    `
    SELECT * FROM flashcards
    WHERE id = $1
  `,
    [id]
  );
};

Flashcard.findByCategory = category => {
  return db.manyOrNone(
    `
  SELECT * FROM flashcards
  WHERE category = $1
  `,
    [category]
  );
};

Flashcard.create = flashcard => {
  return db.one(
    `
    INSERT INTO flashcards
    (question, answer, category, difficulty)
    VALUES ($/question/, $/answer/, $/category/, $/difficulty/)
    RETURNING *
  `,
    flashcard
  );
};

Flashcard.update = (flashcard, id) => {
  return db.one(
    `
    UPDATE flashcards SET
    question = $1,
    answer = $2,
    category = $3,
    difficulty = $4
    WHERE id = $5
    RETURNING *
  `,
    [flashcard.question, flashcard.answer, flashcard.category, flashcard.difficulty, id,]
  );
};

Flashcard.destroy = id => {
  return db.none(
    `
    DELETE FROM flashcards
    WHERE id = $1
  `,
    [id]
  );
};

module.exports = Flashcard;