Difference between revisions of "MongoDB JS Files"

From mi-linux
Jump to navigationJump to search
Line 32: Line 32:
  
 
== Run a JS File ==
 
== Run a JS File ==
 +
 +
Within MongoDB type in:
 +
 +
load("myQuery.js")
 +
 +
 +
=== Further Information ===
 +
 +
See the [https://docs.mongodb.com/manual/tutorial/write-scripts-for-the-mongo-shell/ MongoDB] manual for further details.
  
 
== Next Step ==
 
== Next Step ==
  
 
Return to the [[MongoDB_Workbook|Workbook]].
 
Return to the [[MongoDB_Workbook|Workbook]].

Revision as of 16:21, 24 October 2016

Main Page >> MongoDB >>MongoDB Workbook >> JavaScript Files

Query Files

The Mongo Shell used mi-linux is an interactive JavaScript interface to MongoDB. As you have seen the mongo shell can be used to query and update your data.

So far the query examples seen are not saved for future use. The data will be stored in the database, but not the queries used.

If you wish to save a query, a text editor should be used to create a .js file. If you are familiar with vi, this can be used on mi-linux (csl-student) to create the file.

Note, these files are created outside the MongoDB environment.

If you do not know how to use vi then it is probably easier if you use something like NotePad++ on your PC to create,or amend the file, then use a secure file transfer protocol (sftp) programme to transfer it to mi-linux using a client, such as FireZilla.

Using FTP

Note when using a FTP client:

  • it must be a secure connection, i.e., sftp
  • the full hostname is: mi-linux.wlv.ac.uk (or csl-student.wlv.ac.uk)
  • the login and username is your normal University username and password

Create a file

Use a text editor you are familiar with and type in the following:

db.deptCollection.find({deptno:20},  { employees: {$elemMatch: { job: "MANAGER"}}}).pretty()


Save the file as:

myQuery.js

Run a JS File

Within MongoDB type in:

load("myQuery.js")


Further Information

See the MongoDB manual for further details.

Next Step

Return to the Workbook.