Category Archives: mongodb

MongoDB: Get a random record

Get a random record in Mongo

A quick and simple function that picks a random record from a cursor:

var getRnd = function(q) {
  var count = q.count()
  var o = q.limit(-1).skip(Math.random() * q.count()).next()
  printjson(o)
}

var getRnd = function(q) {

var count = q.count()

var o = q.limit(-1).skip(Math.random() * q.count()).next()

printjson(o)

}

Example:

> var getRnd = function(q) {
...   var count = q.count()
...   var o = q.limit(-1).skip(Math.random() * q.count()).next()
...   printjson(o)
... }
> use hotel
switched to db hotel
> getRnd(db.hotelWithDetail.find())
{
        "_id" : ObjectId("538f5fa6d9805dc69ea218b5"),
        "hotel" : {
                "id" : 88173,
                "name" : "Pantai Inn",
                "addressProvider" : "GoogleMaps",
                "addressLine1" : "1003 Coast Boulevard",
                "city" : "San Diego",
                "countryCode" : "US",
                "phoneNumber" : "+1-858-224-7600",
                "location" : {
                        "latitude" : 32.8485673,
                        "longitude" : -117.275847,
                        "geocodeProvider" : "GoogleMaps",
                        "geocodeAccuracy" : "Vicinity",
                        "created" : ISODate("2014-04-19T17:48:45.101Z")
                },
                "oomProviderMapping" : [
                        {
                                "provider" : "TP",
                                "providerId" : "71990"
                        },
                        {
                                "provider" : "GIA",
                                "providerId" : "250629"
                        }
                ],
                "propertyType" : "Unknown",
                "optPostalCode" : "92037",
                "optStateCode" : "CA",
                "optChainCode" : "WV"
        },
        "hotelDetail" : {
                "id" : 88173,
                "description" : "The Pantai Inn is a Balinesian inspired hotel perched atop La Jollas jagged cliffs. Boutique-lined streets gemmed with art gifts and other shopping destinations. Indulgent soft sand beaches with year-round vacation sunshine and the Pacific Oceans watercolor sunsets. From the village to the cove La Jolla truly is the jewel of Southern California. - 11 ROOMS - 2 LEVELS - INTERIOR CORRIDORS",
                "zomProviderOomAmenity" : [ ],
                "optTpCityCode" : "SAN",
                "optCheckInTime" : "1500"
        }
}

> var getRnd = function(q) {

... var count = q.count()

... var o = q.limit(-1).skip(Math.random() * q.count()).next()

... printjson(o)

... }

> use hotel

switched to db hotel

> getRnd(db.hotelWithDetail.find())

{

"_id" : ObjectId("538f5fa6d9805dc69ea218b5"),

"hotel" : {

"id" : 88173,

"name" : "Pantai Inn",

"addressProvider" : "GoogleMaps",

"addressLine1" : "1003 Coast Boulevard",

"city" : "San Diego",

"countryCode" : "US",

"phoneNumber" : "+1-858-224-7600",

"location" : {

"latitude" : 32.8485673,

"longitude" : -117.275847,

"geocodeProvider" : "GoogleMaps",

"geocodeAccuracy" : "Vicinity",

"created" : ISODate("2014-04-19T17:48:45.101Z")

"oomProviderMapping" : [

{

"provider" : "TP",

"providerId" : "71990"

{

"provider" : "GIA",

"providerId" : "250629"

}

"propertyType" : "Unknown",

"optPostalCode" : "92037",

"optStateCode" : "CA",

"optChainCode" : "WV"

"hotelDetail" : {

"id" : 88173,

"description" : "The Pantai Inn is a Balinesian inspired hotel perched atop La Jollas jagged cliffs. Boutique-lined streets gemmed with art gifts and other shopping destinations. Indulgent soft sand beaches with year-round vacation sunshine and the Pacific Oceans watercolor sunsets. From the village to the cove La Jolla truly is the jewel of Southern California. - 11 ROOMS - 2 LEVELS - INTERIOR CORRIDORS",

"zomProviderOomAmenity" : [ ],

"optTpCityCode" : "SAN",

"optCheckInTime" : "1500"

}

[DEPRECATED] CentOS 6: Install MongoDB Java REST server

Verisons

CentOS 6.4
Oracle Java 1.6 JDK
MongoDB 2.4

Prerequisites

Install

1. Download, extract tar and mv to /usr/lib

wget http://commondatastorage.googleapis.com/andreidata/mongoser.tar.gz
tar xvf mongoser.tar.gz
sudo mv mongoser /usr/lib

wget http://commondatastorage.googleapis.com/andreidata/mongoser.tar.gz

tar xvf mongoser.tar.gz

sudo mv mongoser /usr/lib

Install as a service

1. Edit /etc/init.d/mongoser

#!/bin/sh
#
# chkconfig: 2345 80 80
#
# Bash script to run mongoser.sh as a service
#

# Note: Normal env variables are discarded by service. So must export JAVA_HOME here, see http://serverfault.com/questions/374404/service-command-and-environment-variables
export JAVA_HOME=/usr/java/latest

MONGOSER_HOME=/usr/lib/mongoser
MONGOSER_DAEMON=bin/mongoser.sh
MONGOSER_USER=root
START_OPTIONS=start
STOP_OPTIONS=stop

start() {
    echo "Starting Mongoser Java REST for MongoDB..."
    su --preserve-environment $MONGOSER_USER -c "cd $MONGOSER_HOME && $MONGOSER_DAEMON $START_OPTIONS"
    return 0
}

stop() {
    echo "Stopping Mongoser Java REST for MongoDB..."
    su --preserve-environment $MONGOSER_USER -c "cd $MONGOSER_HOME && $MONGOSER_DAEMON $STOP_OPTIONS"
    return 0
}

case "$1" in
  start)
    start
    ;;
  stop)
    stop
      ;;
  restart)
    stop
    start
    ;;
  *)
  echo $"Usage: $0 {start|stop|restart}"
  exit 1
esac

exit $?

#!/bin/sh

# chkconfig: 2345 80 80

# Bash script to run mongoser.sh as a service

# Note: Normal env variables are discarded by service. So must export JAVA_HOME here, see http://serverfault.com/questions/374404/service-command-and-environment-variables

export JAVA_HOME=/usr/java/latest

MONGOSER_HOME=/usr/lib/mongoser

MONGOSER_DAEMON=bin/mongoser.sh

MONGOSER_USER=root

START_OPTIONS=start

STOP_OPTIONS=stop

start() {

echo "Starting Mongoser Java REST for MongoDB..."

su --preserve-environment $MONGOSER_USER -c "cd $MONGOSER_HOME && $MONGOSER_DAEMON $START_OPTIONS"

return 0

}

stop() {

echo "Stopping Mongoser Java REST for MongoDB..."

su --preserve-environment $MONGOSER_USER -c "cd $MONGOSER_HOME && $MONGOSER_DAEMON $STOP_OPTIONS"

return 0

}

case "$1" in

start)

