models

Hendrixer · Hendrixer · commit 66a017a92328 · 2018-10-10T21:24:00.000-05:00
diff --git a/.gitignore b/.gitignore
@@ -0,0 +1,5 @@
+node_modules
+*.log
+yarn-error.log
+dist
+DS_Store
diff --git a/README.md b/README.md
diff --git a/exercises/connect.js b/exercises/connect.js
@@ -0,0 +1,7 @@
+const mongoose = require('mongoose')
+
+const connect = (url) => mongoose.connect(url, {
+  useNewUrlParser: true
+})
+
+module.exports = connect
diff --git a/exercises/models/__test__/crud.spec.js b/exercises/models/__test__/crud.spec.js
@@ -0,0 +1,78 @@
+const User = require('../user')
+const crud = require('../crud')
+
+describe('user crud', () => {
+  describe('getUserById', () => {
+    test('get user by object id', async () => {
+      const user = await User.create({
+        firstName: 'Nemo',
+        lastName: 'Nemo',
+        email: 'nemo@nemo.com'
+      })
+      const match = await crud.getUserById(user.id)
+
+      expect(match.id).toBe(user.id)
+    })
+  })
+  describe('getAllUsers', () => {
+    test('get all users in the DB', async () => {
+      const usersToCreate = [
+        {
+          firstName: 'Nemo',
+          lastName: 'Nemo',
+          email: 'nemo@nemo.com'
+        },
+        {
+          firstName: 'Nemo1',
+          lastName: 'Nemo1',
+          email: 'nemo1@nemo.com'
+        },
+        {
+          firstName: 'Nemo3',
+          lastName: 'Nemo3',
+          email: 'nemo3@nemo.com'
+        }
+      ]
+      const users = await User.create(usersToCreate)
+      const matchedUsers = await crud.getAllUsers()
+      
+      expect(matchedUsers).toHaveLength(users.length)
+    })
+  })
+  describe('createUser', () => {
+    test('create a user', async () => {
+      const userConfig = {
+        firstName: 'Nemo',
+        lastName: 'Nemo',
+        email: 'nemo@nemo.com'
+      }
+      const {id} = await crud.createUser(userConfig)
+      const match = await User.findById(id).exec()
+      expect(match.id).toBe(id)
+    })
+  })
+  describe('removeUserById', () => {
+    test('remove user by id', async () => {
+      const {id} = await User.create({
+        firstName: 'Nemo',
+        lastName: 'Nemo',
+        email: 'nemo@nemo.com'
+      })
+      await crud.removeUserById(id)
+      const match = await User.findById(id).exec()
+      expect(match).toBe(null)
+    })
+  })
+  describe('updateUserById', () => {
+    test('update user by id', async () => {
+      const {id} = await User.create({
+        firstName: 'Nemo',
+        lastName: 'Nemo',
+        email: 'nemo@nemo.com'
+      })
+      const user = await crud.updateUserById(id, {betaUser: true})
+      expect(user.id).toBe(id)
+      expect(user.betaUser).toBe(true)
+    })
+  })
+})
diff --git a/exercises/models/__test__/user.spec.js b/exercises/models/__test__/user.spec.js
@@ -0,0 +1,104 @@
+const User = require('../user')
+
+describe('user', () => {
+  test('first name must be required', async () => {
+    expect.assertions(1)
+
+    try {
+      await User.create({
+        lastName: 'Williams',
+        email: 'sasha@gmail.com'
+      })
+    } catch (e) {
+      expect(e).toBeTruthy()
+    }    
+  })
+  test('last name must be required', async () => {
+    expect.assertions(1)
+
+    try {
+      await User.create({
+        firstName: 'Williams',
+        email: 'sasha@gmail.com'
+      })
+    } catch (e) {
+      expect(e).toBeTruthy()
+    }    
+  })
+  test('email must be required', async () => {
+    expect.assertions(1)
+
+    try {
+      await User.create({
+        lastName: 'Williams',
+        firstName: 'Sasha'
+      })
+    } catch (e) {
+      expect(e).toBeTruthy()
+    }    
+  })
+
+  test('email must be unique', async () => {
+    expect.assertions(1)
+
+    try {
+      await User.init() // wait for index to build
+      await User.create([
+        {
+          lastName: 'Williams',
+          firstName: 'Sasha',
+          email: 'email@gmail.com'
+        },
+        {
+          lastName: 'Haas',
+          firstName: 'Mel',
+          email: 'email@gmail.com'
+        }
+      ])
+    } catch (e) {
+      expect(e).toBeTruthy()
+    }    
+  })
+
+  test('betaUser should default to false', async () => {
+    const user = await User.create({
+      firstName: 'Tilly',
+      lastName: 'Mills',
+      email: 'tg@gmail.com'
+    })
+
+    expect(user.betaUser).toBe(false)
+  })
+
+  test('should have correct fields', async () => {
+    const now = Date.now()
+    const {_id, __v, ...user} = (await User.create({
+      firstName: 'Tilly',
+      lastName: 'Mills',
+      email: 'tg@gmail.com',
+      birthDate: now, // they were born today 😎
+      address: {
+        street: 'Heming way',
+        houseNumber: 1234,
+        zip: 91917,
+        city: 'SF',
+        State: 'CA'
+      }
+    })).toObject()
+
+    expect(user).toEqual({
+      firstName: 'Tilly',
+      lastName: 'Mills',
+      email: 'tg@gmail.com',
+      birthDate: new Date(now),
+      betaUser: false,
+      address: {
+        street: 'Heming way',
+        houseNumber: 1234,
+        zip: 91917,
+        city: 'SF',
+        State: 'CA'
+      }
+    })
+  })
+})
diff --git a/exercises/models/crud.js b/exercises/models/crud.js
@@ -0,0 +1,30 @@
+const User = require('./user')
+
+const getUserById = (id) => {
+  return User.findById(id)
+    .exec()
+}
+
+const getAllUsers = () => {
+  return User.find({})
+    .exec()
+}
+
+const createUser = (userDetails) => {
+  return User.create(userDetails)
+}
+const removeUserById = (id) => {
+  return User.findByIdAndDelete(id).exec()
+}
+
+const updateUserById = (id, update) => {
+  return User.findByIdAndUpdate(id, update, {new: true}).exec()
+}
+
+module.exports = {
+  getUserById,
+  getAllUsers,
+  createUser,
+  removeUserById,
+  updateUserById
+}
diff --git a/exercises/models/user.js b/exercises/models/user.js
@@ -0,0 +1,32 @@
+const mongoose = require('mongoose')
+
+const userSchema = new mongoose.Schema({
+  firstName: {
+    type: String,
+    required: true
+  },
+  lastName: {
+    type: String,
+    required: true
+  },
+  email: {
+    type: String,
+    required: true,
+    unique: true
+  },
+  betaUser: {
+    type: Boolean,
+    default: false
+  },
+  birthDate: Date,
+  address: {
+    other: Boolean,
+    street: String,
+    houseNumber: Number,
+    zip: Number,
+    city: String,
+    State: String
+  }
+})
+
+module.exports = mongoose.model('user', userSchema)
diff --git a/exercises/queries/index.js b/exercises/queries/index.js
diff --git a/exercises/queries/post.js b/exercises/queries/post.js
@@ -0,0 +1,12 @@
+const mongoose = require('mongoose')
+
+const postSchema = new mongoose.Schema({
+  title: {
+    type: String,
+    required: true,
+    unique: true,
+    sparse: true
+  },
+  
+  
+}, {timestamps: true})
diff --git a/package.json b/package.json
@@ -0,0 +1,27 @@
+{
+  "name": "intro-to-mongodb",
+  "version": "1.0.0",
+  "main": "index.js",
+  "author": "Scott Moss <willscottmoss@gmail.com>",
+  "license": "MIT",
+  "scripts": {
+    "test": "jest"
+  },
+  "dependencies": {
+    "cuid": "^2.1.4",
+    "mongoose": "^5.3.2"
+  },
+  "jest": {
+    "verbose": true,
+    "testURL": "http://localhost/",
+    "testEnvironment": "node",
+    "setupTestFrameworkScriptFile": "<rootDir>/testconfig.js",
+    "restoreMocks": true,
+    "testPathIgnorePatterns": [
+      "dist/"
+    ]
+  },
+  "devDependencies": {
+    "jest": "^23.6.0"
+  }
+}
diff --git a/testconfig.js b/testconfig.js
@@ -0,0 +1,35 @@
+const mongoose = require('mongoose')
+const cuid = require('cuid')
+const connect = require('./exercises/connect')
+const url = 'mongodb://localhost:27017/intro-mongodb-testing'
+
+global.newId = () => {
+  return mongoose.Types.ObjectId()
+}
+
+beforeEach(async done => {
+  const db = cuid()
+  function clearDB() {
+    for (var i in mongoose.connection.collections) {
+      mongoose.connection.collections[i].remove(function() {})
+    }
+    return done()
+  }
+  if (mongoose.connection.readyState === 0) {
+    try {
+      await connect(url + db)
+      clearDB()
+    } catch (e) {
+      throw e
+    }
+  } else {
+    clearDB()
+  }
+})
+afterEach(done => {
+  mongoose.disconnect()
+  return done()
+})
+afterAll(done => {
+  return done()
+})
diff --git a/yarn.lock b/yarn.lock
