require('dotenv').config()
const { Sequelize, QueryTypes } = require('sequelize')

const sequelize = new Sequelize(process.env.DB_URL)

const main = async () => {
	try {
		await sequelize.authenticate()
		const blogs = await sequelize.query("SELECT * FROM blogs", { type: QueryTypes.SELECT })
		blogs.forEach(blog => (
			console.log(`${blog.author}: '${blog.title}', ${blog.likes} likes`)
		))
		console.log('Connection has been established successfully')
		sequelize.close()
	} catch (error) {
		console.error('Unable to connect to the database', error)
	}
}

main()