-
Notifications
You must be signed in to change notification settings - Fork 0
/
migrator.macros.js
29 lines (20 loc) · 934 Bytes
/
migrator.macros.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
require("./lib/configurate");
var getPostgresConnection = require("./lib/data");
var getMongoConnection = require("./lib/mongo");
getPostgresConnection(function(conn){
conn.query("select gid,(ST_AsGeoJSON(the_geom)) as geometry, denominacion as name, idoperador as operator" +
" from layerseditables.macroambientes limit 20000 offset 10000", function (err, result){
if(err) return console.log("error connecting to postgres", err);
var macros = result.rows;
console.log("transforming geometry to standard json doc");
macros.forEach(function (macro) {
macro.geometry = JSON.parse(macro.geometry);
});
console.log("inserting " + macros.length + " in mongodb");
getMongoConnection(function(db){
db.collection("macros").insert(macros, function(err, inserted){
console.log("inserted " + inserted.length + " documents in mongodb");
});
});
});
});