Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.2k views
in Technique[技术] by (71.8m points)

google apps script - How to replace the deprecated ScriptDb with Mongodb using URL Fetch service?

Due to the recent ScriptDb deprecation I need to replace it. I chose MongoDb(as I need noSQL db). Google does not provide any guides on how to connect mongo. It's just said that one should use mongolab and URL Fetch service.

I created a data base on mongolab. They gave me the following ways of connecting to it:

To connect using the shell:
   mongo ds045679.mongolab.com:45679/prjacc -u <dbuser> -p <dbpassword>
To connect using a driver via the standard URI (what's this?):
   mongodb://<dbuser>:<dbpassword>@ds045679.mongolab.com:45679/prjacc

But there's no driver for google script so I can't figure out how to replace my old code:

var db = ScriptDb.getMyDb();
// work with db...

with access to mongo using URL Fetch Service.

Any help is appreciated!

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

It seems that I've found a solution. MongoDB also provides the third way of accessing the DB, though they strongly recommend to use 2 ways described in my question. This is to use their REST API:

enter image description here

So it seems we should pass this url https://api.mongolab.com/api/1/databases?apiKey=<your-api-key> to the UrlFetchApp.fetch() function.

Please correct me if I'm not right. Any additions and notes are appreciated.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...