var mongoose = require('mongoose');
var database = require('../config/database');
var mongoOptions = { db: { safe: true }};
mongoOptions.user = database.user;
mongoOptions.pass = database.pass;

console.log('Running mongoose version %s', mongoose.version);

mongoose.connect(database.url, mongoOptions, function (err, res) {
  if (err) {
    console.log ('ERROR connecting to: ' + database.url + '. ' + err);
  } else {
    console.log ('Successfully connected to: ' + database.url);
  }
});

var Schema = mongoose.Schema;
var citySchema = new Schema({
    name: String,
    url: String,
    uf: String,
    dtRequest: Date,
    active: Boolean,
    loc: {
        type: [Number],
        index: '2dsphere'
    }
});

module.exports = mongoose.model('City', citySchema);

var db = mongoose.connection;
db.on('error', console.error);

process.on('SIGINT', function() {
  db.close(function () {
    console.log('Mongoose default connection disconnected through app termination');
    process.exit(0);
  });
});