17 lines
567 B
Plaintext
17 lines
567 B
Plaintext
// Kw6pSBMvxgcHTh3X
|
|
// count duplicates
|
|
db.Catalog.aggregate({ $group: { _id: { ean: '$ean', site: '$site' }, count: { $sum: 1 } } }, { $match: { count: { $gt: 1 } } }, { $count: 'ean' })
|
|
|
|
// count ean for site
|
|
db.Catalog.aggregate({ $group: { _id: { ean: '$ean', site: '$site' } } }, { $count: 'ean' })
|
|
|
|
// image empty
|
|
db.Catalog.aggregate({ $match: { site_main_img: null } }, { $count: 'ean' })
|
|
|
|
|
|
// rename field
|
|
db.Catalog.updateMany({}, { $rename: { Ean: 'ean', Site: 'site', Uri: 'url' } })
|
|
|
|
// GD4eYvJMHUkXmajs
|
|
|
|
db.Catalog.find({main_img: {$ne: null}}).limit(1) |