Advertisement
Guest User

Untitled

a guest
May 3rd, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. function loadShopsCSV(ShopsName) {
  2. var filename = 'test.csv'
  3.  
  4. csv
  5. .fromPath(filename)
  6. .on("data", function(data) {
  7. var entry = {
  8. PeriodEST: Date.parse(data[0]),
  9. TextDate: textDateM,
  10. ShopId: parseInt(data[1]),
  11. ShopName: data[2],
  12. State: data[3],
  13. AreaUS: parseInt(data[4]),
  14. AreaUSX: AreaUSArray[stateArray.indexOf(data[3])],
  15. ProductClass: data[5],
  16. Type: data[6],
  17. SumNetVolume: parseInt(data[7]),
  18. Weekday: weekdayNum,
  19. WeightedAvgPrice: parseFloat(data[8]),
  20.  
  21. }
  22.  
  23.  
  24. db.get(ShopsDBname).update(
  25. {"PeriodEST" : entry.PeriodEST,
  26. "ShopName": entry.ShopName,
  27. "State" : entry.State,
  28. "AreaUS" : entry.AreaUS,
  29. "ProductClass" : entry.ProductClass,
  30. "Type" : entry.Type},
  31. {$set : entry},
  32. function(err, result) {
  33.  
  34. }
  35. );
  36. }
  37. }
  38. })
  39. .on("end", function() {
  40. console.log('finished loading: '+ShopsName)
  41. });
  42. }, function(err) {
  43. console.error(err);
  44. });
  45. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement