I am fetching data from MongoDB using java program. MongoDB data contains:
{
"gender": "female",
"city": "ABC",
"phone": "+1 (995) 441-2988",
"email": "[email protected]",
"date": "2015-08-11T15:55:00 -06:-30",
"age": 37,}
Need to validate data like city should be string value, age should be integer, etc. Is there any quick way to use MongoDB queries in java to validate this?
MongoDB $type selects the documents where the value of the field is an instance of the specified numeric BSON type.
As per your document structure date field is not actual ISODATE it looks like String so it's data type 2 and age default data type 1 like double so your java code as
BasicDBObject query = new BasicDBObject();
query.put("gender",new BasicDBObject("$type",2));
query.put("city",new BasicDBObject("$type",2));
query.put("phone",new BasicDBObject("$type",2));
query.put("email",new BasicDBObject("$type",2));
query.put("date",new BasicDBObject("$type",2));
query.put("age", new BasicDBObject("$type",1));
DBCursor cursorDoc = collection.find(query);
while (cursorDoc.hasNext()) {
BasicDBObject object = (BasicDBObject) cursorDoc.next();
System.out.println(object);
}
city:"abc123" is String not number if you insert city:123 then it invalid because 123 consider as number not string , If you confused about data type then read this mongo type it will helpful to find out which documents are valid or notIn the upcoming Mongo 3.2 version they added document validation (slides).
You can specify validation rules for each collection, using validator option using almost all mongo query operators (except $geoNear, $near, $nearSphere, $text, and $where).
Based on your requirements, it is enough to achieve what you want with just checking type. You can read more here.
