var express = require("express");
var app = express();

// route
app.get("/", function(req, res) {
   res.send("<h1>hi there!</h1>"); 
});

app.get("/bye", function(req, res) {
    res.send("bye");
});

// listen to a port and ip
app.listen(process.env.PORT, process.env.IP, function() {
    console.log("Server started");
});

app.get("/", function(req, res) {
   res.send("<h1>hi there!</h1>"); 
});

app.get("/bye", function(req, res) {
    res.send("bye");
});

// pages not found
app.get("*", function(req, res) {
    res.send("Star page");
})

//use colon
app.get("/r/:subTerm", function(req, res) {
    // access variable
    var subTerm = req.params.subTerm;
    res.send(subTerm + " page");
});

// pass variable to template
app.get("/love/:thing", function(req, res) {
    var thing = req.params.thing;
    var posts = [{id: 1}, {id: 2}, {id: 3}];
    res.render("love.ejs", {thingVar: thing, posts: posts});
});

// use relative path in public folder
app.use(express.static(__dirname + "/public"));

// set
app.set("view engine", "ejs");

// use
res.render("home");

app.get("/results", function(req, res) {
    var search = req.query.search;
    request("http://www.omdbapi.com/?s=" + search + "&apikey=thewdb", 
            function(error, response, body) {
        if (!error && response.statusCode == 200) {
            // parse JSON
            var data = JSON.parse(body);
            console.log(data);
            res.render("results", {data: data});
        }
    });
});

var friends = ["a", "b", "c"];
app.get("/friends", function(req, res) {
    res.render("friends", {friends: friends});
});


app.post("/addfriend", function(req, res) {
    var newfriend = req.body.newfriend;
    friends.push(newfriend);
    // redirect to another page
    res.redirect("/friends");
});

var request = require('request');
request('http://www.google.com', function (error, response, body) {
  console.log('error:', error); // Print the error if one occurred
  console.log('statusCode:', response && response.statusCode); // Print the response status code if a response was received
  console.log('body:', body); // Print the HTML for the Google homepage.
});

var request = require('request');
request("https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20weather.forecast%20where%20woeid%20in%20(select%20woeid%20from%20geo.places(1)%20where%20text%3D%22nome%2C%20ak%22)&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys", function(error, response, body) {
    // check error
    if (!error && response.statusCode == 200) {
        // parse JSON
        var parsedData = JSON.parse(body);
        console.log(parsedData["query"]["results"]["channel"]);
    }
})

var mongoose = require("mongoose");
mongoose.connect("mongodb://localhost/cat_app", {useMongoClient: true});

// define schema
var catSchema = new mongoose.Schema({
    name: String,
    age: Number,
    place: String
});

// compile shema into a model
var Cat = mongoose.model("Cat", catSchema);

// add a new 
var cat1 = new Cat({
    name: "Cat1",
    age: 11,
    place: "Cal"
});
cat1.save(function(err, cat){
    // cat is what is saved in db
    if (err) {
        console.log("error");
    } else {
        console.log("good");
        console.log(cat);
    }
});

    // or another method
Cat.create({
    name: "Cat1",
    age: 11,
    place: "Cal"
}, function(err, cat) {
    if (err) {
        console.log("error");
    } else {
        console.log("good");
        console.log(cat);
    }
});


// retrieve all cats
Cat.find({}, function(err, cats) {
    if (err) {
        console.log("error");
    } else {
        console.log("good");
    }
});

// find one
Cat.findOne();

// all objects have a built-in ID
cat._id;

// FindById
Cat.findById(id, function(err, foundCat){
     // if err
});

// findByIdAndUpdate
Cat.findByIdAndUpdate(id, newCatObj, function(err, foundCat){
     // if err
});

// findByIdAndRemove
Cat.findByIdAndRemove(id, function(err, foundCat){
     // if err
});

var postSchema = new mongoose.Schema({
    title: String,
    content: String
});

var Post = mongoose.model("Post", postSchema);

var userSchema = new mongoose.Schema({
    name: String,
    email: String,
    // one to many
    posts: [postSchema]
});

var User = mongoose.model("User", userSchema);

var newUser = new User({
    email: "tsj@gmail.com",
    name: "Skin"
});

newUser.posts.push({
    title: "first post",
    content: "hi"
});

newUser.save(function(err, user) {
    // if err
});

// use this schema
var userSchema = new mongoose.Schema({
    name: String,
    email: String,
    // ref, one to many
    posts: [
        {
            type: mongoose.Schema.Types.ObjectId,
            ref: "Post"
        }
    ]
});

aUser.posts.push(newPost._id);
aUser.save();

// find posts for a user, the post objects will be inside returned user variable
User.findOne({name: "jack"}).populate("posts").exec(function(err, user) {

});

var mongoose = require("mongoose");

var postSchema = new mongoose.Schema({
    title: String,
    content: String
});

module.exports = mongoose.model("Post", postSchema);

var Post = require("./models/post");

// get human readable 
date.toDateString()

var expressSanitizer = require("express-sanitizer");

app.use(bodyParser.urlencoded({extended: true}));
//after above line
app.use(expressSanitizer());


// inside create and update
    // content is the value we want to sanitize inside blog object
req.body.blog.content = req.sanitize(req.body.blog.content);