Subversion Repositories SmartDukaan

Rev

Rev 15272 | Rev 21826 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15272 Rev 15381
Line 2... Line 2...
2 
 
 2 
 
3 
 
 3 
 
4 
import in.shop2020.dtrapi.models.MasterData;
 4 
import in.shop2020.dtrapi.models.MasterData;
5 
import in.shop2020.model.v1.order.AmazonFbaSalesSnapshot;
 5 
import in.shop2020.model.v1.order.AmazonFbaSalesSnapshot;
6 
 
 6 
 
- 
 
 7 
import java.awt.List;
7 
import java.net.UnknownHostException;
 8 
import java.net.UnknownHostException;
- 
 
 9 
import java.util.ArrayList;
8 
 
 10 
 
9 
import com.google.gson.Gson;
 11 
import com.google.gson.Gson;
10 
import com.mongodb.BasicDBObject;
 12 
import com.mongodb.BasicDBObject;
11 
import com.mongodb.DB;
 13 
import com.mongodb.DB;
12 
import com.mongodb.DBCollection;
 14 
import com.mongodb.DBCollection;
- 
 
 15 
import com.mongodb.DBCursor;
13 
import com.mongodb.DBObject;
 16 
import com.mongodb.DBObject;
14 
import com.mongodb.MongoClient;
 17 
import com.mongodb.MongoClient;
15 
 
 18 
 
16 
 
 19 
 
17 
public class Mongo {
 20 
public class Mongo {
Line 40... Line 43...
40 
		Gson gson = new Gson();
 43 
		Gson gson = new Gson();
41 
		MasterData masterData = gson.fromJson(result.toString(), MasterData.class);
 44 
		MasterData masterData = gson.fromJson(result.toString(), MasterData.class);
42 
		return masterData;
 45 
		return masterData;
43 
	}
 46 
	}
44 
 
 47 
 
- 
 
 48 
	public static ArrayList<MasterData> getItemsByBundleId(long bundleId){
- 
 
 49 
		DB db = mongo.getDB(CATALOG_DB);
- 
 
 50 
		DBCollection collection = db.getCollection(MASTER_DATA);
- 
 
 51 
		BasicDBObject obj = new BasicDBObject();
- 
 
 52 
		BasicDBObject in_query = new BasicDBObject();
- 
 
 53 
		obj.append("skuBundleId", bundleId);
- 
 
 54 
		obj.append("in_stock",1);
- 
 
 55 
		in_query.append("$in",new int[] {1,2,3,4});
- 
 
 56 
		obj.append("source_id", in_query);
- 
 
 57 
		ArrayList<MasterData> items = new ArrayList<MasterData>();
- 
 
 58 
		DBCursor result = collection.find(obj);
- 
 
 59 
		Gson gson = new Gson();
- 
 
 60 
		while (result.hasNext()) {
- 
 
 61 
			MasterData masterData = gson.fromJson(result.next().toString(), MasterData.class);
- 
 
 62 
			items.add(masterData);
- 
 
 63 
		}
- 
 
 64 
		return items;
- 
 
 65 
	}
- 
 
 66 
 
45 
	public static void main(String[] args) throws Exception{
 67 
	public static void main(String[] args) throws Exception{
46 
		System.out.println(getItemByID(1).getAvailable_price());
 68 
		System.out.println(getItemsByBundleId(100000));
47 
	}
 69 
	}
48 
}
 70 
}
49 

            71