db.js

import sqlite3 from 'sqlite3'

const db = new sqlite3.Database('./db.sqlite3')

export function fetchPosts(limit = 199) {
  return new Promise((resolve, reject) => {
    db.all('SELECT rowid AS id, * FROM posts ORDER BY date DESC LIMIT ?', limit, (err, rows) => {
      if (err) {
        reject(err)
      }

      resolve(rows)
    })
  })
}

export function fetchPost(id) {
  return new Promise((resolve, reject) => {
    db.get('SELECT rowid AS id, * FROM posts WHERE id = ?', id, (err, row) => {
      if (err) {
        reject(err)
      }

      resolve(row)
    })
  })
}

export function insertPost(post) {
  return new Promise((resolve, reject) => {
    db.run('INSERT INTO posts VALUES (?, ?, ?)', post.title, post.body, post.date, (err) => {
      if (err) {
        reject(err)
      }

      resolve()
    })
  })
}

export function deletePost(id) {
  return new Promise((resolve, reject) => {
    db.run('DELETE FROM posts WHERE rowid = ?', id, (err) => {
      if (err) {
        reject(err)
      }

      resolve()
    })
  })
}

export function updatePost(post) {
  return new Promise((resolve, reject) => {
    db.run('UPDATE posts SET title = ?, body = ? WHERE rowid = ?', post.title, post.body, post.id, (err) => {
      if (err) {
        reject(err)
      }

      resolve()
    })
  })
}