index.js

var request = require('request');
var cheerio = require('cheerio');
var fs = require('fs');
var mongoose = require('mongoose');
var promise = require('promise');

var url = "http://www.d20pfsrd.com/magic/spell-lists-and-domains/spell-lists-sorcerer-and-wizard/#TOC-8th-Level-Sorcerer-Wizard-Spells";

function SpellsCrawling() {

    var counter = 0;

    mongoose.connect('mongodb://localhost/tp1_database');
    var db = mongoose.connection;

    db.on('error', console.error.bind(console, 'connection error: '));

    db.once('open', function () {
        console.log('Connection successful');
    });

    console.log('Crawling the page: ' + url);

    request(url, (error, response, html) => {

        if (!error && response.statusCode == 200) {
            console.log('OKKKKK');
            const $ = cheerio.load(html);

            const toJSON = {
                spells: []
            }

            $('.article-content table').each((i, element) => {
                const level = $(element)
                    .children('caption')
                    .text();

                $(element).children('tbody').each((i, element) => {
                    $(element).children('tr').each((i, element) => {
                        const spell = $(element)
                            .children('td')
                            .children('a')
                            .first()
                            .text();

                        toJSON.spells.push(
                            {
                                name: spell,
                                level: level,
                                components: ["V", "S", "M"],
                                spell_resistance: false
                            }
                        );

                        counter++;

                        console.log('Name ' + spell + ' ' + counter);

                        db.collection('spells').insertOne({
                            name: spell,
                            level: level,
                            components: ["V", "S", "M"],
                            spell_resistance: false
                        })
                    })
                })
            })

            // let jsonSpells = JSON.stringify(toJSON);
            // fs.writeFileSync('spells.json', jsonSpells);
        }
        else {
            console.log('Code: ' + response.statusCode + ' Error: ' + error);
        }
    })
}

SpellsCrawling();