const axios = require("axios");
const mysql = require("mysql");

const connection = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database: "movies"
});

connection.connect();

connection.query("delete from movies.moviesnow");

axios
  .get(
    "https://api.themoviedb.org/3/movie/now_playing?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c&region=GR" //calls the now playing info
  )
  .then(response => {
    for (page = 1; page <= response.data.total_pages; page++) {
      paginatorFunc(page); //for every page in the now playing calls paginator
    }
  })
  .catch(error => {
    console.log(error);
  });

paginatorFunc = page => {
  axios
    .get(
      "https://api.themoviedb.org/3/movie/now_playing?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c&region=GR&page=" +
        page
    )
    .then(response => {
      setTimeout(crewImdbFinder(response.data), 1000); //for every page we are in, call crewImdb finder
    })
    .catch(error => {
      console.log(error);
    });
};
crewImdbFinder = page => {
  page.results.map(result => {
    axios
      .get(
        "https://api.themoviedb.org/3/movie/" +
          result.id +
          "?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c&append_to_response=credits"
      )
      .then(response => {
        response.data.credits.crew.map(member => {
          if (member.job === "Director") {
            directorHandler(member.id, response.data.title);
          }
        });
        // connection.query("INSERT INTO moviesnow VALUES (?, ?, ?, ?, ?)", [
        //   response.data.title,
        //   response.data.overview,
        //   response.data.original_title,
        //   response.data.original_title,
        //   response.data.original_title
        // ]);
      })

      .catch(error => {
        console.log(error);
      });
  });
};
directorHandler = (directorId, title) => {
  axios
    .get(
      "https://api.themoviedb.org/3/person/" +
        directorId +
        "?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c"
    )
    .then(response => {
      connection.query("INSERT INTO directors VALUES (?, ?, ?, ?)", [
        response.data.id,
        title,
        response.data.name,
        response.data.imdb_id
      ]);
    })
    .catch(error => {
      console.log(error);
    });
};