Robomongo and MongoDB - initial setup on Mac

1. Install MongoDB :

  • Download tgz or zip file from MongoDB website
     
  • Extract tgz or zip file in home directory
    • eg : /Users/userName/mongodb_x86_64-3.0.0
  • Add path of mongoDB directory in PATH


 2. Run MongoDB server :
  • Create a directory for primary DB path.
    • /Users/userName/mongodb_x86_64-3.0.0/data/db
  • Run Command
    • /Users/userName/mongodb_x86_64-3.0.0/bin/mongod --dbpath /Users/userName/mongodb_x86_64-3.0.0/data/db  --bind_ip 0.0.0.0 -v
3. Install RoboMongo :
  • Download RoboMongo from http://robomongo.org/
  • Drop downloaded/extracted folder in Applications folder (/Applications)
4. Run RoboMongo and Connect with MongoDB :





5. Create Example Database in RoboMongo :
Step 1 : Create Database


 Step 2 : Create Collection ( Collection of Documents/Tables )




Step 3 : Create Document/Table 



Step 4 : Insert data in Document
Query Test in Python ( using pymongo)

import pymongo
# Connecting with server
client = pymongo.MongoClient('10.100.101.11', 27017)

 # Get database
db = client.database_name

# Query Single value
queryResult = db['Models'].find({'assetname':"mesh01"})

# Query with wild card value
queryResult = db['Models'].find({'assetname':{'$regex': 'mesh'}})

# Query Multiple values
queryResult = db['Models'].find({'assetname':{'$in':["mesh01", "rig04"]}})


for entry in queryResult:
print entry



 # Copying Database
import pymongo
mongoServerIP = '10.217.130.12'
mongoServerPort = 27017
client = pymongo.MongoClient(mongoServerIP, mongoServerPort)
client.copy_database('databaseName', 'databaseName_copy', mongoServerIP + ':' + mongoServerPort)

[ Documentation : https://docs.mongodb.com/manual/reference/operator/query/ ]
Unity C# (Adding data to collection)


        private static MongoClient client;
        private static IMongoDatabase database;
        private static IMongoCollection collection;

        public static void MDBConnect()
        {
            client = new MongoClient("mongodb://127.0.0.1:27017/");
            // "/' frontslash after port number is important
            database = client.GetDatabase("DatabaseName");
            collection = database.GetCollection("CollectionName");
        }

        public static void SendEvent(string action, string information)
        {
            var entry = new BsonDocument {
                { "action", action },
                { "info", information}
            };
            Debug.Log(client.ListDatabaseNames());
            collection.InsertOneAsync(entry);
        }




Comments

Post a Comment

Popular posts from this blog

Bounding Box in PIL (Python Image Library)

Image
Bounding Box in PIL(Python Image Library) : Bounding Box function of PIL can be very useful for removing unused pixels from an image. Eg. If we want to remove unused pixels based on alpha channel of an image, we can use following code.   im = Image.open(imagePath) r,g,b,a = im.split() left,upper,right,lower = a.getbbox() tempImage = im.crop((left,upper,right,lower)) newPath = imagePath.split(".")[0]+"_Cropped" + "." + imagePath.split(".")[1] tempImage.save(newPath) To understand which values, getbbox() function returns and what do they look like on an image, I created an image showing the values returned by the function. left,upper,right,lower = image.getbbox()   Suppose you have a point in an original image and you want to find out the new position of the same point in the cropped image, lets see how we can do it. Suppose the point is at (300,450) position in an original image, so after cr
Read more

Dictionary vs KeyValuePair vs Struct - C#

Dictionary :  //   Declare   Dictionary and assign value Dictionary < string ,  object >  parameter  =  new   Dictionary < string ,  object >(); parameter [ " View " ] =  viewComp ; parameter [ " Play " ] =  true ; FunctionName( parameter ); //   Use   Dictionary private   void   FunctionName ( object   parameter ) {      Dictionary < string ,  object >  dict  = ( Dictionary < string ,  object >) parameter ;      GameObject   viewComp  = ( GameObject ) dict  [ " View " ];      bool   play  = ( bool ) dict [ " Play " ];      UseValuesInFunction ( viewComp ,  play ); } KeyValuePair : KeyValuePair < GameObject ,  bool >  parameter  =  new   KeyValuePair < GameObject ,  bool >( viewComp ,  true ); FunctionName( parameter ); //   Use   KeyValuePair                    private   void   FunctionName ( object   parameter ) {      KeyValuePair < GameObject ,  bool >  param  = ( KeyValuePair < Gam
Read more

Rendering order and Z-sorting

Image
Rendering order and Z-sorting . In Unity, there are a couple of options using which we can control render order of the objects, two of them are 1. Render queue in shaders and 2. Painter's algorithm but eventually, what appears in front and what stays hidden is decided by Z-sorting/depth sorting. Here is the authoritative sequence of order of objects that will appear on the screen. Z-sorting/ Depth sorting is the final step to sort pixels based on the z-distance from the camera, but we can still turn ZWrite-off in the shaders (which in a way breaks Z-sorting). If we turn off ZWrite in all the shaders then render-queue will be in charge of deciding what comes in front and what goes in back If all shaders have ZWrite turned off and as well as they are on the same render-queue then the distance of their transform point from the camera will decide the render order. Eg : - ZWrite Off - Render Queue same - Painter's algorithm - ZWrite Off - Render Queue in
Read more