@@ -212,3 +212,60 @@ gulp.task('sde:refresh:wormhole_classes', function(done) {
   //   // db.disconnect(done);
   // });
 });
+
+gulp.task('db:repair:1', function(done) {
+  var mongoose = require('mongoose')
+    , _ = require('lodash')
+    , System = require('./server/models/system')
+    , Region = require('./server/models/region')
+    , map_data = require('./public/data/map.json')
+
+  var db = mongoose.connect(process.env.MONGODB_URL);
+  mongoose.set('debug', true);
+
+  db.models.System.remove().execQ();
+  db.models.Region.remove().execQ();
+  _.forEach(map_data.Systems, function(data) {
+    var system = new System(data);
+    system.save();
+  });
+
+  // db.disconnect(done);
+});
+
+gulp.task('db:repair:2', function(done) {
+  var mongoose = require('mongoose')
+    , sqlite3 = require('sqlite3').verbose()
+    , _ = require('lodash')
+    , System = require('./server/models/system')
+    , sde = new sqlite3.Database('./sde/sqlite-latest.sqlite')
+
+  var db = mongoose.connect(process.env.MONGODB_URL);
+  mongoose.set('debug', true);
+
+  sde.each('select * from mapSolarSystems', function(err, row) {
+    system = {id: row.solarSystemID, regionID: row.regionID, constellationID: row.constellationID, name: row.solarSystemName,
+              security: row.security, security_class: row.securityClass};
+    System.updateQ({id: system.id}, system, {upsert: true});
+  });
+
+  // sde.close(function() {
+  //   db.disconnect(done);
+  // });
+});
+
+gulp.task('db:repair:3', function(done) {
+  var mongoose = require('mongoose')
+    , _ = require('lodash')
+    , System = require('./server/models/system')
+    , wormholes = require('./test/fixtures/wormholes.json')
+
+  var db = mongoose.connect(process.env.MONGODB_URL);
+  mongoose.set('debug', true);
+
+  _.forEach(wormholes.wormholes, function(wormhole) {
+    System.updateQ({name: wormhole.name}, {wormhole_data: {class: wormhole.class}}, {upsert: true});
+  });
+
+  // db.disconnect(done);
+});