How I can use mongoose and Koa.js

Question

I have a simple Koa app. I also use mongoose, mongodb(Mlab)

I connected to mongodb. And I can find only ourCat. I see array in console. But I don't know, how I can get and show result on page. And how I can use my request to db in some middleware?

const Koa = require('koa');
const app = new Koa();
const mongoose = require('mongoose');
const mongoUri = '...';

mongoose.Promise = Promise;
function connectDB(url) {
    if (!url) {
        throw Error('Mongo uri is undefined');
    }

    return mongoose
        .connect(url)
        .then((mongodb) => {
            return mongodb;
        });
}
connectDB(mongoUri);
const db = mongoose.connection;
db.on('error', console.error.bind(console, 'connection error:'));
db.once('open', function() {
    console.log('we\'re connected!');

    const Cat = mongoose.model('Cat', { name: String });
    const kitty = new Cat({ name: 'Zildjian' });
    kitty.save().then(() => console.log('meow'));

    const ourCat = Cat.find({ name: 'Zildjian' });
    ourCat.exec((er, cats) => {
        if (er) {
            console.log(er);
        }
        else if (cats) {

            console.log(cats);
        }
    });
});

app.use(async ctx => {
    ctx.body = 'Hello World';
});

app.listen(3000);

How I can add my answer from db to ctx.response?

Jonas Wilms · Accepted Answer · 2018-07-05T11:11:35.320

5

Wrap your database initialization into a Promise:

const Cat = mongoose.model('Cat', { name: String });

function getCats() {
  return new Promise((resolve, reject) => {
     const ourCat = Cat.find({ name: 'Zildjian' });
     ourCat.exec((er, cats) => {
       if (er) {  reject(er);   }
       else { resolve(cats); }
     });        
  });
}

So then you can just do:

const connection = connectDB(mongoUri);
app.use(async ctx => {
   await connection;
   ctx.body = await getCats();
});

edited Jul 05 '18 at 11:11

answered Jul 05 '18 at 09:06

Jonas Wilms

132,000
20
149
151

@aaron oh that might be caused by `"once"` being triggered before the listener is attached, maybe removing it completely solves it – Jonas Wilms Jul 05 '18 at 10:49
Now we have error: OverwriteModelError: Cannot overwrite `Cat` model once compiled. – Aaron Jul 05 '18 at 10:57
Maybe you know, where I can get the best practices for koa and db? – Aaron Jul 05 '18 at 11:06
@aaron I'm not using both, so i cannot really tell ... But that error can be fixed easily :) – Jonas Wilms Jul 05 '18 at 11:12
Jonas W. It's wonderful my friend! And what stack technology do you use? – Aaron Jul 05 '18 at 11:58
@aaron mongodb and express. – Jonas Wilms Jul 05 '18 at 12:00
Jonas W Herzlichen Dank! – Aaron Jul 05 '18 at 12:01
@aaron gehts denn jetzt? Oder hab ichs zum dritten Mal verbockt? :/ – Jonas Wilms Jul 05 '18 at 12:08
Jonas W Es funktioniert jetzt gut! – Aaron Jul 05 '18 at 12:21
where is `connectDB` from? – chovy Oct 08 '19 at 03:18
@chovy thats some wrapper around [`mongoose.connect`](https://mongoosejs.com/docs/connections.html) – Jonas Wilms Oct 08 '19 at 05:37

score 1 · Answer 2 · answered Jul 05 '18 at 12:58

1

Have a look at this repo:

https://github.com/jsnomad/koa-restful-boilerplate

It is quite updated and you will get your mind around the koa-mongoose stack... I think it will answer most of your questions; otherwise ask in the comments and will be able to help you :)

answered Jul 05 '18 at 12:58

Javier Aviles

7,952
2
22
28

Javier Aviles. Danke! And what technology stack do you use? – Aaron Jul 05 '18 at 14:04
Well depends a lot... for an easy rest api I have this stack ready to go on github with good docs: https://github.com/javieraviles/node-typescript-koa-rest But it really depends on your needs and what you like :) – Javier Aviles Jul 05 '18 at 20:08
This doesn't use `koa-mongoose` – chovy Oct 08 '19 at 03:26
The one from my answer (not the comment) definitely does :) https://github.com/jsnomad/koa-restful-boilerplate/blob/master/package.json – Javier Aviles Oct 08 '19 at 08:10

score 0 · Answer 3 · answered Mar 27 '19 at 07:43

For Example How to Create Koa.js+Mongodb

const Koa = require('koa')
const mongoose = require('koa-mongoose')
const User = require('./models/user')
const app = new Koa()

app.use(mongoose({
    user: '',
    pass: '',
    host: '127.0.0.1',
    port: 27017,
    database: 'test',
    mongodbOptions:{
        poolSize: 5,
        native_parser: true
    }
}))

app.use(async (ctx, next) => {
    let user = new User({
        account: 'test',
        password: 'test'
    })
    await user.save()
    ctx.body = 'OK'
})

Example create schemas

const Koa = require('koa')
const mongoose = require('koa-mongoose')
const app = new Koa()

app.use(mongoose({
    username: '',
    password: '',
    host: '127.0.0.1',
    port: 27017,
    database: 'test',
    schemas: './schemas',
    mongodbOptions:{
        poolSize: 5,
        native_parser: true
    }
}))

app.use(async (ctx, next) => {
    let User = ctx.model('User')
    let user = new User({
        account: 'test',
        password: 'test'
    })
    //or
    let user = ctx.document('User', {
        account: 'test',
        password: 'test'
    })

    await user.save()
    ctx.body = 'OK'
})

``` db.open(options.host, database, options.port, options) ^ TypeError: db.open is not a function``` — chovy, Sep 22 '19 at 19:11

How I can use mongoose and Koa.js

3 Answers3

Example create schemas