Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
G
G
gsdev992019-06-07 18:59:27
MongoDB
gsdev99, 2019-06-07 18:59:27

How to read the request correctly?

Hello. Guys, tell me, please, how to read the request correctly?
I have a collection: Products

/* 1 */
{
    "_id" : ObjectId("5b2d3648ca6a03cd33af924c"),
    "sold" : 38,
    "name" : "AZ2040",
    "description" : "Super awesome guitar",
    "price" : 2000,
    "brand" : ObjectId("5b2c11d2d37177aedfd6d962"),
    "shipping" : true,
    "available" : true,
    "wood" : ObjectId("5b2c1c88255983b4795f8fdb"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T17:47:52.838Z"),
    "updatedAt" : ISODate("2018-06-26T22:09:18.969Z"),
    "__v" : 0
}

/* 2 */
{
    "_id" : ObjectId("5b2d38027d75e2cdcb31cf04"),
    "sold" : 4,
    "name" : "Roadcore",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 1500,
    "brand" : ObjectId("5b2c11d2d37177aedfd6d962"),
    "shipping" : true,
    "available" : true,
    "wood" : ObjectId("5b2c1c0981e781b44909627d"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T17:55:14.152Z"),
    "updatedAt" : ISODate("2018-06-26T22:09:18.972Z"),
    "__v" : 0
}

/* 3 */
{
    "_id" : ObjectId("5b2d38217d75e2cdcb31cf05"),
    "sold" : 15,
    "name" : "JEM UV7",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 3500,
    "brand" : ObjectId("5b2c11d2d37177aedfd6d962"),
    "shipping" : true,
    "available" : false,
    "wood" : ObjectId("5b2c1c81255983b4795f8fda"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T17:55:45.880Z"),
    "updatedAt" : ISODate("2018-06-22T17:55:45.880Z"),
    "__v" : 0
}

/* 4 */
{
    "_id" : ObjectId("5b2d384b7d75e2cdcb31cf06"),
    "sold" : 0,
    "name" : "TELE-ub23",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 600,
    "brand" : ObjectId("5b2c11481470fbaecd159dfd"),
    "shipping" : false,
    "available" : false,
    "wood" : ObjectId("5b2c1c0981e781b44909627d"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T17:56:27.270Z"),
    "updatedAt" : ISODate("2018-06-22T17:56:27.270Z"),
    "__v" : 0
}

/* 5 */
{
    "_id" : ObjectId("5b2d390d7d75e2cdcb31cf07"),
    "sold" : 9,
    "name" : "FR7",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 1300,
    "brand" : ObjectId("5b2c12a4d37177aedfd6d967"),
    "shipping" : false,
    "available" : true,
    "wood" : ObjectId("5b2c1c81255983b4795f8fda"),
    "frets" : 24,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T17:59:41.868Z"),
    "updatedAt" : ISODate("2018-06-22T17:59:41.868Z"),
    "__v" : 0
}

/* 6 */
{
    "_id" : ObjectId("5b2d39407d75e2cdcb31cf08"),
    "sold" : 0,
    "name" : "Blue6",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 700,
    "brand" : ObjectId("5b2c12a1d37177aedfd6d966"),
    "shipping" : true,
    "available" : true,
    "wood" : ObjectId("5b2c1c81255983b4795f8fda"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T18:00:32.803Z"),
    "updatedAt" : ISODate("2018-06-22T18:00:32.803Z"),
    "__v" : 0
}

/* 7 */
{
    "_id" : ObjectId("5b2d39697d75e2cdcb31cf09"),
    "sold" : 4,
    "name" : "PET967",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 1200,
    "brand" : ObjectId("5b2c171c357cb8b03cb04342"),
    "shipping" : true,
    "available" : true,
    "wood" : ObjectId("5b2c1c0981e781b44909627d"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T18:01:13.043Z"),
    "updatedAt" : ISODate("2018-06-22T18:01:13.043Z"),
    "__v" : 0
}

/* 8 */
{
    "_id" : ObjectId("5b2d39987d75e2cdcb31cf0a"),
    "sold" : 0,
    "name" : "Robot 5",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 1200,
    "brand" : ObjectId("5b2c1267d37177aedfd6d965"),
    "shipping" : true,
    "available" : true,
    "wood" : ObjectId("5b2c1c0981e781b44909627d"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T18:02:00.569Z"),
    "updatedAt" : ISODate("2018-06-22T18:02:00.569Z"),
    "__v" : 0
}

/* 9 */
{
    "_id" : ObjectId("5b2d39bd7d75e2cdcb31cf0b"),
    "sold" : 3,
    "name" : "Dinky 7",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 600,
    "brand" : ObjectId("5b2c1264d37177aedfd6d964"),
    "shipping" : true,
    "available" : true,
    "wood" : ObjectId("5b2c1c88255983b4795f8fdb"),
    "frets" : 24,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T18:02:37.344Z"),
    "updatedAt" : ISODate("2018-06-26T06:11:52.923Z"),
    "__v" : 0
}

/* 10 */
{
    "_id" : ObjectId("5b2d39d97d75e2cdcb31cf0c"),
    "sold" : 15,
    "name" : "RoadCaster",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 1,
    "brand" : ObjectId("5b2c11481470fbaecd159dfd"),
    "shipping" : true,
    "available" : false,
    "wood" : ObjectId("5b2c1c0981e781b44909627d"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T18:03:05.168Z"),
    "updatedAt" : ISODate("2018-06-26T23:32:52.944Z"),
    "__v" : 0
}

/* 11 */
{
    "_id" : ObjectId("5b2d4b70e4b4a1d22d374f8b"),
    "sold" : 12,
    "name" : "ACU700",
    "description" : "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. ",
    "price" : 1,
    "brand" : ObjectId("5b2c1216d37177aedfd6d963"),
    "shipping" : true,
    "available" : true,
    "wood" : ObjectId("5b2c1c81255983b4795f8fda"),
    "frets" : 22,
    "publish" : true,
    "createdAt" : ISODate("2018-06-22T19:18:08.458Z"),
    "updatedAt" : ISODate("2018-06-26T23:32:52.949Z"),
    "__v" : 0
}

The following request is written in the server.js file:
// http://localhost:3002/api/product/articles/?sortBy=createdAt&order=desc&limit=4
app.get('/api/product/articles', (req, res) => {
    let order = req.query.order ? req.query.order : 'asc';

    let sortBy = req.query.sortBy ? req.query.sortBy : '_id';

    let limit = req.query.limit ? parseInt(req.query.limit) : 100;

    console.log('order:', order); // desc
    console.log('sortBy:', sortBy); // createdAt
    console.log('limit:', limit); // 4

    Product.find()
        .populate('brand')
        .populate('wood')
        .sort()
        .limit(limit)
        .exec((err, articles) => {
            if (err) {
                return res.status(400).send(err);
            }
            res.send(articles);
        });
});

Actually a question:
How correctly there is a sequence of request?
In the products collection we are looking for a document:
(not clear: .populate('brand') .populate('wood').sort())
And what does exec mean?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
X
xcandlelight2022-02-19 21:55:09
How to insert data from one cell to another by selecting it dynamically? 3Reply
V
voproser456542022-02-24 17:56:58
Which modification of the assembler is better? 2Reply
F
fedot13252016-05-11 17:57:17
What is the best way to make user "variables" in MongoDB? 1Reply
P
Philipp2014-03-17 03:41:55
How to store CELERYBEAT_SCHEDULE in MongoDB? 2Reply
R
riddlr2018-10-16 18:31:44
How to make a recursive populace? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question