Create db with next bash script:
#! /bin/bash
curl -X PUT http://127.0.0.1:5984/sales
IFS=$';'
vals=`cat sales_upload.json`
for i in $vals
do
curl -X POST http://127.0.0.1:5984/sales -H "Content-Type: application/json" -d $i
done
unset IFS
and resource file:
{
"Type" : "customer",
"LastName" : "Welsh",
"FirstName" : "Jim",
"Address" : "340 West 50th Street, New York, NY",
"TotalSpent" : 734.34
};
{
"Type" : "customer",
"LastName" : "Zuch",
"FirstName" : "Bo",
"Address" : "116 10th Avenue, New York, NY",
"TotalSpent" : 1102.47
};
{
"Type" : "customer",
"LastName" : "Libby",
"FirstName" : "Joe",
"Address" : "611 Fifth Avenue, New York, NY",
"TotalSpent" : 290.01
};
{
"Type" : "customer",
"LastName" : "Grant",
"FirstName" : "Sue",
"Address" : "7 West 55th Street, Manhattan, NY",
"TotalSpent" : 430.83
};
{
"Type" : "salesman",
"LastName" : "Green",
"FirstName" : "Gwen",
"Level" : 1
};
{
"_id" : "_design/logic",
"language" : "javascript",
"views" :
{
"customers": {
"map" : "function(doc) { if (doc.Type == 'customer') emit(null, {LastName: doc.LastName, FirstName: doc.FirstName, Address: doc.Address}) }"
},
"total_purchases": {
"map" : "function(doc) { if (doc.Type == 'customer') emit(null, doc.TotalSpent) }",
"reduce" : "function(keys, values) { return sum(values) }"
}
}
}
when i calling curl -X GET http://127.0.0.1:5984/sales/_design/logic/_view/total_purchases
i get:
{"rows":[ {"key":null,"value":2557.65} ]}
but if i in total_purchases change first parameter of emit to emit(doc.LastName, doc.TotalSpent), then i will get:
{"rows":[ {"key":null,"value":2557.6499999999996} ]}
Why so?