db.js

const sqlite3 = require("sqlite3").verbose()
const db = new sqlite3.Database('./ws.db')

db.serialize(function() {
    // criar a tabela
    db.run(`
        CREATE TABLE IF NOT EXISTS ideas(
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            image TEXT,
            title Text,
            category TEXT,
            description TEXT,
            link TEXT
        );
    `)

    //inserir os dados na tabela
    /*const query = `
    INSERT INTO ideas(
        image,
        title,
        category,
        description,
        link
    ) VALUES (?,?,?,?,?);
    `
    const values = [
        "https://image.flaticon.com/icons/svg/2729/2729007.svg",
        "Cursos de Programação",
        "Estudo",
        "Lorem ipsum dolor sit, amet consectetur adipisicing elit. Aliquid ad porro distinctio pariatur repellendus ratione, at sequi, veritatis corrupti, voluptatem iure perferendis blanditiis officiis vitae itaque necessitatibus molestias eum nesciunt!",
        "https://rocketseat.com.br"
    ]

    db.run(query, values, function(err) {
        if (err) return console.log(err)

        console.log(this)
    })*/

    //deletar um dado da tabela
    /*db.run(`DELETE FROM ideas WHERE id = ?`, [1], function(err) {
        if (err) return console.log(err)

        console.log("DELETEI", this)
    })*/

    //consultar dados na tabela

    /*db.all(`SELECT * FROM ideas`, function(err, rows) {
        if (err) return console.log(err)

        console.log(rows)
    })*/


})

module.exports = db