chore

Hendrixer · Hendrixer · commit fce254969c70 · 2018-10-10T23:12:32.000-05:00
diff --git a/exercises/models/__test__/crud.spec.js b/exercises/models/__test__/crud.spec.js
@@ -1,7 +1,7 @@
 const User = require('../user')
 const crud = require('../crud')
 
-describe('user crud', () => {
+describe('User crud', () => {
   describe('getUserById', () => {
     test('get user by object id', async () => {
       const user = await User.create({
diff --git a/exercises/models/__test__/user.spec.js b/exercises/models/__test__/user.spec.js
@@ -1,6 +1,6 @@
 const User = require('../user')
 
-describe('user', () => {
+describe('User model', () => {
   test('first name must be required', async () => {
     expect.assertions(1)
 
@@ -83,7 +83,8 @@ describe('user', () => {
         zip: 91917,
         city: 'SF',
         State: 'CA'
-      }
+      },
+      pets: ['tido', 'miguel']
     })).toObject()
 
     expect(user).toEqual({
@@ -98,7 +99,8 @@ describe('user', () => {
         zip: 91917,
         city: 'SF',
         State: 'CA'
-      }
+      },
+      pets: ['tido', 'miguel']
     })
   })
 })
diff --git a/exercises/models/user.js b/exercises/models/user.js
@@ -19,6 +19,7 @@ const userSchema = new mongoose.Schema({
     default: false
   },
   birthDate: Date,
+  pets: [{type: String}],
   address: {
     other: Boolean,
     street: String,
diff --git a/exercises/queries/__test__/post.spec.js b/exercises/queries/__test__/post.spec.js
@@ -0,0 +1,43 @@
+const Post = require('../post')
+const Author = require('../author')
+
+describe('Post model', () => {
+  test('author is required and id type', async () => {
+    expect.assertions(2)
+    
+    try {
+      await Post.create({
+        title: 'Top ten movie books',
+        content: 'There are a bunch books out there with movies. But which ones are legit?',
+      })
+    } catch (e) {
+      expect(e).toBeTruthy()
+    }
+
+    try {
+      await Post.create({
+        title: 'Top ten movie books',
+        content: 'There are a bunch books out there with movies. But which ones are legit?',
+        author: 'hello'
+      })
+    } catch (e) {
+      expect(e).toBeTruthy()
+    }
+  })
+  test('author must ref author collection', async () => {
+    const name = 'JK Moose'
+    const author = await Author.create({
+      name,
+      bio: 'I have so many awards'
+    })
+
+    const post = await Post.create({
+      title: 'Top ten movie books',
+      content: 'There are a bunch books out there with movies. But which ones are legit?',
+      author: author.id
+    })
+
+    const p = await post.populate('author').execPopulate()
+    expect(p.author.name).toBe(name)
+  })
+})
diff --git a/exercises/queries/__test__/queries.spec.js b/exercises/queries/__test__/queries.spec.js
@@ -0,0 +1,53 @@
+const {
+  postByTitle,
+  postByContentLength,
+  postsForAuthor
+} = require('../queries')
+const Post = require('../post')
+const Author = require('../post')
+const mongoose = require('mongoose')
+const createConent = (length, fill = 'b') => new Array(length).fill(fill).join('')
+
+describe('queries', () => {
+  describe('postByTitle', () => {
+    test('get post by title', async () => {
+      const title = 'cat bedtime'
+      const post = await Post.create({
+        title,
+        author: mongoose.Types.ObjectId(),
+        content: createConent(50)
+      })
+      
+      const match = await postByTitle(title)
+      expect(match.id).toBe(post.id)
+    })
+  })
+
+  describe('postsForAuthor', () => {
+    test('get post by author', async () => {
+      const author = mongoose.Types.ObjectId()
+      const post = await Post.create({
+        author,
+        title: 'Carter v',
+        content: createConent(50)
+      })
+      const match = await postsForAuthor(author)
+      expect(match.author.toString()).toBe(post.author.toString())
+    })
+  })
+
+  describe('postByContentLength', () => {
+    test('find posts in between content lengths', async () => {
+      const author = mongoose.Types.ObjectId()
+
+      const posts = await Post.create([
+        {title: 'Super Duper', author, content: createConent(1000)},
+        {title: 'Amazing', author, content: createConent(100)},
+        {title: 'Other', author, content: createConent(800)}
+      ])
+
+      const matches = await postByContentLength(1000, 100)
+      expect(matches).toHaveLength(1)
+    })
+  })
+})
diff --git a/exercises/queries/author.js b/exercises/queries/author.js
@@ -0,0 +1,27 @@
+const mongoose = require('mongoose')
+
+const authorSchema = new mongoose.Schema({
+  name: {
+    type: String,
+    required: true,
+    trim: true
+  },
+  bio: {
+    type: String,
+    required: true
+  },
+  social: {
+    twitter: {
+      type: String,
+      unique: true,
+      sparse: true
+    },
+    linkedin: {
+      type: String,
+      unique: true,
+      sparse: true
+    }
+  }
+}, {timestamps: true})
+
+module.exports = mongoose.model('author', authorSchema)
diff --git a/exercises/queries/index.js b/exercises/queries/index.js
diff --git a/exercises/queries/post.js b/exercises/queries/post.js
@@ -4,9 +4,27 @@ const postSchema = new mongoose.Schema({
   title: {
     type: String,
     required: true,
-    unique: true,
-    sparse: true
+    unique: true
   },
-  
-  
+  content: {
+    type: String,
+    required: true,
+    minlength: 50,
+    maxlength: 1200
+  },
+  author: {
+    type: mongoose.Schema.Types.ObjectId,
+    ref: 'author',
+    required: true
+  },
+  isFeatured: {
+    type: Boolean,
+    deafult: false
+  },
+  similarPosts: [{
+    type: mongoose.Schema.Types.ObjectId,
+    ref: 'post',
+  }]
 }, {timestamps: true})
+
+module.exports = mongoose.model('post', postSchema)
diff --git a/exercises/queries/queries.js b/exercises/queries/queries.js
@@ -0,0 +1,44 @@
+const Post = require('./post')
+
+const postByTitle = (title) => {
+  return Post.findOne({title}).exec()
+}
+
+const postsForAuthor = (authorId) => {
+  return Post.find({author: authorId}).exec()
+}
+
+const fullPostById = (id) => {
+  return Post.findById(id)
+    .populate('author')
+    .populate('similarPosts')
+    .exec()
+}
+
+const selectivePostsByLatest = (fieldsToSelect) => {
+  return Post.find({})
+    .select(fieldsToSelect)
+    .sort('-createdAt')
+    .exec()
+}
+
+const postByContentLength = (maxContentLength, minContentLength) => {
+  return Post.find({
+    content: {$lt: maxContentLength, $gt: minContentLength}
+  })
+    .exec()
+}
+
+const addRelatedPosts = (postId, relatedPosts) => {
+  return Post.findById(postId, {$pushAll: {relatedPosts}}, {new: true})
+}
+
+module.exports = {
+  postByTitle,
+  postsForAuthor,
+  postByContentLength,
+  fullPostById,
+  selectivePostsByLatest,
+  postByContentLength,
+  addRelatedPosts
+}
