package pl.edu.agh.bd.mongo;

import java.net.UnknownHostException;

import com.mongodb.BasicDBObject;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.DBCursor;
import com.mongodb.DBObject;
import com.mongodb.MongoClient;
import com.mongodb.QueryBuilder;

public class MongoLab {
	private MongoClient mongoClient;
	private DB db;
	private DBCollection collection;
	
	public MongoLab() throws UnknownHostException {
		mongoClient = new MongoClient();
		db = mongoClient.getDB("jeopardy");
		collection = db.getCollection("Jeopardy");
	}
	
	private void firstQuery(){
		System.out.println("1. Show elements from category AIRLINE TRAVEL where 'flight' appears in question, sorted descending by value.");
		BasicDBObject query = new BasicDBObject("category","AIRLINE TRAVEL").append("question",new BasicDBObject("$regex",".*flight.*"));
		
		DBCursor cursor = collection.find(query).sort(new BasicDBObject("value",-1));
		try{
			while(cursor.hasNext()){
				System.out.println(cursor.next());
			}
		} finally{
			cursor.close();
		}
	}
	
	
	private void showCollections(){
		for(String name : db.getCollectionNames()){
			System.out.println("colname: "+name);
		}
	}

	public static void main(String[] args) throws UnknownHostException {
		MongoLab mongoLab = new MongoLab();
		mongoLab.firstQuery();
		System.out.print("Done!");
	}

}