const pool = require('./connection.js')
const express = require('express');
const app = express();
const cors = require("cors");
const bodyParser = require("body-parser");

app.use(express.json());
app.use(
  cors({
    origin: "http://localhost:5173",
    methods: "GET,POST,PUT,DELETE",
    credentials: true,
  })
);

app.use(bodyParser.json());


// Route handler for the root URL
app.get('/', (req, res) => {
  res.send('Welcome to the Q&A API');
});


// GET ALL QUESTIONS
app.get("/questions", async (req, res) => {
    const selectQuery = `
    SELECT * FROM questions q INNER JOIN answers a 
    ON q.question_id = a.question_id
    `;
  
    try {
      const { rows } = await pool.query(selectQuery);
      res.json({ rows });
      const questions = rows
      console.log(questions[0])
    } catch (error) {
      console.error(error);
      res.status(500).json({ error: "Internal Server Error" });
    }
  });

const pool = require('./connection.js')
const express = require('express');
const app = express();
const cors = require("cors");
const bodyParser = require("body-parser");

app.use(express.json());
app.use(
  cors({
    origin: "http://localhost:5173",
    methods: "GET,POST,PUT,DELETE",
    credentials: true,
  })
);

app.use(bodyParser.json());


// Route handler for the root URL
app.get('/', (req, res) => {
  res.send('Welcome to the Q&A API');
});


// GET ALL QUESTIONS
app.get("/questions", async (req, res) => {
    const selectQuery = `
    SELECT * FROM questions q INNER JOIN answers a 
    ON q.question_id = a.question_id
    `;
  
    try {
      const { rows } = await pool.query(selectQuery);
      res.json({ rows });
      const questions = rows
      console.log(questions[0])
    } catch (error) {
      console.error(error);
      res.status(500).json({ error: "Internal Server Error" });
    }
  });