mysql和mongodb替换字段中某字符

1

update cloud_push_log set result_path = replace(result_path, 'zjy.zyzhjyy.cn','zjy.zyjyxx.com');

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

db.getCollection('eventArgs').find({'contextFileHost':{'$ne':null}, 'contextFileHost':/\.zjy\.zyjyxx\.com/}).

forEach( 

    function(item) {

        var tmp = String(item.contextFileHost)

        if (tmp == null){

            print(item.contextFileHost) 

        }

        else{

            tmp = tmp.replace(/\.zjy\.zyjyxx\.com/g,"\.zjy\.zyzhjyy\.cn");

            }

            item.contextFileHost = tmp ;

            db.getCollection('eventArgs').save(item);

            print("update to " + item.contextFileHost) 

    } 

);

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

db.getCollection('eventArgs').find({'files.origin':{'$ne':null}, 'files.origin':/\.zjy\.zyjyxx\.com/}).

forEach( 

    function(item) {

        var tmp = String(item.files.origin)

        if (tmp == null){

            print(item.files.origin) 

        }

        else{

            tmp = tmp.replace(/\.zjy\.zyjyxx\.com/g,"\.zjy\.zyzhjyy\.cn");

            }

            item.files.origin= tmp ;

            db.getCollection('eventArgs').save(item);

            print("update to " + item.files.origin) 

    } 

);

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

db.getCollection('convert_state_copy0515-1').find({'executeArgs.source':new RegExp(".*zjy.zyjyxx.com.*")}).forEach(

function(item){

        var executeArgs = item['executeArgs'];

        for(var i in executeArgs){

                var source = executeArgs[i]['source'];

                if(null != source && String(source).search('zjy.zyjyxx.com') > -1) {

                    executeArgs[i]['source'] = source.replace('zjy.zyjyxx.com', 'zjy.zyzhjyy.cn');

                }  

                var callback = executeArgs[i]['callback'];

                if(null != callback){

                    var callback_url = executeArgs[i]['callback']['url'];

                    if(null != callback_url && String(callback_url).search('zjy.zyjyxx.com') > -1) {

                        executeArgs[i]['callback']['url'] = callback_url.replace('zjy.zyjyxx.com', 'zjy.zyzhjyy.cn');

                    } 

                }

                var upload = executeArgs[i]['upload'];

                if(null != upload){

                    var upload_url = executeArgs[i]['upload']['url'];

                    if(null != upload_url && String(upload_url).search('zjy.zyjyxx.com') > -1) {

                        executeArgs[i]['upload']['url'] = upload_url.replace('zjy.zyjyxx.com', 'zjy.zyzhjyy.cn');

                    }         

                }

        }

    db.getCollection('convert_state_copy0515-1').update({"_id":item['_id']},{$set:{"executeArgs":executeArgs,"exec":1}});

})