can you support script

[icyxp]

Need to have data record changes, can support scripts？thank you

[coldze]

Hi @icyxp,

At the moment this tool supports only mongodb's database commands:
https://docs.mongodb.com/manual/reference/command/

There are delete, insert and update commands + you can add several commands into a single migration to execute them in a sequence, writing a root json element "cmds" and adding commands into array under this key, like:

{
  "cmds": [
    {
      "delete": "test_collection",
      "deletes": [
        {
          "q": {
            //your filter, relaxed ExtJSON format is supported (https://github.com/mongodb/specifications/blob/master/source/extended-json.rst)
          },
          "limit": 1
        }
      ]
    }, {
      //another command
    }
  ]
}

(probably, I need to write some docs on how to use it :))

So some rather simple manipulations are supported and, at the moment, you can write more complex ones, using aggregation/map-reduce/etc +command sequences, but it is definitely much harder, than to write a script and I need to figure out how to support it. And yes, scripts' support is planned, but it will require some efforts on my side :) If you have any thoughts or suggestions on this (implementation/syntax/etc), please feel free to share.

[coldze]

Forgot to mention, if you're using MongoDB version between 3.0 (inclusively) and 4.0 (exclusively), then you can use eval command:
https://docs.mongodb.com/v3.6/reference/command/eval/#dbcmd.eval

This one allows you to write and apply JavaScript function.