| 15272 |
kshitij.so |
1 |
package in.shop2020.dtrapi.Storage;
|
|
|
2 |
|
|
|
3 |
|
|
|
4 |
import in.shop2020.dtrapi.models.MasterData;
|
|
|
5 |
import in.shop2020.model.v1.order.AmazonFbaSalesSnapshot;
|
|
|
6 |
|
|
|
7 |
import java.net.UnknownHostException;
|
|
|
8 |
|
|
|
9 |
import com.google.gson.Gson;
|
|
|
10 |
import com.mongodb.BasicDBObject;
|
|
|
11 |
import com.mongodb.DB;
|
|
|
12 |
import com.mongodb.DBCollection;
|
|
|
13 |
import com.mongodb.DBObject;
|
|
|
14 |
import com.mongodb.MongoClient;
|
|
|
15 |
|
|
|
16 |
|
|
|
17 |
public class Mongo {
|
|
|
18 |
|
|
|
19 |
private static MongoClient mongo;
|
|
|
20 |
private static final String CATALOG_DB = "Catalog";
|
|
|
21 |
private static final String MASTER_DATA = "MasterData";
|
|
|
22 |
|
|
|
23 |
static {
|
|
|
24 |
try {
|
|
|
25 |
mongo = new MongoClient( "localhost" , 27017 );
|
|
|
26 |
} catch (UnknownHostException e) {
|
|
|
27 |
e.printStackTrace();
|
|
|
28 |
}
|
|
|
29 |
}
|
|
|
30 |
|
|
|
31 |
public static MasterData getItemByID(long id) throws Exception{
|
|
|
32 |
DB db = mongo.getDB(CATALOG_DB);
|
|
|
33 |
DBCollection collection = db.getCollection(MASTER_DATA);
|
|
|
34 |
BasicDBObject obj = new BasicDBObject();
|
|
|
35 |
obj.append("_id", id);
|
|
|
36 |
DBObject result = collection.findOne(obj);
|
|
|
37 |
if (result==null){
|
|
|
38 |
throw new Exception();
|
|
|
39 |
}
|
|
|
40 |
Gson gson = new Gson();
|
|
|
41 |
MasterData masterData = gson.fromJson(result.toString(), MasterData.class);
|
|
|
42 |
return masterData;
|
|
|
43 |
}
|
|
|
44 |
|
|
|
45 |
public static void main(String[] args) throws Exception{
|
|
|
46 |
System.out.println(getItemByID(1).getAvailable_price());
|
|
|
47 |
}
|
|
|
48 |
}
|