const database = require('../source/database')
const estore = database('EStore')

class Shop {
    constructor() {}

    async Main() {
        return estore.Query('SELECT * FROM Products').then(output => {
            const data = {
                start: `
                    <section id='shop'>
                    <div>
                    <h1>This is the Shop page</h1>
                `,
                body: '',
                end: `
                    </div>
                    </section>
                `
            }
            if (output) {
                for (let i = 0; i < output[0].length; i++) {
                    data.body += `
                        <div class='item'>
                        <h2>${output[0][i].ProductName}</h2>
                        <p>ID: ${output[0][i].ID}</p>
                        </div>
                    `
                }
            } else {
                data.body = `
                    There are no items in the database.
                `
            }
            return data.start + data.body + data.end
        })
    }
    Product() {
        const data = `
            <section id='product'>
            <div>
            <h1>This is the Product page</h1>
            <p>Description</p>
            </div>
            </section>
        `
        return data
    }
}

module.exports = () => {return new Shop()}