-
docker run --name NOME_BASE -p 27017:27017 -d -t mongo
-
Criar a base NOME_BASE
- mongo mongodb://localhost:27017/NOME_BASE
ensureIndex( { id:1}, { unique:true, dropDups:true } )
db.tickets
.find({id:1})
.sort({_id:1})
.forEach(function(doc){
db.tickets
.remove({ _id: {$gt:doc._id}, id:doc.id });
})
R$ 9,99 -> 9.99 Usando o shell
db
use NOME_BASE
db.tickets.find({ inicio : /12\/09/ }).forEach(function(obj) {
obj.price = obj.valor.replace(/R\$ /g, '');
obj.price = obj.price.replace(/,/, '.');
obj.price = NumberDecimal(obj.price);
db.tickets.save(obj);
});
{
_id: { day: { $dayOfYear: ISODate("$inicio")} },
total: { $sum: "$price" },
count: { $sum: 1 }
}
ok abaixo
db.tickets.aggregate([
{ "$match": { "inicio": /14\/09/}},
{ "$group": { "_id": null, "total": { "$sum": "$price" }}}
]);
db.tickets.aggregate(
[
{
$group:
{
_id: { day: { $dayOfYear: ISODate("$inicio")} },
total: { $sum: "$price" },
count: { $sum: 1 }
}
}
]
);
db.tickets.aggregate(
[
{
$group:
{
_id: { day: { $dayOfYear: "$inicio"}, year: { $year: "$inicio" } },
total: { $sum: "$price" },
count: { $sum: 1 }
}
}
]
)