Skip to content
xicombd edited this page Jan 3, 2015 · 7 revisions

Direct mongo commands

Type mongo on your terminal and then paste the following commands

use deck
db.dropDatabase();
use sinfo
db.copyDatabase('sinfo', 'deck');

use deck
db.members.update( {}, { $rename: { 'mails.sinfo': 'mails.main', 'mails.msn':'mails.microsoft', 'mails.ist': 'mails.institutional' } }, { multi: true } )
db.members.update( {}, { $rename: { 'facebook': 'badjoras' } }, { multi: true } )
db.members.update( {}, { $rename: { 'badjoras': 'facebook.username', 'facebookId':'facebook.id' } }, { multi: true } )

db.comments.update( { }, { $rename: { 'markdown': 'text' } }, { multi: true } )
db.comments.update( { }, { $unset: { 'html': '' } }, { multi: true } )

db.topics.update( { }, { $rename: { 'text': 'name' } }, { multi: true } )
db.topics.update( { kind: 'Decision' }, { $set: { kind: 'decision' } }, { multi: true } )
db.topics.update( { kind: 'Info' }, { $set: { kind: 'info' } }, { multi: true } )
db.topics.update( { kind: 'Idea' }, { $set: { kind: 'idea' } }, { multi: true } )
db.topics.update( { kind: 'To do' }, { $set: { kind: 'todo' } }, { multi: true } )

db.speakers.update( { 'participations.status': 'Selected' }, { $set: { 'participations.$.status': 'selected' } }, { multi: true } )
db.speakers.update( { 'participations.status': 'Approved' }, { $set: { 'participations.$.status': 'approved' } }, { multi: true } )
db.speakers.update( { 'participations.status': 'Contacted' }, { $set: { 'participations.$.status': 'contacted' } }, { multi: true } )
db.speakers.update( { 'participations.status': 'In Conversations' }, { $set: { 'participations.$.status': 'in-conversations' } }, { multi: true } )
db.speakers.update( { 'participations.status': 'Accepted' }, { $set: { 'participations.$.status': 'accepted' } }, { multi: true } )
db.speakers.update( { 'participations.status': 'Rejected' }, { $set: { 'participations.$.status': 'rejected' } }, { multi: true } )
db.speakers.update( { 'participations.status': 'Give Up' }, { $set: { 'participations.$.status': 'give-up' } }, { multi: true } )
db.speakers.update( { 'participations.status': 'Announced' }, { $set: { 'participations.$.status': 'announced' } }, { multi: true } )

db.companies.update( { 'participations.status': 'Selected' }, { $set: { 'participations.$.status': 'selected' } }, { multi: true } )
db.companies.update( { 'participations.status': 'Approved' }, { $set: { 'participations.$.status': 'approved' } }, { multi: true } )
db.companies.update( { 'participations.status': 'Contacted' }, { $set: { 'participations.$.status': 'contacted' } }, { multi: true } )
db.companies.update( { 'participations.status': 'In Conversations' }, { $set: { 'participations.$.status': 'in-conversations' } }, { multi: true } )
db.companies.update( { 'participations.status': 'In Negotiations' }, { $set: { 'participations.$.status': 'in-negotiations' } }, { multi: true } )
db.companies.update( { 'participations.status': 'Closed Deal' }, { $set: { 'participations.$.status': 'closed-deal' } }, { multi: true } )
db.companies.update( { 'participations.status': 'Rejected' }, { $set: { 'participations.$.status': 'rejected' } }, { multi: true } )
db.companies.update( { 'participations.status': 'Give Up' }, { $set: { 'participations.$.status': 'give-up' } }, { multi: true } )
db.companies.update( { 'participations.status': 'Announced' }, { $set: { 'participations.$.status': 'announced' } }, { multi: true } )

Subscriptions migration script

Download the file https://gist.github.com/xicombd/1b4a52a047d8a6ca8be5

Run it by typing NODE_PATH=. node migrations/subscriptions.js | bunyan on your terminal

Clone this wiki locally