const mongoose = require('mongoose')
//require uuid
const { v4: uuidv4 } = require('uuid')
const newsSchema = mongoose.Schema(
    {
        uuid: {
             type: String,
            default: () => uuidv4()
        },
        subject: {
            type: String,
            match: [
                /^.{2,10}$/,
                'Please add a valid subject 2~10',
            ],
            required: [true, "Please enter subject"],
            trim: true,
        },
        content: {
            type: String,
            match: [
                /^.{4,500}$/,
                'Please add a valid content 4~500',
            ],
            required: [true, "請輸入內容"],
            trim: true, 
        },
        createdTime: {
            type: String,
        },
        updatedTime: {
            type: String,
        }
    }
   /* {
        timestamps: true
    }*/
)
const News = mongoose.model('News', newsSchema);
module.exports = News;

npm install moment --save

const express = require('express')
//載入newsModel
const News = require('../models/newModel')
//載入時間套件
const moment = require('moment');
moment().format();


//Create
router.post('/new', async(req, res) => {   
    try {
    /* 	#swagger.tags = ['News']
        #swagger.description = '' */

    /*	#swagger.parameters['obj'] = {
            in: 'body',
            description: '',
            required: true,
            schema: { $ref: "#/definitions/AddNews" }
    } */

    /* #swagger.security = [{
            "apiKeyAuth": []
    }] */
         const data = new News({
            subject:req.body.subject,
            image:req.body.image,
            content:req.body.content,
            createdTime: moment(Date.now()).format('YYYY-MM-DDTHH:mm:ss.SSS'),
            updatedTime: moment(Date.now()).format('YYYY-MM-DDTHH:mm:ss.SSS'),
        })
        const news = await data.save();
        res.status(200).json(news);
        
    } catch (error) {
        const expr = error.message;
        console.log('News error.message',expr)
        switch (expr) { 
            case 'News validation failed: subject: Please add a valid subject 2~30':
            res.status(400).json({ message: 'subject 驗證失敗:subject必須2~30字符' })
                break;
            case 'News validation failed: subject: Please add a valid name 2~30, content: Please add a valid content 4~500':
                res.status(400).json({message: '`subject`,`content`驗證失敗' })
                break;
            case 'News validation failed: content: Please add a valid content 4~500':
                res.status(400).json({message: 'content驗證失敗:subject必須4~500字符' })
              break;
            default:
               console.log('!!');
        }
      //  res.status(500).json({message: error.message})
    }
})
router.get('/news', async(req, res) => {
    try {
        const news = await News.find({});
        res.status(200).json(news);
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})
router.get('/news/:id', async(req, res) =>{
    try {
        const {id} = req.params;
        const news = await News.findById(id);
        res.status(200).json(news);
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})
router.put('/news/:id', async(req, res) => {
    try {
    /* 	#swagger.tags = ['News']
        #swagger.description = '' */

    /*	#swagger.parameters['obj'] = {
            in: 'body',
            description: '',
            required: true,
            schema: { $ref: "#/definitions/News" }
    } */

    /* #swagger.security = [{
            "apiKeyAuth": []
    }] */
        const { id } = req.params;
         const data = {
            subject:req.body.subject,
            image:req.body.image,
            content:req.body.content,
            updatedTime: moment(Date.now()).format('YYYY-MM-DDTHH:mm:ss.SSS'),
        }
        const news = await News.findByIdAndUpdate(id, data);
        // we cannot find any news in database
        if(!news){
            return res.status(404).json({message: `cannot find any news with ID ${id}`})
        }
        const updatedNews = await New.findById(id);
        res.status(200).json(updatedNews);
        
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})
router.delete('/news/:id', async(req, res) =>{
    try {
        const {id} = req.params;
        const test = await News.findByIdAndDelete(id);
        if(!test){
            return res.status(404).json({message: `cannot find any news with ID ${id}`})
        }
        res.status(200).json(test);
        
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})

npm i mongoose

//express
const express = require('express')
//資料庫
const mongoose = require('mongoose')
//環境變數
require('dotenv').config()
const user = process.env.DB_USER;
const password = process.env.DB_PASS;
const host = process.env.DB_HOST;
const project = process.env.MONGO_PROJECT;
const retryWrites = process.env.MONGO_RETRY_WRITES;
const connectionString = `mongodb+srv://${user}:${password}@${host}/${project}?retryWrites=${retryWrites}&w=majority`;
const connectionString = `mongodb+srv://${user}:${password}@${host}/?retryWrites=${retryWrites}&w=majority`;
mongoose.set("strictQuery", false)

mongoose.connect(connectionString,{serverSelectionTimeoutMS: 5000})
  .then(() => {
    console.log('連結mongoose');
  })
  .catch((err) => {
    console.log(err.message);
  });

const app = express()

app.use(express.json())
// express 網址編碼 中內置的一種方法，用於將傳入的 Request Object 識別為strings 或 arrays; extended=>廣大的。

app.use(express.urlencoded({ extended: false }))


const api = require('./routes/api')
app.use('/api', api)

const auth = require('./routes/auth')
app.use('/auth', auth)


app.get('/', (req, res) => {
  res.send('Hello Node Api!')
})

const PORT = process.env.PORT || 8080;


app.listen(PORT, () => console.log(`服務器正在監聽端口 ${PORT}`));

module.exports = app;

const mongoose = require('mongoose')
//Mongoose對MongoDB的操作涉及三個層面：Schema, Model與Entity
//Schema是資料文件的骨架，本身不影響資料庫，用來產生Model
//Model是用Schema產生的模型。
//Entity是用Model創建的實作。
//Model與Entity的操作會影響資料庫。

const newSchema = mongoose.Schema(
    {
        subject: {
            type: String,
            required: [true, "Please enter subject"]
        },
        image: {
            type: String,
            required: false,
        },
        content: {
            type: String,
            required: false,
        }
    },
    {
        timestamps: true
    }
)


const New = mongoose.model('News', newSchema);

module.exports = New;

const express = require('express')
const mongoose = require('mongoose')
const New = require('./models/newModel')
//環境變數
require('dotenv').config()
const user = process.env.DB_USER;
const password = process.env.DB_PASS;
const host = process.env.DB_HOST;
const project = process.env.MONGO_PROJECT;
const retryWrites = process.env.MONGO_RETRY_WRITES;
const connectionString = `mongodb+srv://${user}:${password}@${host}/${project}?retryWrites=${retryWrites}&w=majority`;

mongoose.set("strictQuery", false)

mongoose.connect(connectionString,{serverSelectionTimeoutMS: 5000})
  .then(() => {
    console.log('連結mongoose');
  })
  .catch((err) => {
    console.log(err.message);
  });

const app = express()

// Json格式
app.use(express.json())
// express 中內置的一種方法，用於將傳入的 Request Object 識別為strings 或 arrays。
app.use(express.urlencoded({extended: false}))


//建立Create ＝>New.create
app.post('/new', async(req, res) => {
  try {
        const news = await New.create(req.body)
        res.status(200).json(news);
        
    } catch (error) {
        console.log(error.message);
        res.status(500).json({message: error.message})
    }
})
//Read news All =>New.find({})
app.get('/news', async(req, res) => {
    try {
        const news = await New.find({});
        res.status(200).json(news);
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})
//Read  news id=> New.findById(id)
app.get('/news/:id', async(req, res) =>{
    try {
        const {id} = req.params;
        const news = await New.findById(id);
        res.status(200).json(news);
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})

//updatedNews => New.findByIdAndUpdate(id, req.body)
app.put('/news/:id', async(req, res) => {
    try {
        const {id} = req.params;
        const newR = await New.findByIdAndUpdate(id, req.body);
        // we cannot find any news in database
        if(!newR){
            return res.status(404).json({message: `cannot find any news with ID ${id}`})
        }
        const updatedNews = await New.findById(id);
        res.status(200).json(updatedNews);
        
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})

//Delete news id =>New.findByIdAndDelete(id)
app.delete('/news/:id', async(req, res) =>{
    try {
        const {id} = req.params;
        const test = await New.findByIdAndDelete(id);
        if(!test){
            return res.status(404).json({message: `沒有發現任何 News ID ${id}`})
        }
        res.status(200).json(test);
        
    } catch (error) {
        res.status(500).json({message: error.message})
    }
})

const PORT = process.env.PORT || 8080;


app.listen(PORT, () => console.log(`服務器正在監聽端口 ${PORT}`));

module.exports = app;

npm install express-generator -g

express -e 專案名稱

到專案
cd 專案名稱

npm start