start

;;

stop)

stop

;;

restart)

stop

start

;;

echo $"Usage: $0 {start|stop|restart}"

exit 1

esac

exit $?

Note: the script hard codes JAVA_HOME, but this could be deferred to the /etc/sysconfig/mongoser script (which you must create) if desired. Note that the normal /etc/profile.sh is *not* run for services.
2. Make it executable

sudo chmod +x /etc/init.d/mongoser

1	sudo chmod +x /etc/init.d/mongoser

3. Start service

sudo service mongoser start

1	sudo service mongoser start

4. Start service on boot

sudo chkconfig mongoser on

1	sudo chkconfig mongoser on

Test

1. Get a list of databases

curl -i "http://localhost:8081/database"

1	curl -i "http://localhost:8081/database"

Output:

HTTP/1.1 200 OK
Cache-Control: no-cache,no-store,must-revalidate
Content-Type: application/json;charset=UTF-8
Transfer-Encoding: chunked

["local"]

HTTP/1.1 200 OK

Cache-Control: no-cache,no-store,must-revalidate

Content-Type: application/json;charset=UTF-8

Transfer-Encoding: chunked

["local"]

Source

https://sites.google.com/site/mongodbjavarestserver/home

CentOS 6: Install MongoDB

1 Reply

Versions

CentOS 6.5
MongoDB 2.4.10

Install

Edit /etc/yum.repos.d/10gen.repo

Default

[10gen] name=10gen Repository baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64 gpgcheck=0

1
2
3
4

[10gen]
name=10gen Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64
gpgcheck=0
Install

Shell

sudo yum install mongo-10gen mongo-10gen-server

1

sudo yum install mongo-10gen mongo-10gen-server

Configure

Start service

Shell

sudo service mongod start

1

sudo service mongod start
Start on boot

Shell

sudo chkconfig mongod on

1

sudo chkconfig mongod on

Test

$ mongo
MongoDB shell version: 2.4.0
> use test
switched to db test
> db.foo.find()
> db.foo.save({a: 1})
> db.foo.find()
{ "_id" : ObjectId("514cd798c59449cc1f1344d3"), "a" : 1 }
> db.foo.update({a: 1}, {a: 5})
> db.foo.find()
{ "_id" : ObjectId("514cd798c59449cc1f1344d3"), "a" : 5 }
> db.foo.remove({a: 5})
> db.foo.find()

$ mongo

MongoDB shell version: 2.4.0

> use test

switched to db test

> db.foo.find()

> db.foo.save({a: 1})

> db.foo.find()

{ "_id" : ObjectId("514cd798c59449cc1f1344d3"), "a" : 1 }

> db.foo.update({a: 1}, {a: 5})

> db.foo.find()

{ "_id" : ObjectId("514cd798c59449cc1f1344d3"), "a" : 5 }

> db.foo.remove({a: 5})

> db.foo.find()

Optional: Open firewall port

Open port 27017 for mongodb See CentOS 6: Open a port for iptables

Decidable Dreams

Category Archives: mongodb

MongoDB: Get a random record

Get a random record in Mongo

[DEPRECATED] CentOS 6: Install MongoDB Java REST server

Verisons

Prerequisites

Install

Install as a service

Test

Source

CentOS 6: Install MongoDB

Versions

Install

Configure

Test

Optional: Open firewall port

Sources