main.js

sqlite.open(path.join('/', 'Users', 'joshuabrown3', 'Desktop', 'chat.db')).then(db => db.all('SELECT * FROM `chat`').then(chats => {
        const promises = [];
        const convos = chats.map(chat => {
            const convo = new Conversation(chat, db);
            promises.push(new Promise(resolve => {
                convo.on("ready", resolve);
            }));
            convos.push(convo);
        });
        Promise.all(promises).then(_ => {
            mainWindow.chats = convos.filter(convo => convo.messages.length > 0).sort((a, b) => {
                return b.messages[0].date - a.messages[0].date;
            });
            mainWindow.loadFile(path.join(__dirname, 'src', 'render', 'index.html')).then(() => console.log("loaded"));
            console.log("Done");
        });
    }));